sort stage problem

monaz · Post by **monaz** » Mon Oct 06, 2008 5:05 am

Hi
I have problem with the sort stage.My job is getting aborted by the below FATAL ERROR: "CopyOfTestRSNAM_ExtractBPSA_Seg10..Sort_28: ct_fetch failed or canceled
Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 6 resulted in an overflow."

Can anyone guide me what exactly the mistake i have done in the Sort stage.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 06, 2008 8:16 am

This is actually an error with the connection to Sybase. It is reported by the Sort stage because passive stages do not have processes and therefore can not report their own errors. Make sure that the columns defined in your job match those in the SQL query, both in number and in data type.