[Building Sakai] Oracle error with Samigo feedback

[Anand Mehta]

Hi Karen,

We are also unable to consistently reproduce this issue. We will try your suggestion and see if it helps.
 


Thanks, 
Anand


________________________________
 From: Karen Tsao <ktsao at stanford.edu>
To: Anand Mehta <anand.mehta at yahoo.com> 
Cc: Omer A Piperdi <omer at rice.edu>; "sakai-dev at collab.sakaiproject.org" <sakai-dev at collab.sakaiproject.org> 
Sent: Monday, December 16, 2013 4:02 PM
Subject: Re: [Building Sakai] Oracle error with Samigo feedback
 


Hi Anand,

Your change looks correct.

There is no JIRA ticket for this issue. Please feel free to log one. because we (Stanford) are not able to reproduce this issue again, I am 100% sure about the fix. Can you consistently reproduce this issue?

Thanks,
Karen






On Mon, Dec 16, 2013 at 1:33 PM, Anand Mehta <anand.mehta at yahoo.com> wrote:

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/20131223/c39175da/attachment.html