Original error message: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Help Studio
, , ,
1

Write Range: Failed setting the current sheet to: DSR CAV-IT in workbook. Original error message: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
I am getting this error, as suggested I used the Delay also, but it is not working in any condition. I used delay before activity for(5 sec to 3 sec).
Before the write range, there is SQL sequence, I have used delay after that execute query activity as well as before the write range. But no success.

2

HI @Khushbu_Sharma

Use Kill Process and kill excel first and check on continue on error
then delay 2 sec or 3 sec
then your excel activities whatever read or write

Please Make this as a habit

Regards
Sudharsan

4

@Khushbu_Sharma,

Are you writing into share sharedpath excel?, where the excel is located.

5

Hi @Sudharsan_Ka
The whole process is going on single excel application scope, and the Kill process is already in use before the Excel application scope and the Close workbook is also used at the end of the flow.

6

Try kill and delay before excel application scope @Khushbu_Sharma

And check if excel activities package has an update if its there update System.excel.activities and try again

Regards
Sudharsan

7

Hi @Khushbu_Sharma

Instead of Excel application scope - Write Range activity use Workbook Write Range activity.

Update the Excel package to Lastest version and check it too.

Regards
Gokul

8

Hi @sarathi125

The excel is located in the Temp folder.

9

@Khushbu_Sharma
I am not sure, I think you need to activate your windows OS. It seems not activated. It may throw an error.

10

Use this, it work’s for me