[Building Sakai] Oracle error with Samigo feedback

[Karen Tsao]

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
>  <http://www.odi.ch/weblog/posting.php?posting=496>
> 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/e313b82a/attachment.html