Message is “You cannot run this report as the data is in use by another task.” Other messages include: "view cannot be used - one or more tables are missing" to the table VIEW_ to the "you do not have sufficient rights" depending on if you try to select, copy or run the report and where it is selected.
This is the only BI Report in the system. I created a new report with data from the same view, which runs. When I try to select the original report it lists the Report Name The report will not run when launched from within Crystal with the message “Failed to retrieve data from the database. Details: S0000:[ProvideX][ODBC Driver][FILEIO] Table is not accessible [Database Vendor Code: 12]. Note: the message appears even if CSODBC is not enabled for all users.
Steps taken:
- Rebuilt BI Reporter Views
- Exported the report from a working backup
- Re-imported the report (overwrote existing report)
- Copied the .BIR and .rpt and from the backup and imported into the production system (BIR Import seems to have succeeded (i.e., files were removed from the Import folder), but the report did not appear in BIR or BIR Listing
- Deleted all reports from BIR and re-imported the original report. Same message.
To complicate matters, in the backup system, I tried to copy the report (by selecting it in BIR and making a copy, but after assigning a new Report Name and clicking “Next”, this message appears: “Report XXXX is in use”. This report will be skipped.”
Has anyone encountered this issue &/or have ideas? I have a case open with Sage, who suggested I post here.