com.ibm.icm.ts.tss.ls.DatabaseException

Error getting index from database for update .

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web3

  • Error getting index from database for update .
  • via Google Groups by TestKiller, 1 year ago
    Error removing expired index claims from the database.
  • Stack trace

    • com.ibm.icm.ts.tss.ls.DatabaseException: Error getting index from database for update . at com.ibm.icm.ts.tss.ls.LibraryServerImpl.getIndexToUpdate(LibraryServerImpl.java:269) at com.ibm.icm.ts.tss.ls.LibraryServerImpl.pendingReader(LibraryServerImpl.java:93) at com.ibm.icm.ts.tss.app.IndexMaintainer.runIndexMaintenance(IndexMaintainer.java:138) at com.ibm.icm.ts.tss.app.IndexMaintainer.checkForUpdates(IndexMaintainer.java:119) at com.ibm.icm.ts.tss.app.IndexMaintenanceService.checkForUpdates(IndexMaintenanceService.java:65) at com.ibm.icm.ts.tss.app.IndexMaintenanceService.access$000(IndexMaintenanceService.java:27) at com.ibm.icm.ts.tss.app.IndexMaintenanceService$Notifiee.onEvent(IndexMaintenanceService.java:114) at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.runActivity(ActivityImpl.java:333) at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.run(ActivityImpl.java:303) at com.ibm.hrl.workmanager.RunnableWrapper.run(RunnableWrapper.java:44) at com.ibm.hrl.workmanager.impl.was.WasWork.run(WasWork.java:75) at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:261) at java.security.AccessController.doPrivileged(AccessController.java:219) at javax.security.auth.Subject.doAs(Subject.java:495) at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:118) at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:328) at java.security.AccessController.doPrivileged(AccessController.java:246) at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:757) at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:218) at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:158) at java.lang.Thread.run(Thread.java:811) Caused by: java.sql.SQLException: ConnectionWrapper.getConnection() at com.ibm.icm.ts.tss.ls.BaseDBImpl$ConnectionWrapper.getConnection(BaseDBImpl.java:1411) at com.ibm.icm.ts.tss.ls.BaseDBImpl.executeQuery(BaseDBImpl.java:252) at com.ibm.icm.ts.tss.ls.BaseDBImpl.findUnclaimedIndex(BaseDBImpl.java:719) at com.ibm.icm.ts.tss.ls.BaseDBImpl.claimUnprocessedIndex(BaseDBImpl.java:704) at com.ibm.icm.ts.tss.ls.LibraryServerImpl.getIndexToUpdate(LibraryServerImpl.java:265) ... 20 more Caused by: com.ibm.icm.ci.CDMException: Failed to get a connection from the pool at com.ibm.icm.ci.ConnectionService.getConnection(ConnectionService.java:80) at com.ibm.icm.ts.tss.ls.BaseDBImpl$ConnectionWrapper.getConnection(BaseDBImpl.java:1408) ... 24 more Caused by: java.sql.SQLException: addSync: caught Exception at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1376) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:462) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:418) at com.ibm.icm.ci.Datastore$DataSource.getConnection(Datastore.java:596) at com.ibm.icm.ci.ConnectionService.getConnection(ConnectionService.java:67) ... 25 more Caused by: javax.resource.ResourceException: addSync: caught Exception at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:300) at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:1337) at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:1062) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:612) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:449) ... 28 more Caused by: javax.transaction.RollbackException: Transaction rolled back at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3546) at com.ibm.ws.Transaction.JTA.TransactionImpl.registerSynchronization(TransactionImpl.java:3525) at com.ibm.ws.Transaction.JTA.TranManagerSet.registerSynchronization(TranManagerSet.java:514) at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:290) ... 32 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.