Sort wornings are differ from server to server

pimmit22043 · Post by **pimmit22043** » Mon Dec 03, 2007 11:25 am

we are geeting sort warnings messages in the new server like below
where as in the old server where we have developed and tested did not get any warnings. did anybody has similar issue or did anybody see help us.

please view the warnings below.

Join_73: When checking operator: User inserted sort "{natural="sortMinSrtDt:lnk_MinStrtDt.v", synthetic="buffer(5)"}" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperatorNC in Join_73"

Thanks for your time.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 03, 2007 2:43 pm

What's different between the old server and the new server? "Nothing" is not the correct answer.

Were the warnings being suppressed by a local message handler on the old server? If so there will be events in the job log informing you that a message handler was used.

pimmit22043 · Post by **pimmit22043** » Mon Dec 03, 2007 3:22 pm

As you said there should n't any differnce between those and sort APT_ env paramerts are also specified same on two server.

there is no message haldlers on any of the server.

Thanks for your time and answer.

Minhajuddin · Post by **Minhajuddin** » Mon Dec 03, 2007 9:38 pm

You get this warning whenever you use a sort stage to sort on different keys before a join, aggregator or a remove duplicates stage.

I doubt that you may be having some kind of message handlers(maybe a project level message handler) which is suppressing this in the job log. You can verify it by looking at the job log on your dev server.

hiral.chauhan · Post by **hiral.chauhan** » Tue Apr 14, 2009 9:29 am

[quote="Minhajuddin"]You get this warning whenever you use a sort stage to sort on different keys before a join, aggregator or a remove duplicates stage.

Thanks Minhajuddin !