You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@oozie.apache.org by "Venkat Ranganathan (JIRA)" <ji...@apache.org> on 2015/02/20 23:23:11 UTC

[jira] [Created] (OOZIE-2147) Oozie upgrade from 4.0.0 to 4.1.0 fails with CLOBs of zero length with Oracle DB

Venkat Ranganathan created OOZIE-2147:
-----------------------------------------

             Summary: Oozie upgrade from 4.0.0 to 4.1.0 fails with CLOBs of zero length with Oracle DB
                 Key: OOZIE-2147
                 URL: https://issues.apache.org/jira/browse/OOZIE-2147
             Project: Oozie
          Issue Type: Bug
    Affects Versions: 4.1.0
         Environment: Oracle
            Reporter: Venkat Ranganathan
            Assignee: Venkat Ranganathan
            Priority: Critical


When upgrading from 4.0.0 to 4.1.0 the upgrade fails when the DB contains CLOBS of zero length with the following error

ERROR:
ORA-22994: source offset is beyond the end of the source LOB
ORA-06512: at "SYS.DBMS_LOB", line 978

The reason for this is that DBMS_LOB.CONVERTTOBLOB does not handle zero length CLOBs correctly. 

The fix is to explicitly check for the lob.length and skip those when doing the conversion




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)