BUG Xpages using NSFDB2 query views

HCL Domino Domino Forum
1

My situation:Domino 8.5

Windows 2003 SRV

DB2 V9.1.2

I’ve got a DB2 enabled database with a QueryView, a Form and two Xpages.

In the first Xpage called “T1” I’ve set a datasource on a XSPView control bound to the View.

I set the first column to be opened as a link and I set “at runtime, open selected document using” to the other Xpage called “T2”.

In T2 there is a datasource bound to the Form.

This is working correctly when ran on a not DB2 enabled database.

but

Using this on a DB2 Enabled db i still get this error:

Unexpected runtime error

The runtime has encountered an unexpected error.

Error source

Page Name:/t2.xsp

Exception

Could not open the document

► ▼ Stack Trace

com.ibm.xsp.FacesExceptionEx: Could not open the document

com.ibm.xsp.model.domino.DominoDocumentData.doOpenDocument(DominoDocumentData.java:331)

com.ibm.xsp.model.AbstractDocumentDataSource.openDocument(AbstractDocumentDataSource.java:142)

com.ibm.xsp.model.AbstractDocumentDataSource.load(AbstractDocumentDataSource.java:94)

com.ibm.xsp.model.AbstractDataSource.getDataContainer(AbstractDataSource.java:348)

com.ibm.xsp.model.domino.DominoDocumentData.getDataObject(DominoDocumentData.java:106)

com.ibm.xsp.model.AbstractDataSource.pushData(AbstractDataSource.java:458)

com.ibm.xsp.util.DataUtil.putData(DataUtil.java:102)

com.ibm.xsp.util.DataUtil.putData(DataUtil.java:56)

com.ibm.xsp.component.UIViewRootEx.initBeforeContents(UIViewRootEx.java:837)

com.ibm.xsp.page.compiled.AbstractCompiledPage.initComponent(AbstractCompiledPage.java:308)

com.ibm.xsp.page.compiled.AbstractCompiledPage.createTree(AbstractCompiledPage.java:239)

com.ibm.xsp.page.compiled.AbstractCompiledPage.createViewRoot(AbstractCompiledPage.java:146)

com.ibm.xsp.application.ViewHandlerExImpl._createViewRoot(ViewHandlerExImpl.java:446)

com.ibm.xsp.application.ViewHandlerExImpl.createViewRoot(ViewHandlerExImpl.java:498)

com.ibm.xsp.application.ViewHandlerExImpl.doCreateView(ViewHandlerExImpl.java:131)

com.ibm.xsp.application.ViewHandlerEx.createView(ViewHandlerEx.java:112)

com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:189)

com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:151)

com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:148)

com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:128)

com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:113)

com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:354)

com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:414)

com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:508)

com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:451)

com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:343)

com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:398)

com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:143)

com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:221)

com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:183)

com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:222)

NotesException: Invalid universal id

lotus.domino.local.Database.NgetDocumentByUNID(Native Method)

lotus.domino.local.Database.getDocumentByUNID(Unknown Source)

com.ibm.xsp.model.domino.DominoUtils.getDocumentById(DominoUtils.java:225)

com.ibm.xsp.model.domino.DominoDocumentData.doOpenDocument(DominoDocumentData.java:322)

com.ibm.xsp.model.AbstractDocumentDataSource.openDocument(AbstractDocumentDataSource.java:142)

com.ibm.xsp.model.AbstractDocumentDataSource.load(AbstractDocumentDataSource.java:94)

com.ibm.xsp.model.AbstractDataSource.getDataContainer(AbstractDataSource.java:348)

com.ibm.xsp.model.domino.DominoDocumentData.getDataObject(DominoDocumentData.java:106)

com.ibm.xsp.model.AbstractDataSource.pushData(AbstractDataSource.java:458)

com.ibm.xsp.util.DataUtil.putData(DataUtil.java:102)

com.ibm.xsp.util.DataUtil.putData(DataUtil.java:56)

com.ibm.xsp.component.UIViewRootEx.initBeforeContents(UIViewRootEx.java:837)

com.ibm.xsp.page.compiled.AbstractCompiledPage.initComponent(AbstractCompiledPage.java:308)

com.ibm.xsp.page.compiled.AbstractCompiledPage.createTree(AbstractCompiledPage.java:239)

com.ibm.xsp.page.compiled.AbstractCompiledPage.createViewRoot(AbstractCompiledPage.java:146)

com.ibm.xsp.application.ViewHandlerExImpl._createViewRoot(ViewHandlerExImpl.java:446)

com.ibm.xsp.application.ViewHandlerExImpl.createViewRoot(ViewHandlerExImpl.java:498)

com.ibm.xsp.application.ViewHandlerExImpl.doCreateView(ViewHandlerExImpl.java:131)

com.ibm.xsp.application.ViewHandlerEx.createView(ViewHandlerEx.java:112)

com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:189)

com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:151)

com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:148)

com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:128)

com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:113)

com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:354)

com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:414)

com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:508)

com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:451)

com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:343)

com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:398)

com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:143)

com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:221)

com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:183)

com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:222)

I think this is a bug.

Is it known?

Is it fixed in release 8.5.1 ?

Thanks

Marco

2

Subject: Re: XPAGES and NSFDB2

Is the query view working properly without xpages? You were having some problems earlier.

3

Subject: RE: BUG Xpages using NSFDB2 query views…

Hello Patrick,

yes it is.

I’m using the DB2 view now and not the table (*_T) as you suggested and everything in the query view is ok.

4

Subject: You might try…

Since the error listed is " Invalid universal id", try ensuring that your query view includes SELECT #UNID, … in the SQL statement.

5

Subject: no UNID

I did’nt have any #UNID nor in the DAV and in the DB2 table (and view).

I inserted a Special DAV field of type “Auto” named #UNID and now i can see the UNID in the DB2 table and in the DB2 view but i don’t know how to put this field in my queryview.

Should it be in column ?

I tried again (without a specific column for the UNID), also changing the SELECT and explicitly using the field #UNID…

but i still get the same error.

Thanks

Marco

6

Subject: …

any news?I’d like to know if this an effective bug, and in this case if it is known?

Thanks

Marco

7

Subject: Re:

I’m not familiar with the inner workings of xpages, there may be some interaction between NSFDB2 and xpages. I’m not sure if that is a supported configuration.

If the QV is working as it should, I don’t know what more to tell you. The next step would be to open a report with the support organization so it can be investigated further.

8

Subject: open a report

Hello Patrick,and thanks for your reply.

I’m not familiar with open report with the support organization, I’ve never done it.

Could you, please, help me telling me what I’m suppose to do in this case.

Consider that I’m not a business partner i’m not in the Software Support.

Thank you.

Marco

9

Subject: need answer

I can provide my nsf database to let everyone test my software.I’m pretty sure I’m doing right but, of course, I may forget something.

I just need an answer because I need this feature for a project I’m working on and I need to know if i count on this feature or if I have to look for somethign different.

Thanks

Marco