【ogg遇错】无主键表OGG-01296

Opened trail file ./dirdat/si001435 at 2019-10-26 02:59:17

Wildcard MAP resolved (entry LZJBSI.*):
  MAP LZJBSI.BZ13, TARGET ZB_LZJBSI.BZ13,filter (@GETENV ("TRANSACTION", "CSN")>16737036956600);

2019-10-26 02:59:17  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  BAZ001, BAZ002, AAZ010, BAZ100, AAE002, BAE165, AAB001, BAE168, 
  AAE030, AAE031, BAZ111, BAZ112, BAZ113, AAE013, BAB223, BAZ003, 
  BAZ004, AAE011, AAE036, AAB034, AAA027

Using the following key columns for target table ZB_LZJBSI.BZ13: BAZ001, BAZ002, AAZ010, BAZ100, AAE002, BAE165, AAB001, BAE168, AAE030, AAE031, BAZ111, BAZ112, BAZ113, AAE013, BAB223, BAZ003, BAZ004, AAE011, AAE036, AAB034, AAA027.

2019-10-26 02:59:17  WARNING OGG-01431  Aborted grouped transaction on 'ZB_LZJBSI.BZ13', Mapping error.

2019-10-26 02:59:17  WARNING OGG-01003  Repositioning to rba 48699319 in seqno 1435.

2019-10-26 02:59:17  WARNING OGG-01151  Error mapping from LZJBSI.BZ13 to ZB_LZJBSI.BZ13.

2019-10-26 02:59:17  WARNING OGG-01003  Repositioning to rba 48699319 in seqno 1435.

Source Context :
  SourceModule            : [er.main]
  SourceID                : [/scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/app/er/rep.c]
  SourceFunction          : [take_rep_err_action]
  SourceLine              : [16148]
  ThreadBacktrace         : [8] elements
                          : [/oracle/gg/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f2ac6]]
                          : [/oracle/gg/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e9562]]
                          : [/oracle/gg/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessageFactory::MessageDisposition)+0x9b) [0x5c79bb]]
                          : [/oracle/gg/replicat [0x832a3a]]
                          : [/oracle/gg/replicat [0x910279]]
                          : [/oracle/gg/replicat(main+0x84b) [0x5081ab]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3c7f61d994]]
                          : [/oracle/gg/replicat(__gxx_personality_v0+0x1da) [0x4e479a]]

2019-10-26 02:59:17  ERROR   OGG-01296  Error mapping from LZJBSI.BZ13 to ZB_LZJBSI.BZ13.

处理方式，手指定个

MAP LZJBSI.BZ13 , target ZB_LZJBSI.BZ13 , KEYCOLS ( BAZ001 );

这个鬼东西的位置还是有说法的，如果用了map   *通配符，最好这个放到map  *的前一行

不然会依然提示错误，同时伴有这么一条信息：

2019-10-26 03:21:59  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Detected duplicate MAP entry.  Using prior MAP specification.

放map *之后的日志

Wildcard MAP resolved (entry LZJBSI.*):
  MAP LZJBSI.BZ13, TARGET ZB_LZJBSI.BZ13,filter (@GETENV ("TRANSACTION", "CSN")>16737036956600);

2019-10-26 03:21:59  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  BAZ001, BAZ002, AAZ010, BAZ100, AAE002, BAE165, AAB001, BAE168, 
  AAE030, AAE031, BAZ111, BAZ112, BAZ113, AAE013, BAB223, BAZ003, 
  BAZ004, AAE011, AAE036, AAB034, AAA027

Using the following key columns for target table ZB_LZJBSI.BZ13: BAZ001, BAZ002, AAZ010, BAZ100, AAE002, BAE165, AAB001, BAE168, AAE030, AAE031, BAZ111, BAZ112, BAZ113, AAE013, BAB223, BAZ003, BAZ004, AAE011, AAE036, AAB034, AAA027.


MAP resolved (entry LZJBSI.BZ13):
  MAP LZJBSI.BZ13, TARGET ZB_LZJBSI.BZ13,filter (@GETENV ("TRANSACTION", "CSN")>16737036956600) , KEYCOLS ( BAZ001 );

2019-10-26 03:21:59  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Detected duplicate MAP entry.  Using prior MAP specification.

2019-10-26 03:21:59  WARNING OGG-01431  Aborted grouped transaction on 'ZB_LZJBSI.BZ13', Mapping error.

2019-10-26 03:21:59  WARNING OGG-01003  Repositioning to rba 48699319 in seqno 1435.

2019-10-26 03:21:59  WARNING OGG-01151  Error mapping from LZJBSI.BZ13 to ZB_LZJBSI.BZ13.

2019-10-26 03:21:59  WARNING OGG-01003  Repositioning to rba 48699319 in seqno 1435.

放前面一行的日志

MAP resolved (entry LZJBSI.BZ13):
  MAP LZJBSI.BZ13, TARGET ZB_LZJBSI.BZ13,filter (@GETENV ("TRANSACTION", "CSN")>16737036956600) , KEYCOLS ( BAZ001 );

2019-10-26 03:23:20  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  BAZ001, BAZ002, AAZ010, BAZ100, AAE002, BAE165, AAB001, BAE168, 
  AAE030, AAE031, BAZ111, BAZ112, BAZ113, AAE013, BAB223, BAZ003, 
  BAZ004, AAE011, AAE036, AAB034, AAA027

Using the following key columns for target table ZB_LZJBSI.BZ13: BAZ001.


Wildcard MAP resolved (entry LZJBSI.*):
  MAP LZJBSI.BZ13, TARGET ZB_LZJBSI.BZ13,filter (@GETENV ("TRANSACTION", "CSN")>16737036956600);

2019-10-26 03:23:20  WARNING OGG-00869  No unique key is defined for table BZ13. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Detected duplicate MAP entry.  Using prior MAP specification.