Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: Gary on 17 Jul 2014 08:16:19 AM

Title: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: Gary on 17 Jul 2014 08:16:19 AM
I an getting the error while executing the job stream :

Any help on this.:

Error
*************************
[INTERNAL   - 12:11:43] JobStream Node 13 'OASP_STG'; initializing

DM-FIL-0210 Cannot open (write) [errno 6] DSQ file '/tmp/00005c27_301_ztgsusretl1.dsq'.

jobstream -- failed (17-Jul-2014 12:11:43)
Title: Re: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: MFGF on 17 Jul 2014 08:35:00 AM
Quote from: DilsherSingh on 17 Jul 2014 08:16:19 AM
I an getting the error while executing the job stream :

Any help on this.:

Error
*************************
[INTERNAL   - 12:11:43] JobStream Node 13 'OASP_STG'; initializing

DM-FIL-0210 Cannot open (write) [errno 6] DSQ file '/tmp/00005c27_301_ztgsusretl1.dsq'.

jobstream -- failed (17-Jul-2014 12:11:43)

Hi,

It looks like the jobstream is failing at Node 13 - a node named OASP_STG. What does this node do if you examine the jobstream?

My guess is that it is trying to create a file and the user running the data manager job does not have permissions to do so. Is the jobstream being run via a schedule or directly by a logged-in user in Data Manager Designer?

MF.
Title: Re: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: Gary on 17 Jul 2014 08:50:28 AM
OASP_STG is a jobstream executing the fact builds.

I did not find this error in the previous executions and its strange to find now.

i am executing the Jobstreams by LINUX platform.
Title: Re: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: MFGF on 17 Jul 2014 09:11:03 AM
Quote from: DilsherSingh on 17 Jul 2014 08:50:28 AM
OASP_STG is a jobstream executing the fact builds.

I did not find this error in the previous executions and its strange to find now.

i am executing the Jobstreams by LINUX platform.

So the task is being run remotely on a linux server? What user ID does the Data Manager Socket Server service (daemon) use on the linux box? Does it have permission to create files? Could it simply be that the temp space on the server filled up?

MF.
Title: Re: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: Gary on 17 Jul 2014 09:35:40 AM
Yes we are executing remotely from Linux Ssrver and it worked perfectly now.

Seems strange.
Title: Re: DM-FIL-0210 Cannot open (write) [errno 6] DSQ file
Post by: MFGF on 17 Jul 2014 10:01:22 AM
Quote from: DilsherSingh on 17 Jul 2014 09:35:40 AM
Yes we are executing remotely from Linux Ssrver and it worked perfectly now.

Seems strange.

Probably an indication the server temp space was too low at the time the failure occurred? You might want to check with the server admins to see if it can be cleared down or expanded?

MF.
Text only | Text with Images