It's all about the answers!

Ask a question

Error on WI query at all a sudden


Ashish Sahoo (2176) | asked Aug 28 '11, 1:02 p.m.
we are using RTC 2.0.0.2 for client. We suddenly facing data fetching issues. we tried to analyze the WAS and db2 logs found nothing such big issues.
While querying the some WI queries it shows on web also on eclipse client


CRJAZ0350I Error fetching item values. statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID IN statement suffix = parameter = _omRygMq4EeCaf6drRRcZqg parameter = _pvfqwMmvEeCaf6drRRcZqg parameter = _FPiGcMeOEeCaf6drRRcZqg parameter = _dAAkcci_EeCaf6drRRcZqg parameter = _DWQbAMT5EeCaf6drRRcZqg parameter = _r-Ic8MqpEeCaf6drRRcZqg parameter = _VBOCkM2ZEeCaf6drRRcZqg parameter = _ctUSQMdcEeCaf6drRRcZqg parameter = _qT83oM_OEeCHyc2SX1QDdQ parameter = _7sm0EMrBEeCaf6drRRcZqg parameter = _7qtJ8MntEeCaf6drRRcZqg parameter = _ofunQMRlEeCaf6drRRcZqg parameter = _bz8FIMdaEeCaf6drRRcZqg parameter = _zSOcEMntEeCaf6drRRcZqg parameter = _izqSsMeOEeCaf6drRRcZqg parameter = _QUJ6MMnuEeCaf6drRRcZqg parameter = _jPvnMMeNEeCaf6drRRcZqg parameter = _hUgaoMduEeCaf6drRRcZqg parameter = _InwNAMduEeCaf6drRRcZqg parameter = _hBwtoMNkEeCaf6drRRcZqg parameter = _DJ36wM6PEeCaf6drRRcZqg parameter = _FoywSsnZEeCaf6drRRcZqg parameter = _lFZTIMmvEeCaf6drRRcZqg parameter = _4NgDQMntEeCaf6drRRcZqg parameter = _UyEAMMeOEeCaf6drRRcZqg parameter = _i7H3UcnYEeCaf6drRRcZqg parameter = _hrrDwMqrEeCaf6drRRcZqg parameter = _0tRn4M9KEeCHyc2SX1QDdQ parameter = _uTxJkMdyEeCaf6drRRcZqg parameter = _7MzZYc2EEeCaf6drRRcZqg parameter = _Fd3LEMm3EeCaf6drRRcZqg parameter = _e6pFcMdcEeCaf6drRRcZqg parameter = _tRN1cMqpEeCaf6drRRcZqg parameter = _mH7gwMq4EeCaf6drRRcZqg parameter = _ddjoEMqsEeCaf6drRRcZqg parameter = _ZC4SwMdaEeCaf6drRRcZqg parameter = _UhAvcMneEeCaf6drRRcZqg parameter = _r6wbAMq4EeCaf6drRRcZqg parameter = _jlSk4Mq4EeCaf6drRRcZqg parameter = _eZQRoMm3EeCaf6drRRcZqg parameter = _qVaLoMqpEeCaf6drRRcZqg parameter = _VCWUYMeNEeCaf6drRRcZqg parameter = _jgdlsMqsEeCaf6drRRcZqg parameter = _OjUTsMm3EeCaf6drRRcZqg parameter = _37EbAMdyEeCaf6drRRcZqg parameter = _bpljasnYEeCaf6drRRcZqg parameter = __Vch4MdyEeCaf6drRRcZqg




After that we tried to use repotool to rebuild the indices. Here we found error as

com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _9LKLcM9QEeCHyc2SX1QDdQ
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _7NXsMM2nEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _YOZAYM4hEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _DJ36wM6PEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _nlswwM2hEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _TxTbgM6ZEeCaf6drRRcZqg
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _QI3AEM6XEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
Error indexing work items . See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.





Same we found on logs also.

Need help asap as itz an sev1 issue for us going on still.

2 answers



permanent link
Karthikeyan Elangovan (3644) | answered Oct 17 '11, 11:18 a.m.
I'm also facing similar kind of issue. If any one could help me to resolve this issue, it will be of great help!!
Thanks in advance!!!
we are using RTC 2.0.0.2 for client. We suddenly facing data fetching issues. we tried to analyze the WAS and db2 logs found nothing such big issues.
While querying the some WI queries it shows on web also on eclipse client


