Sort Stage Fatal Error.....

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
enigmatic28
Participant
Posts: 13
Joined: Thu Jan 03, 2008 7:54 pm

Sort Stage Fatal Error.....

Post by enigmatic28 »

Hi,

I would just like to ask if why the Sort Stage in the parallel job suddenly returns this fatal error...
Operator terminated abnormally: runLocally did not return APT_StatusOk
What does it mean and what is needed to fix it?

Thanks...
Top
BugFree
Participant
Posts: 82
Joined: Wed Dec 13, 2006 6:02 am

Post by BugFree »

Firstly do a search on the full error message. Are there any other warnings/errors in the log?
Ping me if I am wrong...
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

In particular, how do you know it's the Sort stage? Please post full error message from the job log (copy/paste), and any others that may have occurred.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
enigmatic28
Participant
Posts: 13
Joined: Thu Jan 03, 2008 7:54 pm

Post by enigmatic28 »

Hi,

The other fatal error found is this one:
Operator's runLocally() failed

Thanks...
Top
enigmatic28
Participant
Posts: 13
Joined: Thu Jan 03, 2008 7:54 pm

Post by enigmatic28 »

Hi, Here is the job log:

Since the error was srtClaims,0: Operator terminated abnormally: runLocally did not return APT_StatusOk, and srtClaims is the name of the sort stage, i assumed that it was the sort stage that is at fault...
Occurred: 8:10:24 PM On date: 3/27/2008 Type: Control
Event: Starting Job CopyOfCL02115GetOriginalAdmitDate. (...)

Occurred: 8:10:24 PM On date: 3/27/2008 Type: Info
Event: Attached Message Handlers: (...)

Occurred: 8:10:24 PM On date: 3/27/2008 Type: Info
Event: Environment variable settings: (...)

Occurred: 8:10:25 PM On date: 3/27/2008 Type: Info
Event: Parallel job initiated (...)

Occurred: 8:10:25 PM On date: 3/27/2008 Type: Info
Event: main_program: Ascential DataStage(tm) Enterprise Edition 7.5.0.1 (...)

Occurred: 8:10:25 PM On date: 3/27/2008 Type: Info
Event: main_program: The open files limit is 2000; raising to 2147483647.

Occurred: 8:10:25 PM On date: 3/27/2008 Type: Info
Event: main_program: orchgeneral: loaded (...)

Occurred: 8:10:25 PM On date: 3/27/2008 Type: Info
Event: main_program: APT configuration file: /ds/dsadm/Ascential/DataStage/Configurations/PXConfigIFS3_4.apt (...)

Occurred: 8:10:26 PM On date: 3/27/2008 Type: Warning
Event: t2xGetOAD: Input Dataset 0 has partitioning other than Entire specified; disabling memory sharing.

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Warning
Event: dsWithOAD: When checking operator: Operator of type "APT_CopyOperator": Will partition despite preserve-partitioning flag on dataset on input port 0

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Info
Event: Sequential_File_101,0: Import complete. 52 records imported successfully, 0 rejected.

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,0: Operator's runLocally() failed

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Info
Event: srtClaims,0: Output 0 produced 0 records

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,1: Operator's runLocally() failed

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Info
Event: srtClaims,1: Output 0 produced 0 records

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,1: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,2: Operator's runLocally() failed

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Info
Event: srtClaims,2: Output 0 produced 0 records

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,3: Operator's runLocally() failed

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Info
Event: srtClaims,3: Output 0 produced 0 records

Occurred: 8:10:29 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,2: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:10:30 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,3: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:10:35 PM On date: 3/27/2008 Type: Fatal
Event: main_program: Unexpected exit status 1 (...)

Occurred: 8:10:35 PM On date: 3/27/2008 Type: Fatal
Event: main_program: Step execution finished with status = FAILED.

Occurred: 8:10:35 PM On date: 3/27/2008 Type: Info
Event: main_program: Startup Time 0:09 Production Run Time 0:01

Occurred: 8:10:35 PM On date: 3/27/2008 Type: Info
Event: Messages handled: (...)

Occurred: 8:10:35 PM On date: 3/27/2008 Type: Control
Event: Job CopyOfCL02115GetOriginalAdmitDate aborted.

Occurred: 8:41:06 PM On date: 3/27/2008 Type: Control
Event: Starting Job CopyOfCL02115GetOriginalAdmitDate. (...)

Occurred: 8:41:06 PM On date: 3/27/2008 Type: Info
Event: Attached Message Handlers: (...)

Occurred: 8:41:06 PM On date: 3/27/2008 Type: Info
Event: Environment variable settings: (...)

Occurred: 8:41:07 PM On date: 3/27/2008 Type: Info
Event: Parallel job initiated (...)

Occurred: 8:41:07 PM On date: 3/27/2008 Type: Info
Event: main_program: Ascential DataStage(tm) Enterprise Edition 7.5.0.1 (...)

Occurred: 8:41:07 PM On date: 3/27/2008 Type: Info
Event: main_program: The open files limit is 2000; raising to 2147483647.

Occurred: 8:41:07 PM On date: 3/27/2008 Type: Info
Event: main_program: orchgeneral: loaded (...)

Occurred: 8:41:08 PM On date: 3/27/2008 Type: Info
Event: main_program: APT configuration file: /ds/dsadm/Ascential/DataStage/Configurations/PXConfigIFS3_4.apt (...)

Occurred: 8:41:08 PM On date: 3/27/2008 Type: Warning
Event: t2xGetOAD: Input Dataset 0 has partitioning other than Entire specified; disabling memory sharing.

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Warning
Event: dsWithOAD: When checking operator: Operator of type "APT_CopyOperator": Will partition despite preserve-partitioning flag on dataset on input port 0

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Info
Event: Sequential_File_101,0: Import complete. 52 records imported successfully, 0 rejected.

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,0: Operator's runLocally() failed

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Info
Event: srtClaims,0: Output 0 produced 0 records

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,1: Operator's runLocally() failed

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Info
Event: srtClaims,1: Output 0 produced 0 records

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,1: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,2: Operator's runLocally() failed

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Info
Event: srtClaims,2: Output 0 produced 0 records

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,3: Operator's runLocally() failed

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Info
Event: srtClaims,3: Output 0 produced 0 records

Occurred: 8:41:11 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,2: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:41:12 PM On date: 3/27/2008 Type: Fatal
Event: srtClaims,3: Operator terminated abnormally: runLocally did not return APT_StatusOk

Occurred: 8:41:17 PM On date: 3/27/2008 Type: Fatal
Event: main_program: Unexpected exit status 1 (...)

Occurred: 8:41:17 PM On date: 3/27/2008 Type: Fatal
Event: main_program: Step execution finished with status = FAILED.

Occurred: 8:41:17 PM On date: 3/27/2008 Type: Info
Event: main_program: Startup Time 0:09 Production Run Time 0:01

Occurred: 8:41:17 PM On date: 3/27/2008 Type: Info
Event: Messages handled: (...)

Occurred: 8:41:17 PM On date: 3/27/2008 Type: Control
Event: Job CopyOfCL02115GetOriginalAdmitDate aborted.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

OK, it's the Sort stage srcClaims, and the problem has occurred on node numbers 0,1,2 and 3. This suggests that there's something wrong with how the Sort stage is set up - something that is syntactically correct (so the job compiles) but which the tsort operator can not manage. Can you thoroughly investigate what you've done with your Sort stage? Also, did you run out of scratch space while the sort was running? And is the error reproducible?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
enigmatic28
Participant
Posts: 13
Joined: Thu Jan 03, 2008 7:54 pm

Post by enigmatic28 »

Ah.. Ok, thanks for the info.. i thought the problem was the job itself...

thanks...
Top
Post Reply

Return to “General”