Page 1 of 1

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

Posted: Mon Jan 15, 2007 12:27 pm
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

Posted: Mon Jan 15, 2007 1:22 pm
by samsuf2002
make sure that the file path and file format you are specifying is correct .

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

Posted: Mon Jan 15, 2007 1:24 pm
by kcbland
dxp wrote: ##W TFAR 000000 23:48:05(000) <main_program> File archive: Trouble creating file "/tmp/APTcs1000a9ca91c1"
Did you check this?

Posted: Mon Jan 15, 2007 1:29 pm
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.

Posted: Mon Jan 15, 2007 10:53 pm
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

Posted: Mon Jan 15, 2007 11:50 pm
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?

Posted: Tue Jan 16, 2007 12:40 pm
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

Posted: Tue Jan 16, 2007 4:11 pm
by us1aslam1us
Have you seen this post maybe this can help you

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

Posted: Wed Jan 17, 2007 9:03 am
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