Error when installing K2 4.7: "There is already an object named 'EncryptionInSql' in the database"
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.
SymptomsThe 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.