Extra columns appearing, even when not being directed there.
Posted: Mon Feb 19, 2007 10:07 pm
Hi.
I am using a transformer to perform some validations, and then processing all error datasets using a funnel stage, which then links to a single error dataset.
When I am running the job, I am getting the following warnings.
fnlEXPDTL0Err: When checking operator: Defaulting "ACCESSID" in transfer from "inRec" to "outRec".
fnlEXPDTL0Err: When checking operator: Defaulting "MASTERID" in transfer from "inRec" to "outRec".
fnlEXPDTL0Err: When checking operator: Defaulting "RRN" in transfer from "inRec" to "outRec".
However, I am not passing these columns to the funnel at all. When I tried to use a Modify stage to drop these columns (I know it is stupid, but what the heck, I had to try something!), the above warnings went away, but in their place, came the following warnings.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "ACCESSID" which is not present in output interface.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "MASTERID" which is not present in output interface.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "RRN" which is not present in output interface.
Any suggestions on how I can resolve this issue?
I am using a transformer to perform some validations, and then processing all error datasets using a funnel stage, which then links to a single error dataset.
When I am running the job, I am getting the following warnings.
fnlEXPDTL0Err: When checking operator: Defaulting "ACCESSID" in transfer from "inRec" to "outRec".
fnlEXPDTL0Err: When checking operator: Defaulting "MASTERID" in transfer from "inRec" to "outRec".
fnlEXPDTL0Err: When checking operator: Defaulting "RRN" in transfer from "inRec" to "outRec".
However, I am not passing these columns to the funnel at all. When I tried to use a Modify stage to drop these columns (I know it is stupid, but what the heck, I had to try something!), the above warnings went away, but in their place, came the following warnings.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "ACCESSID" which is not present in output interface.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "MASTERID" which is not present in output interface.
xfmEXPDTL0: When checking operator: On output data set 3: The modify operator drops field "RRN" which is not present in output interface.
Any suggestions on how I can resolve this issue?