RTC3: InternalRepositoryException when loading a plan
Hello
After a days work in migrating the data from RTC 2 to a new RTC 3 setup (manual migration), I stepped into a problem which leads me to mistrust RTC 3 fundamentally.
Our setup has a Project Area with the Scrum Template, and two team areas underneath. In RTC 2 we had three plans per Iteration:
- One owned by the Project Area
- One each owned by the Team Areas
The project manager looked at the overall plan which includes all items, and the team leads looked at their plan which contains just the relevant work items.
In RTC 3, the Team Area-owned plans work, but each and every Project Area-owned plan only yields an exception (com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I A SQL query failed to execute properly on the server.).
The core of the exception seems to be an SQL error thrown by the Oracle Server (ORA-12838: cannot read/modify an object after modifying it in parallel).
--> There seems to be a fundamental incompatibility with Oracle, which leads me to mistrust RTC 3 at this stage.
What can I do to resolve this issue quickly (apart from raising a Defect, which I have done)?
Thansk! Martin
After a days work in migrating the data from RTC 2 to a new RTC 3 setup (manual migration), I stepped into a problem which leads me to mistrust RTC 3 fundamentally.
Our setup has a Project Area with the Scrum Template, and two team areas underneath. In RTC 2 we had three plans per Iteration:
- One owned by the Project Area
- One each owned by the Team Areas
The project manager looked at the overall plan which includes all items, and the team leads looked at their plan which contains just the relevant work items.
In RTC 3, the Team Area-owned plans work, but each and every Project Area-owned plan only yields an exception (com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I A SQL query failed to execute properly on the server.).
The core of the exception seems to be an SQL error thrown by the Oracle Server (ORA-12838: cannot read/modify an object after modifying it in parallel).
--> There seems to be a fundamental incompatibility with Oracle, which leads me to mistrust RTC 3 at this stage.
What can I do to resolve this issue quickly (apart from raising a Defect, which I have done)?
Thansk! Martin
3 answers
Update: I am having two cases of
Some details about the setup:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 11.2.0.2.0
The database is set-up with two Tablespaces / two users (one for JTS and one for CCM).
First case is the mentioned Plan-read operation. SQL Statement is here:
Second case it: I can't write back a Work Item, it seems to be permanently broken. SQL Statement here is:
ORA-12838: cannot read/modify an object after modifying it in parallelnow. Something seems to be fundamentally wrong in either RTC 3 or in our setup.
Some details about the setup:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 11.2.0.2.0
The database is set-up with two Tablespaces / two users (one for JTS and one for CCM).
First case is the mentioned Plan-read operation. SQL Statement is here:
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 JAZZCCMUSER.MODEL_WORK_ITEM t1 left outer join JAZZCCMUSER.MODEL_WORK_ITEM_STRING_EXTNSNS t5 on (t1.ITEM_ID = t5.JZ_PARENT_ID) where ((t1.TARGET_ITEM_ID = ?) and (( exists (select 1 from TEMP_3 x1 where x1.INPUT_ARG_COL = t1.CATEGORY_ITEM_ID) and t1.WORK_ITEM_TYPE in(?, ?)) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?) or (t1.CATEGORY_ITEM_ID = ?)) and (t5.KEY = '\u0001com.ibm.team.apt.attribute.complexity'))
Second case it: I can't write back a Work Item, it seems to be permanently broken. SQL Statement here is:
stmt = select t1.ITEM_ID, t1.STATE_ID from JAZZCCMUSER.LINK_CLOSURE_RELATION t1 where ( exists (select 1 from TEMP_1 x1 where x1.INPUT_ARG_COL = t1.TARGET_ITEM_ID) and exists (select 1 from TEMP_2 x1 where x1.INPUT_ARG_COL = t1.SOURCE_ITEM_ID))
You need to contact IBM support.
A defect is a way of notifying the RTC development team, but you need to
contact Rational support to get immediate assistance with resolving a
problem. They will both help you find a workaround, and work with you
and the development team to get the problem clarified and documented.
Cheers,
Geoff
On 2/7/2011 11:23 AM, merzberger1 wrote:
A defect is a way of notifying the RTC development team, but you need to
contact Rational support to get immediate assistance with resolving a
problem. They will both help you find a workaround, and work with you
and the development team to get the problem clarified and documented.
Cheers,
Geoff
On 2/7/2011 11:23 AM, merzberger1 wrote:
Hello
After a days work in migrating the data from RTC 2 to a new RTC 3
setup (manual migration), I stepped into a problem which leads me to
mistrust RTC 3 fundamentally.
....
What can I do to resolve this issue quickly (apart from raising a
Defect, which I have done)?
Thansk! Martin