Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

RSAT setup, Excel error during "Generate Test Execution and Parameters files"

Posted on by 65

I have created a simple recording in Task Recorder, uploaded it to the BPM library and synced the Test Case to DevOps. When I click the "New" button in RSAT to generate the files needed for running the test (and provide parameters for it) I get a weird error referring to Excel;

[RSAT] FI01 Currency test
System.Exception: The Excel file creation failed at C:\Temp\RegressionTool\14\attachments\Currency_setup_14_Base.xlsx: The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER)) ---> System.Runtime.InteropServices.COMException: The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Dynamic.ComRuntimeHelpers.CheckIfMissingTypeInfoIsExpected(Int32 hresult, Boolean throwIfMissingExpectedTypeInfo)
at System.Dynamic.ComRuntimeHelpers.GetITypeInfoFromIDispatch(IDispatch dispatch, Boolean throwIfMissingExpectedTypeInfo)
at System.Dynamic.IDispatchComObject.EnsureScanDefinedMethods()
at System.Dynamic.IDispatchComObject.System.Dynamic.IDynamicMetaObjectProvider.GetMetaObject(Expression parameter)
at System.Dynamic.DynamicMetaObject.Create(Object value, Expression expression)
at System.Dynamic.DynamicMetaObjectBinder.Bind(Object[] args, ReadOnlyCollection`1 parameters, LabelTarget returnLabel)
at System.Runtime.CompilerServices.CallSiteBinder.BindCore[T](CallSite`1 site, Object[] args)
at System.Dynamic.UpdateDelegates.UpdateAndExecute2[T0,T1,TRet](CallSite site, T0 arg0, T1 arg1)
at CallSite.Target(Closure , CallSite , Object , Int32 )
at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid2[T0,T1](CallSite site, T0 arg0, T1 arg1)
at Microsoft.Dynamics.RegressionSuite.Excel.ExcelService.GenerateVerticalTable(Worksheet sheet, String label, String leftColumnHeader, String rightColumnHeader, List`1 lines, Int32 row, Boolean validate) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Excel\ExcelService.cs:line 525
at Microsoft.Dynamics.RegressionSuite.Excel.ExcelService.GenerateExcel(List`1 forms, String excelOutputFile) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Excel\ExcelService.cs:line 285
--- End of inner exception stack trace ---
at Microsoft.Dynamics.RegressionSuite.Excel.ExcelService.GenerateExcel(List`1 forms, String excelOutputFile) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Excel\ExcelService.cs:line 378
at Microsoft.Dynamics.RegressionSuite.CodeGeneratorHelper.ProcessXml(TestCaseModel testCase, String outputPath, String companyName, Boolean generateOnlyTestExecution, Boolean isCreateDerivedAction) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Helpers\CodeGeneratorHelper.cs:line 321
at Microsoft.Dynamics.RegressionSuite.WindowsApp.MainForm.<>c__DisplayClass78_2.<<ProcessParentWithDerivedTests>b__1>d.MoveNext() in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuiteWindowsApp\MainForm.cs:line 1334

I am running this locally on my onebox, as Admin. What have I missed in my setup?

  • Suggested answer
    Provios Profile Picture
    Provios 65 on at
    RE: RSAT setup, Excel error during "Generate Test Execution and Parameters files"

    I solved it. Turns out you have to have activated Office installation on the machine where the RSAT tool is running. The error stemmed from Excel trying to start but getting stuck in the activation dialog in the background, and that was the cause for the "application is busy" error.

  • Provios Profile Picture
    Provios 65 on at
    RE: RSAT setup, Excel error during "Generate Test Execution and Parameters files"

    Yeah, the path can be written to - I have downloads in there from DevOps that RSAT created. I do not have Excel running, but I tried starting and closing it and I still get the same error - I even rebooted the VM just to be sure.

  • Scott Gaines Profile Picture
    Scott Gaines 1,943 on at
    RE: RSAT setup, Excel error during "Generate Test Execution and Parameters files"

    These are some basic things you've probably checked, but C:\Temp\RegressionTool\14\attachments\ exists and can be written to where RSAT is running?  Also do you have excel open anywhere on the system that is running RSAT?  If excel is up and running even with another file, you might try closing and then running again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans