Extract Table data "Error HRESULT E_FAIL has been returned from a call to a COM component" on some data

Help Studio
,
1

Hi,
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.
Thank you.

2

Hi @MateusLH

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!!!

3

Hi @Nitya1
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.
Thank you

4

@MateusLH

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

cheers

5

@Anil_G
I tried that by making it scroll all way down and all the way up again and it still doesn’t work.

6

@MateusLH

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?

Cheers

7

image
image648×830 35 KB

@Anil_G
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)

8

@MateusLH

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?

Cheers

9

@Anil_G
Yeah, after I read the error log I thought about the timeout as well, I will try that and see if it works.
Thank you

1 Like
10

That did not work

11

@MateusLH

Is it possible to send the link you are trying to use?

Cheers

12

@Anil_G
Here you go Transfer Guide (kent.edu)

13

@MateusLH

Can you please even tell or give a screenshot of one combination which is failing

cheers

14

image
image794×251 9.29 KB

Domestic Schools
Ohio
Bowling Green St U (This is one of the ones that are failing)
Summer 2023
All Subjects

15

@MateusLH

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

cheers

16

As far as i understood, this error may appear if you use the standalone component “Extract Data Table” activity as apposed to the Table Extraction under Scraping (in the tool bar)