ParameterBindingValidationException: Cannot bind argument to parameter ‘Name’ because it is an empty string.
Created: 2023-06-13 08:50:27Modified: 2023-06-13 08:55:41
Tags: Office 365 Troubleshooting
When syncing to a destination o365, the following error may occur.
ParameterBindingValidationException: Cannot bind argument to parameter ‘Name’ because it is an empty string.
When syncing to a destination o365, the DN mapping is dn: ~mail~. If the source ~mail~ is blank, the above error will occur.
The value for ~mail~ is defined by sourcedef field-smtp.
As an example, when the source is o365, the field-smtp attribute is primarysmtpaddress. If the source primarysmtpaddress is blank, the above error will occur.
primarysmtpaddress=null
Options:
If you do nothing, this error will continue to occur for any source object missing a ~mail~ value. This does not affect the rest of the sync. The error identify the object(s) that did not sync due to missing ~mail~ value.
Exclude source objects if field-smtp attribute is blank.
a) To purposely exclude source objects whose field-smtp attribute value is blank, add this to your Exclude file: sourceattribute=null
b) For example, if the source is 365 source, the source attribute is primarysmtpaddress. The necessary exclude rule for o365 would be:
primarysmtpaddress=null
c) Run Discovery. You will see fewer source records are discovered. (A level 3 Discovery log will show you what has been excluded).
d) Run a SIMULATION. Check the Sim log and be on the lookout for unexpected DELETES or ADDs. If there is any concern with Sim results, contact Support@dirwiz.com for help.
e) Run a Sync. You should see the Sync log no longer throws these errors (because any object that would have caused the error is now excluded from the sync.