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)
