Error during migration from rtc 2.0.0.2
I migrate a rtc server 2.0.0.2 to 3.0 and the execution of addTable script return the follow error:
2010-12-17 14:11:12,306 Running post addTables for "com.ibm.team.workitem.linkClosure"... 2010-12-17 14:11:14,724 Failing ast query ----------- RelationQueryModel r = RelationQueryModel.ROOT; AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r); q.filter(r.target().itemId()._inLargeList)._and(r.source().itemId()._inLargeList))); ----------- IDynamicQueryModel d = ItemUtil.itemTypeFor("Relation", "com.ibm.team.workitem.linkClosure").getQueryModel(); IItemQuery q = IItemQuery.FACTORY.newInstance((IDynamicItemQueryModel) d); q.filter(r.target().itemId()._inLargeList)._and(r.source().itemId()._inLargeList))); ----------- failed to generate sql! 2010-12-17 14:11:14,725 InternalRepositoryException processing query com.ibm.team.repository.common.InternalRepositoryException: unable to build temp table at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:104) at com.ibm.team.repository.service.internal.ExecuteDataQuery.doServerQueryData(ExecuteDataQuery.java:80) at com.ibm.team.repository.service.internal.ExecuteDataQuery.doQueryData(ExecuteDataQuery.java:122) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892) at com.ibm.team.repository.service.internal.AbstractQueryService.performQuery(AbstractQueryService.java:68) at com.ibm.team.repository.service.internal.QueryService.doExecuteItemQuery(QueryService.java:334) at com.ibm.team.repository.service.internal.QueryService.access$0(QueryService.java:329) at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:176) at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:440) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:267) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332) at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy51.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:219) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:119) at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy88.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.QueryService.executeItemQuery(QueryService.java:165) at com.ibm.team.repository.service.internal.QueryService.queryItems(QueryService.java:475) at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy114.queryItems(Unknown Source) at com.ibm.team.repository.service.internal.SecureQueryService.queryItems(SecureQueryService.java:52) at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:87) at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:1) at com.ibm.team.workitem.service.internal.ServerServiceContext.callCancelableService(ServerServiceContext.java:31) at com.ibm.team.workitem.common.internal.AuditableCommon.queryItemsInContext(AuditableCommon.java:91) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at com.ibm.team.workitem.service.internal.ServiceAdapter.invoke(ServiceAdapter.java:74) at $Proxy373.queryItemsInContext(Unknown Source) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy375.queryItemsInContext(Unknown Source) at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.update(ItemQueryIterator.java:78) at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.hasNext(ItemQueryIterator.java:58) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.getExistingRelations(LinkClosureService.java:373) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.addRelation(LinkClosureService.java:337) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.addRelationFromExistingLink(LinkClosureService.java:290) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy381.addRelationFromExistingLink(Unknown Source) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureMigrationHandler.processLinks(LinkClosureMigrationHandler.java:62) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureMigrationHandler.postAddTables(LinkClosureMigrationHandler.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy481.postAddTables(Unknown Source) at com.ibm.team.repository.migration.internal.service.MigrationHandlerDispatcher.postAddTables(MigrationHandlerDispatcher.java:551) at com.ibm.team.repository.migration.internal.service.MigrationHandlerDispatcher.postAddTables(MigrationHandlerDispatcher.java:543) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.performPostAddTables(DatabaseMaintenanceService.java:1200) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.performPostAddTables(DatabaseMaintenanceService.java:305) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy117.performPostAddTables(Unknown Source) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.addTables(AddTablesCommand.java:61) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.execute(AddTablesCommand.java:118) at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:56) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311) at org.eclipse.equinox.launcher.Main.main(Main.java:1287) Caused by: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=JAZZTMPSPACE, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:676) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.km.b(km.java:2164) at com.ibm.db2.jcc.am.km.c(km.java:2147) at com.ibm.db2.jcc.t4.db.k(db.java:354) at com.ibm.db2.jcc.t4.db.a(db.java:60) at com.ibm.db2.jcc.t4.t.a(t.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:218) at com.ibm.db2.jcc.am.lm.ec(lm.java:2692) at com.ibm.db2.jcc.am.lm.b(lm.java:3552) at com.ibm.db2.jcc.am.lm.Wb(lm.java:690) at com.ibm.db2.jcc.am.lm.executeUpdate(lm.java:673) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeUpdate(AbstractDbProvider.java:1486) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLargeInListValueTempTable(AbstractDbProvider.java:1226) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy50.newLargeInListValueTempTable(Unknown Source) at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:96) ... 107 more 2010-12-17 14:11:14,731 CRJAZ0683I An error occurred during the post-import handler for the "com.ibm.team.workitem.linkClosure" namespace. com.ibm.team.repository.common.InternalRepositoryException: CRJAZ1037I The following SQL query did not execute properly on the server. RelationQueryModel r = RelationQueryModel.ROOT; AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r); q.filter(r.target().itemId()._inLargeList)._and(r.source().itemId()._inLargeList))); at com.ibm.team.repository.service.internal.ExecuteDataQuery.doServerQueryData(ExecuteDataQuery.java:106) at com.ibm.team.repository.service.internal.ExecuteDataQuery.doQueryData(ExecuteDataQuery.java:122) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892) at com.ibm.team.repository.service.internal.AbstractQueryService.performQuery(AbstractQueryService.java:68) at com.ibm.team.repository.service.internal.QueryService.doExecuteItemQuery(QueryService.java:334) at com.ibm.team.repository.service.internal.QueryService.access$0(QueryService.java:329) at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:176) at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:440) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:267) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332) at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy51.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:219) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:119) at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy88.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.QueryService.executeItemQuery(QueryService.java:165) at com.ibm.team.repository.service.internal.QueryService.queryItems(QueryService.java:475) at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy114.queryItems(Unknown Source) at com.ibm.team.repository.service.internal.SecureQueryService.queryItems(SecureQueryService.java:52) at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:87) at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:1) at com.ibm.team.workitem.service.internal.ServerServiceContext.callCancelableService(ServerServiceContext.java:31) at com.ibm.team.workitem.common.internal.AuditableCommon.queryItemsInContext(AuditableCommon.java:91) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at com.ibm.team.workitem.service.internal.ServiceAdapter.invoke(ServiceAdapter.java:74) at $Proxy373.queryItemsInContext(Unknown Source) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy375.queryItemsInContext(Unknown Source) at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.update(ItemQueryIterator.java:78) at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.hasNext(ItemQueryIterator.java:58) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.getExistingRelations(LinkClosureService.java:373) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.addRelation(LinkClosureService.java:337) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureService.addRelationFromExistingLink(LinkClosureService.java:290) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy381.addRelationFromExistingLink(Unknown Source) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureMigrationHandler.processLinks(LinkClosureMigrationHandler.java:62) at com.ibm.team.workitem.service.internal.linkClosure.LinkClosureMigrationHandler.postAddTables(LinkClosureMigrationHandler.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy481.postAddTables(Unknown Source) at com.ibm.team.repository.migration.internal.service.MigrationHandlerDispatcher.postAddTables(MigrationHandlerDispatcher.java:551) at com.ibm.team.repository.migration.internal.service.MigrationHandlerDispatcher.postAddTables(MigrationHandlerDispatcher.java:543) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.performPostAddTables(DatabaseMaintenanceService.java:1200) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.performPostAddTables(DatabaseMaintenanceService.java:305) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy117.performPostAddTables(Unknown Source) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.addTables(AddTablesCommand.java:61) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.execute(AddTablesCommand.java:118) at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:56) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311) at org.eclipse.equinox.launcher.Main.main(Main.java:1287) Caused by: com.ibm.team.repository.common.InternalRepositoryException: unable to build temp table at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:104) at com.ibm.team.repository.service.internal.ExecuteDataQuery.doServerQueryData(ExecuteDataQuery.java:80) ... 106 more Caused by: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=JAZZTMPSPACE, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:676) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.km.b(km.java:2164) at com.ibm.db2.jcc.am.km.c(km.java:2147) at com.ibm.db2.jcc.t4.db.k(db.java:354) at com.ibm.db2.jcc.t4.db.a(db.java:60) at com.ibm.db2.jcc.t4.t.a(t.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:218) at com.ibm.db2.jcc.am.lm.ec(lm.java:2692) at com.ibm.db2.jcc.am.lm.b(lm.java:3552) at com.ibm.db2.jcc.am.lm.Wb(lm.java:690) at com.ibm.db2.jcc.am.lm.executeUpdate(lm.java:673) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeUpdate(AbstractDbProvider.java:1486) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLargeInListValueTempTable(AbstractDbProvider.java:1226) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy50.newLargeInListValueTempTable(Unknown Source) at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:96) ... 107 more I continued the migration and now when i try to remove a link from a work item i get an error. What can I do for correct this error. Anyone can help me? Thank you. Luca. |
6 answers
Ralph Schoon (63.4k●3●36●46)
| answered Jan 20 '11, 3:42 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Luca,
I think I remember there were new temp tables introduces somewhere in the steps going to one of the 2.0.0.x. There was specific documentation on how to create those and migrate. Maybe these are missing and that causes the problem. Would be great if you could provide more information on your infrastructure. OS, DB, .... Some suggestions: 1. Check the DB log files, in case there are other reasons why the temp tables can not be created. 2. I'd suggest to try to migrate to 2.0.0.5 first and make sure you updated the Database and the tables as mentioned in the release notes. Then migrate to 3.0. Thanks, Ralph I migrate a rtc server 2.0.0.2 to 3.0 and the execution of addTable script return the follow error: |
|
Ralph Schoon (63.4k●3●36●46)
| answered Jan 20 '11, 3:49 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,
when re-checking your logs I found you are using DB2.... Please try to look up the DB2 Error Code 204 that shows up below. Maybe you can fix that. Otherwise you could try my other suggestions or create PMR or a work item. Thanks, Ralph I migrate a rtc server 2.0.0.2 to 3.0 and the execution of addTable script return the follow error: |
|
Ralph,
thank you for your reply. The error code means object not found and I believe your suggest about temp table is correct. But, I have only this error in the log files and I don't know what are the missing table(s). I tried install 2.0.0.5 before migration but I got the same error. Furthermore I have another problem: my RTC 3.0 server is in production environment and I must fix this database without lost data. There is a way to export all data, re-create and empty database (I hope correct) and populate it from the export? Or there is another way to fix the database? I insert the work item 150578 about an error removing link from a work item and I think that the reason is the corrupted database. How can fix it? Luca. Hi, I migrate a rtc server 2.0.0.2 to 3.0 and the execution of addTable script return the follow error: |
|
Ralph Schoon (63.4k●3●36●46)
| answered Jan 20 '11, 5:03 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Luca,
seriously I am not sure about the implications when you started working on a 3.0 DB that was only partially migrated. I certainly would have hold back the migration and tried to fix the root cause before going productive. Have you experienced data losses? Having said that, what you could do is - on a isolated test system - use the repotools (there is one for each capability in your case repotools-jts and repotools-jazz) to fix the issue. You could try -verify --Verify the integrity of the database tables. --Path to the teamserver.properties file. --Path to the log file. --The level at which to perform verification. You could try to use the command that adds missing tables, you could try to recreate the indexes. In general you could try a -export to export your databases, recreate the databases and do a -import. This would also cause the datawarehouse and the search indices to be refilled. I would also suggest to post a new subject about how to fix your DB in this forum. If you have support you could create a PMR to ask for suggestions. If you try the suggestion above, if it works after thorough testing the outcome you could do the same in your production environment. You might want to check here to understand a bit better how the pieces belong together too: http://jazz.net/library/article/547. Just some thoughts, Ralph Ralph, Hi, I migrate a rtc server 2.0.0.2 to 3.0 and the execution of addTable script return the follow error: |
|
Ralph,
I using export and import like you suggest and I solve my problem. Thank you very much. Luca. Hi Luca, |
|
Ralph Schoon (63.4k●3●36●46)
| answered Jan 24 '11, 3:28 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Luca,
I am glad you got it fixed! Ralph Ralph, |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.