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.<>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. ---> System.Data.SqlClient.SqlException: Login failed for user 'collectionuser'.\r\n at
Resolving this issue then allowed me to import the contacts