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

[Kim Huang]

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