[gradebook2-dev] Have you seen this error before ?

[Michael Wenk]

Kim,

This looks like GRBK-945.  What's the size for PROPERTY_VALUE in your
db?  Have you increased it from the 255 size it creates?  If not,
increase it, here at UCD we have ours set to 768.

Mike

On Tue, Oct 18, 2011 at 12:02 PM, Kim Huang <kimhuang at oit.rutgers.edu> wrote:
> Hi, Thomas,
>
> Recently, we have several strange errors occurring in Rutgers GB2(Sakai 2.8.0, GB2- 1.5.0b11). Besides the incidence of the blue screen(suppose to be the instructor view) for one or two TAs(instructors), the new error is about entering a grade for a particular student(just one site, one student so far, no problem for entering grade for other students in that site), there is an error display of "request failed,failed to update the record for XXXX, database constraint violation:500"
>
> Here is the log file,
> ------------------------------
>  WARN http-443-Processor21 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1406, SQLState: 22001
> 2011-10-18 13:55:52,638 ERROR http-443-Processor21 org.hibernate.util.JDBCExceptionReporter - Data truncation: Data too long for column 'PROPERTY_VALUE' at row 1
>
> 2011-10-18 13:55:52,638 ERROR http-443-Processor21 org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.DataException: could not insert collection: [org.sakaiproject.gradebook.gwt.sakai.model.ActionRecord.propertyMap#999138]
>        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
>        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>        at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1183)
>        at org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:39)
>        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
>        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
>        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)
>        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
>        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:339)
>        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
>        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
>        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
>        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
>        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
>        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>        at $Proxy160.storeActionRecord(Unknown Source)
>        at org.sakaiproject.gradebook.gwt.sakai.Gradebook2ComponentServiceImpl.assignScore(Gradebook2ComponentServiceImpl.java:551)
>        at org.sakaiproject.gradebook.gwt.sakai.rest.resource.LearnerRecord.assignNumericScore(LearnerRecord.java:66)
>        at sun.reflect.GeneratedMethodAccessor6913.invoke(Unknown Source)
> ....
>  -----------------------------------------
> Actually, the grade of that particular student has been updated, if you refresh GB2 display, the new grade will be shown. But the history table(click on view, then history) does not record the action of updating grade due to the database constraint error(No record has been inserted into GB_ACTION_RECORD_PROPERTY_T) . I checked the DB table GB_ACTION_RECORD_PROPERTY_T, the length of the column 'PROPERTY_VALUE' is 255. The stored value in that field is something like "false/true/85.0/null", etc.
>
> Apparently for this case, it should store some numerical value equals to the new grade entered for that student. The length of the new grade value could not be longer that 255.
>
> Do I miss something here ?
>
> Thanks,
> -Kim
>
>
>
>
>
>
>
>
> _______________________________________________
> gradebook2-dev mailing list
> gradebook2-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev
>



-- 
Michael Wenk
mjwenk at ucdavis.edu