合 OGG-01296、OGG-06439、OGG-01169 表有主键或惟一键，但是仍然使用全部列来解析行

2021-12-13 17:01:59  INFO    OGG-06506  Wildcard MAP resolved (entry lhr.*): MAP "LHR"."ORDERS", TARGET "PDB2".lhr."ORDERS".

 

2021-12-13 17:02:04  WARNING OGG-06439  No unique key is defined for table ORDERS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

 

2021-12-13 17:02:04  INFO    OGG-02756  The definition for table LHR.ORDERS is obtained from the trail file.

 

2021-12-13 17:02:04  INFO    OGG-06511  Using following columns in default map by name: ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID, WAREHOUSE_ID, DELIVERY_TYPE, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, DELIVERY_ADDRESS_ID, CUSTOMER_CLASS, CARD_ID, INVOICE_ADDRESS_ID.

 

2021-12-13 17:02:04  INFO    OGG-06510  Using the following key columns for target table PDB2.LHR.ORDERS: ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID, WAREHOUSE_ID, DELIVERY_TYPE, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, DELIVERY_ADDRESS_ID, CUSTOMER_CLASS, CARD_ID, INVOICE_ADDRESS_ID.

 

2021-12-13 17:02:04  INFO    OGG-06074  Unique constraint columns used in dependency calculation for table PDB2.LHR.ORDERS: ORDER_ID.

 

2021-12-13 17:02:04  INFO    OGG-06075  Referential constraint columns used in dependency calculation for table PDB2.LHR.ORDERS: CUSTOMER_ID.

 

2021-12-13 17:02:04  WARNING OGG-01431  Canceled grouped transaction on PDB2.LHR.ORDERS, Mapping error.

 

2021-12-13 17:02:04  WARNING OGG-01003  Repositioning to rba 2944 in seqno 7.

 

2021-12-13 17:02:04  WARNING OGG-01151  Error mapping from LHR.ORDERS to PDB2.LHR.ORDERS.

 

Source Context :

  SourceModule            : [er.replicat.errors]

  SourceID                : [er/replicat/reperrors.cpp]

  SourceMethod            : [repError]

  SourceLine              : [1832]

  ThreadBacktrace         : [15] elements

                          : [/ogg213c/ogg_ma/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]

                          : [/ogg213c/ogg_ma/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]

                          : [/ogg213c/ogg_ma/bin/../lib/libgglog.so(_MSG_QualTableName_QualTableName(CSourceContext*, int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition))]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::er::ReplicatContext::repError(short, int, char const*, extr_ptr_def*, ggs::gglib::gglcr::CommonLCR const*, std_rec_hdr_def*, char*, ObjectMetadata*, bool))]

                          : [/ogg213c/ogg_ma/bin/replicat()]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::er::ReplicatContext::processRecord(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*&, extr_ptr_def*&, bool&, int&, bool, RepCsn&))]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::er::ReplicatContext::processReplicatLoop())]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::er::ReplicatContext::run())]

                          : [/ogg213c/ogg_ma/bin/replicat()]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]

                          : [/ogg213c/ogg_ma/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]

                          : [/ogg213c/ogg_ma/bin/replicat(main)]

                          : [/lib64/libc.so.6(__libc_start_main)]

                          : [/ogg213c/ogg_ma/bin/replicat()]

 

2021-12-13 17:02:04  ERROR   OGG-01296  Error mapping from LHR.ORDERS to PDB2.LHR.ORDERS.

2021-12-13 17:02:04  WARNING OGG-06439  No unique key is defined for table ORDERS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

 

2021-12-13 17:02:04  INFO    OGG-02756  The definition for table LHR.ORDERS is obtained from the trail file.

 

2021-12-13 17:02:04  INFO    OGG-06511  Using following columns in default map by name: ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID, WAREHOUSE_ID, DELIVERY_TYPE, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, DELIVERY_ADDRESS_ID, CUSTOMER_CLASS, CARD_ID, INVOICE_ADDRESS_ID.

 

2021-12-13 17:02:04  INFO    OGG-06510  Using the following key columns for target table PDB2.LHR.ORDERS: ORDER_ID, ORDER_DATE, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID, WAREHOUSE_ID, DELIVERY_TYPE, COST_OF_DELIVERY, WAIT_TILL_ALL_AVAILABLE, DELIVERY_ADDRESS_ID, CUSTOMER_CLASS, CARD_ID, INVOICE_ADDRESS_ID.