DSXchange

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

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

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

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

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