thread not run in paralel

Question

1.00/5 (1 vote)

See more:

Hi, friends, I created two threads. Each thread is running separately, but are not running simultaneously. The program stops and displays the error below:

"

C#

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Range'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020846-0000-0000-C000-000000000046}' failed due to the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA).

"

Sometimes it displays following error:

"

C#

The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

"

Please help me to resolve this error.

Thank you.

Posted 26-Jan-16 20:42pm

Member 12235586

Updated 27-Jan-16 0:08am

Sinisa Hajnal

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Jan-16 3:06am

"In parallel" does not have to be "simultaneously". The timing is random. Your exception is totally unrelated to parallelism; this is a casting exception. The question does not make sense, because — what's the use of showing exception message without code which throws that exception. Okay, the answer would be: fix your bug.
—SA

dan!sh 27-Jan-16 3:12am

What are you doing on those threads?

Member 12235586 27-Jan-16 3:26am

creating excel files.one thread creates odd numbers excel files.other one creates even numbers files.

dan!sh 27-Jan-16 3:43am

Are you writing to same file in both threads or you are creating files with different names?

Member 12235586 27-Jan-16 4:27am

like this
ex:- 1.xls, 3.xls, 5.xls creates by thread_odd
2.xls, 4.xls, 6.xls creates by thread_evan

lukeer 27-Jan-16 5:28am

Odd's counterpart is even, not Evan. That would be Jim Carrey's rival for the anchorman job.

But I'm 99% sure that spelling has nothing to do with your exception.

Sinisa Hajnal 27-Jan-16 6:10am

This is your real error:
The RPC server is unavailable

Google it and see what options you have.

Richard Deeming 27-Jan-16 8:27am

If all you're doing is creating Excel files, you might want to ditch Office Interop and use an alternative library instead. For example:

* EPPlus[^];
* ClosedXML[^];
* The OpenXML SDK[^];

These libraries don't use Office at all, and will even work on computers which don't have Office installed.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)