unable to view data in seq.file stage in parallel job
Moderators: chulett, rschirm, roy
unable to view data in seq.file stage in parallel job
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
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
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Re: unable to view data in seq.file stage in parallel job
Did you check this?dxp wrote: ##W TFAR 000000 23:48:05(000) <main_program> File archive: Trouble creating file "/tmp/APTcs1000a9ca91c1"
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
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
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
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
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Thx Whale.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.
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hi ray,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?
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
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Have you seen this post maybe this can help you
viewtopic.php?t=93989&highlight=trouble ... teing+file
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)
Thomas Alva Edison(1847-1931)
Thx us1aslam1us.us1aslam1us wrote:Have you seen this post maybe this can help you
viewtopic.php?t=93989&highlight=trouble ... teing+file
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