|
Hello,
We are facing a problem, after deployment and partial execution of code
when we try to fetch the data populated in an EJB by the get methods
defined in the ejb, the server responds after a long interval of time with
the following exception.(the data is populated by a call to finder method,
The debug JAWS trace shows the successfull populating of the parameters)
This problem is eratic, that is the problem appears at times and at
times the code works fine.The problem also appears at times after the STORE
method of the same ejb is called.
Has anybody any idea regarding this.
Thanx in advance.
Transaction XidImpl [FormatId=257, GlobalId=hpv2k.cdotd.ernet.in//99,
BranchQual=] timed out. status=STATUS_ACTIVE
[JAWS] java.sql.SQLException: ORA-02049: timeout: distributed transaction
waiting for lock
[JAWS] ORA-02063: preceding line from PRD
[JAWS]
[JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
[JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[JAWS] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
[JAWS] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
[JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
[JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
[JAWS] at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
[JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
[JAWS] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:322)
[JAWS] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97)
[JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156)
[JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401)
[JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342)
[JAWS] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228)
[JAWS] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322)
[JAWS] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323)
[JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:482)
[JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:146)
[JAWS] at org.jboss.proxy.ProxyCompiler$Runtime.invoke(ProxyCompiler.java:74)
[JAWS] at cdot.smp.com.admin.location.ejb.EbInlocdata$Proxy.getLocname(Unknown
Source)
[JAWS] at cdot.smp.com.login.jb.JbUserSession.setLocation(JbUserSession.java:309)
[JAWS] at cdot.smp.com.login.jb.JbUserSession.init(JbUserSession.java:257)
[JAWS] at cdot.smp.com.login.jb.JbUserSession.processRequest(JbUserSession.java:184)
[JAWS] at cd_00025t.smp.jsp.login._0002fcdot_0002fsmp_0002fjsp_0002flogin_0002fLogin_0002ejspLogin_jsp_27._jspService(_0002fcdot_0002fsmp_0002fjsp_0002flogin_0002fLogin_0002ejspLogin_jsp_27.java:117)
[JAWS] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
[JAWS] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
[JAWS] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[JAWS] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[JAWS] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[JAWS] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
[JAWS] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[JAWS] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[JAWS] at java.lang.Thread.run(Unknown Source)
[EbInlocdataBean] java.rmi.ServerException: Store failed; nested exception
is:
[EbInlocdataBean] java.sql.SQLException:
ORA-02049: timeout: distributed transaction waiting for lock
[EbInlocdataBean] ORA-02063: preceding line from PRD
[EbInlocdataBean]
[EbInlocdataBean] java.sql.SQLException: ORA-02049: timeout: distributed
transaction waiting for lock
[EbInlocdataBean] ORA-02063: preceding line from PRD
[EbInlocdataBean]
[EbInlocdataBean] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
[EbInlocdataBean] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[EbInlocdataBean] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[EbInlocdataBean] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[EbInlocdataBean] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
[EbInlocdataBean] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
[EbInlocdataBean] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
[EbInlocdataBean] at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
[EbInlocdataBean] at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
[EbInlocdataBean] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
[EbInlocdataBean] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:322)
[EbInlocdataBean] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
[EbInlocdataBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[EbInlocdataBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160)
[EbInlocdataBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97)
[EbInlocdataBean] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156)
[EbInlocdataBean] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401)
[EbInlocdataBean] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342)
[EbInlocdataBean] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228)
[EbInlocdataBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322)
[EbInlocdataBean] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
[EbInlocdataBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318)
[EbInlocdataBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[EbInlocdataBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190)
[EbInlocdataBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[EbInlocdataBean] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323)
[EbInlocdataBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:482)
[EbInlocdataBean] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:146)
[EbInlocdataBean] at org.jboss.proxy.ProxyCompiler$Runtime.invoke(ProxyCompiler.java:74)
[EbInlocdataBean] at cdot.smp.com.admin.location.ejb.EbInlocdata$Proxy.getLocname(Unknown
Source)
[EbInlocdataBean] at cdot.smp.com.login.jb.JbUserSession.setLocation(JbUserSession.java:309)
[EbInlocdataBean] at cdot.smp.com.login.jb.JbUserSession.init(JbUserSession.java:257)
[EbInlocdataBean] at cdot.smp.com.login.jb.JbUserSession.processRequest(JbUserSession.java:184)
[EbInlocdataBean] at cd_00025t.smp.jsp.login._0002fcdot_0002fsmp_0002fjsp_0002flogin_0002fLogin_0002ejspLogin_jsp_27._jspService(_0002fcdot_0002fsmp_0002fjsp_0002flogin_0002fLogin_0002ejspLogin_jsp_27.java:117)
[EbInlocdataBean] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[EbInlocdataBean] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[EbInlocdataBean] at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
[EbInlocdataBean] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
[EbInlocdataBean] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
[EbInlocdataBean] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[EbInlocdataBean] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[EbInlocdataBean] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[EbInlocdataBean] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[EbInlocdataBean] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[EbInlocdataBean] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[EbInlocdataBean] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
[EbInlocdataBean] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[EbInlocdataBean] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[EbInlocdataBean] at java.lang.Thread.run(Unknown
Source)
--
manisha
------------------------------------------------------------------------------
Strive for "PERFECTION"
------------------------------------------------------------------------------
|
