Unable to run reports from ITIM console

Unable to run reports from ITIM console

By Siva Praturi & Vamshidhar K

When an attempt is made to run run reports in ITIM  console, the following message is displayed on the screen

"CTGIMU793E : Reports cannot run while the report data synchronization is in progress."

It happens if data synchronization task has failed for some reason and status column in SYNCHRONIZATION_HISTORY table is not updated. The only way to correct this issue is to update the status column manually.

When data synchronization task is started from ITIM console, then you will find one row with STATUS of "Started" in the SYNCHRONIZATION_HISTORY table.

This is what ITIM uses to determine if Data Synchronization is in progress or not. Most likely the actual processing finished long ago with some kind of error that was not reflected in the SYNCHRONIZATION_HISTORY table.

The database administrator can correct this situation by updating the status of the "Started" synchronization entry to "Failed". See DB2 SQL commands below.

DB2 CONNECT TO ITIMDB USER ITIMUSER USING PASSWORD

SELECT * FROM ITIMUSER."SYNCHRONIZATION_HISTORY" where status='Started';

UPDATE ITIMUSER.SYNCHRONIZATION_HISTORY set status='Failed' where status='Started';

DB2 CONNECT RESET

Manual update to SYNCHRONIZATION_HISTORY table will enable to run data synchronization task from ITIM console. It may take to complete data synchronization and some times it may result in below status

"Last synchronization completed with 8 non-fatal exceptions. Check Tivoli Identity Manager trace and message log files and application server log files for details"

After checking log files you may find CTGIMF007E and "LDAP: error code 32 - No Such Object" errors. This error occurs as ITIM LDAP contains a DN that no longer exists. One way to fix it by identifying and fixing them manually.

References:

http://www-304.ibm.com/support/docview.wss?uid=swg21303678

http://www-304.ibm.com/support/docview.wss?uid=swg21593082