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

["Bowen Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OOZIE-2147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345982#comment-14345982 ] 

Bowen Zhang commented on OOZIE-2147:
------------------------------------

+1 pending jenkins.

> 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
>             Fix For: trunk
>
>         Attachments: OOZIE-2147.patch
>
>
> 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)