Sort order lost in transformer when migrated to 11.5

irshanuddin · Post by **irshanuddin** » Wed Jun 22, 2016 7:49 am

We have a job that we migrated from 8.5 to 11.5 which was giving incorrect results. We narrowed this down to a transformer messing up the sort order after reading from a sort stage.
We have tried changing the partition to "Same" but didnt work.
The only way the transformer appears to maintain the sort order is if it is run in Sequential mode.
I have also tried sorting again in the transformer using the same keys as the sort stage but that failed as well.

Any suggestions?

ArndW · Post by **ArndW** » Wed Jun 22, 2016 10:55 am

If you set the partitioning to "same" and are not modifying the key column in the transformer, then the order won't be changed.
Turn on $APT_DUMP_SCORE and see what operators are actually being called; and perhaps you might try disabling combination of operators ($APT_DISABLE_COMBINATION) to see if that might be having an affect on your problem.

rkashyap · Post by **rkashyap** » Thu Jun 23, 2016 10:28 am

Do contact IBM support for this issue.

qt_ky · Post by **qt_ky** » Thu Jun 23, 2016 1:27 pm

Each time I have seen "strange things" going on related to the Transformer stage, it has been caused by using the wrong compiler version. A major, minor, or fix pack difference in the compiler version can definitely cause unusual, incorrect behaviors. Double check system requirements' exact version listed against the version you have installed.