Sitecore 9 XConnect List Manager Import Error

Today I attempted to import a list into List Manager using Sitecore 9 Update 1. The import went fine but none of the contacts would not show up

In the logs I received the following errors which didnt appear to provide much information:

INFO  [ListManagement]: Starting contacts importing
ERROR Request of 'importing' is failed. Retry will not be performed because the issue is probably caused not during xDB operation... (Message: Object reference not set to an instance of an object.)
Exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Sitecore.ListManagement.XConnect
at Sitecore.ListManagement.XConnect.Import.XConnectContactImporter.<>c__DisplayClass3_0.b__1(IXdbContext client)
at Sitecore.ListManagement.XConnect.XdbRequestPerformer.RequestWithRetry(Action`1 action, String actionMessage)</code>

11824 17:19:19 ERROR [ListManagement]: Failed to finish importing. The error has been occurred: Object reference not set to an instance of an object.
Exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Sitecore.ListManagement.XConnect
at Sitecore.ListManagement.XConnect.Import.XConnectContactImporter.&lt;&gt;c__DisplayClass3_0.b__1(IXdbContext client)
at Sitecore.ListManagement.XConnect.XdbRequestPerformer.RequestWithRetry(Action`1 action, String actionMessage)

This error didn’t seem very conclusive so I attempted to see whether xconnect was working correctly.

To see whether XConnect was working correctly by exposing the oData feed I opened up the config xconnectsite/App_config/AppSettings.config and commented out this line:

<add key="validateCertificateThumbprint" value="1F24CBC38F9239DEDCF166A82E1C0B2A47D12844" />

I then went to look at the exposed data contacts via https://sc91.xconnect.local/odata/Contacts and came across the following error:

"Message":"Operation failed: Store Error: Login failed for user 'collectionuser'.. The error occurred while attempting to perform the underlying storage operation during 'Microsoft.Azure.SqlDatabase.ElasticScale.ShardManagement.StoreException: Error occurred while performing store operation. See the inner SqlException for details. ---&gt; System.Data.SqlClient.SqlException: Login failed for user 'collectionuser'.\r\n at 

Resolving this issue then allowed me to import the contacts

Leave a Reply

Your email address will not be published. Required fields are marked *