This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

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.