[Building Sakai] Discussion to Forum conversion question

[Omer Piperdi]

Hi Nuno,

I checked it out from

https://source.sakaiproject.org/contrib/ufp/discussion2forums/trunk/

on June 1.. Anything change since then or different location?

Thanks again..
Omer

Nuno Fernandes wrote:
> I Omer,
> 
> Ideally, you should truncate those fields to 255 chars and re-run the 
> conversion (only the remaining 5 sites will be processed).
> 
> Do you have the latest dicussion2forums project code? You can issue a 
> "svn up" on the project folder just to make sure (and compile and deploy 
> if code was updated). I am asking you this because in the latest code, 
> the code block that sets the topic shortDescription already checks the 
> text length:
> 
> if(topicBody.length() <= 255){
>     topic.setShortDescription(topicBody);
> }else{
>     topic.setExtendedDescription(topicBody);
> }
> 
> Hope it helps,
> Nuno
> 
> 
> 
> 2009/6/2 Omer Piperdi <omer at rice.edu <mailto:omer at rice.edu>>
> 
>     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)
>     -----------
> 
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto: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
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
> 
> 
> 
> 
> -- 
> Nuno Fernandes  [www.linkedin.com/in/nfgrilo 
> <http://www.linkedin.com/in/nfgrilo>]
> Software Developer - UFP-UV  [Universidade Virtual]
> Software Developer - Sakai Foundation  [sakaiproject.org 
> <http://sakaiproject.org>]
> Sakai Fellow 2008 - Sakai Foundation 
>  [confluence.sakaiproject.org/confluence/x/FIF9AQ 
> <http://confluence.sakaiproject.org/confluence/x/FIF9AQ>]
> 
> Universidade Fernando Pessoa  [www.ufp.pt <http://www.ufp.pt>]
> Praça 9 de Abril, 349
> 4249-004 Porto
> tel: + 351 22 507 13 00
> fax: + 351 22 550 82 69
> !DSPAM:2294,4a264b30164803938018231!

-------------- 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/20090603/0b8261c9/attachment.bin