-
Título
When working with SQL empty string values, using "Remove leading and trailing whitespace characters" does not result in a NULL -
Descripción
In the Active Roles Synchronization Service and Quick Connect, when working with a SQL data source, it is possible for a value to be either a NULL or an empty string.
These are functionally different values with different properties. When performing an unmodified update, some systems, such as an Oracle database, will treat them as interchangeable. Some will not. Active Directory attributes, for example, can contain a NULL but cannot contain an empty string.
If syncing from a SQL source system to an Active Directory target system, empty strings will need to be converted into NULL values, otherwise, an error message similar to the following will occur during an update attempt:
An error occurred while modifying the object "Test User".The attribute syntax specified to the directory service is invalid.
When working with a Forward Sync Rule and configuring an Attribute update, the Advanced option shows a screen with the option to Remove leading and trailing whitespace characters. This does not, however, trim an empty string into a NULL, as expected.When working with a Forward Sync Rule and configuring a Rule update, the option to Remove leading and trailing whitespace characters is also present. Using this option does trim an empty string into a NULL value. -
Causa
This issue has been identified as a product defect and is being tracked as Defect ID 779451. -
Resolución
WORKAROUND
Configure a Rule update and use the option to Remove leading and trailing whitespace characters when working with a SQL source which has empty strings and when updating to a data source which does not accept empty string values.
STATUS
Waiting for a fix in a future release of Active Roles.
-
Solicitud de cambio
779451