Risks on Project Workspace

[winnes]

Where are these to be found in the database (published, reporting),
eventually through PSI calls?

In a test workspace I already have 2 risks, but e.g.
MSP_PROJECTS.PROJ_ACTIVE_RISK_COUNT = 0!?
MSP_PROJECTS.WPROJ_RISK_LIST_NAME has a Guid, but what use is this?

Thanks for any help.

 

[Rod Gill]

You say PSI, so you have Project Server 2007? Please always state version
and service pack level.

Look in the Reporting database then at the built in Views for the reporting
db. They include Risks and Issues from the SharePoint db.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[winnes]

Thanks for your answer Rod.
Project Server 2007 indeed, service pack 1.
Views work on table MSP_WssRisk, which remains empty...

Have tried following scenario on the latest EPMDemoV4 VPC (so latest service
packs), to exclude issues coming from my setup of EPM or issues originating
from my customisations:

in Project Professional 2007:
- connect to EPMDemo2007/PWA
- create and save a project with 2 (blank) tasks
- publish project and save a workspace

In PWA:
- open project workspace for this project
- add a risk (description + default values)

Checked tables and views in Reporting db, remains empty

Found this in the event viewer:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: General
Event ID: 6875
Date: 9/3/2009
Time: 2:09:43 AM
User: N/A
Computer: EPM2007DEMO
Description:
Error loading and running event receiver
Microsoft.Office.Project.PWA.WSSEventReceivers.PSDBUpdater in
Microsoft.Office.Project.Server.PWA,Version=12.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c. Additional information is below.

: The request failed with HTTP status 401: Unauthorized.

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

Looks like this is related to one another...
Any further ideas?

 

[winnes]

Turns out that after a (new) publish project the reporting db sync is
launched and fills wss data in the reporting wss risk tables and views...

I will need to make calls to the WSS object model in order to get my risk
info. (Cannot ask enduser to perform project publish after having changed
risk stuff...

 

[Rod Gill]

Glad I was able to fix the problem!!!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com