I am new using UiPath and so I started using it to extract data from a website, filter it and write the filtered data on a Google Sheets spreadsheet, there are several drop items and I am selecting one by one and them run it, most of them works fine but some of them that have more data to be extracted gives the error message “Error HRESULT E_FAIL has been returned from a call to a COM component”. I don’t know what to do or how to solve as it only occurs sometimes in specific selections.
Extract Table data "Error HRESULT E_FAIL has been returned from a call to a COM component" on some data
The error message “Error HRESULT E_FAIL has been returned from a call to a COM component” indicates a failure in a COM (Component Object Model) component during the execution of your UiPath workflow. This error can occur due to various reasons, including issues with the website, network connectivity, or the configuration of your activities.Ensure that the website you are trying to extract data from is accessible and functioning properly. Verify that you have a stable internet connection. Inconsistent network connectivity can sometimes cause errors during data extraction.
Thanks for the quick reply. The website is working fine, as I said it already extract it from other selected items it is just in some of them that it gives the error.
Make sure the table is fully loaded before extracting may be it is still loading and the extraction has started
If there are multiple pages try using delay between pages
and to make sure table is loaded may be indicate a element which is at the bottom of website and use check appstate on it so that the bot waits till the last element is loaded
I tried that by making it scroll all way down and all the way up again and it still doesn’t work.
Can you please show the workflow you are using…
And is it failing on extraction only?
And how big is the data?
And is there any change in the table structure
Can you please open the locals panel when error occurs and check the exception details from there
And also is it happening for the same selection always? Or is it random?
Yes, just on the extraction in some items, always the same ones, the other items from “School Name” works fine. I am not sure how big it is or how to show how big it is.
2023-06-07 14:08:14.517 GMT−4: Error: UiPath.UIAutomationNext.Exceptions.UiAutomationException: Error HRESULT E_FAIL has been returned from a call to a COM component.
at UiPath.UIAutomationNext.Extensions.ExceptionExtensions.GetFriendly(COMException comException)
at UiPath.UIAutomationNext.Extensions.ExceptionExtensions.ThrowFriendly(COMException comException)
at UiPath.UIAutomationNext.Services.DriverServiceCore.WrapComAsync[T](Func`1 toExecute)
at UiPath.UIAutomationNext.Services.DataExtractionService.ExtractPageDataAsync(IUiNodeX target, DataTable dataTable, String metadata, TimeoutToken timeoutToken)
If it is not failing immediately then
May be it might be a timeout issue…try increasing the timeout of the activity and check
If you open manually may be you cna see how much data is coming right?
Yeah, after I read the error log I thought about the timeout as well, I will try that and see if it works.
That did not work
Is it possible to send the link you are trying to use?
Can you please even tell or give a screenshot of one combination which is failing
Bowling Green St U (This is one of the ones that are failing)
So I checked and it is a very huge table…I can see that it is taking time to load and time to extract as well…
After the last click activity on submit…add one more dummy click activity and you can indicate a column or any element and set the wait for page load to complete…and then use extract table activity and set the timeout of both activities to around 90 seconds
Set wait for page load to complete is important so that it waits till then…click is a dummy one just to make it wait