[Building Sakai] Importing assessments

[Nguni Phakela]

Hi All,

When importing assessments into tests and quizzes from Respondus, we
haven't run into image problems, except today when trying to import an
assessment that has feedback with images. There is an exception that is
thrown:

Caused by: org.hibernate.exception.DataException: could not insert:
[org.sakaiproject.tool.assessment.data.dao.assessment.ItemFeedback]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2153)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2633)
        at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
        at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at
org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:508)



Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too
long for column 'TEXT' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)



-- 
Nguni Phakela
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121210/f2cffbbe/attachment.html