How to ignore warning......in sequencer

sagar deshmukh · Post by **sagar deshmukh** » Fri May 08, 2009 12:30 am

ETL job receives 2 files (or 1 file) and inserts into PeopleSoft Staging table.

Whenever we receive 1 file the ETL job finishes but with warning message saying that another file was not found.

MetlifeBillSeq..JobControl (DSWaitForFile): Timed out after 00:00:05 while checking file '/BOSS/PXWork_12/staging/IBA032/BLOCKBUST_WK_BILL.DAT'

Due to this warning message TWS job is aborting and not able to trigger successive jobs.

we have used wait for file activity stage..it has time out set as 00:00:05...

can you please let me know how to eliminate the warning ...or how to make the job sucessfull

ray.wurlod · Post by **ray.wurlod** » Fri May 08, 2009 2:28 am

You can't eliminate it. The activity expired its given timeout period and has to alert you of that fact. Emplace an explicit Failure trigger on the WaitForFile activity to handle the situation, but you can't eliminate the warning. You can, however, use a local message handler to demote its severity to informational if that's really what you want. I'd be thinking very hard about whether that is true, if I were you.

sagar deshmukh · Post by **sagar deshmukh** » Fri May 08, 2009 3:08 am

if we supress this warning for this job will it help?

chulett · Post by **chulett** » Fri May 08, 2009 7:18 am

I thought "message handlers" could only be used in Parallel jobs.

sagar deshmukh · Post by **sagar deshmukh** » Fri May 08, 2009 10:12 am

we have message handler available in sever also.... but documents speaks only about parallel....anybody have idea?