Orchestration Process - Wait for Form Task and Resume

[Rohit_More]

Hi,

I’m working on orchestration process, in that post the task is resumed I’m updating the excel file with the responses from action center tasks. But I’m facing issues such as excel being used by another user/The RPC server unavailable etc.

Can you please help me with any way or workaround to deal with this problem.

[ashokkarale]

@Rohit_More,

Check if excel scope used in your code closing the excel properly before using in another activity.

Try to use Write Range workbook activity wherever possible.

The error “The RPC server is unavailable” typically indicates a problem with communication between your UiPath robot and the Excel application. This error can occur due to various reasons, such as network issues, Excel application not responding, or permissions problems. Here are some steps to troubleshoot and resolve this issue:

1. Excel Application Scope Configuration:

• Ensure that the Excel Application Scope activity is configured correctly. Check the properties such as WorkbookPath to make sure it points to the correct Excel file.

2. Excel Application Running:

• Make sure that Excel is installed and running on the machine where the UiPath robot is executing the automation. If Excel is closed or not responding, it can cause communication errors.

3. Check Excel Instance:

• Verify that there are no existing instances of Excel running in the background that might be interfering with the automation process. You can check Task Manager to see if any Excel processes are running and terminate them if necessary.

4. Network and Firewall Settings:

• Network issues or firewall settings can sometimes block communication between UiPath and Excel. Ensure that there are no network connectivity issues and that the necessary ports are open for communication.

5. Permissions:

• Ensure that the user account under which the UiPath robot is running has the necessary permissions to access and interact with Excel files. This includes permissions to read from and write to the Excel file, as well as permissions to launch the Excel application.

6. Restart UiPath Studio and Excel:

• Sometimes, simply restarting UiPath Studio and Excel can resolve communication issues between the two applications. Close both applications, restart them, and try running the automation again.

7. Update UiPath and Excel:

• Make sure that you are using the latest versions of UiPath Studio and Excel. Updating both applications to the latest versions may resolve compatibility issues that could be causing the error.

8. Error Handling:

• Implement error handling mechanisms in your UiPath workflow to handle this specific error. You can use try-catch blocks or other error handling activities to gracefully handle communication errors and take appropriate actions, such as retrying the operation or logging the error.

By following these steps and troubleshooting the possible causes of the “The RPC server is unavailable” error, you should be able to resolve the issue and successfully write to Excel using UiPath.

Thanks,
Ashok

[Rohit_More]

Here’s what I did, I used the write cell/append range/write range activity in the Retry Scope and it’s working seamlessly.