Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL0601N The name of the object to be created is identical to the existing

944 views
Skip to first unread message

fli

unread,
Jan 21, 2008, 8:03:42 PM1/21/08
to
I had the following exception in the log file. Anybody knows how to resolve it?<br />
The enviornment is WP6 and DB2.<br />
<br />
Thanks.<br />
<br />
<strike>1/21/08 19:52:47:728 EST</strike> 0000005c JCRCFLLoggerI E com.ibm.icm.ts.tss.JCRCFLLoggerImpl com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredTableClaims [java.lang.ThreadGroup<a href="http://www-128.ibm.com/developerworks/forums/">name=icmciWorkManager: icmjcrear,maxpri=10]</a>: Error creating new search result table: {0}. 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<br />
<br />
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:275)<br />
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Inlined Compiled Code))<br />
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))<br />
at COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statement.java:861)<br />
at COM.ibm.db2.jdbc.app.DB2Statement.executeUpdate(DB2Statement.java:749)<br />
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteUpdate(WSJdbcStatement.java:1235)<br />
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcStatement.java:738)<br />
at com.ibm.icm.ts.tss.ls.BaseDBImpl.executeUpdate(BaseDBImpl.java:89)<br />
at com.ibm.icm.ts.tss.ls.BaseDBImpl.createTable(BaseDBImpl.java:147)<br />
at com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredTableClaims(LibraryServerImpl.java:438)<br />
at com.ibm.icm.ts.tss.ls.LibraryServerImpl.state(LibraryServerImpl.java:52)<br />
at com.ibm.icm.ts.tss.app.Janitor.cleanupLibraryServer(Janitor.java:43)<br />
at com.ibm.icm.ts.tss.app.JanitorService.cleanupLibraryServer(JanitorService.java:66)<br />
at com.ibm.icm.ts.tss.app.JanitorService.access$000(JanitorService.java:22)<br />
at com.ibm.icm.ts.tss.app.JanitorService$Notifiee.onEvent(JanitorService.java:110)<br />
at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.runActivity(ActivityImpl.java:333)<br />
at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.run(ActivityImpl.java:303)<br />
at com.ibm.hrl.workmanager.RunnableWrapper.run(RunnableWrapper.java:44)<br />
at com.ibm.hrl.workmanager.impl.was.WasWork.run(WasWork.java:75)<br />
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:258)<br />
at java.security.AccessController.doPrivileged1(Native Method)<br />
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<br />
at javax.security.auth.Subject.doAs(Subject.java:477)<br />
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:118)<br />
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:325)<br />
at java.security.AccessController.doPrivileged1(Native Method)<br />
at java.security.AccessController.doPrivileged(AccessController.java:351)<br />
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:709)<br />
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:218)<br />
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:154)<br />
at java.lang.Thread.run(Thread.java:570)<br />
<br />
<strike>1/21/08 19:52:47:791 EST</strike> 0000005c JCRCFLLoggerI E com.ibm.icm.ts.tss.JCRCFLLoggerImpl com.ibm.icm.ts.tss.app.Janitor.cleanupLibraryServer [java.lang.ThreadGroup<a href="http://www-128.ibm.com/developerworks/forums/">name=icmciWorkManager: icmjcrear,maxpri=10]</a>: Error getting the library server. com.ibm.icm.ts.tss.ls.DatabaseException: 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<br />
<br />
at com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredTableClaims(LibraryServerImpl.java:443)<br />
at com.ibm.icm.ts.tss.ls.LibraryServerImpl.state(LibraryServerImpl.java:52)<br />
at com.ibm.icm.ts.tss.app.Janitor.cleanupLibraryServer(Janitor.java:43)<br />
at com.ibm.icm.ts.tss.app.JanitorService.cleanupLibraryServer(JanitorService.java:66)<br />
at com.ibm.icm.ts.tss.app.JanitorService.access$000(JanitorService.java:22)<br />
at com.ibm.icm.ts.tss.app.JanitorService$Notifiee.onEvent(JanitorService.java:110)<br />
at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.runActivity(ActivityImpl.java:333)<br />
at com.ibm.icm.ts.act.ActivityImpl$ManagerImpl$ActivityRunner.run(ActivityImpl.java:303)<br />
at com.ibm.hrl.workmanager.RunnableWrapper.run(RunnableWrapper.java:44)<br />
at com.ibm.hrl.workmanager.impl.was.WasWork.run(WasWork.java:75)<br />
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:258)<br />
at java.security.AccessController.doPrivileged1(Native Method)

hlq...@us.ibm.com

unread,
Feb 13, 2008, 2:31:00 PM2/13/08
to
I also have a very similar error: <br />
00000044 JCRCFLLoggerI E com.ibm.icm.ts.tss.JCRCFLLoggerImpl com.ibm.icm.ts.tss.ls.LibraryServerImpl.removeExpiredTableClaims [java.lang.ThreadGroup<a href="http://www-128.ibm.com/developerworks/forums/">name=icmciWorkManager: icmjcrear,maxpri=10]</a>: Error creating new search result table: {0}. 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_1" of type "TABLE". SQLSTATE=42710<br />
<br />
Were you able to fix it?<br />
<br />
Thanks<br />
Henry

mustaph...@ordina.nl

unread,
Apr 29, 2008, 7:12:38 AM4/29/08
to
where you able to fix this?

I get the same exception

thanks

vivek....@netquotient.com

unread,
Jul 14, 2008, 11:03:03 PM7/14/08
to
I ran into the same problem and was able to resolve it by deleting the TSSTBLs and the rows from ICMSTJCRTSTABLES. You can find more information at http://vivekagarwal.wordpress.com/2008/07/14/resolved-an-exception-stacktrace-related-to-quickrwebsphere-portal-search-tables/.
0 new messages