[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