Executing DB2 Stored Procedure - Fails

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
dtatem
Participant
Posts: 54
Joined: Wed Jun 09, 2004 7:50 am

Executing DB2 Stored Procedure - Fails

Post by dtatem »

When Executing a DB2 Stored Procedure, I am getting the following error message

node_node2: Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::Eof: From: File archive loading from: /app/Ascential/work/temp/APTps45890dfa280a9.


What does this means and does anyone have a correction for this? Also why is it that you cannot have a transformer between the store procedure stage and a flat file stage. When I do this it fails when trying to compile

thanks

dtatem
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Are there any other error/warning messages?
Have you ever successfully compiled a job with a transformer in it? Its more than likely that your C compiler is not set up. I dont see any reason why a transformer cannot sit between an STP and sequential file stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
dtatem
Participant
Posts: 54
Joined: Wed Jun 09, 2004 7:50 am

Post by dtatem »

Thanks for replying...after future review, it appears that our /tmp path was full..strange error message though
Post Reply