Page 1 of 1

Executing DB2 Stored Procedure - Fails

Posted: Wed May 30, 2007 2:47 pm
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

Posted: Thu May 31, 2007 7:13 am
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.

Posted: Thu May 31, 2007 7:36 am
by dtatem
Thanks for replying...after future review, it appears that our /tmp path was full..strange error message though