When launching SmartConnect after upgrading to SmartConnect 22.214.171.124 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 = ''