Hello,

when we reconfigured a team release plan to always load all execution items error CRJAZ1037I appeared.
It seems to be connected with inability to create temporary tables.
Could the upgrade to iFix4 help?


Thank you in advance

David Csikkel



ERRORLOG:

com.ibm.team.repository.common.InternalRepositoryException: CRJAZ1037I Failing query ->

WorkItemQueryModel r = WorkItemQueryModel.ROOT;
AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r);
q.select(r.itemId());
q.select(r.stateId());
q.select(r.duration());
q.select(r.correctedEstimate());
q.select(r.timeSpent());
q.select(r.internalState());
q.select(r.workItemType());
q.select(r.category().itemId());
q.select(r.target().itemId());
q.select(r.owner().itemId());
q.filter(r.target()._eq(q.newItemHandleArg())._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._or(r.target()._eq(q.newItemHandleArg()))._and(r.category().itemId()._inLargeList)));

at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:931)

at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892)

at com.ibm.team.repository.service.internal.QueryService.performQuery(QueryService.java:569)

at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQuery(QueryService.java:374)

at com.ibm.team.repository.service.internal.QueryService.access$2(QueryService.java:367)

at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1062)

at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:320)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:79)

at sun.reflect.GeneratedMethodAccessor78.invoke(null)

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 $Proxy43.runInTransaction(null)

at com.ibm.team.repository.service.internal.QueryService.doQueryData(QueryService.java:1054)

at com.ibm.team.repository.service.internal.QueryService.queryDataInContext(QueryService.java:1012)

at com.ibm.team.repository.service.internal.QueryService.queryData(QueryService.java:1030)

at sun.reflect.GeneratedMethodAccessor123.invoke(null)

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 $Proxy58.queryData(null)

at com.ibm.team.repository.service.internal.SecureQueryService.queryData(SecureQueryService.java:140)

at com.ibm.team.apt.internal.common.util.DataQueryRowIterator.<init>(DataQueryRowIterator.java:40)

at com.ibm.team.apt.internal.common.util.DataQueryRowIterator.<init>(DataQueryRowIterator.java:30)

at com.ibm.team.apt.internal.service.tools.WorkItemInfo$DataRowIterator.<init>(WorkItemInfo.java:58)

at com.ibm.team.apt.internal.service.tools.AbstractPlanResolveHelper.createWorkItemInfoIterator(AbstractPlanResolveHelper.java:676)

at com.ibm.team.apt.internal.service.progress.PlanProgressHelper.computeProgress(PlanProgressHelper.java:158)

at com.ibm.team.apt.internal.service.progress.PlanProgressHelper.getIterationPlanProgressRcp(PlanProgressHelper.java:79)

at com.ibm.team.apt.internal.service.IterationPlanService$6.run(IterationPlanService.java:380)

at com.ibm.team.apt.internal.service.IterationPlanService$6.run(IterationPlanService.java:1)

at com.ibm.team.repository.service.internal.TransactionService$1.run(TransactionService.java:104)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:320)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:79)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:68)

at sun.reflect.GeneratedMethodAccessor142.invoke(null)

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 $Proxy44.runInTransaction(null)

at com.ibm.team.repository.service.AbstractService.runInTransaction(AbstractService.java:772)

at com.ibm.team.apt.internal.service.IterationPlanService.fetchPlanProgress2(IterationPlanService.java:376)

at com.ibm.team.apt.internal.service.IterationPlanService$4.run(IterationPlanService.java:214)

at com.ibm.team.repository.service.internal.TransactionService$1.run(TransactionService.java:104)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)

at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:331)

at sun.reflect.GeneratedMethodAccessor64.invoke(null)

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 $Proxy21.withCurrentConnection(null)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:79)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:68)

at sun.reflect.GeneratedMethodAccessor142.invoke(null)

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 $Proxy44.runInTransaction(null)

at com.ibm.team.repository.service.AbstractService.runInTransaction(AbstractService.java:772)

at com.ibm.team.apt.internal.service.IterationPlanService.fetchResolvedIterationPlan2(IterationPlanService.java:154)

