I love the ability in R4 where if you schedule a document via the CMC you can now have it email a notification upon success or failures as well as retry the report X number of times, but I ran into a small issue.
I scheduled a document the other day to run daily at 7:30 am. It delivers an Excel file to an exchange mail group.
I’ve set the notification to email me on failure, and for the system to retry up to 3 times at 10 minute intervals. (It’s a fast report).
For the last two days, the initial running at 7:30 has failed, generating the email, but the 2nd attempt succeeds.
The issue is, I cannot seem to locate any sort of log in the system to let me know WHY the first instance keeps failing. Normally I’d see the history in the schedule and click on failure and see the error message, but since it retried and succeeded the system only shows the success message.
Before I open a ticket with SAP I thought perhaps someone might know where I can look for the failure of the first instance. I didn’t have any luck with the Query Builder against the CMS but then again I’m not very good at that data model.
The other option is I can remove the retries, let it fail tommorrow and see what the issue is at 7:30. But I’m hoping it doesn’t come to this.
JPetlev (BOB member since 2006-11-01)