where in the database are issues & risk stored?

[Stephan Steiner]

Hi

I'd like to read existing and add new issues to a MS Project 2003 Server.
Since there's no method for doing that via PDS, I'm thinking of writing a
PDS extender, but I need to know which tables are used in the database and
I'm having the hardest time figuring out where exactly the issues and risks
are stored.

I've been reading up on this and a few other project related groups and what
I found is that issues and risks ought to be in the STS database
(STS_hermes_1 in my case where hermes is the name of the system where
project server is running), not the project database (ProjectServer) but no
matter how hard I look in every table in the STS database I can't find the
issues that are present in my projects.

Any idea where exactly those issues and risks are stored would be much
appreciated.

Regards
Stephan

 

[Jim Corbin [MSFT]]

If you are using Windows SharePoint Services 2.0 (SP1), the way to access the
data is with the WSS Web services, which are documented in the WSS SDK:
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/sharepoint.asp. WSS does not publish the db schema, and discourages direct db access.

An example of using the WSS Web Services with issues and risks is in the
Project 2003 OLAP Extensions Solution Starter download
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEED7E60-C83F-4B1D-980F-8298C0911E1E.
Essentially, you create the tables MSP_ISSUE and MSP_RISKS, then send SOAP
calls to each WSS project site to populate the tables. The table schema and
source are in the TaskIssuesRisks directory of the Solution Starter download.

See also Adding Windows SharePoint Services Data for Risk Analysis:
http://www.msdn.microsoft.com/libra...html/pjsdkCubes3RiskManagement_HV01096313.asp.

 

[Stephan Steiner]

Jim

I finally figured out where the proper table (UserData table in the STS
database (named STS_servername_X)), but it does look pretty complex and I
feel much more comfortable knowing there's an API. Thanks a bunch for your
help.

Stephan

If you are using Windows SharePoint Services 2.0 (SP1), the way to access the
data is with the WSS Web services, which are documented in the WSS SDK:

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/sharepoint.asp.
WSS does not publish the db schema, and discourages direct db access.

An example of using the WSS Web Services with issues and risks is in the
Project 2003 OLAP Extensions Solution Starter download
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEED7E60-C83F-4B1D-980F-8298C0911E1E.
Essentially, you create the tables MSP_ISSUE and MSP_RISKS, then send SOAP
calls to each WSS project site to populate the tables. The table schema and
source are in the TaskIssuesRisks directory of the Solution Starter download.

See also Adding Windows SharePoint Services Data for Risk Analysis:

http://www.msdn.microsoft.com/libra...html/pjsdkCubes3RiskManagement_HV01096313.asp.