TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ashokan Elumalai
NA
4
0
Excel 2007 throiwng RPC failed/RPC Unavailable exception on large datasets
Jul 18 2009 4:46 AM
Hi,
Following is log of an error that we are frequently getting while invoking excel and perfoming calculations using
asp.net
(Excel 2007)
17Jul2009
13:03:42
INFO ODSReports.OrdStatsByPercentGraph - .Creating chart for OrdStatsBySKU
17Jul2009
14:14:51
WARN ODSReports.ODSExcelFunctions - Unable to programmatically set <CenterFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
>>>>>>>.Exception here - Remote procedure call failed. Note that the chart prep has taken 1 hr +
17Jul2009 14:14:51 WARN ODSReports.ODSExcelFunctions - Unable to programmatically set <RightFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
>>>>>> RPC is unavailable...
Notes:
1) We get this error only when we use a large dataset (e.g. working with > 10000 rows). Things work perfectly when we use smaller datasets (e.g. 1000 rows etc)
2) We did not see this on Excel 2003. Excel 2007 seems to be slower and also having this problem.
Do you know of any info/issues regarding excel 2007 and RPC disconnect/timeout etc ?
Thanks a lot for your time
Reply
Answers (
0
)
How do I programatically retrieve and update data within an .mdf database within my solution
Help word automation with c# urgent please