Failed to open sequential file

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 05, 2006 8:24 am

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

kcbland · Post by **kcbland** » Wed Jul 05, 2006 9:06 am

When I've seen this on Windoze servers it's been because too many jobs to simultaneously executing.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 05, 2006 9:24 am

Do we have any optimum number of jobs which can be run? anything ideal?

If we run on unix then it should be fine?

kcbland · Post by **kcbland** » Wed Jul 05, 2006 9:52 am

Weird problems occur when you overload any system with too much activities. Windoze seems to be especially problematic, haven't you noticed?

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 05, 2006 10:02 am

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.

gateleys · Post by **gateleys** » Wed Jul 05, 2006 2:01 pm

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).

DSXchange

Failed to open sequential file

Failed to open sequential file

Re: Failed to open sequential file