System failure causes data synchronization problem

If a system fails during data synchronization, we might not be able to run data synchronization after a system restore. Application server and database failures can cause this problem. When data synchronization starts, IBM Security Identity Manager sets the STATUS column to Started in the ITIMDB.SYNCHRONIZATION_HISTORY table. When the system fails, the status is not updated to Failure. We must set data synchronization status correctly in the SYNCHRONIZATION_HISTORY table. Complete these steps:

1. Connect to the ISIM database.

2. Open the SYNCHRONIZATION_HISTORY table.
3. Locate the entry for data synchronization that reads Started in the STATUS column. Only one Started entry is displayed.

4. Change the value of Started to Failure.
5. Commit the change to the database.
6. Run data synchronization.

Parent topic: Troubleshooting database problems