When synchronizing data from a SQL table to Active Directory with SQL Server connector, if a source field contains non-null value, and the target attribute is not set in AD, synchronization fails with the following error:
"Value does not fall within the expected range"
This happens when a simple attribute-to-attribute workflow rule is set up in a provisioning or update step.
If a source field in SQL table contains non-null value, and the target attribute is not set in AD, Quick Connect attempts to set the target value to an empty string.
Some attributes in AD do not allow empty values.
Replace all the empty fields in SQL table with Null values.
Replace the simple attribute synchronization rule for the failing attribute with a rule to trim spaces from the source attribute: