"Service can not be found" error in xConnect logs


Description

The following messages might appear in xConnect logs due to the orphaned section found in the sc.Xdb.Collection.Data.Sql.xml configuration file:
[Error] Service can not be found: Sitecore.Xdb.Collection.Data.SqlServer.Configuration.ColumnEncryptionKeyStoreProviders.KeyStoreProviders, Sitecore.Xdb.Collection.Data.SqlServer
The error does not affect the functionality, and you can safely ignore such messages. Otherwise, try the following solution.

Solution

To get rid of the errors you can remove (comment out) the following section from the sc.Xdb.Collection.Data.Sql.xml file:
<Sitecore.Xdb.Collection.Data.SqlServer.Configuration.ColumnEncryptionKeyStoreProviders.IKeyStoreProviders>
<Type>Sitecore.Xdb.Collection.Data.SqlServer.Configuration.ColumnEncryptionKeyStoreProviders.KeyStoreProviders, Sitecore.Xdb.Collection.Data.SqlServer</Type>
<As>Sitecore.Xdb.Collection.Data.SqlServer.Configuration.ColumnEncryptionKeyStoreProviders.IKeyStoreProviders, Sitecore.Xdb.Collection.Data.SqlServer</As>
<LifeTime>Singleton</LifeTime> 
</Sitecore.Xdb.Collection.Data.SqlServer.Configuration.ColumnEncryptionKeyStoreProviders.IKeyStoreProviders>