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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.2.0

Environment

Oracle

• Assignee: Venkat Ranganathan
• Reporter: Venkat Ranganathan
• Created: 20/Feb/15 22:22
• Updated: 18/May/15 07:11
• Resolved: 04/Mar/15 21:45

Description

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