WARNING OGG-01154 SQL Error 14400 In Golden Gate With Partitioned Table (Doc ID 1561537.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

Replicat abended with error WARNING OGG-01154 SQL error 14400 in GoldenGate in partitioned table .
I dont have any record with partition key null in source.

2013-05-29 08:24:22  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repmera.prm:  SQL error 14400 mapping myowner.My_TABLE to myowner.My_TABLE
OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400). INSERT INTO "myowner"."My_TABLE" ("FECHA_PROG","COD_AGENTE","COD_UNIDAD","COD_UFI","VERSION","PERIODO_MINUTO_INI","PERIODO_MINUTO_FIN","HORA","TIPO_LIMITACION","FECHA_PUB"
,"DESCRIPCION","POT_LIMITE","FECHA_ACT","USUARIO_ACT") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13).

 

Error: ORA-14400 (ORA-14400)
Text: inserted partition key does not map to any partition
---------------------------------------------------------------------------
Cause: An attempt was made to insert a record into, a Range or Composite
Range object, with a concatenated partition key that is beyond the
concatenated partition bound list of the last partition -OR- An
attempt was made to insert a record into a List object with a
partition key that did not match the literal values specified for
any of the partitions.
Action: Do not insert the key. Or, add a partition capable of accepting
the key, Or add values matching the key to a partition
specification


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