If you are using Rational Team Concert (RTC) 220.127.116.11 and an Oracle database, trying to load a plan with more than 1000 work items may fail.
Here are the symptoms and errors:
a. In the web client, it shows the below error:
Error - [object Object]: CRJAZ0368I A SQL query failed to execute properly on the server stmt = select1.SOURCE_ITEM_ID, t1.TARGET_ITEM_ID, t1.NAME from JAZZDBUSER.LINK_CLOSURE_RELATION t1 where (t1.SOURCE_ITEM_ID in
b. In the Eclipse client, it gives the warning that it has more than 1000 work items.
The plan contains more than 1000 work items. Please split the plan by assigning work items to other iterations or team areas
However, ignoring the warning still doesn’t help in loading the workitems on the planned items tab.
c. The complete error is as follows:
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0586I Query is too complex (10695 parameters).
Caused by: java.lang.UnsupportedOperationException: CRJAZ0586I Query is too complex (10695 parameters).
If the working environment is a combination of RTC 18.104.22.168 version and Oracle database only and this issue is encountered, one has come across a known defect.
Here are the details of the defect work item from jazz.net and this is fixed in RTC 4.0.1: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=233995
In case you need a fix, a PMR needs to be raised with IBM Rational Client Support asking for a hot-fix, along with the mention of the existing hot-fixes installed, if any.