Unable to run excel workflows parallelly from 2 users

Help Studio
, , , , , , , , , , ,
1

Hello,

recently we have faced issue to run automations with excel automation activities parallelly from 2 different users /accounts.
our setup - we have total 4 admin users/accounts and we have named user enterprise studio licenses and we run automations from all 4 acounts.(mostly parallelly)
we faced issue as mentioned to run excel automations
Example 1- account 1 running excel automation with classic activities and account 2 running automation with classic activities
result - running properly as i have made recently changes to add kill process and in properties of kill i have selected to kill for curent user.

Example 2 - account 1 running excel automation with modern activities and account 2 running automation with classic activities
result - either one of failing and showing The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

please update me how to kill process for excel only for current user if i am using modern excel activities so i guess isue will get resolve.(because it is closing excel for other account as well so automation running on another user stopping and giving The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) error )
what configuration i need to do may be in excel process scope properties or some where else?

help me on same , as we are facing this issue fro last week and need to solve urgently.

2

Hi @Mathkar_kunal ,

Could you let us know the setup of the Modern Excel activities used ? Particularly the Properties of Excel Process Scope ?

I believe the same Kill Process activity could be used for the 2 Example scenario as well.

Also, have you checked the below post on the suggestions for resolving the error mentioned:

3

image
image1123×472 56.8 KB

you can see properties in above image
@supermanPunch

4

Hi @Mathkar_kunal ,

Could you maybe try keeping the Properties set as shown below in screenshot and check ?

image
image319×241 11.6 KB

Also, we didn’t get your update on the RPC Server issue troubleshooting suggestions mentioned. Was it checked ?

5

if i ahve 4 admin account then force kill option will kill excel only for current user?
or for all users?
if for all users then automation running on another acount with excel activities will give rcp server error or stop.

6

If you want to Kill the “EXCEL” process only for the current user in order to not have the error The RPC server is unavailable. (Exception from HRESULT: 0x800706BA), use the Kill Process activity from UiPath.System.Activities package.

In this case, do not use the Force kill option under the Excel Process Scope activity.

Under the Applies To, select KillProcessApplyOn.OnlyCurrentUser

image
image2356×676 89.6 KB

7

ok , but just confirm me once like if i put configuration as it is like below

image
image1306×490 108 KB

if i am not selecting force kill ,then is it close excel from other users?
@marian.platonov

8

Check what option you have selected under the Project settings for the Existing processes action and you will know for sure.

image
image990×694 50.7 KB

If you have None - No action is taken in relation to the existing processes on the machine.

9

i have checked i have same configuration, but still facing issue.
when i start automation with old classic activitirs from user 1 and consider after 2 mins if i start another automation with modern activities from user 2 then at that point automation started on user 1 shows error or stops

10

The setup that I presented is only for modern activities. Make sure that all users are using modern activities for Excel with the same configuration.

11

some scripts are with old activities and those are huge scipt , it is unable to change or modify to new excel activities.
what will be the solution for this and if no force kill is there then how excel activities are not working parallelly from 2 users?

12

If you don’t want to perform anything in the classic activities, the options will be like

Option 1
Don’t run the classic and modern Excel automations at the same time.

Option 2
Split the Excel automations in separate VMs (classic in one and modern in another one).