Topic
  • 1 reply
  • Latest Post - ‏2010-11-08T20:41:57Z by Dave Sanders
SystemAdmin
SystemAdmin
32 Posts

Pinned topic Urgent : CMISPreview not fucntioning properly

‏2010-11-08T04:03:56Z |
Hi ,
We are facing issues with CMISTechPreview for Filenet:

Please find the required information as follows:
1. Can you please be more specific on the problem occurred?

The problem is as follows:
We are using Filenet CMISPreview to intigrate with Filenet for the CMIS aspect.
Though the integration has been done successfully , still it is not functional.
We found the following issues:

1> Documents are not identified.
2> If folders have documents in it , the folder doesnot get displayed and it throws error.

2. Can you please provide details of your system configuration including OS, DB, Application Server with versions/patches etc.?

OS - Windows 2003
DB - Oracle 11g
AE-4.0.2
PE-4.5.1
CE-4.5.1
Websphere 7.0
3. Can you please provide versions and patches levels for related FileNet components(i.e., AE and CE)?

AE-4.0.2
PE-4.5.1
CE-4.5.1

5. Is this a new installation? When was this problem first noticed?
Yes, the issue was identified when CMISPreview was installed.

6. Can you please provide copies of the latest application server logs, as well as p8_server_error.log?
Please also provide us with the time point around which this issue was re-produced.

