Re: Internal Error while trying to set up start or end key for index read

foof890@hotmail.com (JayDS) wrote in message news:<355a0e46.0404141110.448d64c@posting.google.com>... > We've run into the same situation using WLS81SP2 with the IBM Informix > drivers > version 2.21JC5. Our application works fine initially, performing some > tasks > just fine. But after a few repitions, we get > > javax.ejb.FinderException: Problem in findByPrimaryKey while preparing > or executing statement: > 'weblogic.jdbc.wrapper.PreparedStatement_com_informix_jdbc_IfxPreparedStatement@45c': > java.sql.SQLException: [Internal] Error while trying to set up start > or end key for index read [fmstopset_release] > java.sql.SQLException: [Internal] Error while trying to set up start > or end key for index read [fmstopset_release] > at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3082) > at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396) > at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) > at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:119) > at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSqli.java:1444) > at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1383) > at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1313) > at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:216) > at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:839) > at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:246) > at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80) > at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2__WebLogic_CMP_RDBMS.java:3697) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:239) > at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:1473) > at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:1429) > at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:264) > at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_LocalHomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHomeImpl.java:277) > at org.ecmc.nib.model.CommonFinders.getBorrowerProfile(CommonFinders.java:110) > at org.ecmc.nib.model.CommonFinders.getBorrowerProfileForPlacement(CommonFinders.java:126) > at org.ecmc.nib.model.CollectorWorkFacadeBean.retrieveAddressPhoneInfo(CollectorWorkFacadeBean.java:144) > at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupCollectorWorkWindow(CollectorWorkFacadeBean.java:96) > at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOImpl.lookupCollectorWorkWindow(CollectorWorkFacade_afjei8_EOImpl.java:46) > at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOImpl_WLSkel.invoke(Unknown > Source) > at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:477) > at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:108) > at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:353) > at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:144) > at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:415) > at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) > > at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebLogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2__WebLogic_CMP_RDBMS.java:3736) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.findByPrimaryKey(RDBMSPersistenceManager.java:239) > at weblogic.ejb20.manager.BaseEntityManager.findByPrimaryKey(BaseEntityManager.java:1473) > at weblogic.ejb20.manager.BaseEntityManager.localFindByPrimaryKey(BaseEntityManager.java:1429) > at weblogic.ejb20.internal.EntityEJBLocalHome.findByPrimaryKey(EntityEJBLocalHome.java:264) > at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_LocalHomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHomeImpl.java:277) > at org.ecmc.nib.model.CommonFinders.getBorrowerProfile(CommonFinders.java:110) > at org.ecmc.nib.model.CommonFinders.getBorrowerProfileForPlacement(CommonFinders.java:126) > at org.ecmc.nib.model.CollectorWorkFacadeBean.retrieveAddressPhoneInfo(CollectorWorkFacadeBean.java:144) > at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupCollectorWorkWindow(CollectorWorkFacadeBean.java:96) > at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOImpl.lookupCollectorWorkWindow(CollectorWorkFacade_afjei8_EOImpl.java:46) > at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOImpl_WLSkel.invoke(Unknown > Source) > at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:477) > at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:108) > at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:353) > at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:144) > at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:415) > at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Did u find a solution? Regards, Alex