GoldenGate Replicat Abended: Database error 1465 (ORA-01465: invalid hex number) (Doc ID 1332974.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

replicat abended  Database error 1465 (ORA-01465: invalid hex number)


and

CREATE INDEX ORDER_STAGE.MS_TASK_WF_INDX7 ON ORDER_STAGE.MS_TASK (HEXTORAW("WF_TASK_ID")) LOGGING TABLESPACE ORDER_STAGE_INDX PCTFREE    10 INITRANS   2 MAXTRANS   255 STORAGE    ( INITIAL          64K MINEXTENTS       1 MAXEXTENTS       UNLIMITED PCTINCREASE      0 FREELISTS        1 FREELIST GROUPS  1 BUFFER_POOL      DEFAULT ) NOPARALLEL;

Aborting transaction on /obscure/p1efm1d5/ggs/trails/p1efm1d7/a3 beginning at seqno 2064 rba 107131
            error at seqno 2064 rba 107131
Problem replicating MSXXX.MS_TASK to ORDER_STAGE.MS_TASK
Error (1465) occurred with insert record (target format)...
*
MS_TASK_ID = 167136926
WF_JOB_ID = _PI:90030130.521c81df.e0c6f77d.2a160015


The oracle definition of this error is this:
ORA-01465: invalid hex number
Cause: In an UPDATE statement following a SELECT FOR UPDATE, part of the ROWID contains invalid characters. ROWID must be expressed in the proper and expected format for ROWID and within quotes.
Action: Enter the ROWID just as it was returned in the SELECT FOR UPDATE.



Changes

The target had a function based index that the source did not have.

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