Excel processes problem

Question

Hello,

Please resolve the below problem.

I am creating 50 excel processes using excel 12.0 COM interop dll thru a WCF webservice which is hosted in IIS server.

(each excel process is taking 3 MB memory it means for 50 excels it need 150 MB only and my system RAM is 8GB). but after creation of 20 processes approx its stopped creation of rest.

Iam able to create all the processes succesfully  using  Visual studio ASPNET Development server.

I tried with these
1) gave admin rights to the account on which IIS is running.
2) Hosted WCF service (which is creating excel processes) on windowservice instead of IIS

 

 

Answer 1

Hi,
Welcome to MSDN!
One question, what do you mean in sentence "but after creation of 20 processes approx its stopped creation of rest ."? any exception there? could you please post the exception detail?
COM Interop, WCF and IIS are all involved in this case, the suspect maybe one of them, let's find it out:
    1. Extract the method that for creating excel process, put it into a seperate solution and test whether it can create 50 processes     successfully.
    2. If succeed in step1, we can publish the method as a WCF service, use self hosting, then call the service to see results.
    3. If succeed in step2, we may need to check the configuration of IIS or the Application Pool, and http://forums.iis.net/ where IIS experts live in is the best place for your questions.
By the way, why we need to create up to 50 processes for excel? you'd better read the requirements again to see whether 50 processes is needed.

Thanks,
Eric

---

Please remember to mark helpful replies as answers and unmark them if they provide no help.

Answer 2

Hi Eric,
Below mentioned errors are occuring, pls have a look.

The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A

 

(RPC_E_SERVERCALL_RETRYLATER))

 

 

The program used to create this object is Excel. That program is not installed on your computer.

To edit this object, you must install a program that can open the object

 

 

PROBLEM OCCURED WHEN CREATING EXCEL PROCESSES :Retrieving the COM class factory for component with CLSID

 

{00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.

 

 

ERROR OCCURED IN WORD PROCESS CREATION: Retrieving the COM class factory for component with CLSID

 

{000209FF-0000-0000-C000-000000000046} failed due to the following error: 80080005.

 

 

Reporting queued error: faulting application EXCEL.EXE, version 12.0.4518.1014, faulting module EXCEL.EXE,

 

version 12.0.4518.1014, fault address 0x00009848.

 

 

 

Exception from HRESULT: 0x800A03EC

Answer 3

Hi Eric,
Below mentioned errors are occuring, pls have a look.

The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A

 

(RPC_E_SERVERCALL_RETRYLATER))

 

 

The program used to create this object is Excel. That program is not installed on your computer.

To edit this object, you must install a program that can open the object

 

 

PROBLEM OCCURED WHEN CREATING EXCEL PROCESSES :Retrieving the COM class factory for component with CLSID

 

{00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.

 

 

ERROR OCCURED IN WORD PROCESS CREATION: Retrieving the COM class factory for component with CLSID

 

{000209FF-0000-0000-C000-000000000046} failed due to the following error: 80080005.

 

 

Reporting queued error: faulting application EXCEL.EXE, version 12.0.4518.1014, faulting module EXCEL.EXE,

 

version 12.0.4518.1014, fault address 0x00009848.

 

 

 

Exception from HRESULT: 0x800A03EC