User tokens creating duplicate entries in trail file
edited Oct 19, 2012 6:42AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
When I add user tokens in the extract parameter file, it is creating two entries in trail file for INSERTs.REPLICAT is abending with duplicate key error.
Do you guys know how to handle this scenario.
Here is extract mapping:
TABLE DBO.sqlexectb,
SQLEXEC (ID getdeptname, QUERY "select name from dbo.dept where deptno = ?", PARAMS (p1 = deptno)),
TOKENS (TKN-DEPT-NAME = getdeptname.name, TKN-OP-TYPE = @GETENV("GGHEADER","OPTYPE"));
Data pump is using passthru.
In the replicat mapping:
MAP DBO.sqlexectb, TARGET DBO.sqlexectb,
SQLEXEC (ID getdeptno, QUERY "select deptno from dbo.dept where name = ?",
PARAMS (p1 = @token ("TKN-DEPT-NAME"))),
COLMAP (USEDEFAULTS, deptno = getdeptno.deptno, deptname =
0