[ 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)