Look Up failure
Moderators: chulett, rschirm, roy
Look Up failure
Hi I am doing a look up based on 2 columns ColumnA, ColumnB from Primary and ColumnA_Ref and ColumnB_Ref from reference link.
The priamary link is coming from the Transformer output and the reference from the Db2 Udb database using the DB2 Enterprise stage.
But when i try to run the job it is getting abended with the following error message
Error when checking operator: Key field "ColumnA" not found in input schema.
but this column is present in the Primary link and the corresponding column "ColumnA_ref" from reference link is also present.
RCP is disabled at job level.
I have tried to modify the Ref column names to match that of the Primary column names then i encountered following error
Added field has duplicate identifier(): ColumnA.
My Job Design is
DB2EnterpriseStage -->Transformer -->LookUp --> series of joins/lookup--> Db2enterprise stage
Appreciate if any one can help me in solving this.
Thanks,
Naru
The priamary link is coming from the Transformer output and the reference from the Db2 Udb database using the DB2 Enterprise stage.
But when i try to run the job it is getting abended with the following error message
Error when checking operator: Key field "ColumnA" not found in input schema.
but this column is present in the Primary link and the corresponding column "ColumnA_ref" from reference link is also present.
RCP is disabled at job level.
I have tried to modify the Ref column names to match that of the Primary column names then i encountered following error
Added field has duplicate identifier(): ColumnA.
My Job Design is
DB2EnterpriseStage -->Transformer -->LookUp --> series of joins/lookup--> Db2enterprise stage
Appreciate if any one can help me in solving this.
Thanks,
Naru
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
I do not have any column with same name from both the ref link and the primary link...peddidsx wrote:This might with the columns with the same name in both master link and reference link which are not used as a key.Try by removing un-used column with the same name in the reference link.Hope this should work
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: