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:
