Symptoms

The client tried to upgrade his K2 environment from 4.5 with 1420 to 4.6.8. During the upgrade, the DBs failed and the client requested assistance to get his environment up and running again.
 

Diagnoses

After looking at his log files, it appears as if the "Workspace.TestTable" was missing from the K2Workspace DB. Some upgrades fail because the table is missing from the DB. When we get to the part where the table is supposed to get updated, it fails.
 

Resolution

We removed the K2Server 4.6.8 components from the K2 Server machine. After that, we restored the 4.5 with 1420 DBs, installed K2 4.5 with 1420 pointing to the restored DBs and we were back to the point where we were before the upgrade. From here we ran the following script against the K2Workspace DB to re-create the "Workspace.TestTable" table.

//----- Start -----
USE K2Workspace
GO

CREATE TABLE dbo]. TestTable](
(Reportid] oint] IDENTITY(1,1) NOT NULL,
,ReportName] tnvarchar](256) NULL,
,RSSPath] Snvarchar](256) NULL
) ON /PRIMARY]

GO

//----- End -----

We then upgraded the K2Server to 4.6.8 and the upgrade went well.