Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SharePoint (MOSS) Excel Calculation Services multiple concurrent ses

  Asked By: Jay    Date: Feb 12    Category: MOSS    Views: 3055

Can I open multiple concurrent Excel Workbooks (using Excel
Calculation Services, ex:
http://devServer/_vti_bin/ExcelService.asmx) and keep these sessions
open for 3-minutes?

We have a requirement that needs to maintain 20 concurrent sessions
to the Excel Calculation Services for at least 3 minutes each
(preferable 10 minutes).

Is there any special configuration for Excel Services to support this?

For testing I wrote a small program (windows form) to open an Excel
workbook on a MOSS trusted location. This program works as long as I
execute one instance of it at a time.

To simulate a user connection and keep the session open, my program
stays in a loop for 3 minutes while repeatedly calculating and
obtaining results from the Excel workbook.

This program works fine if I execute only one instance (one thread,
i.e. one user).

If I execute more than one instance of the program, it will run for
awhile, access the Excel workbook hundred times and then it gets one
of the following errors:

1) "Error: An operation is already being processed in this session.
Only one operation can be processed in a session at a time".
2) "Your session has timed out because of inactivity."
3) "Unable to connect to the remote server"

I've modified
1) the Excel Calculation Server web.config file to include:
<system.net>
<connectionManagement>
<add address="*" maxconnection="10" />
</connectionManagement>
</system.net>
2) the IIS connection timeout for the Office Server Web Services to
be 1200 seconds

I got the similar results from either a single server (1 CPU & 2GB
Memory) MOSS environment or a 3-server (1 WFE + 1 App + 1 SQL )
environment – the WFE server has 1 CPU and 2GB memory; the
Application server has 1 CPU and 4 GB memory; the SQL server has 1
CPU and 4GB memory. I configured Shared Services to run on the
Application server.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Hema Hegde     Answered On: Feb 12

Have you tried the registry modifications, as described in this article:-

technet2.microsoft.com/.../fb6928ce-49f8-492a-abff-5bd00\
ed588e21033.mspx?mfr=true

see under 'Plan for Concurrent Excel Calculation Services session  requests'.

 
Answer #2    Answered By: Lacey Daniels     Answered On: Feb 12

No, I have not tried any registry modifications.

I was hoping for another solution since my organization does not like
to implement registery changes in the production environment.

I will try to change the registry in my test server  and see if that
helps.