Hi,
why a job do not come into finished state (in Datastage director log file )while loading the data into data base from a sequential file.
I mean why it still shows that it is in running state....for a long time...
it gets hanged in that state(running)
thanku
When does a job hang in RUN state
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
When does a job hang in RUN state
Shivaranjani
There could be several reasons why a job hangs. Do you have all your metadata defined correctly, have all the necessary insert/update permissions on the target table, Is your data violating any unique key constraints.
I would try to insert one record in the target table manually using SQL and see what error message it throws.
I would try to insert one record in the target table manually using SQL and see what error message it throws.
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
SIGINT error appeared because you tried to interrupt a process. ie. you might have tried to stop the job (pause ?
)
![Confused :?](./images/smilies/icon_confused.gif)
G SHIVARANJANI wrote: But i would like to let u know that the error shown in directory is
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
When i tried to pause the job.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>