The initial synchronization fails to synchronize the objects from the Microsoft (MS) SQL database as a filter condition is configured in the insert/update/delete step of the initial synchronization workflow for DSI Module, MS SQL Server /DB Level templates.
Please note: This issue is applicable only in One Identity Manager version 8.1.1.
This error is due to an issue in One Identity Manager version 8.1.1, referenced with product defect #31986.
To successfully synchronize objects from Microsoft SQL Database to One Identity Manager 8.1.1, please follow the below instructions.
Workaround for the MS SQL Server Level Project:
Workaround for the MS SQL Database Level Project:
Development will provide a hotfix for product defect #31986 for One Identity Manager 8.1.1 in the future.