Issue

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.

Image

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.