Workflow projects that use office component such as 'Excel Write Component' may fail to load them after upgrade

Products

• Client Management Suite

Issue/Introduction

Workflow version 8.7.3 may fail if it uses office component such as 'Excel Write Component':

"Could not load file or assembly office, Version=11.0.0.0"

Error which appears in log or in debug mode is:

--------

System.Exception: exception invoking method ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IO.FileNotFoundException: Could not load file or assembly 'office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
   at System.Reflection.RuntimeAssembly.GetExportedTypes(RuntimeAssembly assembly, ObjectHandleOnStack retTypes)
   at System.Reflection.RuntimeAssembly.GetExportedTypes()
   at LogicBase.Core.Utilities.ComponentClassHandler.UpdateDataHandlerIndex()
   at LogicBase.Core.Utilities.ComponentClassHandler.GetHandlerForType(Type dataType)
   at LogicBase.Core.Data.OrchestrationData.RootSetValue(String name, Object value)
   at LogicBase.Core.Data.OrchestrationData.SetValue(String name, Object value)
   at LogicBase.Core.ExecutionEngine.TLExecutionContext.get_GlobalStorageData()
   at LogicBase.Core.ExecutionEngine.TLExecutionContext.InitGlobalData()
   at LogicBase.Core.Models.Workflow.WorkflowExecutionEngine.StartInternal(String trackingId, IData data, String modelName, IData globalData, String testRunId, TestingScenario testingScenario)
   at Default.MyService.Execute()
   --- End of inner exception stack trace ---
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at MyService.Execute()
   --- End of inner exception stack trace ---
   at LogicBase.Framework.DynamicProxy.InvokeMethod(String methodName, Object[] parameters)
   at LogicBase.Tool.UI.Debugging.DebugEngine.ExecuteMethodThreadStart(Object parameter)

 

Environment

Workflow 8.7.3

Cause

Product defect

Resolution

This issue has been fixed in our ITMS 8.8 Release.

Workaround for earlier version:

Copy attached office.dll into [C:\Program Files\Symantec\Workflow\Shared\lib] to resolve the problem.