Job running continously
Posted: Tue Nov 17, 2009 11:21 pm
Hi All,
I am having one parallel multi instance job with the following job design :
Netezza DB Table (N1) -> Lookup -> Xfmr -> Netezza DB table (N3)
Netezza table (N2)
Here i am selecting data from one netezza table N1 & doing lookup on another netezza table N2. In the lookup if both the tables records match, the record from N1 will be propogating to further stages say Xfmr & N3 and when there is no match record from N1 will be dropped.
When i am executing this job it is getting completed for few invocations but the same job is running continously for other invocation ids.
When i try to stop the job, following message are coming in the log:
1. " main_program: ORCHESTRATE step execution terminating due to SIGINT "
2. Parallel job was aborted
Can any one guide me regarding this issue, Any help is appreciated .
I am having one parallel multi instance job with the following job design :
Netezza DB Table (N1) -> Lookup -> Xfmr -> Netezza DB table (N3)
Netezza table (N2)
Here i am selecting data from one netezza table N1 & doing lookup on another netezza table N2. In the lookup if both the tables records match, the record from N1 will be propogating to further stages say Xfmr & N3 and when there is no match record from N1 will be dropped.
When i am executing this job it is getting completed for few invocations but the same job is running continously for other invocation ids.
When i try to stop the job, following message are coming in the log:
1. " main_program: ORCHESTRATE step execution terminating due to SIGINT "
2. Parallel job was aborted
Can any one guide me regarding this issue, Any help is appreciated .