Question
Flextronics Technologies PVT Ltd
IN
Last activity: 28 May 2019 1:08 EDT
The application called an interface that was marshalled for a different thread.
Hi Team,
I am facing a frequent exception which gets resolve by restating the BOT. The process step is : "BOT will run & close the excel macro file followed by C# script to kill all opened excel objects and then open another Excel." Logfile say then exception has occurred at excel opening.
Exception:
“Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-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 find the attachments and help me to resolve it.
***Moderator Edit-Vidyaranjan: Updated SR details***
***Edited by Moderator Marissa to update platform capability tags' update SR details****
Flextronics Technologies PVT Ltd
IN
Hello Team,
Still I am facing the same issue, Please find the attached C# codes and sample data file.
The flow is :
1. RPA will import the excel data into DataTable using C#
2. Based on Excel parameter "Sr.No." C# will fetch the "SiteCode" value
3. Based on Excel parameter "Sr.No." C# will fetch the "Site_Name" value
I have design a same RPA flow to repeat the above steps 1,2,& 3. Can any one help me to resolve the explained exception.
Flextronics Technologies PVT Ltd
IN
Hi Team,
Seems the issue is of thread hence I am trying to use asynchronous execution path, But still failing, Can any one help to resolve it.
Pegasystems Inc.
US
Please share the SR ID @HafizurRehmanA so that we may track it for you here!
Pegasystems Inc.
IN
Hello!
On reviewing the SR we see that the issue was due to the design - The Automation consisted large number of components which is not a best practice. Please break down the automation into smaller automations.
The below two articles help.
https://community.pega.com/knowledgebase/documents/best-practices-building-solutions
Regards,