Job aborts if composite key columns are passed as a parametr

ujala · Post by **ujala** » Mon Dec 03, 2012 2:42 am

Hello all,
I am using netezza connector to update a set of records through Netezza connector through Datastage.
I am using RCP enabled data from dataset and moreover i wanted to resue the same job for different table updates.

While using netezza connector and passing the composite key columns to netezza stage via parameter, job aborts due to the following error:
(Netezza stage expects the key column to update and a check mark in columns tab will not surve the purpose.)

The following key column(s): Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number were not found in the link schema (CC_NZMetadataHelper::validateColumnsAgainstLinkSchema, file CC_NZMetadataHelper.cpp, line 2,917)

Order_Number,Item_number is the composite key which is used for update.

Let me know if any one has the solution for the above stated problem.
Note: It works fine if the composite key columns are selected manually.Problem persists only when passing it through the parameter

BI-RMA · Post by **BI-RMA** » Mon Dec 03, 2012 6:04 am

Are you sure your parameter is set correctly. What does the job-log tell your parameter value to be? Is it really "Order_Number,Item_number" or is it "Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number"?

If it is the latter: How do you select the parameter?

ujala · Post by **ujala** » Mon Dec 03, 2012 6:25 am

Yes i have set the parameter correctly.

The parameter is "Order_Number,Item_number"

The job executes if i use only one column as key column say for example if i pass only one column as order_number job executes fine problem occurs when i give multiple columns

abhinavsuri · Post by **abhinavsuri** » Mon Dec 17, 2012 10:17 am

Did you get a solution to this problem?

ujala · Post by **ujala** » Wed Dec 26, 2012 3:24 am

No i didnot get any solution!

chulett · Post by **chulett** » Wed Dec 26, 2012 7:10 am

Well past time to involve your official support provider, it would seem. Did you look to see if there were any patches available for that connector? What exact 8.x version are you running?

ujala · Post by **ujala** » Mon Jan 14, 2013 11:03 pm

Yes, i looked to see for patches and found that there were no patches available for netezza connector.

I am using Datastage v8.7

chulett · Post by **chulett** » Mon Jan 14, 2013 11:26 pm

I would ask if you finally involved support but worry it would be two or three weeks again before the answer came. And I have a funny feeling we already know the answer...