Aegis Reports in NRC return "No Data for Report (NETIQKB73134)

When running the prepackaged Aegis reports in NRC (NetIQ Reporting Center) all reports fail and return "No Data for Report"

To resolve this issue, please follow the process noted below:

1. Locate the Program Files\NetIQ\Aegis\DB\RPT directory.

2. Verify that ImportData.cmd, RemoveTables.sql, AllRPTTables.sql, and LoadRPTRefTables.sql are all present.

3. From SQL Server Management Studio execute the following query's against the Aegis database

4. EXEC RemoveTables.sql

5. EXEC AllRPTTables.sql

6. From the command line, change directories into the Program Files\NetIQ\Aegis\DB\RPT directory and execute the following:

7. Call ImportData.cmd

8. Go back to Microsoft SQL Server Management Studio and execute the following against the Aegis DB

9. EXEC LoadRPTRefTables.sql

10. Restart all Aegis Services (NETIQKB73021)

11. Attempt re-running your reports.

A possible reason you may be receiving the "No Data for Report" message is that the RPT.Numbers table may not have been populated during installation of the Aegis database.

To verify that this is the issue you are seeing; execute the following SQL Query against the Aegis Database in Microsoft SQL Management Studio:

USE AEGIS
SELECT * FROM RPT.Numbers

If you have any rows returned the contents of this knowledge base article will not resolve your issue, and you should contact NetIQ Technical Support for further assistance.

If upon the completion of this query no rows are returned please follow the instructions below.

Formerly known as NETIQKB73134