I am getting below error when my bot is running

[cheersrpa]

Hi Team,

Do you have any idea about the below error message.?When i am running my macro within excel application scope.

Application Exception: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Please give me some idea about this error.How to fix it.This will save my life.

Thanks and Regards,

[cheersrpa]

Hi @arivu96 @Susana

I think you guys can help on this.

Thanks in Advance

[cheersrpa]

Hi @ Vlad_Postolache

Can you please help on the above query.Hoping you might be aware of this type of issue .

TIA

[PD2 (Priya)]

Have you checked this out:

Error: 'Microsoft.Office.Interop.Excel.Worksheet'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D8-0000-0000-C000-000000000046}' failed

Will you please share when you are getting this error? and the excel you are reading is containing what type of data ? Regards…!!

Error Executing Macro. Unable to cast COM

Scenario: Trying to execute a macro in a excel aplication scope. To execute this macro i need to have open another 2 excel files. Doing this manual it works just fine. Note that it takes a while to finish running the macro (in manual execution). Steps to reproduce: You need my files to reproduce. Using 3 excel files in excel application scopes and execute macro. Current Behavior: Macro runs and after some time it throw’s the following error: Execute macro : Unable to cast COM object of type ‘…

[cheersrpa]

Hey ,@PD2

Thanks for the reply.I too checked the above links ,but no luck

FYI-Excel has 300000 Data(as huge).It has plain 2 dimensional data and we dont have any charts in the excel.We are trying to invoke the macro within the excel application scope.

Any workaround for this?

TIA

[PD2 (Priya)]

I haven’t tried this, since you mentioned Macros within Excel Application scope,it’s worth a shot:

Unable to cast COM object of type 'System.__ComObject' to interface type

Hi Daniel, I unchecked the Visible property of Excel Application Scope from which the ExecuteMacro Activity was being called. And it worked for me. The issue in my case was around the screen update during macro execution. Regards, Rajni

[cclam81]

I realized this error appears in 2018.4.2, but when I run the same bot in 2018.4.1 everything runs fine.

Can someone from UiPath look into this?

[cclam81]

It seems the error is popping up randomly in both 2018.4.1 and 2018.4.2.
Sometimes it works, sometimes it just throws the error.
This is really strange. If anyone could assist that would be helpful.

[loginerror (Maciej Kuźmicz)]

Hi @cclam81

Could you post a screenshot of the error message you are receiving and some context?
Also, do you use the Community Edition or the Enterprise Edition?

Would it be possible for you to create a new project with minimum amount of activities that would reproduce the error. A sort of a sample, dummy project for us to investigate?

Also, if you happen to be on the Enterprise edition, please create a Support ticket to properly track the issue.

[cclam81]

Hi @loginerror, thanks for your reply.

I realized the issue I am facing should be on a separate thread since the process does not involve executing macro within an Excel application scope. However the exception encountered is quite similar. The process involves reading some data using Read Range into datatables from two Excel files. The exception occurs very randomly and if it happens, it’s always at the second Excel application scope.

Details:
18.4.2+Branch.master.Sha.9888b477be8d3ec8a832306fc59c34ba6edad108

Source: Excel application scope

Message: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘System.Runtime.InteropServices.ComTypes.IConnectionPointContainer’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{B196B284-BAB4-101A-B69C-00AA00341D07}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).

Exception Type: System.InvalidCastException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.InvalidCastException: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘System.Runtime.InteropServices.ComTypes.IConnectionPointContainer’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{B196B284-BAB4-101A-B69C-00AA00341D07}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).
at UiPath.Excel.WorkbookApplication…ctor(String workbookPath, String password, Boolean visible, Boolean autoSave, Boolean createNew, String editPassword, Boolean readOnly)
at UiPath.Excel.Activities.ExcelApplicationScope.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)

I am using Community Edition.

Please find below the sample project. Note that the above error occurs very randomly. And if the above error doesn’t appear, there will be a Runtime execution error:

TestForError.zip (38.8 KB)

Update: Unfortunately, when I open the sample project attached now, no errors will occur. The error can only be reproduced if I run the original project, but I can’t attach the original file and original Excel files as they contain sensitive data.

[loginerror (Maciej Kuźmicz)]

Interesting. This is already a valuable information, as it proves that there must be something in particular that is causing this issue.

Ideally, the path to fix this issue is to keep adding things to the small sample files until it starts reproducing the issue.

Could you give us an overview of how the original project looks like?

A quick thought - could you maybe introduce a small delay between the two Excel scopes in your original project (if they happen to be right after each other)?

[tclukay (Thomas Clukay)]

Just as a side note, I am getting EXACTLY the same error message listed earlier in this thread (the COM QueryInterface error), right down to the Windows registry ID and HRESULT code… I am not on 18.4 however, I am on 18.2.4.

All other behaviors identical. Sporadic issue, only happens with back-to-back Excel Application Scope activities. Since adding a 5 second delay between activities earlier today, I have not received the error.

[cclam81]

I have since tried another solution: Adding a Do-While loop containing a Try-Catch containing the second Excel Application Scope. And I also tried a 5 second delay between two Excel Application Scope activities. Both solutions worked.

It seems the problem lies in Excel not having released from memory fast enough in the first Read Range activity before the second Read Range activity starts.

@loginerror Regarding your question about the original project, the Excel files are quite small in size (<300kb). Nothing special about the files.

I guess the solution is really to introduce a short delay between any two Read Range activities. Perhaps this has nothing to do with the Excel Application Scope activity but rather how fast the Excel file can be released from memory in the first activity before moving on to the next activity involving another Excel file.

[ujjwal_gupta]

@cclam81 is right. I too get this error, but when I added a delay of 2 or 3 seconds between the excel reads/write of same excel, error was gone.

[Ra_ees_Khan]

HI guys

I am getting the same error as well

This happens at the second application scope
I did put a delay in between the excel applicaiton scopes and this has been working previously. But for some reason today, i am getting the following error.

If anyone has found another solution, please let me know

[armando.rueda]

This problem continues to happen, UiPath needs to pay attention to this problem, macros are an important part in many process automations.

[loginerror (Maciej Kuźmicz)]

Hi @armando.rueda

Could you explain your particular situation? I’ve seen this issue around and it seems to be related to some UiPath Excel activities (such as Copy Sheet) not working properly on the older versions of Excel (<2016). Is it the case for you?

If not, could you provide a sample project that causes the issue for you? Please include the version of your Studio, activity packages and your MS Office full version number (as seen in the backstage view).

Also, if you own the Enterprise edition, please also contact our technical support directly

[marjames777]

HI, Have you fixed this ?

[Biddles]

HI, I can see this error when I use copy sheet. My Excel version is 2016MSO（16.0.4266.1001） x64（EN）
Excel version is 2016MSO（16.0.4266.1003） x64（Chinese）
Is there any update？
copy sheet: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error:The requested does not exist。 (Exception from HRESULT: 0x80010114).

Thanks，

[loginerror (Maciej Kuźmicz)]

Hi @Biddles

Welcome to our UiPath Forum1

Could you maybe attach a new, sample project that reproduces the issue for you?
(a full project with Main.xaml and project.json file where the error will happen after running the process)