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