at sun.reflect.GeneratedMethodAccessor276.invoke(null)

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 $Proxy242.fetchResolvedIterationPlan2(null)

at sun.reflect.GeneratedMethodAccessor276.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleMethod(AbstractTeamServerServlet.java:1170)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.executeMethod(AbstractTeamServerServlet.java:926)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPost(AbstractTeamServerServlet.java:728)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1773)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1642)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1555)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)

at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:811)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(MarshallerUtil.java:326)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(MarshallerUtil.java:296)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeFault(MarshallerUtil.java:261)

at com.ibm.team.repository.transport.client.RemoteTeamService.constructExceptionFromFault(RemoteTeamService.java:613)

at com.ibm.team.repository.transport.client.RemoteTeamService.executeMethod(RemoteTeamService.java:483)

at com.ibm.team.repository.transport.client.RemoteTeamService.invoke(RemoteTeamService.java:201)

at com.ibm.team.repository.transport.client.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:43)

at $Proxy58.fetchResolvedIterationPlan2(Unknown Source)

at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invokeServiceCall(ServiceInterfaceProxy.java:149)

at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invoke(ServiceInterfaceProxy.java:84)

at $Proxy58.fetchResolvedIterationPlan2(Unknown Source)

at com.ibm.team.apt.internal.client.IterationPlanClient$1.run(IterationPlanClient.java:345)

at com.ibm.team.apt.internal.client.IterationPlanClient$1.run(IterationPlanClient.java:1)

at com.ibm.team.repository.client.internal.TeamRepository$3.run(TeamRepository.java:1169)

at com.ibm.team.repository.common.transport.CancelableCaller.call(CancelableCaller.java:79)

at com.ibm.team.repository.client.internal.TeamRepository.callCancelableService(TeamRepository.java:1162)

at com.ibm.team.apt.internal.client.IterationPlanClient.fetchIterationPlanData(IterationPlanClient.java:348)

at com.ibm.team.apt.internal.ide.ui.editor.IterationPlanEditorInput$2.resolve(IterationPlanEditorInput.java:142)

at com.ibm.team.apt.internal.ide.ui.editor.IterationPlanEditorInput$2.resolve(IterationPlanEditorInput.java:1)

at com.ibm.team.apt.internal.ide.core.util.TeamFuture$DefaultResolver.resolve(TeamFuture.java:39)

at com.ibm.team.apt.internal.ide.core.util.TeamFuture$LoadJob.execute(TeamFuture.java:112)

at com.ibm.team.apt.internal.ide.core.util.TeamFuture$LoadJob.access$0(TeamFuture.java:110)

at com.ibm.team.apt.internal.ide.core.util.TeamFuture$LoadJob$1.run(TeamFuture.java:95)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)

at com.ibm.team.apt.internal.ide.core.util.TeamFuture$LoadJob.run(TeamFuture.java:93)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

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:106)

at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:913)

... 144 more

Caused by: java.sql.SQLException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=JAZZTMPSPACE, DRIVER=3.53.70

at com.ibm.db2.jcc.b.bd.a(bd.java:676)

at com.ibm.db2.jcc.b.bd.a(bd.java:60)

at com.ibm.db2.jcc.b.bd.a(bd.java:127)

at com.ibm.db2.jcc.b.fm.b(fm.java:2132)

at com.ibm.db2.jcc.b.fm.c(fm.java:2115)

at com.ibm.db2.jcc.t4.db.k(db.java:353)

at com.ibm.db2.jcc.t4.db.a(db.java:59)

at com.ibm.db2.jcc.t4.t.a(t.java:50)

at com.ibm.db2.jcc.t4.tb.b(tb.java:200)

at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)

at com.ibm.db2.jcc.b.gm.e(gm.java:3287)

at com.ibm.db2.jcc.b.gm.Rb(gm.java:612)

at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595)

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.newLargeInListValueTempTable(AbstractDbProvider.java:1142)

at sun.reflect.GeneratedMethodAccessor1095.invoke(null)

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 $Proxy20.newLargeInListValueTempTable(null)

at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:98)

... 145 more