Job Design is as follows
ORA---> IPC----> Transform---along with 3 lookups---->finally --->Target(ORA)
The following is the error i got
Abnormal termination of stage EligPxiLoadFileExtractJob.12752.InterProcess_125.IDENT5 detected
When i reset the job I got the below error
EligPxiLoadFileExtractJob.12752.INP_PERS_FILE_CNT.INP_CNT_Lnk: DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'.
I tried removing the IPC and I reran the job,it worked fine.
There was no change done to the Timeout seconds or any properties.I even tried to re-import the job,still did not work.
Abnormal Termination Of IPC Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am
Re: Abnormal Termination Of IPC Stage
Is this hashed file used in one of your 3 lookups?Vinodanand wrote:...DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am
Hi Arnd,
This is a hash file where record counts are written.Sorry this is not used as a look up,data is written into this file.
When i run it without the IPC it works fine.I could also see the following error.
From previous run
DataStage Job 971 Phantom 19565
jobnotify: Unknown error
jobnotify: Unknown error
jobnotify: Unknown error
jobnotify: Unknown error
DataStage Phantom Finished.
[19661] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_141.IDENT8 1 0/0/1 - core dumped.
[19654] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_132.IDENT6 1 0/0/1 - core dumped.
[19632] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_125.IDENT5 1 0/0/1 - core dumped.
[19659] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_136.IDENT7 1 0/0/1 - core dumped.
----------------------------------
From previous run
DataStage Job 971 Phantom 19654
Abnormal termination of DataStage.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.IPCOpen at address 8c0.
This is a hash file where record counts are written.Sorry this is not used as a look up,data is written into this file.
When i run it without the IPC it works fine.I could also see the following error.
From previous run
DataStage Job 971 Phantom 19565
jobnotify: Unknown error
jobnotify: Unknown error
jobnotify: Unknown error
jobnotify: Unknown error
DataStage Phantom Finished.
[19661] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_141.IDENT8 1 0/0/1 - core dumped.
[19654] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_132.IDENT6 1 0/0/1 - core dumped.
[19632] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_125.IDENT5 1 0/0/1 - core dumped.
[19659] DSD.StageRun EligPxiLoadFileExtractJob.12752 EligPxiLoadFileExtractJob.InterProcess_136.IDENT7 1 0/0/1 - core dumped.
----------------------------------
From previous run
DataStage Job 971 Phantom 19654
Abnormal termination of DataStage.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.IPCOpen at address 8c0.
According to your first post, there is no hashed file used. Where do you write these records counts? The IPC stage itself is probably not causing your erroring, but by using this stage you make DS use distinct processes at runtime, which in turn is probably causing your problem.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Abnormal Termination Of IPC Stage
Errors written to the log by the Reset process can be ignored. What matters are the ones logged by the failing process and anything 'From previous run...'.Vinodanand wrote:When i reset the job I got the below error
EligPxiLoadFileExtractJob.12752.INP_PERS_FILE_CNT.INP_CNT_Lnk: DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am