OGG-01431 Mapping Error When Using CSN=@GETENV('TRANSACTION','CSN')

(Doc ID 2089274.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 to 12.1.2.1.9 [Release 11.1.1.1 to 12.1]
Information in this document applies to any platform.
Check for currency
08/23/2017

Goal



Added the following to the parm file CSN=@GETENV('TRANSACTION','CSN') and now replicat fails with the following 


2015-11-16 17:21:10 WARNING OGG-01431 Aborted grouped transaction on 'PRF_USD_OPT.SFORDD_TDTEST_P', Mapping error.

2015-11-16 17:21:10 WARNING OGG-01003 Repositioning to rba 1472 in seqno 21850.

2015-11-16 17:21:10 WARNING OGG-01151 Error mapping from SFBASLIB.SFORDD to PRF_USD_OPT.SFORDD_TDTEST_P.

2015-11-16 17:21:10 WARNING OGG-01003 Repositioning to rba 1472 in seqno 21850.



2015-11-16 17:21:10 ERROR OGG-01296 Error mapping from SFBASLIB.SFORDD to PRF_USD_OPT.SFORDD_TDTEST_P.

 

What causes this to fail ? 
 

Solution

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