Page 1 of 1
Failed to open sequential file
Posted: Wed Jul 05, 2006 8:24 am
by Krazykoolrohit
Hi everyone,
I am constantly getting the following error in my project. Funny thing is that i do not get this error in the same job twice. but whenever i run the project some of the jobs get this error.
DSD.SEQOpen Failed to open LT_Gp1b_LtAuditDoc_In2 in directory /Ascential/Datastage/Projects/UNIFI/Data
STATUS = -1.
thanx,
rohit
Posted: Wed Jul 05, 2006 9:06 am
by kcbland
When I've seen this on Windoze servers it's been because too many jobs to simultaneously executing.
Posted: Wed Jul 05, 2006 9:24 am
by Krazykoolrohit
Do we have any optimum number of jobs which can be run? anything ideal?
If we run on unix then it should be fine?
Posted: Wed Jul 05, 2006 9:52 am
by kcbland
Weird problems occur when you overload any system with too much activities. Windoze seems to be especially problematic, haven't you noticed?
Posted: Wed Jul 05, 2006 10:02 am
by Krazykoolrohit
Ya i have. But the thing is that i have to show a normal run of the project without any aborts for the support team to accept the project. was wondering wat i culd do.
Re: Failed to open sequential file
Posted: Wed Jul 05, 2006 2:01 pm
by gateleys
Krazykoolrohit wrote:I am constantly getting the following error in my project. Funny thing is that i do not get this error in the same job twice. but whenever i run the project some of the jobs get this error.
Hey Rohit,
A quick solution would be to run your jobs over and over again such that all of them get the error [ Since you
CONSTANTLY get this error and that it has never occured in the same job twice, it should not be hard to achieve it.] Then, voila!! you will not get those errors again (based on your observation).
