cancel
Showing results for 
Search instead for 
Did you mean: 

Monthly reports run one day late

bouserli
Explorer
0 Kudos
174

Hello, we have many reports scheduled to run on the 2nd business day of the month. The BO calendar called “Second Business Day” has the correct dates.
The reports are scheduled to run after a System Event (text file is placed into a specific folder).
The problem is, all the reports using the 2nd Business Day calendar with the System Event run a day late. If I run them without the System Event, they run correctly on the 2nd Business Day.

Our daily reports run correctly with a business days calendar and the System Event.
What would cause the monthly reports to run a day late?

The text file is placed into the folder around 4:20am.
The reports are scheduled to run at various times. For example, one report is scheduled to run at 7:30am, but it ran on July 3 instead of July 2.
The reports are webi.

Appreciate any help on this.

Thank you.

View Entire Topic
nscheaffer
Active Contributor

Your reports need to be scheduled to run before the file change so the File Event can detect it. If your 7:30 am report were scheduled to run the before the file was placed in the specified location, let's say 4:00 am, the report would run when the file is place there are 4:20 am.

Noel

bouserli
Explorer
Thank you, Noel. Most of our reports are actually scheduled for around 3am, so I didn’t use a good example. However, I now realize that even though the daily schedule works, our end of month processing does the file change at a different time than our daily jobs. Next month, I will note what time the file change occurs and will revise the monthly report schedules accordingly.