Symptoms

The following error is thrown on workspace after upgrade from blackpoint 4.6 to 4.6.4, then upgrade to blackpearl 4.6.9:

"Initialization failed before PreInit: Membership could not be verified: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'."
 

Diagnoses

The issue is reproducible by following the same upgrade path (Blackpoint 4.6 -> 4.6.4 -> Blackpearl 4.6.9)

Note:

The upgrade path is not a supported upgrade path as per k2 upgrade support matrix: http://help.k2.com/blackpearl/support-matrix
 

Resolution

The following steps can be taken to resolve the issue:

1. C:Program Files (x86)K2 blackpointSetupConfigurationScripts1596Script.1596.config

change from newdb to always
<script file="ConfigurationScriptscleanSourceCode.Data.Workspace.inject.sql" type="inject" executeOn="always" />

2. Delete all workspace tables
3. Delete all View for workspace schema
4. Check procedures and Synonyms

5. Run these scripts manually in order.
- C:Program Files (x86)K2 blackpointSetupConfigurationScriptscleanSourceCode.Data.Workspace.table.sql
- C:Program Files (x86)K2 blackpointSetupConfigurationScriptscleanSourceCode.Data.Workspace.constraint.sql
- C:Program Files (x86)K2 blackpointSetupConfigurationScriptscleanSourceCode.Data.Workspace.procedure.sql
- C:Program Files (x86)K2 blackpointSetupConfigurationScriptscleanSourceCode.Data.Workspace.index.sql

6. Reconfigure using the "K2 blackpearl Setup Manager" from the start menu.

7. After reconfigure has completed, revert the config change back to NewDB
C:Program Files (x86)K2 blackpointSetupConfigurationScripts1596Script.1596.config
change from always to newdb
<script file="ConfigurationScriptscleanSourceCode.Data.Workspace.inject.sql" type="inject" executeOn="newdb" />