Script generates error is run in unattended mode via orchestrator

If I run a script in Studio pro directly, the script runs to success with no issues.
But when I run the script in “unattended” mode via orchestrator, i get an error related to : Exception from HRESULT: 0x800AC472 Issue is excel related but only via orchestrator.

Can anyone help explain why ?

full error is something like this:

Failed setting the current sheet to: input_data in workbook: C:\Users\sheetFile.xlsx. Original error message: Exception from HRESULT: 0x800AC472

@vze
The error message you encountered, “Failed setting the current sheet to: input_data in workbook: C:\Users\sheetFile.xlsx. Original error message: Exception from HRESULT: 0x800AC472,” typically occurs when there is an issue with accessing or interacting with the Excel file. This error can be caused by various factors, such as file permissions, file format compatibility, or issues with the Excel application itself. I faced same issue many times and I solved by retry and if you are using Excel Scope then put zero in Cache property.

And this would cause the script to work run 1 way (via Studio Pro) but not another (via Orchestrator)?

@vze

Is the file present in a user profile folder?

And the is the user you are trying to use as unattended is different?

Can you try placing the file in any location like C:\Folder\File.xlsx

This way file is not linked to any user

Cheers

Hi @vze

When running the script directly in Studio Pro, it runs under your user context with your permissions and privileges. However, when running it in “unattended” mode via Orchestrator, it runs under the context of the Orchestrator Robot or the specified user account. This user might have different permissions or settings that could affect the execution of the script, particularly when interacting with external resources like Excel.

Thanks!!