LastRowInGroup() function not working all of a sudden

[saiwelcomes]

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.

[rahcomp]

Try converting your sort / partition keys to not nullable and then try once.

[saiwelcomes]

Hi,

I have already applied non-nullable on sorting and partitioning columns. Is there any environment variable setting for this.

[jwiles]

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,

[saiwelcomes]

Hi,

APT_NO_SORT_INSERTION varaible was already set to False in our environment.

I am really in need of urgent help on this.

Thanks in advance.

[chulett]

Then contact your official support provider.

[saiwelcomes]

Hi Craig,

The problem is resolved. :D I just set APT_NO_SORT_INSERTION flag to True and compiled the jobs. Then again set APT_NO_SORT_INSERTION flag to false. Restarted the server as well. I think the reason for this is cache overflow.

Thanks to all for your replies.