datastage

apeksha munje · Post by **apeksha munje** » Mon Jul 16, 2012 1:52 am

Iam getting this error :
Transformer_89: Error when checking operator: Could not find input field "SRC_SYS_CD".

ArndW · Post by **ArndW** » Mon Jul 16, 2012 2:28 am

Welcome to DSXchange, apeksha.

Your error message looks like you specified the column "SRC_SYS_CD" in your transform stage without using the input link name, i.e "DSLink32.SRC_SYS_CD". In several Stages the link name is not required, but in the transform stage it is a necessary component of the field name.

p.s. Next post you might try to chose a more descriptive text than "datastage" - perhaps "Problems in Transform stage" or "Error could not find input field" or something along those lines.

jwiles · Post by **jwiles** » Mon Jul 16, 2012 8:42 am

It's also possible that this is a runtime error (during job startup) indicating that the SRC_SYS_CD column does not exist in the input data. You should backtrack the job stages to determine if you may have inadvertently dropped the column in an earlier stage or job.

Regards,

Kryt0n · Post by **Kryt0n** » Mon Jul 16, 2012 4:37 pm

Can only see that happening if RCP is enabled otherwise it wouldn't compile. And if RCP is enabled and this is a runtime error, it's more because of a reference to SRC_SYS_CD when that field isn't in the source stream.

aartlett · Post by **aartlett** » Mon Jul 16, 2012 6:23 pm

I've seen this a bit lately. When dropping columns in a stage the incremental complier will work (force compile doesn't) and job fails.

Also occurs if you have an output column in an SQL stage that does not have a matching select column from the SQL, especially user defined SQL. Happened a few times to me when I added a column to the lookup reference link but forgot the SQL was U/D not auto gen.