i have a group of reports that i have loaded into Central Management Console / Infoview and have scheduled to run at various intervals.
occasionally, a report will fail with an error similar to this:
Error in File E:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\RServer.reportjobserver\~tmpe3c505dcf81380.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: -1812 ]
however, if i reschedule to report, sometimes it will succeed. or, if i run the report manually, it will succeed. so i know it's not a problem with the report, or with the options i'm using to run the report.
what could be causing this problem?
if it matters, the DB i'm connecting to is MS Access.