ORA-01858: a non-numeric character was found where a numeric was expected (Doc ID 2121603.1)

Last updated on APRIL 08, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Replicat is abending with the following:


  Oracle GoldenGate Delivery for Oracle
  Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
 Solaris, sparc, 64bit (optimized), Oracle 11g on Aug 8 2014 06:54:40


REPLICAT SD92RPT3
USERID OGGMGR@vsmrpt3.txslvsmpd7, PASSWORD *********
ASSUMETARGETDEFS
SETENV (NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252")

2016-03-25 16:19:58 INFO OGG-02095 Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252.
DBOPTIONS NOSUPPRESSTRIGGERS
DDLERROR DEFAULT IGNORE
DDL INCLUDE MAPPED OBJNAME netexpert.timestamp_table
DISCARDFILE /usr/apps/oracle/product/GG_12.1.2.1/dirdat/SD92RPT3.dsc, PURGE, MEGABYTES 100
MAP netexpert.timestamp_table, TARGET netexpert.timestamp_table;
MAP KANDAMA.MO, TARGET KANDAMA.MO;
MAP KANDAMA.ALERTLOG, TARGET KANDAMA.ALERTLOG;


2016-03-25 16:20:37 WARNING OGG-01154 SQL error 1858 mapping KANDAMA.MO to KANDAMA.MO OCI Error ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "KANDAMA.MO_AUDIT_INS_TRG", line 8
ORA-04088: error during execution of trigger 'KANDAMA.MO_AUDIT_INS_TRG' (status = 1858), SQL .



NOTE: On the target side they have a trigger that fires on changes to alertlog and populates an audit table ( alertlog_audit).

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