Look up issue

[just4u_sharath]

Hello,
I am doing a look up on records and rejected records i am catching in a netezza table. Its giving me the following error.

NZ_incr_dp_scrp_data: Process meta data not available in database
main_program: Fatal Error: Added field has duplicate identifier():

But Meta data is available in my table definitions.

Instead of table if i put a peek stage. The jobs runs fine. I want to store the rejected records.

plz help

[ArndW]

Do you have RCP enabled? Also, in your PEEK stage, look at the columns and see if you have a duplicated name, most likely stemming from the lookup stage.

[behrouz]

Hello,
I am doing a look up on records and rejected records i am catching in a netezza table. Its giving me the following error.

NZ_incr_dp_scrp_data: Process meta data not available in database
main_program: Fatal Error: Added field has duplicate identifier():

But Meta data is available in my table definitions.

Instead of table if i put a peek stage. The jobs runs fine. I want to store the rejected records.

plz help

I guess in your lkp yuou are tring to send 2 differets filesd from you r souerce and your reference

with same name which is not correct

Hope this help you

Regards.
Arash.

[behrouz]

Hello,
I am doing a look up on records and rejected records i am catching in a netezza table. Its giving me the following error.

NZ_incr_dp_scrp_data: Process meta data not available in database
main_program: Fatal Error: Added field has duplicate identifier():

But Meta data is available in my table definitions.

Instead of table if i put a peek stage. The jobs runs fine. I want to store the rejected records.

plz help

with same name which is not correct

Hope this help you

Regards.
Arash.

plz if this helps you send your message Id for this errror

NZ_incr_dp_scrp_data: Process meta data not available in database
main_program: Fatal Error: Added field has duplicate identifier():
I guess in your lkp yuou are tring to send 2 differets filesd from you r souerce and your reference