OGG-01296 Error mapping from OGG-01154 SQL error 1400 ORA-01400: cannot insert NULL into

Hi,

You can get frequently ” OGG-01296 Error mapping from ” error from Goldengate.

 

Goldengate replicat is abended with ” OGG-01296 Error mapping from ” error like below.

 

2020-04-14 15:25:43  INFO    OGG-06510  Using the following key columns for target table MSDEVECI.TEST_TABLE: REQUEST_ID.


2020-04-14 15:25:43  WARNING OGG-00869  Aborting BATCHSQL transaction. Detected inconsistent result: executed 21 operations in batch, resulting in 20 affected rows.

2020-04-14 15:25:43  WARNING OGG-01137  BATCHSQL suspended, continuing in normal mode.

2020-04-14 15:25:43  WARNING OGG-01003  Repositioning to rba 12119957 in seqno 0.

2020-04-14 15:25:43  WARNING OGG-01004  Aborted grouped transaction on MSDEVECI.TEST_TABLE, Database error 1400 (OCI Error ORA-01400: cannot insert NULL into (
"MSDEVECI"."TEST_TABLE"."ENTRY_DATE") (status = 1400), SQL <INSERT INTO "MSDEVECI"."TEST_TABLE" ("ENTRY_ID","ENTRY_MOD_DATE","REQUEST_ID","STATUS","ACC
OUNT_INT_NO","GG_TRANS_DATE") VALUES (:a6,:a7,:a8,:a9,:a10,:a11)>).

2020-04-14 15:25:43  WARNING OGG-01003  Repositioning to rba 12119957 in seqno 0.

2020-04-14 15:25:43  WARNING OGG-01154  SQL error 1400 mapping MSDEVECI.TEST_TABLE to MSDEVECI.TEST_TABLE OCI Error ORA-01400: cannot insert NULL into ("EXTRAC
T_GG"."TEST_TABLE"."ENTRY_DATE") (status = 1400), SQL <INSERT INTO "MSDEVECI"."TEST_TABLE" ("ENTRY_ID","ENTRY_MOD_DATE","REQUEST_ID","STATUS","ACCOUNT_IN
T_NO","GG_TRANS_DATE") VALUES (:a6,:a7,:a8,:a9,:a10,:a11)>.

Source Context :
  SourceModule            : [er.replicat.errors]
  SourceID                : [er/replicat/reperrors.cpp]
  SourceMethod            : [repError]
  SourceLine              : [1754]
  ThreadBacktrace         : [15] elements
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/libgglog.so(_MSG_QualTableName_QualTableName(CSourceContext*, int, ggs::gglib::ggapp::CQualDBOb
jName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::er::ReplicatContext::repError(short, int, char const*, extr_ptr_def*, ggs::gglib:
:gglcr::CommonLCR const*, std_rec_hdr_def*, char*, ObjectMetadata*, bool))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat()]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::er::ReplicatContext::processRecord(ggs::gglib::gglcr::CommonLCR const*, ggs::ggli
b::gglcr::CommonLCR*, extr_ptr_def*&, extr_ptr_def*&, bool&, int&, bool, RepCsn&))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::er::ReplicatContext::run())]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat()]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::Thre
adArgs*))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/ggatea01/goldengate/product/GG19cFor18cDB/replicat()]

2020-04-14 15:25:43  ERROR   OGG-01296  Error mapping from MSDEVECI.TEST_TABLE to MSDEVECI.TEST_TABLE.


 

When you get ” OGG-01296 Error mapping from ” error, firstly check replicat table constraints and triggers.

 

You can also see that replicat report file says ” ORA-01400: cannot insert NULL into ” error.

So when I check related table triggers and constraints, problem is occured because of constraints.

 

Constraints on the related table are enabled, you should disable them.

 

I have disabled triggers with the following command.

alter trigger TRIGGER_NAME disable;

You can disable constraint with the following command.

ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;


ALTER TABLE MSDEVECI.TEST_TABLE DISABLE CONSTRAINT SYS_C00149016;

 

When I disable the constraints, my Replicat has been started and run properly.

 

There are several types of OGG-01296 Error mapping in Goldengate. You should review the OGG-01296 error with the other ORA Errors like ORA-01400.

 

If you got OGG-01296 Error mapping with OGG-01154 error, you can read the following post to solve it.

https://ittutorial.org/goldengate-ogg-01296-error-mapping-from-ogg-01154/

 

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/

 365 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply