difference stage error - Unexpected termination by Unix

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

difference stage error - Unexpected termination by Unix

Post by deesh »

Hi,

I am getting after passing the records to difference stage and the source count is 1540 and 2 source count is 6

RemoveEntriesInExceptionList,0: Input 0 consumed 1540 records.
Input 1 consumed 2 records.

RemoveEntriesInExceptionList,0: Output 0 produced 1539 records.

Warnings
----------
RemoveEntriesInExceptionList,0: The after input is not sorted at record 1.

main_program: APT_PMsectionLeader(1, node1), player 3 - Unexpected termination by Unix signal 9(SIGKILL).




pls let me know any one
Last edited by deesh on Wed Apr 02, 2014 5:38 am, edited 1 time in total.
dsetlteam
Premium Member
Premium Member
Posts: 35
Joined: Mon Feb 10, 2014 10:14 pm
Location: USA

Post by dsetlteam »

From the error message, it is clear that the input data from After link is not sorted. Before passing the data to the Difference stage, sort the data (preferably using sort stage)
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

Post by deesh »

Even i have done sorting in differencestage itself.
but same result

Early it was giving fine results without sorting data.
dsetlteam
Premium Member
Premium Member
Posts: 35
Joined: Mon Feb 10, 2014 10:14 pm
Location: USA

Post by dsetlteam »

Check if there is any special character in the key value on which the data is being sorted
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

Post by deesh »

yes, i have done linksort for both the links, after sort it is working fine.

Early i tried with one linksort, after giving for both, it is working fine.
Post Reply