Maintaining synchronization information in column definitions
All columns in the One Identity Manager schema can store additional information, which is evaluated when is set up. This information is mainly required for setting up synchronization with the One Identity Manager connector, but can also be used when synchronizing tables and columns.
Settings in the synchronization information do not override the default behavior of the One Identity Manager connector. They provide information if the default behavior cannot be determined automatically. For example, if a column is marked as a mandatory column by the MinLen='1' property, the connector will automatically recognize it as a mandatory column even if the Mandatory column value is disabled in the Synchronization information field.
To edit synchronization information in column definitions
-
In the , select One Identity Manager .
-
Select the table and start the Schema Editor with the Show table definition task.
-
Select the column and then the Column properties view.
-
Select the More tab.
-
Select all applicable values from the Synchronization information menu.
-
Not relevant for synchronization: The column is not displayed in the .
-
Has unique value: The column contains a unique value.
-
Has conditional default value: The column contains a value that is formatted automatically under certain conditions, for example by a customizer.
-
Has a default value: The column contains a value that is formatted automatically, for example by a formation rule.
-
Conditional mandatory column: The column is a mandatory column under certain conditions, for example if the value is checked by triggers.
-
Mandatory column: The column is a mandatory column.
-
Select the Database > Commit to database menu item and click Save.
Troubleshooting
One Identity Manager offers different options for logging errors. These logs help you to analyze errors. These include:
For more information and help on troubleshooting in One Identity Manager and configuring log files, see the One Identity Manager Process Monitoring and Troubleshooting Guide.
Error log
In expert mode, you can show the error log. In the error log, you can view all the errors that have occurred since the program started up. The error log is reinitialized when the restarts.
To display items from error log
For more information about functions in the error log, see the One Identity Manager Process Monitoring and Troubleshooting Guide.
Ignoring data error in synchronization
By default, objects with incorrect data are not . For example, a user account is not loaded in the One Identity Manager database if, in the user account table, the formatting script of a column contains an email address detects invalid data. These objects can be synchronized once the data has been corrected. In certain situations, however, it might be necessary to synchronize objects like these and ignore the data properties that have errors. This synchronization behavior can be configured in One Identity Manager.
To ignoring data errors during synchronization in One Identity Manager
-
In the , open the .
-
Select the Configuration > One Identity Manager connection category.
-
In the General view, click Edit connection.
This starts the system connection wizard.
-
On the Additional options page, enable Try to ignore data errors.
This option is only effective if Continue on error is set in the .
Default columns, such as primary keys, columns, or mandatory input columns cannot be ignored.
- Save the changes.
IMPORTANT: If this option is set, One Identity Manager tries to ignore commit errors that could be related to data errors in a single column. This causes the data changed in the affected column to be discarded and the object is subsequently saved again. This effects performance and leads to loss of data.
Only set this option in the exceptional circumstance of not being able to correct the data before synchronization.
