K2 Blackpearl Setup Manager Error: Could not recreate encryption key
kbt131346
PRODUCTK2 blackpearl 4.7
TAGSAdministrator
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.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
The issue happens within set up manager after installing all of the K2 Blackpearl components and then further running the configuration analysis as well. The set up manager throws an error in which it is unable to create an Encryption key.Symptoms
The error message appears within the config analysis and the install trace logs as well. The error is the following: Could not create key System Data.SQLClient.SQLException Target did not complete successfully, please recreate encryption key.Troubleshooting Steps
Please do change the Compatibility Level on the K2 database from SQL Server 2016 (130) to SQL Server 2014 (120). After this run the configuration analysis all should be resolved from here. You can have a look at the following articles for more information on this as well.
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/choose-an-encryption-algorithm
http://dinesql.blogspot.cz/2017/01/incorrect-syntax-near-triple-des-sql-server-error.html
