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
DataStage has no facility for pausing jobs. I don't know what you did, but it caused the job to abort.G SHIVARANJANI wrote:...When i tried to pause the job...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- 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 ? )
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>