On 12/18/09 5:07 AM, tbartley wrote:

I created a new project area, set up work item categories, a team with
members, a release, a top level iteration.

I then went to create an iteration plan beneath my top level iteration
and chose plan type "Product Backlog". This resulted in an
InternalRepositoryException being generated when RTC attempts to
display the newly created plan. See below for the details.

The plan appears to be created successfully because it shows up in the
"Plans" hieararchy in Team Artifacts.

We're using a 2.0.0.1 RTC server using DB2 and I was doing this from a
2.0.0.1 eclipse RTC client. The server was upgraded from 2.0 but has
had no other issues since we upgraded. If I try and create the plan
as a Team Plan or Spring Plan it works fine.

Should I just open a defect?

Pretty sure you are seeing
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/87533.
Can you pls verify?

--
Cheers, Johannes
Agile Planning Team

Hi All,

I have the same issue but I'm using a Oracle database. Could somebody help me in the troubleshooting of this issue?

The error in the client is:

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()})._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")));)

The SERVER full log is:


2010-02-09 03:35:28,171 INFO uration.OverridablePropertyFileServerConfiguration - CRJAZ1363I Loading configuration from "file:///C%3a/PROGRA~1/IBM/JAZZTE~1/server/conf/jazz/teamserver.properties".
2010-02-09 03:35:28,968 INFO .repository.service.internal.rdb.ConnectionFactory - CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@//10.77.203.129:1521/prodapp1.am.mot.com
2010-02-09 03:35:29,171 INFO .repository.service.internal.rdb.ConnectionFactory - CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 11g Release 11.1.0.0.0 - Production
Db URL: jdbc:oracle:thin:teamconcert/teamc0nc3rt@//10.77.203.129:1521/prodapp1.am.mot.com
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.4.0
2010-02-09 03:35:29,171 INFO .repository.service.db.provider.AbstractDbProvider -

//////////////////////////////////////////////////////////////////////////////
WARNING: User has choosen to override database version checking
and appears to be running with an unsupported version of oracle!
//////////////////////////////////////////////////////////////////////////////

