CDC Error

[ksimon00]

Has anyone experienced the error below? Does anyone know what is meant by "view-adapted input schema" in this case, and the major causes of this problem?


CC_DeptXref: Key field "DEPT" not found in view-adapted input schema
Key field "DEPT" not found in view-adapted input schema


Thanks,

Karl

[richdhan]

Hi Karl,

I believe DEPT is the key that you are specifying in CDC stage. Actually CDC is used to compare 2 datasets. In the CDC stage in the Input tab you will have 2 input links. Check the columns tab in the 2 input links. Check DEPT exists in the two input column list. Maybe you have used alias name in one of the column list.

HTH.

--Rich

A liitle bit of ink is powerful than the strongest memory
--Confucius

[Gazelle]

I received the same error in a Remove Duplicates stage, so it is not to do with mismatched columns in the CDC.

Reiterating Karl's question:
Has anyone experienced the error below? Does anyone know what is meant by "view-adapted input schema" in this case, and the major causes of this problem?

More importantly, does anyone know the solution?

- g

[T42]

Double check your input dataset. The field is simply not there during runtime, nor is it propagated through there.

[Gazelle]

Thanks.
By removing the Remove Duplicates stage, it uncovered another error.
Refer to the topic: Fatal error due to "differing nullability".