Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm
384 views
Skip to first unread message
budired...@gmail.com
Apr 2, 2008, 10:24:44 AM4/2/08
to
Hi All,<br />
<br />
We migrated from WSAD5.1 to RAD7 and we setup the data sources.When we try to run the application we got the following Exception.<br />
<br />
Can any body help to reduce this exception?<br />
<br />
Exception:<br />
<br />
<strike>4/2/08 12:27:54:778 IST</strike> 0000002f DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
<strike>4/2/08 12:27:54:809 IST</strike> 0000002f DataAccessReq E PMGR0000E: Call stack:<br />
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:288)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeQuery(ConcreteBeanStatefulInstanceExtensionImpl.java:1626)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1529)<br />
at com.genencor.sdc.ejb.ConcreteLegalEntity_b384583b.ejbFindByRef_id_Ref_type_id_Local(ConcreteLegalEntity_b384583b.java:125)<br />
at com.genencor.sdc.ejb.EJSCMPLegalEntityHomeBean_b384583b.findByRef_id_Ref_type_id_Local(EJSCMPLegalEntityHomeBean_b384583b.java:119)<br />
at com.genencor.sdc.ejb.EJSLocalCMPLegalEntityHome_b384583b.findByRef_id_Ref_type_id(EJSLocalCMPLegalEntityHome_b384583b.java:187)<br />
at com.genencor.sdc.ejb.BaseSessionEJB.ejbCreate(BaseSessionEJB.java:225)<br />
at com.genencor.sdc.ejb.StrainSessionEJBBean.ejbCreate(StrainSessionEJBBean.java:179)<br />
at com.genencor.sdc.ejb.EJSStatefulStrainSessionEJBHomeBean_2abe4c47.create_Local(EJSStatefulStrainSessionEJBHomeBean_2abe4c47.java:91)<br />
at com.genencor.sdc.ejb.EJSLocalStatefulStrainSessionEJBHome_2abe4c47.create(EJSLocalStatefulStrainSessionEJBHome_2abe4c47.java:105)<br />
at com.genencor.sdc.bo.Strain.<init>(Strain.java:92)<br />
at com.genencor.sdc.auth.Session.setContext(Session.java:312)<br />
at com.ibm._jsp._CreateStrain._jspService(_CreateStrain.java:180)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:606)<br />
at com.ibm._jsp._switchpage._jspService(_switchpage.java:514)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)<br />
at javazoom.upload.filter.UploadBeanFilter.doFilter(UploadBeanFilter.java:95)<br />
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)<br />
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)<br />
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)<br />
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)<br />
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)<br />
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)<br />
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)<br />
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)<br />
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)<br />
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist<br />
DSRA0010E: SQL State = 42000, Error Code = 942<br />
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)<br />
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)<br />
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:509)<br />
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)<br />
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1096)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3018)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3059)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.pmiExecuteQuery(WSResourceAdapterBase.java:505)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.executeQuery(WSResourceAdapterBase.java:386)<br />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.FindByRef_id_Ref_type_id(LegalEntityBeanFunctionSet_b384583b.java:493)<b r />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.execute(LegalEntityBeanFunctionSet_b384583b.java:791)<br />
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:528)<br />
at com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeFinder(WSEJBToRAAdapter.java:212)<br />
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:399)<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:125)<br />
... 59 more<br />
<br />
<strike>4/2/08 12:27:54:949 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file D:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_30103010_08.04.02_12.27.54_4.txt<br />
<strike>4/2/08 12:27:54:965 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file D:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_30103010_08.04.02_12.27.54_4.txt<br />
<strike>4/2/08 12:27:54:996 IST</strike> 0000002f ExceptionUtil E CNTR0019E: EJB threw an unexpected (non-declared) exception during invocation of method "findByRef_id_Ref_type_id". Exception data: com.ibm.ws.exception.WsEJBException<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1560)<br />
at com.genencor.sdc.ejb.ConcreteLegalEntity_b384583b.ejbFindByRef_id_Ref_type_id_Local(ConcreteLegalEntity_b384583b.java:125)<br />
at com.genencor.sdc.ejb.EJSCMPLegalEntityHomeBean_b384583b.findByRef_id_Ref_type_id_Local(EJSCMPLegalEntityHomeBean_b384583b.java:119)<br />
at com.genencor.sdc.ejb.EJSLocalCMPLegalEntityHome_b384583b.findByRef_id_Ref_type_id(EJSLocalCMPLegalEntityHome_b384583b.java:187)<br />
at com.genencor.sdc.ejb.BaseSessionEJB.ejbCreate(BaseSessionEJB.java:225)<br />
at com.genencor.sdc.ejb.StrainSessionEJBBean.ejbCreate(StrainSessionEJBBean.java:179)<br />
at com.genencor.sdc.ejb.EJSStatefulStrainSessionEJBHomeBean_2abe4c47.create_Local(EJSStatefulStrainSessionEJBHomeBean_2abe4c47.java:91)<br />
at com.genencor.sdc.ejb.EJSLocalStatefulStrainSessionEJBHome_2abe4c47.create(EJSLocalStatefulStrainSessionEJBHome_2abe4c47.java:105)<br />
at com.genencor.sdc.bo.Strain.<init>(Strain.java:92)<br />
at com.genencor.sdc.auth.Session.setContext(Session.java:312)<br />
at com.ibm._jsp._CreateStrain._jspService(_CreateStrain.java:180)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:606)<br />
at com.ibm._jsp._switchpage._jspService(_switchpage.java:514)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)<br />
at javazoom.upload.filter.UploadBeanFilter.doFilter(UploadBeanFilter.java:95)<br />
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)<br />
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)<br />
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)<br />
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)<br />
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)<br />
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)<br />
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)<br />
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)<br />
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)<br />
Caused by: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:288)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeQuery(ConcreteBeanStatefulInstanceExtensionImpl.java:1626)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1529)<br />
... 57 more<br />
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist<br />
DSRA0010E: SQL State = 42000, Error Code = 942<br />
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)<br />
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)<br />
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:509)<br />
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)<br />
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1096)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3018)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3059)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.pmiExecuteQuery(WSResourceAdapterBase.java:505)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.executeQuery(WSResourceAdapterBase.java:386)<br />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.FindByRef_id_Ref_type_id(LegalEntityBeanFunctionSet_b384583b.java:493)<b r />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.execute(LegalEntityBeanFunctionSet_b384583b.java:791)<br />
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:528)<br />
at com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeFinder(WSEJBToRAAdapter.java:212)<br />
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:399)<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:125)<br />
... 59 more<br />
<br />
<strike>4/2/08 12:27:55:121 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file
<br />
We migrated from WSAD5.1 to RAD7 and we setup the data sources.When we try to run the application we got the following Exception.<br />
<br />
Can any body help to reduce this exception?<br />
<br />
Exception:<br />
<br />
<strike>4/2/08 12:27:54:778 IST</strike> 0000002f DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
<strike>4/2/08 12:27:54:809 IST</strike> 0000002f DataAccessReq E PMGR0000E: Call stack:<br />
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:288)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeQuery(ConcreteBeanStatefulInstanceExtensionImpl.java:1626)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1529)<br />
at com.genencor.sdc.ejb.ConcreteLegalEntity_b384583b.ejbFindByRef_id_Ref_type_id_Local(ConcreteLegalEntity_b384583b.java:125)<br />
at com.genencor.sdc.ejb.EJSCMPLegalEntityHomeBean_b384583b.findByRef_id_Ref_type_id_Local(EJSCMPLegalEntityHomeBean_b384583b.java:119)<br />
at com.genencor.sdc.ejb.EJSLocalCMPLegalEntityHome_b384583b.findByRef_id_Ref_type_id(EJSLocalCMPLegalEntityHome_b384583b.java:187)<br />
at com.genencor.sdc.ejb.BaseSessionEJB.ejbCreate(BaseSessionEJB.java:225)<br />
at com.genencor.sdc.ejb.StrainSessionEJBBean.ejbCreate(StrainSessionEJBBean.java:179)<br />
at com.genencor.sdc.ejb.EJSStatefulStrainSessionEJBHomeBean_2abe4c47.create_Local(EJSStatefulStrainSessionEJBHomeBean_2abe4c47.java:91)<br />
at com.genencor.sdc.ejb.EJSLocalStatefulStrainSessionEJBHome_2abe4c47.create(EJSLocalStatefulStrainSessionEJBHome_2abe4c47.java:105)<br />
at com.genencor.sdc.bo.Strain.<init>(Strain.java:92)<br />
at com.genencor.sdc.auth.Session.setContext(Session.java:312)<br />
at com.ibm._jsp._CreateStrain._jspService(_CreateStrain.java:180)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:606)<br />
at com.ibm._jsp._switchpage._jspService(_switchpage.java:514)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)<br />
at javazoom.upload.filter.UploadBeanFilter.doFilter(UploadBeanFilter.java:95)<br />
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)<br />
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)<br />
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)<br />
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)<br />
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)<br />
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)<br />
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)<br />
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)<br />
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)<br />
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist<br />
DSRA0010E: SQL State = 42000, Error Code = 942<br />
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)<br />
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)<br />
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:509)<br />
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)<br />
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1096)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3018)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3059)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.pmiExecuteQuery(WSResourceAdapterBase.java:505)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.executeQuery(WSResourceAdapterBase.java:386)<br />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.FindByRef_id_Ref_type_id(LegalEntityBeanFunctionSet_b384583b.java:493)<b r />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.execute(LegalEntityBeanFunctionSet_b384583b.java:791)<br />
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:528)<br />
at com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeFinder(WSEJBToRAAdapter.java:212)<br />
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:399)<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:125)<br />
... 59 more<br />
<br />
<strike>4/2/08 12:27:54:949 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file D:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_30103010_08.04.02_12.27.54_4.txt<br />
<strike>4/2/08 12:27:54:965 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file D:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_30103010_08.04.02_12.27.54_4.txt<br />
<strike>4/2/08 12:27:54:996 IST</strike> 0000002f ExceptionUtil E CNTR0019E: EJB threw an unexpected (non-declared) exception during invocation of method "findByRef_id_Ref_type_id". Exception data: com.ibm.ws.exception.WsEJBException<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1560)<br />
at com.genencor.sdc.ejb.ConcreteLegalEntity_b384583b.ejbFindByRef_id_Ref_type_id_Local(ConcreteLegalEntity_b384583b.java:125)<br />
at com.genencor.sdc.ejb.EJSCMPLegalEntityHomeBean_b384583b.findByRef_id_Ref_type_id_Local(EJSCMPLegalEntityHomeBean_b384583b.java:119)<br />
at com.genencor.sdc.ejb.EJSLocalCMPLegalEntityHome_b384583b.findByRef_id_Ref_type_id(EJSLocalCMPLegalEntityHome_b384583b.java:187)<br />
at com.genencor.sdc.ejb.BaseSessionEJB.ejbCreate(BaseSessionEJB.java:225)<br />
at com.genencor.sdc.ejb.StrainSessionEJBBean.ejbCreate(StrainSessionEJBBean.java:179)<br />
at com.genencor.sdc.ejb.EJSStatefulStrainSessionEJBHomeBean_2abe4c47.create_Local(EJSStatefulStrainSessionEJBHomeBean_2abe4c47.java:91)<br />
at com.genencor.sdc.ejb.EJSLocalStatefulStrainSessionEJBHome_2abe4c47.create(EJSLocalStatefulStrainSessionEJBHome_2abe4c47.java:105)<br />
at com.genencor.sdc.bo.Strain.<init>(Strain.java:92)<br />
at com.genencor.sdc.auth.Session.setContext(Session.java:312)<br />
at com.ibm._jsp._CreateStrain._jspService(_CreateStrain.java:180)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:606)<br />
at com.ibm._jsp._switchpage._jspService(_switchpage.java:514)<br />
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:85)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)<br />
at javazoom.upload.filter.UploadBeanFilter.doFilter(UploadBeanFilter.java:95)<br />
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)<br />
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)<br />
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:115)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:168)<br />
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)<br />
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)<br />
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)<br />
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)<br />
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)<br />
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)<br />
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)<br />
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)<br />
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)<br />
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)<br />
Caused by: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@39e639e6<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:288)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeQuery(ConcreteBeanStatefulInstanceExtensionImpl.java:1626)<br />
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeFind(ConcreteBeanStatefulInstanceExtensionImpl.java:1529)<br />
... 57 more<br />
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist<br />
DSRA0010E: SQL State = 42000, Error Code = 942<br />
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)<br />
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)<br />
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)<br />
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:509)<br />
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979)<br />
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)<br />
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1096)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3018)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3059)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.pmiExecuteQuery(WSResourceAdapterBase.java:505)<br />
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.executeQuery(WSResourceAdapterBase.java:386)<br />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.FindByRef_id_Ref_type_id(LegalEntityBeanFunctionSet_b384583b.java:493)<b r />
at com.genencor.sdc.ejb.websphere_deploy.ORACLE_V10_1.LegalEntityBeanFunctionSet_b384583b.execute(LegalEntityBeanFunctionSet_b384583b.java:791)<br />
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:528)<br />
at com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeFinder(WSEJBToRAAdapter.java:212)<br />
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:399)<br />
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:125)<br />
... 59 more<br />
<br />
<strike>4/2/08 12:27:55:121 IST</strike> 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file
ven...@paraconsult.com
Apr 2, 2008, 11:01:50 AM4/2/08
to
Hi All,<br />
<br />
We migrated from WSAD5.1 to RAD7 and we setup the data sources.When we try to run the application we got the following Exception.<br />
<br />
5. We remove the ORACLE_V9_1 backend folder and we create the new backend folder ORACLE_V10_1 by using EJB to RDB Mapping(Top down approach). Change the currentBackendId=ORACLE_V10_1 in ibm-ejb-jar-bnd.xmi<br /><br />
We migrated from WSAD5.1 to RAD7 and we setup the data sources.When we try to run the application we got the following Exception.<br />
<br />
<br />
Exception:<br />
<br />
4/2/08 12:27:54:809 IST 0000002f DataAccessReq E PMGR0000E: Call stack:<br />
4/2/08 12:27:54:965 IST 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file D:\Program Files\IBM\SDP70\runtimes\base_v61\profiles\AppSrv01\logs\ffdc\server1_30103010_08.04.02_12.27.54_4.txt<br />
4/2/08 12:27:54:996 IST 0000002f ExceptionUtil E CNTR0019E: EJB threw an unexpected (non-declared) exception during invocation of method "findByRef_id_Ref_type_id". Exception data: com.ibm.ws.exception.WsEJBException<br />
.. 59 more<br />
<br />
4/2/08 12:27:55:121 IST 0000002f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file<br />
0 new messages