It's all about the answers!

Ask a question

How do I fix ORA-01795 error when doing an RTC Quick Search?


Doug Williams (132) | asked Dec 11 '18, 6:01 p.m.

 We have a project in RTC 5.0.2, and when we perform a Quick Search for work items using a certain user's name, the following exception gets generated:  


com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368E A database query could not run on the server.     stmt = select distinct t1.ITEM_ID, t1.STATE_ID, t1.MODIFIED from CCM.MODEL_WORK_ITEM t1 where ((t1.PROJECT_AREA_ITEM_ID = ?) and t1.ITEM_ID  in('_Ka-gsLkfEee5ZbITwcw6_w', '_l0Js1cSaEeet7oMheR0gIg', '_YYZQ8AN8Eee5n71er35KxQ', '_gI_ZhIbQEeeXNfn2eb0iLw', '_veYStANIEee5n71er35KxQ', '_NPTEfSj-EeekZqx_ztOOig', '_Pn59gIZnEeeXU8l5Gdbo7g', '_NHAsIOdhEeecj7k0ZxEgMA', '_mqcBoBrSEeeZUvQSAUbYkA', '_iOUfwKRHEee6HchL154HQg', ......................................................
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

I have removed most of the exception from the posting because it is very long.  It lists all 1000+ items in the "in" clause.  

Is there a way to modify the SQL query behind the Quick Search so that this user can get a list of his items?  Or another way to fix this error?  The Quick Search works fine for other users.

One answer



permanent link
Ralph Schoon (63.1k33645) | answered Dec 12 '18, 2:14 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 Dough,


You want to run this by support.


Comments
Krzysztof Kaźmierczyk commented Dec 13 '18, 8:52 a.m.
Dough,
Please open a new case for a support.

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.