Check the installation logs, Located [installdir]SetupLog. See if you can see if some scripts failed to run. You can also attach the logs to the thread. Do you perhaps have Stats running on any of the SQL tablecolumns? If so that might be the issue.

HTH

Vernon

Thanks for quick reply,

I checked the installation logs and i found the following errors:

1. 
   
2. "15138","2011-08-22 02:06:20","Error","15","15002","ERROR","SourceCode.Database.Configuration.ConfigureDBs","15002 SqlException.Number != -2, so not handling it as a timeout. SqlException.Number = 547. Exception: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint 'FK_LicensedUsers_SecurityCredentialCache'. The conflict occurred in database 'K2_HostServer', table 'dbo.SecurityCredentialCache', column 'CredentialID'.","anonymous","0.0.0.0","K2:C:IDEASK2 Installation FilesK2 blackpearl 4.5 (4.10060.1.0) with Update KB001370Installation","15138","4dba0827159547758f0923cfe3da75ab",""
   

Also I found the following script logs in the log folder:

1. 
   
2. ScriptErrors-2214756 "see attached file".
   
3. ScriptErrors-2214618 "see attached file".
   

ScriptErrors-2214756 --- Either the SQL Server agent is not running or it is running under the incorrect credentials. You can also run the K2 Configuration Analysis tool it contains tasks with steps to fix the Reporting indexing. In the Analysis tool this can be found under the K2 Workspace node.

ScriptErrors-2214618 --- Looks like a known issue when upgrading to 1370. Run the following script against the K2HostServer db:

Use [K2HostServer]

DELETE FROM LicensedUsers

WHERE LicensedUsers.CredentialID NOT IN (SELECT CredentialID FROM SecurityCredentialCache)

After this Run the HostserverAlter.sql located in C:Program Files (x86)K2 BlackpearlSetupConfigurationScripts

HTH

Vernon

I will describe the scenario that i have it here. I have environment A and environment B. Environment A is k2 blackpearl 0807  with update 4.8210.2.670 and this environment has huge number of process running on it. Environment B is new k2 4.5 (4.10060.1.0) with Update KB001370. To do the migration i did the below steps:

1. 
   
2. I installed K2 Blackpearl 0807 version on environment B.
   
3. I installed K2 Blackpearl updates in the following sequence:
   
   • 
     
   • K2 blackpearl 0807 Update (4.8210.2.370)
     
   • K2 blackpearl 0807 Update (4.8210.2.450)
     
   • K2 blackpearl 0807 Update (4.8210.x.670)
     
   
   
   
4. I backup database from Envrionment A and I restore it to Environment B.
   
5. I run K2 configuration Manager to update the K2 environment with new data.
   
6. I upgrade the K2 to version 4.5 (4.10060.1.0) with Update KB001370
   

and then when I start k2 service it give me the above mentioned error.

Regards,

The upgrade path looks good. They key being the restore of the db’s and running the K2 Configuration. Are you sorted now?

Vernon

Just to ADD to this thread. The answer as marked is not 100% correct, so here is the correction:

ScriptErrors-2214618 --- Looks like a known issue when upgrading to 1370. Run the following script against the K2HostServer db:

Use [K2HostServer]

DELETE FROM LicensedUsers

WHERE LicensedUsers.CredentialID NOT IN (SELECT CredentialID FROM SecurityCredentialCache)

CORRECTION:

After this Run the HostserverAlter.sql located in C:Program Files (x86)K2 BlackpearlSetupConfigurationScripts

SHOULD BE:

After this Run the HostserverAlter.sql located in C:Program Files (x86)K2 BlackpearlSetupConfigurationScriptsSnapshotsDATE

This script will not have place holder in but contain the correct info for you env. I think this caused the issue in http://www.k2underground.com/forums/p/13751/40497.aspx#40497

Apologies.

Just to ADD to this thread. The answer as marked is not 100% correct, so here is the correction:

ScriptErrors-2214618 --- Looks like a known issue when upgrading to 1370. Run the following script against the K2HostServer db:

Use [K2HostServer]

DELETE FROM LicensedUsers

WHERE LicensedUsers.CredentialID NOT IN (SELECT CredentialID FROM SecurityCredentialCache)

CORRECTION:

After this Run the HostserverAlter.sql located in C:Program Files (x86)K2 BlackpearlSetupConfigurationScripts

SHOULD BE:

After this Run the HostserverAlter.sql located in C:Program Files (x86)K2 BlackpearlSetupConfigurationScriptsSnapshotsDATE

NOTE: this is if the script was created in the snapshotDATEofUpgrade folder. Not sure if it will be created in all cases. IF not you may have to run the K2 Configuration again after.

This script will not have place holder in but contain the correct info for you env. I think this caused the issue in http://www.k2underground.com/forums/p/13751/40497.aspx#40497

Apologies.

Thank you I run the script with any issue, but i have still have the following issue:

http://k2underground.com/forums/t/13757.aspx 

I got the following error:

Invalid column name 'AuthenticationPassword'.