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

K2 Blackpearl - March Cumulative update fails with an error:

Script execute failed: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.

The system cannot find the file specified. File name: 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at SourceCode.Install.SQL.DBQuery.ExecuteTransactionalScript(String scriptFile, String connectionString) at SourceCode.Install.Package.Actions.ExecuteSqlScript.Execute(ITarget target)

 

Symptoms

The Microsoft SQL Server 2008 R2 Management Objects aren't installed on the K2 Environment and this version 10.0.0.0 does not exist in the GAC after reviewing this on the environment.

Resolution

To correct this behaviour
Install the missing components ‘Microsoft SQL Server 2008 R2 Management Objects Feature Pack’ on the environment and test the installer again. The installer should complete as expected.

Please find the dependant assemblies here:

batchparser.dll - Microsoft SQL Server (Batch Parser)
bcp.exe - BCP - SQL bulk copy tool
microsoft.sqlserver.connectioninfo.dll
microsoft.sqlserver.connectioninfoextended.dll
microsoft.sqlserver.dmf.adapters.dll
microsoft.sqlserver.dmf.adapters.resources.dll
microsoft.sqlserver.dmf.dll
microsoft.sqlserver.dmf.resources.dll
microsoft.sqlserver.dmfsqlclrwrapper.dll
microsoft.sqlserver.management.collector.dll
microsoft.sqlserver.management.collectorenum.dll
microsoft.sqlserver.management.registeredservers.dll
microsoft.sqlserver.management.sdk.sfc.dll
microsoft.sqlserver.management.sdk.sfc.resources.dll
microsoft.sqlserver.management.utility.dll
microsoft.sqlserver.management.utility.resources.dll
microsoft.sqlserver.management.utilityenum.dll
microsoft.sqlserver.policyenum.dll
microsoft.sqlserver.regsvrenum.dll
microsoft.sqlserver.regsvrenum.resources.dll
microsoft.sqlserver.servicebrokerenum.dll
microsoft.sqlserver.smo.dll
microsoft.sqlserver.smoextended.dll
microsoft.sqlserver.sqlenum.dll
microsoft.sqlserver.sqlwmimanagement.dll
microsoft.sqlserver.sstring.dll - SQL Server Secure String Package
microsoft.sqlserver.wmienum.dll
sharedmanagementobjects_keyfile.dll - SQL Server Patch KeyFile
sqlcmd.exe - T-SQL execution command line utility
xmlrw.dll - Microsoft XML Slim Library

Please see the Official Microsoft Documentation: https://www.microsoft.com/en-us/download/details.aspx?id=16978