Running any report in Backup Exec results in the above pop up message.

1. If this started happening after an upgrade, then follow the steps listed in the linked Related Article After an upgrade to Backup Exec 2010, canned reports fail with "Unable to run reports".

2. If not upgrade has taken place go to Tools-Options-Reports in the Backup Exec console and set the Reports Display Format to PDF. Run the report and check the result. If the report is generated properly then follow the steps listed in the linked Related Article Running any Report in Backup Exec results in error "Unable to run report. No further information available" and an empty report is generated if Reports Display Format is set to HTML.

3. If the report does is not generated even in the PDF format then proceed to steps given below.

This error may also come up if the SQL database of Backup Exec (BEDB) is unable to locate the stored procedure for the report. To resolve this perform the following steps in the following order as they progress from simple to complex:

Step 1 - Run a repair installation of Backup Exec:

1. Click Start | Control Panel | Add/Remove Programs or type in 'appwiz.cpl' in the run line to launch the Add/Remove Programs. In Windows 2008 and Vista go to Start | Control Panel | Programs and Features | Add/Remove Programs or use the short cut mentioned earlier to launch the same.
2. Select Veritas Backup Exec for Windows Servers.
3. Click Change.
4. Click Next.
5. Click Repair.
6. Click Next.
7. Follow on-screen prompts.
8. Open Backup Exec and attempt to run the report. Proceed to Step 2 if the report still fails to generate.

Step 2 - Run a repair of the Backup Exec Database (BEDB).

1. Open C:\Program Files\veritas\Backup Exec\BEUtility.exe
2. Click Yes
3. Click All Media Servers.

4. Click SERVERNAME and Right-Click on SERVERNAME
5. Select Repair Database. Allow to complete and click Close.
6. Right-Click on SERVERNAME.
7. Select Rebuild Database Indices. Allow to complete and click Close.
8. Right-Click on SERVERNAME.
9. Select Compact Database. Allow to complete and click Close.
10. Open Backup Exec and attempt to run the report. Proceed to Step 3 if the report still fails to generate.

Step 3 - Manually update the Reports table within the BEDB
(Note: Any Custom Reports may be lost with this solution. Follow the steps (1-6) for backing up the database as a precaution.)

1. Open Windows Services Management (Start | Run | services.msc | OK)
2. Right-click on SQL SERVER (BKUPEXEC) and click Stop.
3. Click Yes when prompted about stopping dependent services.
4. In Windows Explorer, navigate to C:\Program Files\veritas\Backup Exec\
5. Copy the folder named Data
6. Paste the folder Data onto the Desktop.
7. In Windows Services Management, start SQL SERVER (BKUPEXEC)
8. Open C:\Program Files\veritas\Backup Exec\BEUtility.exe
9. Click Yes
10. Click All Media Servers
11. Click SERVERNAME and Right-Click on SERVERNAME
12. Select Stop Services. Allow to complete and click close.
13. Open a command prompt (Start | Run | cmd | OK)
14. Type cd c:\Program Files\veritas\Backup Exec\
15. Type osql -E -S SERVERNAME\BKUPEXEC -d BEDB -i reports.sql
16. In BEUtility, Right-Click on SERVERNAME and select Start Services
17. Open Backup Exec and attempt to run the report.
 

 

Note:  If the Backup Exec database (BEDB) is on a remote SQL server use SQL Managment Studio to run the reports.sql script to insert the Reports stored procedures.

 

 If the above steps do not resolve the issue, please contact Veritas Support for further assistance.