Security Reporting Center stops creating reports for a scheduled job

This article applies to:

• Security Reporting Center 2.1

Symptoms:

• Security Reporting Center stops creating reports for a scheduled job.
• A report has been generated fine for a while, and then stops being generated by the same job.

• The job is set to generate reports for this time frame, but it is not generating reports.

Causes:

Information:

The following procedure should resolve the issue:

1. Stop the NetIQ Scheduler Agent service.
2. Open a command prompt
3. cd to the Security Reporting Center installation directory. For instance the directory may be:
   C:\Program Files\NetIQ\Security Reporting Center\
4. From the installation directory, cd into the common\mysql\bin directory
5. Log into mysql. You need to use this command to log in:
   
   mysql -u username -p
   
   Note: The username is case sensitive.
   
6. When you log in, you will see the following:
   
   Enter password: ******
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 27804 to server version: 3.23.54-nt
   mysql>
   
7. Change to the wt_config database with the following command:
   mysql> USE wt_config
   
   You will see this after the command is successful:
   Database changed
   
8. To see what is listed in the chronicles database, use the following command:
   
   mysql> select * from netdb_chronicles;
   
9. To delete all of the data in this database, use the following command:
   
   mysql> delete from netdb_chronicles;
   
10. Use the command from step 8 (select * from netdb_chronicles;) and make sure the table is empty
11. Exit mysql by using the following command:
    
    mysql> \q
    
12. Start the NetIQ Scheduler Agent service
    

Notes:

CAUTION: Editing the MySQL database directly is potentially dangerous. The changes recommended above are irreversible. A front end interface allows greater control and should be used if available.

A number of free GUI tools for MySQL administration are available.

The tool maintained by MySQL AB is available at the following URL: http://dev.mysql.com/downloads/gui-tools/

Note: SRC uses an older version of MySQL, so you may see a warning about version mismatch.

MySQL-Front, a well-known GUI tool, is no longer available.

This article was previously published as:

NETIQKB48997