Hi All,
I have used LastRowInGroup() funtion in one of my job to get the expected result as per my requirement. The job is working fine till yesterday. All of a sudden, the job is not working properly and the job is getting aborted. The error message get displayed is "Error when checking operator: No input sort key information found. Keys being checked: record
( INTERFACE_INSTANCE_ID: int32;
). Input data must be sorted with the keys that are passed to key-break function calls. If input data has already been sorted, a sort stage needs to be inserted on the input link with each key specified in "Don't Sort" mode. If input data has been pre-grouped, a sort stage needs to be inserted on the input link with at least one key not in "Don't Sort" mode."
But I did sorting and could not identify the root cause of the problem
Any suggestions/help is highly appreciated.
LastRowInGroup() function not working all of a sudden
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
LastRowInGroup() function not working all of a sudden
Regards,
Sai Krishna
Sai Krishna
Re: LastRowInGroup() function not working all of a sudden
Try converting your sort / partition keys to not nullable and then try once.
Rahul
DS Lover
DS Lover
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
Possibly something has changed either in the job or within the project the job belongs to. This problem sounds as if it may be related to <a href="http://www-01.ibm.com/support/docview.w ... 9249">APAR JR39249</a> from IBM. I suggest you contact your official support provider to verify.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India