OWB Mapping With DML Error Logging Fails To Log Errors

(Doc ID 1058020.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.


Symptoms

OWB Mapping with DML Error Logging set does not fill in the error table and reports the following:

In the Database alert.log

ORA-00600: internal error code, arguments: [opixrb-3], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], []


In the generated trace file

ORA-00600: internal error code, arguments: [opixrb-3], [1036], [ORA-01036: illegal variable name/number], [], [], [], [], []
Current SQL statement for this session:
INSERT /*+ NOAPPEND PARALLEL("OVERALL_JIG_SHORTAGES") */ INTO "SCR_DW"."OVERALL_JIG_SHORTAGES"@"SID@DWH_LOCATION" "OVERALL_JIG_SHORTAGES" ( ...  ... ) LOG ERRORS INTO OVERALL_JIG_SHORTAGES_ERR (:B1 ) REJECT LIMIT 1000000000

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms