[Building Sakai] Samigo question

[Omer A Piperdi]

We are seeing the following Oracle error with Samigo when a user click 
Published Assessments | Scores | Questions.

2014-09-04 13:29:36,533  WARN http-bio-8443-exec-246 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1795, SQLState: 42000
2014-09-04 13:29:36,534 ERROR http-bio-8443-exec-246 
org.hibernate.util.JDBCExceptionReporter - ORA-01795: maximum number of 
expressions in a list is 1000

org.springframework.dao.InvalidDataAccessResourceUsageException: could 
not execute query; SQL [select publishedi0_.ITEMID as ITEMID218_, 
publishedi0_.SECTIONID as SECTIONID218_, publishedi0_.ITEMIDSTRING as 
ITEMIDST3_218_, publishedi0_.SEQUENCE as SEQUENCE218_, 
publishedi0_.DURATION as DURATION218_, publishedi0_.TRIESALLOWED as 
TRIESALL6_218_, publishedi0_.INSTRUCTION as INSTRUCT7_218_, 
publishedi0_.DESCRIPTION as DESCRIPT8_218_, publishedi0_.TYPEID as 
TYPEID218_, publishedi0_.GRADE as GRADE218_, publishedi0_.SCORE as 
SCORE218_, publishedi0_.DISCOUNT as DISCOUNT218_, 
publishedi0_.ANSWER_OPTIONS_RICH_COUNT as ANSWER13_218_, 
publishedi0_.ANSWER_OPTIONS_SIMPLE_OR_RICH as ANSWER14_218_, 
publishedi0_.HINT as HINT218_, publishedi0_.HASRATIONALE as 
HASRATI16_218_, publishedi0_.PARTIAL_CREDIT_FLAG as PARTIAL17_218_, 
publishedi0_.STATUS as STATUS218_, publishedi0_.CREATEDBY as 
CREATEDBY218_, publishedi0_.CREATEDDATE as CREATED20_218_, 
publishedi0_.LASTMODIFIEDBY as LASTMOD21_218_, 
publishedi0_.LASTMODIFIEDDATE as LASTMOD22_218_ from SAM_PUBLISHEDITEM_T 
publishedi0_ where publishedi0_.ITEMID in (? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? 
, ? , ? , ? , ? , ? ,...

Basically Oracle won't allow more than 1000 in 'in' of select 
statement.. It works when I reverts ( 
https://jira.sakaiproject.org/browse/SAM-2192 ) which was using sub 
select in query.

I am wondering if anyone see this problem or any other issue by 
reverting the above JIRA.

Thanks
Omer