I have a requirement to delete some data from source before loading into target therefore I am running a delete command with where condition in oracle stage OPEN command option.
It runs fine till it find data to delete but when there is no data found to delete the job aborts with errors
node_node0: Player 1 terminated unexpectedly.
main_program: APT_PMsectionLeader(1, node0), player 1 - Unexpected exit status 1.
main_program: Step execution finished with status = FAILED.
warning --- main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400.
No output will be sent to port 13,400 for the rest of the job.
Hi,
You have to split the task into couple of jobs like, one job will read the data and write into a sequential file and at the same time you can delete records by using other ;pipeline', and second job would be loading data into target so that it will not give any problems.
node_node0: Player 1 terminated unexpectedly.
main_program: APT_PMsectionLeader(1, node0), player 1 - Unexpected exit status 1.
main_program: Step execution finished with status = FAILED.
warning --- main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400.
No output will be sent to port 13,400 for the rest of the job.
[/quote]
this error means you cannot see the job progress in the designer meaning the performance stats will not be shown on the designer