[Building Sakai] Importing assessments

[Nguni Phakela]

Thank you Sam for the reply. Will change the column in the table to text or
blob.

Need a quick fix for now and then once we have this working we can look at
resolving the JIRA.

Thanx,
Nguni


On Mon, Dec 10, 2012 at 4:29 PM, Sam Ottenhoff <ottenhoff at longsight.com>wrote:

> 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"
>>
>
>


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