Project Server 2002 - PDS - Creating A New Project

[Craig Beuker]

Greetings,

I am trying to create a new project in MS Project Server
2002 via PDS and seem to be running into problems and have
no idea why.

Anyways, Here is what I am doing.

1) Log onto PDS. I have created an account for myself,
with admin privaledges and the like so I don't run into
any sort of security errors (I hope)

2) I issue the following request:
<Request>
<GetLoginInformation/>
</Request>

This returns me the spiffy result XML:
<Reply>
<HRESULT>0</HRESULT>
<STATUS>0</STATUS>
<UserName>Craig</UserName>
<GetLoginInformation>
<DBType>0</DBType>
<DVR>{SQL Server}</DVR>
<DB>ProjectServer0001</DB>
<SVR>DevServer</SVR>
<ResGlobalID>1</ResGlobalID>
<ResGlobalName>resglobal</ResGlobalName>
<UserName>MSProjectUser0001</UserName>
<Password>SS_*D0YklJea5YN</Password>
</GetLoginInformation>
</Reply>

3) Now, as I understand it, I open a connection to the
database with the items in that result. My connection
string looks like this:

Data Source=DevServer;Initial
Catalog=ProjectServer0001;User
ID=MSProjectUser0001;Password=SS_*D0YklJea5YN

4) I then get the SPID of the Connection with select @@SPID

5) Now that I got said SPID, I build my XML message which
should create a projectaccess item:
<Request>
<ProjectAccess>
<Mode>4</Mode>
<SPID>83</SPID>
<SPIDTimestamp>20030707030613</SPIDTimestamp>
<Project>
<ProjectName>TestProject</ProjectName>
</Project>
</ProjectAccess>
</Request>

The <SPIDTimestamp> item is the current time when I Create
the XML (According to the documentation, it can be, it
just has to be unique or something)

6) Now, I fire this off to Project Server PDS and get the
following response:
<Reply>
<HRESULT>0</HRESULT>
<STATUS>2</STATUS>
<UserName>Craig</UserName>
</Reply>

As I understand it, anything that isn't 0, 0 (HRESULT,
STATUS) is bad, or less than good.

Looking in the documentation about this error status I get
the following useful(less?) information:
"Some part of the request syntax is invalid (general
status)"

Well, I looked at the XML I submitted, it matches what
they show in the Documentation yet I get a Status of 2.

I am at a loss as to what is wrong here. Does anyone have
any ideas??

Thanks in advance

cmb..

 

[Darin]

The ProjectAccess PDS call you are referencing below is to be used to
gain access to a Project so that you can them perform SQL statements
against the MSP Views. The purpose of the PDS call is to insert an
appropriate record into the security tables. All of the MSP Views
require this security record to exist or they will not return any
records.

If you are trying to create a new project I suggest looking at
http://msdn.microsoft.com/library/en-us/pdr/PDR_PDS_UtilitiesExtender_3354.asp.

This gives you a working example for creating a new project using a
PDS Extender.

Darin...

======
Darin
E&C Professional Solutions
Perot Systems Corporation

 

[Craig Beuker]

Ahhh, oh, that clears things up.

I pretty much concluded I needed to write a PDS Extender
shortly after I posted that message.

Thanks for the reply

cmb..