Random Link collector Error
Moderators: chulett, rschirm, roy
Random Link collector Error
Hi,
I've great trouble with a job that fail ramdomly with this message :
"DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization.DSLink178: ds_ipcopen() - Error in open(/tmp/ade.ReportingPrism.DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization-Link_Collector_167.DSLink178) - No such file or directory"
Could anybody help me ?
Thx a lot
I've great trouble with a job that fail ramdomly with this message :
"DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization.DSLink178: ds_ipcopen() - Error in open(/tmp/ade.ReportingPrism.DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization-Link_Collector_167.DSLink178) - No such file or directory"
Could anybody help me ?
Thx a lot
Last edited by fgallet on Mon Jan 23, 2006 9:28 am, edited 1 time in total.
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Hi,
Could you please send some more details as to what your trying to do using the LINK COLLECTOR Stage.
As far as the message you have sent, I guess you taking a couple of Sequential Files and using a LINK COLLECTOR stage ur putting into a Single file, (Correct me if I am wrong :D )
**
ds_ipcopen() - Error in open(/tmp/ade.ReportingPrism.DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization-Link_Collector_167.DSLink178) - No such file or directory"
**
Could you please check the Permissions of the Input files (Read Access) !!.
With Regards
M
Could you please send some more details as to what your trying to do using the LINK COLLECTOR Stage.
As far as the message you have sent, I guess you taking a couple of Sequential Files and using a LINK COLLECTOR stage ur putting into a Single file, (Correct me if I am wrong :D )
**
ds_ipcopen() - Error in open(/tmp/ade.ReportingPrism.DWHAlimACFO.Load_ACFO_Daily_w.ACPRNormalization-Link_Collector_167.DSLink178) - No such file or directory"
**
Could you please check the Permissions of the Input files (Read Access) !!.
With Regards
M
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
you're Wrong ! :D
there's no sequential files.
i'm using Link Collector to "Normalize" several data Flow (Ora9i) and build a datamart table (Ora9i). That error message let me think there's a problem with temp files but I've no clue ....
Thanks fo r confirming the above, then you should be checking for the permissions on TEMP Files being created.
Anyway good for giving some information as to what your trying to do instead of just teh error message.
M
[/b]
there's no sequential files.
i'm using Link Collector to "Normalize" several data Flow (Ora9i) and build a datamart table (Ora9i). That error message let me think there's a problem with temp files but I've no clue ....
Thanks fo r confirming the above, then you should be checking for the permissions on TEMP Files being created.
Anyway good for giving some information as to what your trying to do instead of just teh error message.
M
[/b]
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you are running your jobs as user dsadm then the permissions are most likely not your problem. The most likely cause is what Ray has already mentioned - /tmp either running out of space or inodes. These temporary files are, I think, named pipes (use ls -al and see if the first character is a "p" in the attribute list). The fact that this error is sporadic makes it unlikely to be access rights and more likely to be disk space.
And are you running your jobs as user "dsadmin" as well? Also try to measure your /tmp use during a run; 4% sounds like you have a lot of space left but if your /tmp only has a couple of Mb allocated it will fill up quickly and DataStage does try to clean up after itself.
p.s. Please edit your topic - it is used in searching so "any ideas" ranks pretty low
Perhaps "Sporadic problems on link join sequential files" or something similar might be more descriptive.
p.s. Please edit your topic - it is used in searching so "any ideas" ranks pretty low
![Confused :?](./images/smilies/icon_confused.gif)
That means that at least the cause of the error is explained - the files are being created somewhere in your environment as normal sequential files instead of as pipes. What kind of collection algorithm are you using? If you change the name of the stage does the error re-occur (if not, then it is some other job creating these files, it it still occurs it is something to do with the stage itself).