GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat abending with "Column function diagnostic message: could not find column "TKN-OP-TYPE""

edited Nov 19, 2014 5:57PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

Hi,

I have mapped the tables as below in the replicat parameter file and started the replicat and it is abending with the above error.  Could you please help me out as what went wrong here.  It is a new setup.  

Your early reply is much appreciated. 

=====

MAP TLMPX_DBO.ITEM, TARGET GGAPP.TLM_CUS_ITEM,

COLMAP (USEDEFAULTS, GG_OPERATION = @case( @token ("TKN-OP-TYPE"), "INSERT", "I", "UPDATE", "U", "DELETE", "D", "SQL COMPUPDATE", "U", "FieldComp" , "U"),

GG_OPERATION_TIMESTAMP = @token ("TKN-COMMIT-TS"),

GG_SYSTEM_SOURCE_CODE =  @case( @token ("tk-host"), "tlmdb1q", "tlmcusq")

), &

FILTER (ON INSERT , ON UPDATE, ON DELETE, STMT_DATE >= to_date('2014-08-01','YYYY-MM-DD') );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center