Change data Capture Warning[api/transfer_rep.C:1832]

deepa_shenoy · Post by **deepa_shenoy** » Tue Mar 30, 2010 7:24 am

Hi,

I am constantly getting this warning while using the Change data Capture Stage:

When checking operator: Defaulting "PD_GRD_EFF_DT" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1832]

I have 5 columns in Reference link and 6 columns in Primary link and the 6 th column of the primary (after) link is throwing this warning.
Change Mode is 'Explicit Keys & Values'

Need help ASAP.

Thanks.

Deepa

JSWARBRI · Post by **JSWARBRI** » Tue Mar 30, 2010 7:59 am

You're getting this warning because you don't have the column "PD_GRD_EFF_DT" in your before dataset.

deepa_shenoy · Post by **deepa_shenoy** » Tue Mar 30, 2010 10:06 am

I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

deepa_shenoy · Post by **deepa_shenoy** » Tue Mar 30, 2010 10:08 am

I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

shivajid2k · Post by **shivajid2k** » Tue Mar 30, 2010 12:41 pm

Is the columns in both data sets are in same order with same data types?

shivajid2k · Post by **shivajid2k** » Tue Mar 30, 2010 12:43 pm

Is the columns in both data sets are in same order with same data types?

deepa_shenoy · Post by **deepa_shenoy** » Tue Mar 30, 2010 10:30 pm

Same data types but different order.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 30, 2010 11:20 pm

Try using identical metadata (same order) on all links.

deepa_shenoy · Post by **deepa_shenoy** » Thu Apr 01, 2010 3:21 am

I gave the same order. The warning still persists.