Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Go Back  Xtreme Visual Basic Talk > > > Excel Automation causing: rpc_e_serverfault


Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2010, 10:37 AM
_Hiro _Hiro is offline
Newcomer
 
Join Date: Jun 2010
Posts: 2
Default Excel Automation causing: rpc_e_serverfault


Hi,

We have a vb program which is run on our server by scheduled task every day. The program opens about 30 excel files, refreshes the data connections, pivot tables and then saves the document in another location.

This may run fine for a couple days but sooner or later the process starts crashing, usually with this error: RPC_E_SERVERFAULT.

My question is, Is it expected that continually opening/closing/refreshing workbooks will inevitably cause the Excel object to crash at some point.

thanks,
Reply With Quote
  #2  
Old 06-01-2010, 11:19 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hi Hiro,

Welcome to the forum.

I have not had this sort of problem myself, but I have heard of this kind of thing when processing a lot of workbooks.

Also be careful when using Excel on the server. I would try to make sure that it is logged in as a valid user when it runs. See Considerations for server-side Automation of Office for more details.

- Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #3  
Old 06-02-2010, 03:50 AM
_Hiro _Hiro is offline
Newcomer
 
Join Date: Jun 2010
Posts: 2
Default

Hi Mike,

Thanks for the response.

Yes, everything I read about running the excel object like this on a server is considered a bad thing, plus the need to interact with the GC also. Unfortunately, I dont see another way to complete this task.

I think with this amount of processing we have to accept it's not going to be 100% stable , as the Microsoft KB states. But, this is fine until we find another solution.

Thanks,
George.
Reply With Quote
  #4  
Old 06-02-2010, 06:34 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Ok, yeah, this does seem to be the limitation of the setup. Sorry we couldn't help more.

Good luck with it George, and come back any time...
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
 
Excel Automation causing: rpc_e_serverfault
Excel Automation causing: rpc_e_serverfault
 
-->