CRJAZ0350I Error fetching item values. statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID IN statement suffix = parameter = _omRygMq4EeCaf6drRRcZqg parameter = _pvfqwMmvEeCaf6drRRcZqg parameter = _FPiGcMeOEeCaf6drRRcZqg parameter = _dAAkcci_EeCaf6drRRcZqg parameter = _DWQbAMT5EeCaf6drRRcZqg parameter = _r-Ic8MqpEeCaf6drRRcZqg parameter = _VBOCkM2ZEeCaf6drRRcZqg parameter = _ctUSQMdcEeCaf6drRRcZqg parameter = _qT83oM_OEeCHyc2SX1QDdQ parameter = _7sm0EMrBEeCaf6drRRcZqg parameter = _7qtJ8MntEeCaf6drRRcZqg parameter = _ofunQMRlEeCaf6drRRcZqg parameter = _bz8FIMdaEeCaf6drRRcZqg parameter = _zSOcEMntEeCaf6drRRcZqg parameter = _izqSsMeOEeCaf6drRRcZqg parameter = _QUJ6MMnuEeCaf6drRRcZqg parameter = _jPvnMMeNEeCaf6drRRcZqg parameter = _hUgaoMduEeCaf6drRRcZqg parameter = _InwNAMduEeCaf6drRRcZqg parameter = _hBwtoMNkEeCaf6drRRcZqg parameter = _DJ36wM6PEeCaf6drRRcZqg parameter = _FoywSsnZEeCaf6drRRcZqg parameter = _lFZTIMmvEeCaf6drRRcZqg parameter = _4NgDQMntEeCaf6drRRcZqg parameter = _UyEAMMeOEeCaf6drRRcZqg parameter = _i7H3UcnYEeCaf6drRRcZqg parameter = _hrrDwMqrEeCaf6drRRcZqg parameter = _0tRn4M9KEeCHyc2SX1QDdQ parameter = _uTxJkMdyEeCaf6drRRcZqg parameter = _7MzZYc2EEeCaf6drRRcZqg parameter = _Fd3LEMm3EeCaf6drRRcZqg parameter = _e6pFcMdcEeCaf6drRRcZqg parameter = _tRN1cMqpEeCaf6drRRcZqg parameter = _mH7gwMq4EeCaf6drRRcZqg parameter = _ddjoEMqsEeCaf6drRRcZqg parameter = _ZC4SwMdaEeCaf6drRRcZqg parameter = _UhAvcMneEeCaf6drRRcZqg parameter = _r6wbAMq4EeCaf6drRRcZqg parameter = _jlSk4Mq4EeCaf6drRRcZqg parameter = _eZQRoMm3EeCaf6drRRcZqg parameter = _qVaLoMqpEeCaf6drRRcZqg parameter = _VCWUYMeNEeCaf6drRRcZqg parameter = _jgdlsMqsEeCaf6drRRcZqg parameter = _OjUTsMm3EeCaf6drRRcZqg parameter = _37EbAMdyEeCaf6drRRcZqg parameter = _bpljasnYEeCaf6drRRcZqg parameter = __Vch4MdyEeCaf6drRRcZqg




After that we tried to use repotool to rebuild the indices. Here we found error as

com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _9LKLcM9QEeCHyc2SX1QDdQ
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _7NXsMM2nEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _YOZAYM4hEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _DJ36wM6PEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _nlswwM2hEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _TxTbgM6ZEeCaf6drRRcZqg
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _QI3AEM6XEeCaf6drRRcZqg
CRRTC0182E: Error while indexing page
Error indexing work items . See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See log for details.





Same we found on logs also.

Need help asap as itz an sev1 issue for us going on still.

permanent link
Ashish Sahoo (2176) | answered Oct 17 '11, 11:42 a.m.
After a thorough analysis with jazz dev and other teams we found that the some of DB2 data got corrupt(may be some network connectivity or any kind of connection issue between RTC and DB), for which this error coming we encounter any query for that data. Suggesting you to take help from jazz dev team, as you need to go for analyzing the data and make them some correction on which atleast you see the data and prepare the WI for those again for the client.

Your answer


Register or to post 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.