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

Error removing expired index claims from the database.

Solutions on the web3

  • via Google Groups by TestKiller, 1 year ago
    Error removing expired index claims from the database.
  • Error removing expired index claims from the database.
  • COM.ibm.db2.jdbc.DB2Exception: <a href="http://www-128.ibm.com/developerworks/forums/">IBM</a><a href="http://www-128.ibm.com/developerworks/forums/">CLI Driver</a><strike>DB2/NT</strike> SQL0601N The name of the object to be created is identical to the existing name "JCR.TSSTBL_10" of type "TABLE". SQLSTATE=42710
  • Stack trace

    • com.ibm.icm.ts.tss.ls.DatabaseException: Error removing expired index claims from the database. at com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredIndexClaims(LibraryServerImpl.java:300) at com.ibm.icm.ts.tss.ls.LibraryServerImpl.state(LibraryServerImpl.java:53) at com.ibm.icm.ts.tss.app.Janitor.cleanupLibraryServer(Janitor.java:43) at com.ibm.icm.ts.tss.app.JanitorService.cleanupLibraryServer(JanitorService.java:66) at com.ibm.icm.ts.tss.app.JanitorService.access$000(JanitorService.java:22) at com.ibm.icm.ts.tss.app.JanitorService$Notifiee.onEvent(JanitorService.java:110) 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.removeExpiredIndexClaims(BaseDBImpl.java:310) at com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredIndexClaims(LibraryServerImpl.java:293) ... 19 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) ... 21 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) ... 22 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) ... 25 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) ... 29 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 are the first who have seen this exception. Write a tip to help other users and build your expert profile.