Merge stage error

deva · Post by **deva** » Tue May 29, 2012 11:00 am

Hi I am reading the data from file and my requirement is to use merge stage. I need to validate the file aganest two refference tables.

so I took the merge stage then I have connected the input stage to the merge and selected the key columns. Then added both reference tables to the merge.

Job gets compiled successful. But if I run the job I am getting the following errors

cs}}}(1): Error when checking tsort: Sort key field not found: MKT_SGMNT_CD

subArgs={asc}}}(2): Error when checking tsort: Sort key field not found: SIC

Merge_38: Error when checking operator: On input data set 1: Could not find input field "MKT_SGMNT_CD".
Error when checking operator: On input data set 2: Could not find input field "SIC".

main_program: Could not check all operators because of previous error(s)

I am getting these 4 errors. I have changed the partition to hash but no use. I getting the same error.

Please help me on this.

mobashshar · Post by **mobashshar** » Tue May 29, 2012 11:59 am

Are you sorting the input field MKT_SGMNT_CD in Merge stage?

deva · Post by **deva** » Tue May 29, 2012 9:49 pm

Yes I am doing the internal sort

ray.wurlod · Post by **ray.wurlod** » Wed May 30, 2012 12:52 am

Sort key field not found usually indicates an issue with the metadata rather than with the partitioning.

Check every link thoroughly to make sure that the sort key column is present on that link.