Project import corrupts Release Plan
I imported a project that worked fine in 2.0 M2 into a 2.0 GA repo. The import went fine with no errors. However, when I open one of the plans, I get an error. This plan worked fine in 2.0 M2. In fact, I cannot recreate the plan either. It is a project release plan. See error text below. Help is appreciated.
When accessed from Web: Error invoking service! (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.select(r.stringExtensions().value()); q.filter(r.workItemType()._in(new IString[] {q.newStringArg(), q.newStringArg(), q.newStringArg()})._and(r.category().itemId()._inLargeList))._and(r.target()._in(new IString[] {q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity")));) When recreated from Eclipse: 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.select(r.stringExtensions().value()); q.filter(r.workItemType()._in(new IString[] {q.newStringArg(), q.newStringArg(), q.newStringArg()})._and(r.category().itemId()._inLargeList))._and(r.target()._in(new IString[] {q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity"))); at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:928) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:889) 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:1056) 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:74) at sun.reflect.GeneratedMethodAccessor74.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy36.runInTransaction(null) at com.ibm.team.repository.service.internal.QueryService.doQueryData(QueryService.java:1048) at com.ibm.team.repository.service.internal.QueryService.queryDataInContext(QueryService.java:1006) at com.ibm.team.repository.service.internal.QueryService.queryData(QueryService.java:1024) at sun.reflect.GeneratedMethodAccessor146.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy57.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:535) 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:364) 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:99) 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:74) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:63) at sun.reflect.GeneratedMethodAccessor141.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy37.runInTransaction(null) at com.ibm.team.repository.service.AbstractService.runInTransaction(AbstractService.java:723) at com.ibm.team.apt.internal.service.IterationPlanService.fetchPlanProgress2(IterationPlanService.java:360) at com.ibm.team.apt.internal.service.IterationPlanService$4.run(IterationPlanService.java:204) at com.ibm.team.repository.service.internal.TransactionService$1.run(TransactionService.java:99) 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:328) at sun.reflect.GeneratedMethodAccessor60.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy5.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:74) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:63) at sun.reflect.GeneratedMethodAccessor141.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy37.runInTransaction(null) at com.ibm.team.repository.service.AbstractService.runInTransaction(AbstractService.java:723) at com.ibm.team.apt.internal.service.IterationPlanService.fetchResolvedIterationPlan2(IterationPlanService.java:147) 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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy192.fetchResolvedIterationPlan2(null) 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 com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleMethod(AbstractTeamServerServlet.java:1154) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.executeMethod(AbstractTeamServerServlet.java:910) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPost(AbstractTeamServerServlet.java:712) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1657) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1471) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 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:803) 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:803) 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:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) 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:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) 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:685) at java.lang.Thread.run(Thread.java:810) 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:586) at com.ibm.team.repository.transport.client.RemoteTeamService.executeMethod(RemoteTeamService.java:479) at com.ibm.team.repository.transport.client.RemoteTeamService.invoke(RemoteTeamService.java:197) at com.ibm.team.repository.transport.client.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:43) at $Proxy47.fetchResolvedIterationPlan2(Unknown Source) 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 com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invokeServiceCall(ServiceInterfaceProxy.java:149) at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invoke(ServiceInterfaceProxy.java:84) at $Proxy47.fetchResolvedIterationPlan2(Unknown Source) at com.ibm.team.apt.internal.client.IterationPlanClient$1.run(IterationPlanClient.java:368) 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:1164) at com.ibm.team.repository.common.transport.CancelableCaller.call(CancelableCaller.java:79) at com.ibm.team.repository.client.internal.TeamRepository.callCancelableService(TeamRepository.java:1157) at com.ibm.team.apt.internal.client.IterationPlanClient.fetchIterationPlanData(IterationPlanClient.java:371) at com.ibm.team.apt.internal.ide.ui.editor.IterationPlanEditorInput$2.resolve(IterationPlanEditorInput.java:139) 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:109) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:910) ... 146 more Caused by: java.sql.SQLException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096;DB2ADMIN, 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:1137) 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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy4.newLargeInListValueTempTable(null) at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:100) ... 147 more |
4 answers
Hi,
this issue is tracked in defect 87533: "Failing Query when opening Product Backlog Plan". While it is not confirmed yet, technote 1391062 (http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg21391062) probably documents the issue and the workaround. If applying the technote fixes your problem, could you please annotate the respective work item or let us know here in the forum? Thank you! -- MikeS Jazz Agile Planning team tfeeney wrote: I imported a project that worked fine in 2.0 M2 into a 2.0 GA repo. |
I encountered the same problem. As described in the technote which MikeS mentioned, I did
|
|
I wasn't able to test the solution in my 2.0 instance but when upgrading to 2.0.0.1, it happened again. Happily, creating the temp tablespace as specified in the links posted by Mike S, worked!
|
My problem occured only when trying to create a product backlog plan:
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.select(r.stringExtensions().value()); q.filter(r.workItemType()._in(new IString[] {q.newStringArg(), q.newStringArg()})._and(r.category().itemId()._inLargeList))._and(r.target()._in(new IString[] {q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity"))); Solution by creating temporary table space worked for me also!! In detail: open DB2 command window and you get something like this: C:\Program Files\IBM\SQLLIB\BIN> if not allready attached do the following: db2 attach to db2a user DB2A01 now connect to your database: db2 connect to JAZZRTC user DB2A01 using secretpassword run the command to create tablespace: C:\Program Files\IBM\SQLLIB\BIN>db2 create user temporary tablespace jazztmpspace managed by automatic storage |
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.