[Building Sakai] Samigo question

[Matthew Jones]

Created jira as https://jira.sakaiproject.org/browse/SAM-2401

On Mon, Sep 8, 2014 at 12:34 PM, Matthew Jones <matthew at longsight.com>
wrote:

> Yeah, looking at the code that is an issue introduced there. This is fixed
> in hibernate (finally) but not until 4.1.7 which we haven't been able to
> upgrade to yet mostly because of getHibernateTemplate, but also other
> things that would come up.
>
> In any case I can create a new related jira for this.
>
> On Mon, Sep 8, 2014 at 12:11 PM, Omer A Piperdi <omer at rice.edu> wrote:
>
>> 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
>>
>>
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140908/bc86826f/attachment.html