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

Hi *, I've implemented a little java class which is being called through a cron-job every night and it has the following main tasks to accomplish: 1) Reading a *.CSV file 2) Searching on table 3) Comparing every single field for this registry 4) Making changes or inserting new registry 5) Finally writting a protocol registry in another table for every change As you can imagine I have an amount of searching statements (SELECT) and introducing new registries (INSERT). Of course, I'm using an index to do this. After awhile I am getting: 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:2826) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3115) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2118) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2041) at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1078) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1967) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1917) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:335) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:770) at com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatement.java:280) at compas.batch.EEPVLoad.changes(EEPVLoad.java:311) at compas.batch.EEPVLoad.readFile(EEPVLoad.java:229) at compas.batch.EEPVLoad.main(EEPVLoad.java:722) Error: Cannot read system catalog (systables). java.sql.SQLException: Cannot read system catalog (systables). at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2826) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3115) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2118) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2041) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1193) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1166) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:219) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:716) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:118) at compas.batch.EEPVLoad.searchReg(EEPVLoad.java:550) at compas.batch.EEPVLoad.readFile(EEPVLoad.java:235) And the Data Base is hanging out. If you have any idea please let me know, I’ll be thankfully. Cheers, Alex

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)