[Building Sakai] Importing assessments

[Nguni Phakela]

Changing the column type to text seems to have worked and fixed the problem.

Cheers,
Nguni


On Tue, Dec 11, 2012 at 10:07 AM, Nguni Phakela <nguni52 at gmail.com> wrote:

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


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