not-null property references a null or transient value eOne.SmartConnect.Connectors.Crm2011.MsCrm2011Connector.ClientID

Published: Feb 18, 2022
Post Author Written by eOne Solutions

When launching SmartConnect after upgrading to SmartConnect or above receiving a message that says, “not-null property references a null or transient value eOne.SmartConnect.Connectors.Crm2011.MsCrm2011Connector.ClientID”

This is due to a new field that was created during the upgrade, but the field is set to null.   Run the following script in SQL management studio against the SmartConnect database to correct the issue.  After running the script, launch SmartConnect again and the upgrade will continue.

UPDATE MsCrm2011Connector SET UseOauth = '', ClientId = '', ClientSecret = '', AccessToken = '', AccessTokenExpiry = '1900-01-01', RefreshToken = '',DomainToken = '',DomainTokenExpiry = '1900-01-01',DomainRefreshToken = '',UseRegionalDiscoveryService = ''

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.