Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-2147

Oozie upgrade from 4.0.0 to 4.1.0 fails with CLOBs of zero length with Oracle DB

    XMLWordPrintableJSON

    Details

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

      Oracle

      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

        Attachments

        1. OOZIE-2147.patch
          0.7 kB
          Venkat Ranganathan

          Activity

            People

            • Assignee:
              venkatnrangan Venkat Ranganathan
              Reporter:
              venkatnrangan Venkat Ranganathan
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: