Hi,
I have couple of reports planning to run on file based event, I have scheduled few reports with single file based event for testing with different timings like 8a.m, 9a.m, 10a.m etc…
The first report has been run successfully, because the file is coming exactly at 8a.m, after that rest of the reports still showing pending…
May I know why rest of the reports are showing pending(even file exists)??
FYI… I didn’t clean up the file after success of the first report.
I was expecting rest of the reports will also get success because those reports also depending on the file based event.
Can any one come across this kind of scenario…
Thanks in advance…
Tims_Bo 
(BOB member since 2008-07-26)
Hi Expert,
I am working on file based event, I found few things but I am not sure whether those are bugs or not.
==> Report scheduled at 8a.m which is depending on the file based event.
if file comes before 8a.m report is not working
if file comes after 8a.m then report is working
Is it bug or something else??
if its not bug then what would be the solution for my first post in this mail…
Can anybody have come across this kind of scenario…need help…
Tims_Bo (BOB member since 2008-07-26)
Hi,
There are many posts related to file based scheduling. A recurring instance dependent on a file event does not work in the way you have assume (since you think it is a bug). Let’s say you have scheduled a report for 8am and it is also made to wait for a file event. The report instance is generated only if the file appears in the monitored directory after the recurrence time of 8am. If the file appears between 8am and 9am, then the 8am instance would be successful whereas instances at 9am and thereafter would fail.
vinod_menon (BOB member since 2007-04-09)
Thanks for your good response…
but whereas instances at 9 a.m or after that, report status is showing pending, I don’t think so it will fail…
Thanks,
Tims_Bo (BOB member since 2008-07-26)
It shows pending because the instance is waiting for the file event to occur again.
vinod_menon (BOB member since 2007-04-09)
You need to make sure that once the report gets succes the file gets deleted.
You can make the scheduled job to fire an scheduled event upon sucess, where another scheduled job(to delete the file using program Object) waits for it.
forgotUN (BOB member since 2006-12-13)