11/8/10 10:43:52:078 SGT 00000034 SystemErr R com.ibm.ecm.cmis.app.exceptions.CMISRuntimeException: CIL1500: Runtime error
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.exceptions.ExceptionUtil.decodeException(ExceptionUtil.java:24)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.servlet.CMISExceptionHandler.handleException(CMISExceptionHandler.java:26)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.servlet.ParamMappingServlet.service(ParamMappingServlet.java:226)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.servlet.CMISServlet.service(CMISServlet.java:414)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:272)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R Caused by: com.filenet.api.exception.EngineRuntimeException: DB_BAD_DATATYPE: Bad data type: oracle.sql.RAW errorStack={
at com.filenet.engine.dbpersist.DBResult.getId(DBResult.java:737)
at com.filenet.engine.retrieve.AdHocClassRetriever.loadObject(AdHocClassRetriever.java:4238)
at com.filenet.engine.retrieve.AdHocClassRetriever.doSearchImpl(AdHocClassRetriever.java:1363)
at com.filenet.engine.retrieve.AdHocClassRetriever.doSearch(AdHocClassRetriever.java:1055)
at com.filenet.engine.retrieve.AdHocClassRetriever.executeSearch(AdHocClassRetriever.java:591)
at com.filenet.engine.jca.impl.RequestBrokerImpl.executeSearch(RequestBrokerImpl.java:890)
at com.filenet.engine.jca.impl.RequestBrokerImpl.executeSearch(RequestBrokerImpl.java:813)
at com.filenet.engine.ejb.EngineCoreBean._executeSearch(EngineCoreBean.java:307)
at com.filenet.engine.ejb.EngineCoreBean.executeSearch(EngineCoreBean.java:273)
at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeSearch(Unknown Source)
at com.filenet.engine.ejb.EngineBean.executeSearch(EngineBean.java:421)
at com.filenet.apiimpl.transport.ejbstubs.EJSRemoteStatelessEngine_2e64c374.executeSearch(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:692)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:690)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1156)
at $Proxy39.executeSearch(Unknown Source)
at com.filenet.apiimpl.transport.ejbstubs._Engine_Stub.executeSearch(Unknown Source)
at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl._executeSearch(EJBSession.java:588)
at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.executeSearch(EJBSession.java:446)
at com.filenet.apiimpl.transport.ejb.EJBSession.executeSearch(EJBSession.java:139)
at com.filenet.apiimpl.util.SessionHandle.executeSearch(SessionHandle.java:190)
at com.filenet.apiimpl.core.Session.callExecuteSearch(Session.java:197)
at com.filenet.apiimpl.core.Session.fetchObjects(Session.java:756)
at com.filenet.apiimpl.core.Session.fetchObjects(Session.java:932)
at com.filenet.apiimpl.query.RepositorySearch.fetchObjects(RepositorySearch.java:164)
at com.filenet.api.query.SearchScope.fetchObjects(SearchScope.java:217)
at com.ibm.ecm.cmis.dal.p8.DALP8Folder.getChildren(DALP8Folder.java:354)
at com.ibm.ecm.cmis.mvc.datasource.cmis.ContentSource.getData(ContentSource.java:138)
at com.ibm.ecm.cmis.app.cmis.BaseCollection.get(BaseCollection.java:167)
at com.ibm.ecm.cmis.app.cmis.BaseCollection.get(BaseCollection.java:104)
at com.ibm.ecm.cmis.app.cmis.ContentFlat.get(ContentFlat.java:64)
at com.ibm.ecm.cmis.app.servlet.CMISServlet.doGet(CMISServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at com.ibm.ecm.cmis.app.servlet.ParamMappingServlet.service(ParamMappingServlet.java:224)
at com.ibm.ecm.cmis.app.servlet.CMISServlet.service(CMISServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:272)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
}
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:45)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java:515)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.NoArgNewInstanceAction.run(NoArgNewInstanceAction.java:43)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at java.security.AccessController.doPrivileged(AccessController.java:251)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.IIOPInputStream.allocateNewExternalizableObject(IIOPInputStream.java:2323)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.IIOPInputStream.readExternalizable(IIOPInputStream.java:1095)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.IIOPInputStream.simpleReadObjectInternal(IIOPInputStream.java:425)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.IIOPInputStream.simpleReadObjectLoop(IIOPInputStream.java:512)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.IIOPInputStream.simpleReadObject(IIOPInputStream.java:464)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.io.ValueHandlerImpl.readValue(ValueHandlerImpl.java:210)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.iiop.CDRReader.read_value(CDRReader.java:1556)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.util.ProxyUtil.copyObject(ProxyUtil.java:435)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:723)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1156)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at $Proxy39.executeSearch(Unknown Source)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.transport.ejbstubs._Engine_Stub.executeSearch(Unknown Source)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl._executeSearch(EJBSession.java:588)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.transport.ejb.EJBSession$EJBImpl.executeSearch(EJBSession.java:446)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.transport.ejb.EJBSession.executeSearch(EJBSession.java:139)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.util.SessionHandle.executeSearch(SessionHandle.java:190)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.core.Session.callExecuteSearch(Session.java:197)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.core.Session.fetchObjects(Session.java:756)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.core.Session.fetchObjects(Session.java:932)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.apiimpl.query.RepositorySearch.fetchObjects(RepositorySearch.java:164)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.filenet.api.query.SearchScope.fetchObjects(SearchScope.java:217)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.dal.p8.DALP8Folder.getChildren(DALP8Folder.java:354)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.mvc.datasource.cmis.ContentSource.getData(ContentSource.java:138)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.cmis.BaseCollection.get(BaseCollection.java:167)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.cmis.BaseCollection.get(BaseCollection.java:104)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.cmis.ContentFlat.get(ContentFlat.java:64)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.servlet.CMISServlet.doGet(CMISServlet.java:154)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R at com.ibm.ecm.cmis.app.servlet.ParamMappingServlet.service(ParamMappingServlet.java:224)
11/8/10 10:43:52:078 SGT 00000034 SystemErr R ... 23 more

To reproduce the problem , create a document in a folder , and try using CMISPreview for CMIS aspect.
It would throw error.
Updated on 2010-11-08T20:41:57Z at 2010-11-08T20:41:57Z by Dave Sanders
  • Dave Sanders
    Dave Sanders
    8 Posts

    Re: Urgent : CMISPreview not fucntioning properly

    ‏2010-11-08T20:41:57Z  
    From the stack trace, it appears you're using an old (June) Tech Preview. Please use the latest (October) Tech Preview which is available at http://www.ibm.com/developerworks/data/downloads/cmistechpreview/ .

    "DB_BAD_DATATYPE: Bad data type: oracle.sql.RAW" is a known issue with Oracle 11gR2 and is being investigated with Oracle Support. It is intermittent and may be less likely to occur with the October Tech Preview. What version of Oracle are you using?