ORA-01407 in errorlog.sql (4322461)

ORA-01407 in errorlog.sql

In errorlog.sql:

-- redolog seq#/offset 18642/328286736
-- redolog timestamp 888566285 (08/24/15 07:58:05)
-- original rowid AAAZdFAAJAAAEc7AAE
-- ORA-01407: cannot update ("OWNER"."TABLE_NAME"."PLANT_CD") to NULL
-- INCORRECT TABLE
update   "OWNER"."TABLE_NAME" t
set "HEART_DT"='20'||'150824075805',"PLANT_CD"=null
where rownum = 1
and "LINE_ID"='T22'
and "AREA_ID"='T22D'
and "PLANT_CD"='3   ';

The column "PLANT_CD" was added with default value and has NOT NULL constraint.
The message trying to update NULL for the column, but Post generated a weird SQL statement.

This is a product issue.

With Oracle 'fast add' feature in Oracle11g and above, it is an expected behavior for Oracle to store the default values only in dictionary.
That's why Capture noticed that the column value is NULL.
Capture should handle this case for avoiding UPDATE statement trying to put NULL for that column.

WORKAROUND:

None.

STATUS:

The fix(ST109206) will be included in 8.0.7/8.6.2.44.
The latest version of SharePlex for Oracle can be downloaded at: https://support.quest.com/shareplex/download-new-releases