unable to view data in seq.file stage in parallel job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dxp
Charter Member
Charter Member
Posts: 48
Joined: Sat Oct 01, 2005 10:23 am

unable to view data in seq.file stage in parallel job

Post by dxp »

Hi All,
I have a simple job - reading from one seq. file and then simply writing to another seq.file.

while I tried to view data in source seq.stage..it produced the following error.
but job compiles.
while I run the job, again it produces same error lines as below.

Previously I am able do this using parallel jobs.
suddenly somthing happend, once I installed Cognos server on the same machine.

I developed same job as 'server job', it works fine.
It gives problem only if I develop a 'prallel job'.

Anybody have idea whats the problem?


##I TOSH 000002 23:48:04(001) <main_program> orchgeneral: loaded
##I TOSH 000002 23:48:04(002) <main_program> orchsort: loaded
##I TOSH 000002 23:48:04(003) <main_program> orchstats: loaded
##W TCOS 000049 23:48:04(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000001 23:48:04(009) <main_program> APT configuration file: D:/Ascential/DataStage/Configurations/default.apt
##W TFAR 000000 23:48:05(000) <main_program> File archive: Trouble creating file "/tmp/APTcs1000a9ca91c1"
>##F TFPX 000002 23:48:05(001) <main_program> Fatal Error: Null archive.


...dxp
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

make sure that the file path and file format you are specifying is correct .
hi sam here
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Re: unable to view data in seq.file stage in parallel job

Post by kcbland »

dxp wrote: ##W TFAR 000000 23:48:05(000) <main_program> File archive: Trouble creating file "/tmp/APTcs1000a9ca91c1"
Did you check this?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

You need to be searching the forum. The solution you are looking for already exists. Do an exact search on "File archive: Trouble creating file".

If you still don't find it, which I presume is highly unlikely. Then, click HERE.

Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
dxp
Charter Member
Charter Member
Posts: 48
Joined: Sat Oct 01, 2005 10:23 am

Post by dxp »

I_Server_Whale wrote:You need to be searching the forum. The solution you are looking for already exists. Do an exact search on "File archive: Trouble creating file".

If you still don't find it, which I presume is highly unlikely. Then, click HERE.

Whale.
Thx Whale.
I tried that too.

/tmp folder is existing on my machine.
there are two environment variables - TEMP & TMP
TEMP is in 'User Variables'
TMP is in both 'User Variables' and 'System Variables'.
TMP is pointing to 'tmp' in 'System Variables' only.
In 'User Variables' its pointing to some other location.


Again I checked the permissions on 'tmp' folder using MKSToolkit.
I set SID for the folder 'tmp'

permissions look like below

drwxrwsrwx

...am I missing something in environment variable settings?

One thing I want to mention is.....I am able to run parallel jobs on the same machine previously.
Only when I installed Cognos server, it started giving this problem.
I removed Cognos server and tried again, but no success.
I guess some script file is currepted.

...dxp
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I think it's much more likely that /tmp fills during a job run. Can you, or the UNIX Administrator, delete anything unneeded from the /tmp directory and/or allocate more space to it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dxp
Charter Member
Charter Member
Posts: 48
Joined: Sat Oct 01, 2005 10:23 am

Post by dxp »

ray.wurlod wrote:I think it's much more likely that /tmp fills during a job run. Can you, or the UNIX Administrator, delete anything unneeded from the /tmp directory and/or allocate more space to it?
hi ray,

mine is windows OS.
i checked the parent directories of the 'tmp' folder...they are having enough space.
so, space is available..

do we need to explicitely increase the space in windows environment?

..dxp
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Have you seen this post maybe this can help you

viewtopic.php?t=93989&highlight=trouble ... teing+file
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
dxp
Charter Member
Charter Member
Posts: 48
Joined: Sat Oct 01, 2005 10:23 am

Post by dxp »

us1aslam1us wrote:Have you seen this post maybe this can help you

viewtopic.php?t=93989&highlight=trouble ... teing+file
Thx us1aslam1us.

that link solved my problem.

my DS is in "D:" drive.
but my 'tmp' file is in 'C:\' drive.

the thing which misleaded me was....'ROOTDIR' variable still points to 'C:\' drive only. ..and MKS toolkit also in C drive.

I created 'tmp' in my 'D:\' drive where I installed my DS.

Thank you all of you for your precious time.


....dxp
Post Reply