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.jav a:2826)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3115)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2118)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2041)
at com.informix.jdbc.IfxSqli.sendStatementExecute(Ifx Sqli.java:1078)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.j ava:1967)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.j ava:1917)
at com.informix.jdbc.IfxResultSet.executeExecute(IfxR esultSet.java:335)
at com.informix.jdbc.IfxStatement.executeImpl(IfxStat ement.java:770)
at com.informix.jdbc.IfxPreparedStatement.execute(Ifx PreparedStatement.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.jav a:2826)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3115)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2118)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2041)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1193)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1166)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:219)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:716)
at com.informix.jdbc.IfxStatement.executeQuery(IfxSta tement.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_infor mix_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.jav a:3082)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2259)
at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXAS qli.java:119)
at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSq li.java:1444)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1383)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1313)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:216)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:839)
at com.informix.jdbc.IfxPreparedStatement.executeQuer y(IfxPreparedStatement.java:246)
at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:80)
at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebL ogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2 __WebLogic_CMP_RDBMS.java:3697)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.f indByPrimaryKey(RDBMSPersistenceManager.java:239)
at weblogic.ejb20.manager.BaseEntityManager.findByPri maryKey(BaseEntityManager.java:1473)
at weblogic.ejb20.manager.BaseEntityManager.localFind ByPrimaryKey(BaseEntityManager.java:1429)
at weblogic.ejb20.internal.EntityEJBLocalHome.findByP rimaryKey(EntityEJBLocalHome.java:264)
at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_Local HomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHom eImpl.java:277)
at org.ecmc.nib.model.CommonFinders.getBorrowerProfil e(CommonFinders.java:110)
at org.ecmc.nib.model.CommonFinders.getBorrowerProfil eForPlacement(CommonFinders.java:126)
at org.ecmc.nib.model.CollectorWorkFacadeBean.retriev eAddressPhoneInfo(CollectorWorkFacadeBean.java:144 )
at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupC ollectorWorkWindow(CollectorWorkFacadeBean.java:96 )
at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl.lookupCollectorWorkWindow(CollectorWorkFacade_a fjei8_EOImpl.java:46)
at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl_WLSkel.invoke(Unknown
Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:108)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.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(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebL ogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2 __WebLogic_CMP_RDBMS.java:3736)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.f indByPrimaryKey(RDBMSPersistenceManager.java:239)
at weblogic.ejb20.manager.BaseEntityManager.findByPri maryKey(BaseEntityManager.java:1473)
at weblogic.ejb20.manager.BaseEntityManager.localFind ByPrimaryKey(BaseEntityManager.java:1429)
at weblogic.ejb20.internal.EntityEJBLocalHome.findByP rimaryKey(EntityEJBLocalHome.java:264)
at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_Local HomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHom eImpl.java:277)
at org.ecmc.nib.model.CommonFinders.getBorrowerProfil e(CommonFinders.java:110)
at org.ecmc.nib.model.CommonFinders.getBorrowerProfil eForPlacement(CommonFinders.java:126)
at org.ecmc.nib.model.CollectorWorkFacadeBean.retriev eAddressPhoneInfo(CollectorWorkFacadeBean.java:144 )
at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupC ollectorWorkWindow(CollectorWorkFacadeBean.java:96 )
at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl.lookupCollectorWorkWindow(CollectorWorkFacade_a fjei8_EOImpl.java:46)
at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl_WLSkel.invoke(Unknown
Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:108)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.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(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

foof890@hotmail.com (JayDS) wrote in message news:<355a0e46.0404141110.448d64c@posting.google.c om>...
> 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_infor mix_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.jav a:3082)
> at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3396)
> at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2259)
> at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXAS qli.java:119)
> at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSq li.java:1444)
> at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1383)
> at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1313)
> at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:216)
> at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:839)
> at com.informix.jdbc.IfxPreparedStatement.executeQuer y(IfxPreparedStatement.java:246)
> at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:80)
> at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebL ogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2 __WebLogic_CMP_RDBMS.java:3697)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.f indByPrimaryKey(RDBMSPersistenceManager.java:239)
> at weblogic.ejb20.manager.BaseEntityManager.findByPri maryKey(BaseEntityManager.java:1473)
> at weblogic.ejb20.manager.BaseEntityManager.localFind ByPrimaryKey(BaseEntityManager.java:1429)
> at weblogic.ejb20.internal.EntityEJBLocalHome.findByP rimaryKey(EntityEJBLocalHome.java:264)
> at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_Local HomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHom eImpl.java:277)
> at org.ecmc.nib.model.CommonFinders.getBorrowerProfil e(CommonFinders.java:110)
> at org.ecmc.nib.model.CommonFinders.getBorrowerProfil eForPlacement(CommonFinders.java:126)
> at org.ecmc.nib.model.CollectorWorkFacadeBean.retriev eAddressPhoneInfo(CollectorWorkFacadeBean.java:144 )
> at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupC ollectorWorkWindow(CollectorWorkFacadeBean.java:96 )
> at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl.lookupCollectorWorkWindow(CollectorWorkFacade_a fjei8_EOImpl.java:46)
> at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl_WLSkel.invoke(Unknown
> Source)
> at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
> at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:108)
> at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
> at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
> at weblogic.security.service.SecurityManager.runAs(Se curityManager.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(ExecuteThrea d.java:197)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
>
> at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2__WebL ogic_CMP_RDBMS.ejbFindByPrimaryKey(Boprofil_26bdr2 __WebLogic_CMP_RDBMS.java:3736)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.f indByPrimaryKey(RDBMSPersistenceManager.java:239)
> at weblogic.ejb20.manager.BaseEntityManager.findByPri maryKey(BaseEntityManager.java:1473)
> at weblogic.ejb20.manager.BaseEntityManager.localFind ByPrimaryKey(BaseEntityManager.java:1429)
> at weblogic.ejb20.internal.EntityEJBLocalHome.findByP rimaryKey(EntityEJBLocalHome.java:264)
> at org.ecmc.lms.model.eboprofil.Boprofil_26bdr2_Local HomeImpl.findByPrimaryKey(Boprofil_26bdr2_LocalHom eImpl.java:277)
> at org.ecmc.nib.model.CommonFinders.getBorrowerProfil e(CommonFinders.java:110)
> at org.ecmc.nib.model.CommonFinders.getBorrowerProfil eForPlacement(CommonFinders.java:126)
> at org.ecmc.nib.model.CollectorWorkFacadeBean.retriev eAddressPhoneInfo(CollectorWorkFacadeBean.java:144 )
> at org.ecmc.nib.model.CollectorWorkFacadeBean.lookupC ollectorWorkWindow(CollectorWorkFacadeBean.java:96 )
> at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl.lookupCollectorWorkWindow(CollectorWorkFacade_a fjei8_EOImpl.java:46)
> at org.ecmc.nib.model.CollectorWorkFacade_afjei8_EOIm pl_WLSkel.invoke(Unknown
> Source)
> at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
> at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:108)
> at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
> at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
> at weblogic.security.service.SecurityManager.runAs(Se curityManager.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(ExecuteThrea d.java:197)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

Did u find a solution?

Regards,
Alex

alex_de_souza@hotmail.com (Alex) wrote in message
> Did u find a solution?

Unfortunately, no. And I can find no other references to this problem,
which is why I posted a followup to your original post.

Have you found a solution?

: jay

This error is probably due to a remaining connection in the database
that is locking any of the system tables. You can check the database
conecctions (in informix -> onstat -g ses ) and check for the user that
use the database you are using, if you find those users that are leaving
the conection open kill the sessions (->onmode -z <sessionId>)

If your are using a datasoure or a direct conection check that every of
them get closed, also check that in error case you close the conecction to
the database.

It's good practice to put a time out in the datasource connection, to
assure the closing.