DSXchange

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.

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

Hi,

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

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,

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.

Then contact your official support provider.

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.