Pivot table error The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

[zaid.ahmad (Qazi Zaid Ahmad)]

Hii everyone,

When i create the pivot table first time it is working fine but creating same table for other excel in second time getting error below
Sample Pivot: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
RemoteException wrapping System.Runtime.InteropServices.COMException: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
at Microsoft.Office.Interop.Excel.ApplicationClass.get_Version()
at UiPath.Excel.Helpers.ExcelHelpers.TryGetMajorVersion(Application excelApp, Int32& version)
at UiPath.Excel.ExtendedWorkbookApplication.ExtendedAttachOrCreateNew(WorkbookArguments workbookArguments, IExcelInstanceManager instanceManager, ExcelStartOptions options)
at UiPath.Excel.ExtendedWorkbookFactory.Create(Boolean attachOnly)
at UiPath.Excel.WorkbookQuickHandle.SafeGetWorkbook(Boolean attachOnly)
at UiPath.Excel.WorkbookQuickHandle.OpenWorkbook()
at UiPath.Excel.Activities.Business.ExcelApplicationCard.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Please help me if anyone know it would be very useful for me

Thanks & Regards
Zaid Qazi

[ashokkarale]

@zaid.ahmad,

Try this solution.

RPC server unavailable

@CBahim @pavelhotovec @nesachdeva @BoCoNdOn @rupeshkumar.shah @Vikas.Jain @aksh1yadav @andrzej.kniola @srupesh1906 Hi all, we have been encountering this error today and the delay wasn’t working between scope activities. If you are encountering it when trying to interact with multiple files sequentially, the solution is to add a “close application” activity between each scope. This should eliminate the error - UI Path was struggling to close each file before opening the next and causing some so…

The rpc server is unavailable

@Palaniyappan What process name ? [image]

Also check this Knowledgebase for solution.

Excel Crash Error The RPC Server Is Unavailable Exception From HRESULT 0x800706BA

What troubleshooting steps need to be taken in order to resolve the issue "The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)" in Excel? Description: If an Excel crashes with error message "The RPC server is unavailable" and the HRESULT code 0x800706BA while working with UiPath and Excel. Root Cause: One of the possible causes of this error is when output is taken from a variable from the Excel Application Scope, and then the Excel instance is closed (in any way available, …

Thanks,
Ashok

[Anil_G (Anil Gorthi)]

@zaid.ahmad

Looks liek the excel instance is not closed or is left open

Try to use close explicitly or use a kill process and check

Cheers