DSXchange

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.

I also see the following error

Fault type is 10. Layer type is BASIC run machine.

Fault occurred in BASIC program DSD.IPCOpen at address 8c0.

Please let me know what could be the cause of this issue.

Search the forums for 'Fault type is 10'. I know there's posts out there.

Vinodanand wrote:...DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'...

Is this hashed file used in one of your 3 lookups?

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.

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.

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'.

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...'.

Hi ,


The issue has been resolved. The /tmp directory was at 100% and hence the IPC stages were abnormally terminated. I cleared teh same and ran the job and they went through fine.

Thanks all for your help.

Regards,
Vinod