2010-02-09 03:35:29,343 INFO m.team.fulltext.service.internal.index.IndexConfig - CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
2010-02-09 03:35:57,718 ERROR ository.service.internal.RdbRepositoryDataMediator - Failing ast 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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity")));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("WorkItem", "com.ibm.team.workitem").getQueryModel();
IDataQuery q = IDataQuery.FACTORY.newInstance(d);
q.select(((IUUIDField) d.getReference("itemId")));
q.select(((IUUIDField) d.getReference("stateId")));
q.select(((INumericField) d.getReference("duration")));
q.select(((INumericField) d.getReference("correctedEstimate")));
q.select(((INumericField) d.getReference("timeSpent")));
q.select(((IStringField) d.getReference("internalState")));
q.select(((IStringField) d.getReference("workItemType")));
q.select(((IUUIDField) d.getReference("category").getReference("itemId")));
q.select(((IUUIDField) d.getReference("target").getReference("itemId")));
q.select(((IUUIDField) d.getReference("owner").getReference("itemId")));
q.select(((IStringField) d.getReference("stringExtensions").getReference("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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(((IStringField) d.getReference("stringExtensions").getReference("key"))._eq("com.ibm.team.apt.attribute.complexity")));
-----------
parm 1: com.ibm.team.apt.workItemType.epicparm 2: com.ibm.team.apt.workItemType.storyparm 3: parm 4: parm 5: parm 6:
select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_1 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
2010-02-09 03:35:57,718 ERROR ository.service.internal.RdbRepositoryDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I Error executing query
stmt = select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_1 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:232)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:61)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:922)
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$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.GeneratedMethodAccessor61.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: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(Unknown Source)
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 sun.reflect.GeneratedMethodAccessor75.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: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(Unknown Source)
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.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 $Proxy57.queryData(Unknown Source)
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.getIterationPlanProgressRest(PlanProgressHelper.java:72)
at com.ibm.team.apt.internal.service.rest.helper.PlanProgressSerializer.getPlanProgress(PlanProgressSerializer.java:31)
at com.ibm.team.apt.internal.service.rest.serialize.IterationPlanSerializable.serialize(IterationPlanSerializable.java:85)
at com.ibm.team.apt.internal.service.rest.serialize.IterationPlanSerializable.serialize(IterationPlanSerializable.java:1)
at com.ibm.team.apt.internal.service.rest.serialize.AbstractUIItemSerializable.serialize(AbstractUIItemSerializable.java:1)
at com.ibm.team.apt.internal.service.rest.serialize.WebUISerializer.itemDTO(WebUISerializer.java:275)
at com.ibm.team.apt.internal.service.rest.PlanRestService.getIterationPlanSearchResults(PlanRestService.java:391)
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 $Proxy194.getIterationPlanSearchResults(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.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1655)
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)
Caused by:
java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:229)
... 91 more
2010-02-09 03:36:06,562 ERROR ository.service.internal.RdbRepositoryDataMediator - Failing ast 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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity")));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("WorkItem", "com.ibm.team.workitem").getQueryModel();
IDataQuery q = IDataQuery.FACTORY.newInstance(d);
q.select(((IUUIDField) d.getReference("itemId")));
q.select(((IUUIDField) d.getReference("stateId")));
q.select(((INumericField) d.getReference("duration")));
q.select(((INumericField) d.getReference("correctedEstimate")));
q.select(((INumericField) d.getReference("timeSpent")));
q.select(((IStringField) d.getReference("internalState")));
q.select(((IStringField) d.getReference("workItemType")));
q.select(((IUUIDField) d.getReference("category").getReference("itemId")));
q.select(((IUUIDField) d.getReference("target").getReference("itemId")));
q.select(((IUUIDField) d.getReference("owner").getReference("itemId")));
q.select(((IStringField) d.getReference("stringExtensions").getReference("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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(((IStringField) d.getReference("stringExtensions").getReference("key"))._eq("com.ibm.team.apt.attribute.complexity")));
-----------
parm 1: com.ibm.team.apt.workItemType.epicparm 2: com.ibm.team.apt.workItemType.storyparm 3: parm 4: parm 5: parm 6:
select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_2 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
2010-02-09 03:36:06,562 ERROR ository.service.internal.RdbRepositoryDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I Error executing query
stmt = select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_2 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:232)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:61)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:922)
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$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.GeneratedMethodAccessor61.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: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(Unknown Source)
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 sun.reflect.GeneratedMethodAccessor75.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: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(Unknown Source)
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.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 $Proxy57.queryData(Unknown Source)
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.getIterationPlanProgressRest(PlanProgressHelper.java:72)
at com.ibm.team.apt.internal.service.rest.helper.PlanProgressSerializer.getPlanProgress(PlanProgressSerializer.java:31)
at com.ibm.team.apt.internal.service.rest.serialize.IterationPlanSerializable.serialize(IterationPlanSerializable.java:85)
at com.ibm.team.apt.internal.service.rest.serialize.IterationPlanSerializable.serialize(IterationPlanSerializable.java:1)
at com.ibm.team.apt.internal.service.rest.serialize.AbstractUIItemSerializable.serialize(AbstractUIItemSerializable.java:1)
at com.ibm.team.apt.internal.service.rest.serialize.WebUISerializer.itemDTO(WebUISerializer.java:275)
at com.ibm.team.apt.internal.service.rest.PlanRestService.getIterationPlanSearchResults(PlanRestService.java:391)
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 $Proxy194.getIterationPlanSearchResults(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.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1655)
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)
Caused by:
java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:229)
... 91 more
2010-02-09 03:36:17,218 ERROR ository.service.internal.RdbRepositoryDataMediator - Failing ast 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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(r.stringExtensions().key()._eq("com.ibm.team.apt.attribute.complexity")));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("WorkItem", "com.ibm.team.workitem").getQueryModel();
IDataQuery q = IDataQuery.FACTORY.newInstance(d);
q.select(((IUUIDField) d.getReference("itemId")));
q.select(((IUUIDField) d.getReference("stateId")));
q.select(((INumericField) d.getReference("duration")));
q.select(((INumericField) d.getReference("correctedEstimate")));
q.select(((INumericField) d.getReference("timeSpent")));
q.select(((IStringField) d.getReference("internalState")));
q.select(((IStringField) d.getReference("workItemType")));
q.select(((IUUIDField) d.getReference("category").getReference("itemId")));
q.select(((IUUIDField) d.getReference("target").getReference("itemId")));
q.select(((IUUIDField) d.getReference("owner").getReference("itemId")));
q.select(((IStringField) d.getReference("stringExtensions").getReference("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(), q.newItemHandleArg(), q.newItemHandleArg(), q.newItemHandleArg()}))._and(((IStringField) d.getReference("stringExtensions").getReference("key"))._eq("com.ibm.team.apt.attribute.complexity")));
-----------
parm 1: com.ibm.team.apt.workItemType.epicparm 2: com.ibm.team.apt.workItemType.storyparm 3: parm 4: parm 5: parm 6:
select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_3 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
2010-02-09 03:36:17,218 ERROR ository.service.internal.RdbRepositoryDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I Error executing query
stmt = select t1.ITEM_ID, t1.STATE_ID, t1.DURATION, t1.CORRECTED_ESTIMATE, t1.TIME_SPENT, t1.INTERNAL_STATE, t1.WORK_ITEM_TYPE, t1.CATEGORY_ITEM_ID, t1.TARGET_ITEM_ID, t1.OWNER_ITEM_ID, t5.VALUE from MODEL_WORK_ITEM t1 left outer join MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where (t1.WORK_ITEM_TYPE in(?, ?) and exists (select 1 from TEMP_3 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.TARGET_ITEM_ID in(?, ?, ?, ?) and (t5.KEY = '
com.ibm.team.apt.attribute.complexity'))
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:232)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:61)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:922)
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$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.GeneratedMethodAccessor61.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: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(Unknown Source)
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 sun.reflect.GeneratedMethodAccessor75.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: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(Unknown Source)
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.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 $Proxy57.queryData(Unknown Source)
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.getIterationPlanProgressRest(PlanProgressHelper.java:72)
at com.ibm.team.apt.internal.service.rest.helper.PlanProgressSerializer.getPlanProgress(PlanProgressSerializer.java:31)
at com.ibm.team.apt.internal.service.rest.PlanRestService.getTeamLoad(PlanRestService.java:685)
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 $Proxy194.getTeamLoad(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.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1655)
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)
Caused by:
java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:229)
... 87 more

I think your problem is different. This looks like a problem specific to 11g, with which we haven't declared support for yet. http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB.

I think your problem is different. This looks like a problem specific to 11g, with which we haven't declared support for yet. http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB.

I got this problem on RTC 2.0 for power.
But I cannot create tablespaces on the Power?

Can anyone help me?

I think your problem is different. This looks like a problem specific to 11g, with which we haven't declared support for yet. http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB.

I got this problem on RTC 2.0 for power.
But I cannot create tablespaces on the Power?

Can anyone help me?

Hi Charles, a couple questions:
1. Where are you installing the database for RTCp? (e.g. is this DB2/i on IBM i OS? DB2 or Tomcat on Windows? DB2 on AIX)?
2. When you say that you can't create tablespaces, do you mean that running the repotools command to createtables fails? What error messages are you seeing?

Sean.

Sean

The database is installed in DB2/i

About the tablespaces. I tryed to create them in the STRSQL command screen.
I entered the following command:
"create user temporary tablespace jazztmpspace managed by automatic storage"
And then I got a error that the statement "CREATE TABLESPACE" was not regonized.

hope you know enough now.
Charles

I think your problem is different. This looks like a problem specific to 11g, with which we haven't declared support for yet. http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB.

I got this problem on RTC 2.0 for power.
But I cannot create tablespaces on the Power?

Can anyone help me?

Hi Charles, a couple questions:
1. Where are you installing the database for RTCp? (e.g. is this DB2/i on IBM i OS? DB2 or Tomcat on Windows? DB2 on AIX)?
2. When you say that you can't create tablespaces, do you mean that running the repotools command to createtables fails? What error messages are you seeing?

Sean.

Our Problem is that we are working with version 2.0.0.1 and we should be working with 2.0.0.2

We going to install 2.0.0.2 on monday

Sean

The database is installed in DB2/i

About the tablespaces. I tryed to create them in the STRSQL command screen.
I entered the following command:
"create user temporary tablespace jazztmpspace managed by automatic storage"
And then I got a error that the statement "CREATE TABLESPACE" was not regonized.

hope you know enough now.
Charles

I think your problem is different. This looks like a problem specific to 11g, with which we haven't declared support for yet. http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB.

I got this problem on RTC 2.0 for power.
But I cannot create tablespaces on the Power?

Can anyone help me?

Hi Charles, a couple questions:
1. Where are you installing the database for RTCp? (e.g. is this DB2/i on IBM i OS? DB2 or Tomcat on Windows? DB2 on AIX)?
2. When you say that you can't create tablespaces, do you mean that running the repotools command to createtables fails? What error messages are you seeing?

Sean.