K2 4.7 Cumulative Update fails to install with an error: "Could not load file or assembly'Microsoft.SqlServer.Smo, Version=10.0.0.0"

  • 16 February 2021
  • 0 replies
  • 107 views
MillaZ
Userlevel 5
Badge +20


 




K2 4.7 Cumulative Update fails to install with an error: "Could not load file or assembly'Microsoft.SqlServer.Smo, Version=10.0.0.0"















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


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  


Below is the prerequisite for the K2 4.7 installer:
 https://help.k2.com/onlinehelp/k2five/icg/current/default.htm#Plan/Software-Reqs-component.htm

 


 





Check out these Nintex University Learning paths: https://community.nintex.com/p/NintexUniversity

0 replies

Be the first to reply!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings