[Building Sakai] Oracle error with Samigo feedback

[Anand Mehta]

Hi Omer,

We are seeing the same issue with only a few assessments. It seems to happen when an instructor tries to add comments for an individual student's test submission. Did Karen's suggestion help resolve the issue?

Karen, can you please see the attached GradingData.hbm.xml and let me know if I have moved answerText to the correct location? Also, is there a JIRA ticket for this issue?
 


Thanks, 
Anand


________________________________
 From: Omer A Piperdi <omer at rice.edu>
To: Karen Tsao <ktsao at stanford.edu> 
Cc: "sakai-dev at collab.sakaiproject.org" <sakai-dev at collab.sakaiproject.org> 
Sent: Wednesday, October 2, 2013 9:59 AM
Subject: Re: [Building Sakai] Oracle error with Samigo feedback
 


Thanks Karen. I think you are right.. we saw this article http://www.odi.ch/weblog/posting.php?posting=496  but it is for Oracle 10.0.2.. Looks like same problem with 11g. We will be testing today and will let you know.

Thanks
Omer
 
On 10/1/2013 6:11 PM, Karen Tsao wrote:

Hi Omer,
>
>We also have this issue in our system. Our solution is to
              move the 
>
><property name="answerText" type="text"
              column="ANSWERTEXT" not-null="false" />
>
>
to the end of all other properties in GradingData.hbm.xml.
>
>
However, as we (Stanford) are not able to reproduce this issue again, we cannot be 100% sure about the fix. Please feel free to give this a try.. 
>
>If other developers have better solution/suggestion, please
          let us know..
>
>
Thanks,
>Karen
>
>
>
>
>
>
>
>
>On Tue, Oct 1, 2013 at 3:25 PM, Omer A Piperdi <omer at rice.edu> wrote:
>
>We are seeing the following error message when instructor add feedback
>>when grading in Samigo..
>>
>>org.springframework.jdbc.UncategorizedSQLException:
            Hibernate flushing:
>>Could not execute JDBC batch update; uncategorized
            SQLException for SQL
>>[update SAM_ITEMGRADING_T set ASSESSMENTGRADINGID=?,
            PUBLISHEDITEMID=?,
>>PUBLISHEDITEMTEXTID=?, AGENTID=?, SUBMITTEDDATE=?,
            PUBLISHEDANSWERID=?,
>>RATIONALE=?, ANSWERTEXT=?, AUTOSCORE=?, OVERRIDESCORE=?,
            COMMENTS=?,
>>GRADEDBY=?, GRADEDDATE=?, REVIEW=?, ATTEMPTSREMAINING=?,
            LASTDURATION=? whe
>>re ITEMGRADINGID=?]; SQL state [99999]; error code [24816];
            ORA-24816:
>>Expanded non LONG bind data supplied after actual LONG or
            LOB column
>>; nested exception is java.sql.BatchUpdateException:
            ORA-24816: Expanded
>>non LONG bind data supplied after actual LONG or LOB column
>>
>>We are running Oracle 11.2.0.3 with Sakai 2.9.x. Does anyone
            see this
>>error before? Any suggestion?
>>
>>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"
>>
>
!DSPAM:2294,524b586217402055431606! 


_______________________________________________
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/20131216/1a902671/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GradingData.hbm.xml
Type: text/xml
Size: 10888 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131216/1a902671/attachment.xml