Datastage 8 bug sort stage ?
Posted: Wed Oct 22, 2008 4:05 am
Hi,
I've got the following problem with datastage 8.
I'll first draw the situation a bit...
Oracle stage => Copy stage => Sort stage => Remove duplicate stage => oracle stage
When we ran the job we got the warning :
Remove_Duplicates_21: When checking operator: User inserted sort "Remove_Duplicates_21.SERVICE_Sort" does not fulfill the sort requirements of the downstream operator "Remove_Duplicates_21"
I know that there are a lot of topics about this error and i've read most of them in hoping to find the solution.
But when testing suddenly the error dissapeared. Now it seems if i define in the sort stage how NULL values should be treated (first or last) i get the warning , if I leave this option out then the warning is not shown. Is there any logical explanation for this, or is it indeed a bug ?
These are jobs that are migrated from datastage 7 to 8 ( don't know if this information is vital).
Hope someone can help.
I've got the following problem with datastage 8.
I'll first draw the situation a bit...
Oracle stage => Copy stage => Sort stage => Remove duplicate stage => oracle stage
When we ran the job we got the warning :
Remove_Duplicates_21: When checking operator: User inserted sort "Remove_Duplicates_21.SERVICE_Sort" does not fulfill the sort requirements of the downstream operator "Remove_Duplicates_21"
I know that there are a lot of topics about this error and i've read most of them in hoping to find the solution.
But when testing suddenly the error dissapeared. Now it seems if i define in the sort stage how NULL values should be treated (first or last) i get the warning , if I leave this option out then the warning is not shown. Is there any logical explanation for this, or is it indeed a bug ?
These are jobs that are migrated from datastage 7 to 8 ( don't know if this information is vital).
Hope someone can help.