Error for DB2 job
Moderators: chulett, rschirm, roy
Error for DB2 job
Hello
I'm running into an error in my production environment that I'm not getting in any other environment. The job runs a couple of SQL statements using the DB2 API stage. The first stage gets the latest records from a table and the 2nd stage deletes from another table where the keys match. The errors I'm getting are very generic:
Failure during execution of operator logic.
node_node2: Player 2 terminated unexpectedly.
node_node1: Player 1 terminated unexpectedly.
Transformer_1,2: Fatal Error: waitForWriteSignal(): Premature EOF on node EC07P502 No such file or directory
All of these errors appear several times in the log before the job aborts. There aren't any additional error messages.
I have set $APT_DISABLE_COMBINATION to True.
Could this be a permissions issue even though we're not getting a permissions error returned in our log?
Thanks in advance,
Heather
I'm running into an error in my production environment that I'm not getting in any other environment. The job runs a couple of SQL statements using the DB2 API stage. The first stage gets the latest records from a table and the 2nd stage deletes from another table where the keys match. The errors I'm getting are very generic:
Failure during execution of operator logic.
node_node2: Player 2 terminated unexpectedly.
node_node1: Player 1 terminated unexpectedly.
Transformer_1,2: Fatal Error: waitForWriteSignal(): Premature EOF on node EC07P502 No such file or directory
All of these errors appear several times in the log before the job aborts. There aren't any additional error messages.
I have set $APT_DISABLE_COMBINATION to True.
Could this be a permissions issue even though we're not getting a permissions error returned in our log?
Thanks in advance,
Heather
what a man is contributes much more to his happiness than what he has, or how he is regarded by others.
Could this be a permissions-issue? Yes, it could. "No such file or directory" signifies that Your user can't see the file, not necessarily that it is not there. So it may just as well be that You haven't got read permissions on the file or access to the path where the file is located.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In other cases, I have seen the message "No such file or directory" indicates the file is not found but if the file exists with incorrect permissions then the error will instead indicate a permission problem. Still, it could be permissions.
Is this the first time this job has run in production or did it just recently start to abort?
It may help to open a support case if this is the first time seeing this error.
Is this the first time this job has run in production or did it just recently start to abort?
It may help to open a support case if this is the first time seeing this error.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Thanks for all the replies. I did notice in the job that the config file property was pointing to our UT environment even though the parameter had been set to PR and the job recompiled. I opted to import the job again and reset the config file property. That seemed to do the trick.
Must have been a corrupt job. I imported XML instead of DSX too...not sure it made the difference.
cheers,
Heather
Must have been a corrupt job. I imported XML instead of DSX too...not sure it made the difference.
cheers,
Heather
what a man is contributes much more to his happiness than what he has, or how he is regarded by others.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: