Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))

Question

I am trying to convert a .xls file to an .xlsx file on the server-side using Microsoft.Office.Interop.Excel.Workbook class as follows:

 workBook.SaveAs("FILENAME_HERE", XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

and I get the following error:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)). : System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
   at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
   at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
   at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)
   at CALLING_METHOD_IN_MY_LIBRARY_HERE...

The problem is that this error occurs only on the staging server; on my local machine it works fine.

Things that I have tried on the staging server:

**1) Run dcomcnfg open Component Services

2) Expand Component Services "->" Computer "->" My Computer "->" the DCOM configuration "

3) Find the "Microsoft Excel application."

4) Right to open the Properties dialog box

5) Clicked on the "Security" tab,

6) "Launch and Activation Permissions, configure permissions, have added permissions - Identity run under Adminstrator user (This User), Interactive User and Launching Users

7). Launch and activation permissions + Access Permissions + Configuration Permissions => added IIS_IUSRS + Network Service with Full Controll**

2. Changed the build of the project that converts the .xls file from "Any CPU" to "x86" on my local machine and published this library on the server.

Did someone figured out how to fix this problem? I am struggling on fix this issue for 2 days now.

I know it seems silly, but have you got excel correctly installed on the server? — Melbz, Feb 27 '14 at 09:38
We've started to use Gembox instead of Microsoft.Office.Interop.Excel. This library does not require an Office installation server-side. — Tamas Ionut, May 06 '14 at 10:59
Try this one, it was helpfull for me [post][1] [1]: http://stackoverflow.com/a/3491486/3722162 — mapjaha, Oct 29 '14 at 13:08
For me only setting the IIS user as "this user" under DCOM | Properties | Identity tab worked. — dudeNumber4, Jan 20 '15 at 19:27

score 33 · Answer 1 · edited Sep 27 '16 at 14:57

33

Using DCOMCNFG.exe. Open it and go to: Component Services -> Computers -> My Computer -> DCOM Config -> Microsoft Excel Application.

Open the properties, select Identity tab and select the interactive user.

edited Sep 27 '16 at 14:57

m00am

5,910
11
53
69

answered Sep 27 '16 at 12:43

Vladimir Shiyanov

1,236
16
18

8

This only works when user is logged into the server. – Praveen Govind Oct 18 '19 at 16:37
3

what if there is no _Microsoft Excel Application_ entry in that path? – Silviu Mar 08 '21 at 14:47
Same as @Silviu I don't see Microsoft Excel Application entry in the path. Also does this only works when user is logged in? – Ravi Khambhati Feb 23 '22 at 23:44

score 13 · Answer 2 · answered Mar 11 '19 at 10:23

I found the solution elsewhere.

Doing the following did solve my problem:

Using DCOMCNFG.exe. Open it and go to: Component Services -> Computers -> My Computer -> DCOM Config -> Microsoft Excel Application. Open the properties, select Identity tab and select the interactive user.

BUT - the problem came back every few minutes !

After hours of trying to figure out the cause, I noticed my server had hundreds of opened WINWORD.EXE processes. This caused a memory issue which leaded to the exception from hresult 0x80080005 error.

Well, stupidly enough, I forgot to write the code to close the interop application. Once I fixed that, the error was gone.

doc.Close(false);
Marshal.ReleaseComObject(doc);
word.Quit();
Marshal.ReleaseComObject(word);

I used to solve the same exact problem while trying to interact with MapPoint Interop — Daniele Sartori, Jan 15 '20 at 14:11

ChiragMM · Answer 3 · 2018-02-01T12:08:19.863

8

I found this article which talks more about this issue in depth If this helps, error “80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))” could occur due to following reasons:

The machine has a high CPU load and the process takes a long time to start and fails to execute the CoRegisterClassObjects() in less than 120 seconds.
The COM server doesn't register for the right class IDs.
The COM server is currently stopping and there is a race condition between CoCreateInstance and the COM server stopping part.
There is a security problem in the way the COM server is started (this page seems to suggest misspelled passwords or lacking the "Login as Batch Job" privilege for "Run As.." COM servers, but anyway I would suggest re-verifying this information for your specific configuration)

https://blogs.msdn.microsoft.com/adioltean/2005/06/24/when-cocreateinstance-returns-0x80080005-co_e_server_exec_failure/

edited Feb 01 '18 at 12:08

answered Feb 01 '18 at 12:01

ChiragMM

347
4
12

1

A link to a solution is welcome, but please ensure your answer is useful without it: [add context around the link](//meta.stackexchange.com/a/8259) so your fellow users will have some idea what it is and why it’s there, then quote the most relevant part of the page you're linking to in case the target page is unavailable. [Answers that are little more than a link may be deleted.](//stackoverflow.com/help/deleted-answers) – Papershine Feb 01 '18 at 12:03
@paper1111 I've edited my answer why down vote give enough time to improve the answer While I welcome your suggestion I am working on similar issue and found this directly from Microsoft technical support about this issue If someone mark the answer down Users would not give importance to the answer or link shared in answer. – ChiragMM Feb 01 '18 at 12:09

score 3 · Answer 4 · answered Jun 24 '18 at 10:54

3

I fixed this issue with this solution: right click on Component Services/Computers/DCOM Config/Microsoft Word97 - 2003 Document properties/General Tab

set Authentication Level:None

answered Jun 24 '18 at 10:54

Ghadir Farzaneh

429
5
6

score 2 · Answer 5 · edited Mar 31 '23 at 12:34

The fix for me is to disable AutoRecover from File -> Options -> Save, then discard all autorecovered files. It would appear it's the volume of autorecover files which is the root cause.

Background I cycle through a lot open / close /compute cycles. Periodically the C# app fails to open a workbook with the below error.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

The app repeatedly throws this error and is stuck in this state until the AutoRecovered files are cleared from Excel.

Another symptom follows; when I try to open Excel app (as if to create a new workbook, not open an existing one), it takes a long time spinning cpu cycles. It opens eventually and there are tons of files listed in the Recovered files pane on the left.

I Close the pane using the button, all the files are then discarded. Re-opening Excel again after this procedure is near instant. The app runs fine again from hereon.

This was also the cause in my case. Actually, I resolved it by opening Excel, seeing many hundred files listed in the Recovery tab, clicking "Close" on the recovery tab, which deleted all the files, then closing Excel. Next time I tried using interop, the error no longer occured. — Laurent, Oct 18 '21 at 00:35

score 0 · Answer 6 · answered Jun 10 '14 at 14:03

0

Same problem was solved for me by "allowing desktop interaction" for the service. (in tomcat6w config tool on Log On tab)

answered Jun 10 '14 at 14:03

Gabor

1

score 0 · Answer 7 · answered Dec 14 '21 at 12:58

Start -> Run (Windows+R)

Type: dcomcnfg -32 (hit enter) this should open Component Services

Expand Component Services, Computers, My Computer, DCOM Config

Scroll down to "Microsoft Excel Application"

Right Click, select properties, go to Security tab

Edit Access Permissions

Click Add

Type <Computer_Name>/IIS_IUSRS (or go to Locations, select computer name - if using domain, by default, it will search the domain and will not find IIS_IUSRS)

Make sure the check box for "Allow" is checked for "Local Access"

Click OK, Click OK again (no rebooting is necessary)

Windows Update will reset this ever single time

score 0 · Answer 8 · answered Sep 01 '23 at 15:09

I had a similar issue with my Visual Studio Console Application. I have tried the above solution mentioned by "Vladimir Shiyanov".

Apart from that my application was set to run only for 32-bit applications, When I unchecked that, the application ran successfully.

score -4 · Answer 9 · answered May 08 '16 at 15:15

-4

Try to add Thread.Sleep Method, such as Thread.Sleep(2000) for 2 seconds after workBook.open and workBook.SaveAs two methods. If your Excel file has a lot of formats, try to extend few more seconds.

answered May 08 '16 at 15:15

Robert 30005

1
1
2

There are not callback functions available for open and save Excel files. I was having issue to save file. MS support team provided me a hint of adding sleep after save. It works for me. – Robert 30005 May 08 '16 at 16:05

Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))

9 Answers9

Linked

Related