When upgrading from K2 blackpearl 4.6.11 to K2 blackpearl 4.7 the below error was experienced on the K2 Analysis Manager.
Logged Error "System.Data.SqlClient.SqlException: There is already an object name 'EncryptionInSql' in the database.
The K2 installer will complete with "Error: There is already an object name 'EncryptionInSql' in the database" on the analysis manager and the service will not start up.
To resolve this please follow these steps:
1. Create a backup of the K2 Database
2. Find the function called: Utility.EncryptionInSql
You can find this function by navigating to: SQL Server > Databases > K2 > Programmability > Functions > Scalar-valued Functions > Utility.EncryptionInSql
3. If this function is present , direct database modification will be required. Please log a K2 Support Ticket on the K2 Customer Portal for assistance in resolving the issue.