[Building Sakai] Importing assessments

[Sam Ottenhoff]

This means that the table that corresponds to org.sakaiproject.tool.
assessment.data.dao.assessment.ItemFeedback (SAM_ITEMFEEDBACK_T) has a
column labeled 'TEXT' that is too short for the content you are attempting
to insert into it.  A quick solution might be changing the column type in
your database from a varchar(4000) to a real text column.  The longer
solution would be addressing this JIRA:
https://jira.sakaiproject.org/browse/SAM-757


On Mon, Dec 10, 2012 at 9:19 AM, Nguni Phakela <nguni52 at gmail.com> wrote:

> 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
>
>
> _______________________________________________
> 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/20121210/eb521633/attachment.html