MSP2007, PWA project detailed view fails for large projects

[Vadim Gerya]

Hi ALL!
When I try to use PWA project detailed task view (for example "Tracking") I
fail if project has more that 4000 tasks (or less, it depends of EPM
architecture and hardware configuration) .

..NET warns that request has been aborted due to timeout expired.

Event Log details:
_____________________
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 05.05.2007
Time: 16:16:06
User: N/A
Computer: PROJECT
Description:
Event code: 3001
Event message: The request has been aborted.
Event time: 05.05.2007 16:16:06
Event time (UTC): 05.05.2007 13:16:06
Event ID: 513f22542ffa4370a3cc5b4e98728ef8
Event sequence: 1017
Event occurrence: 2
Event detail code: 0

Application information:
Application domain:
/LM/W3SVC/1720207907/root/SharedServices1-1-128227853744103448
Trust level: Full
Application Virtual Path: /SharedServices1
Application Path: C:\Program Files\Microsoft Office
Servers\12.0\WebServices\Shared\
Machine name: PROJECT

Process information:
Process ID: 2028
Process name: w3wp.exe
Account name: IWMAIN\projectserver

Exception information:
Exception type: HttpException
Exception message: Request timed out.

Request information:
Request URL: http://project:56737/SharedServices1/PSI/PWA.ASMX
Request path: /SharedServices1/PSI/PWA.ASMX
User host address: 10.0.0.230
User: IWMAIN\projectserver
Is authenticated: True
Authentication Type:
Thread account name: IWMAIN\projectserver

Thread information:
Thread ID: 8
Thread account name: IWMAIN\projectserver
Is impersonating: False
Stack trace:


Custom event details:

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
________________________________________________
Vadim Gerya, PMP

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1bf9b85347&dg=microsoft.public.project.server

 

[NZ Projects]

What's the suggestion ?

Have you got a SQL job cleaning WSS sessions ? If so, is it likely that
this is causing the time outs ?

 

[Vadim Gerya]

Thank you for answering!
Could you explain what kind of SQL job has to be configured for cleaning WSS
session or provide references where to read about?

== The sugestion is to get project detailed view working for any pojects

 

[NZ Projects]

Check out the deploy project server 2007 in a farm environment doco at
http://technet2.microsoft.com/Offic...52d2-4967-ab9d-0e199c9bf0041033.mspx?mfr=true

Search for "expired session"

 

[Vadim Gerya]

If you mean TRANCATing dbo.ASPStateTempSessions table in SSP database in
order to delete expired sessions - this is done.

 

[Vadim Gerya]

Dear NZ Poject !
If you have a little time try to publish large project (around 5000 - 7000
tasks with 10 - 15 resources assigned) in YOUR system and go to PWA "Task
Tracking" project detailed view (not "Assignment tracking" ). If you see
this view correctly tel me please.

I have tried to do this in different EPM installation. Assignment views work
OK.
Any view with tasks outlining (displaying summary and detaliled tasks in
outline form) fails for large project.
Why these views so important - the easiest way to show project to the
Customer and export project to Excel directly from PWA keeping task outline
structure.

Thanks in advance for your help and time.