[Building Sakai] Discussion to Forum conversion question
Omer Piperdi
omer at rice.edu
Tue Jun 2 15:12:04 PDT 2009
During the Discussion to Forum conversion.. I got about 5 sites out of
about 11000 sites not converted.. I can see the database error because
of Discussion has longer description than Forum can hold..
If I rerun the conversion (Quartz job) again, only those 5 sites will be
converted or it will start all over again?
Thanks
Omer
------------
ERROR: 'Discussion' --> 'Forums': failed to convert site CHIN 212 001
Sp08. Conversion for this site was aborted - check the errors in logs
and re-run this conversion! (2009-06-02 14:46:30,386
QuartzScheduler_Worker-3_org.sakaiproject.discforumsconv.ConversionImpl)
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing:
Could not execute JDBC batch update; uncategorized SQLException for SQL
[insert into MFR_TOPIC_T (VERSION, UUID, CREATED, CREATED_BY, MODIFIED,
MODIFIED_BY, DEFAULTASSIGNNAME, TITLE, SHORT_DESCRIPTION,
EXTENDED_DESCRIPTION, MODERATED, MUTABLE, SORT_INDEX, TYPE_UUID,
of_surrogateKey, pf_surrogateKey, LOCKED, DRAFT, CONFIDENTIAL_RESPONSES,
MUST_RESPOND_BEFORE_READING, HOUR_BEFORE_RESPONSES_VISIBLE, GRADEBOOK,
GRADEBOOK_ASSIGNMENT, TOPIC_DTYPE, ID) values (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'DT', ?)]; SQL state
[72000]; error code [12899]; ORA-12899: value too large for column
"SAKAIPROD"."MFR_TOPIC_T"."SHORT_DESCRIPTION" (actual: 361, maximum: 255)
; nested exception is java.sql.BatchUpdateException: ORA-12899: value
too large for column "SAKAIPROD"."MFR_TOPIC_T"."SHORT_DESCRIPTION"
(actual: 361, maximum: 255)
-----------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3221 bytes
Desc: S/MIME Cryptographic Signature
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090602/93423f3f/attachment.bin
More information about the sakai-dev
mailing list