PDS ProjectCreate status error

J

James Fraser

I am running into an error when using the PDS projectcreate calls. Often, it
is returning:

<Reply>
<HRESULT>0</HRESULT>
<STATUS>1000</STATUS>
<UserName>James Fraser</UserName>
</Reply>

This status translates to: "rsProjectNotFound" (Well, of course not. That's
why I want to create it.)

The project is not created when I get this error.

The situation is even stranger because this call was failing on my
development server today for several hours, and then began working fine. I
can not figure out anything I changed between when it wasn't working and when
it was. I have copied my call to a text file to run identical calls on my dev
machine and on my production machine where it fails. All other commands that
I have tried through PDS (all data retrieval) have worked as expected on all
machines.

I'm currently getting the same error on a production server, and am at a
loss. I get the error even with the simplest Project Create call I can use:
<Request>
<ProjectCreate>
<AutoPublish>1</AutoPublish>
<Project>
<ProjectName>UniqueName1.Published</ProjectName>
<StartDate>20060428</StartDate>
</Project>
</ProjectCreate>
</Request>


Any hints or ideas? I'll try almost anything at this point.
TIA...
James Fraser
 
J

James Fraser

I am running into an error when using the PDS projectcreate calls. Often, it
is returning:

<Reply>
<HRESULT>0</HRESULT>
<STATUS>1000</STATUS>
<UserName>James Fraser</UserName>
</Reply>

This status translates to: "rsProjectNotFound" (Well, of course not. That's
why I want to create it.)

I'm not sure about all of the causes for this error, but I did resolve it to
some degree. On one of the servers that the ProjectCreate call was failing,
we spotted a duplicate project that did not have a "Version" (ie .Published)
This was listed in the projects appearing in the "Clean up Database" Project
list. All other entries in this table without a Version were templates, as it
should be.

I verified this was a near-duplicate entry in MSP_WEB_PROJECTS (different
WPROJ_ID, but same name.) Deleting this entry from the DB allowed things to
function.

Of course, with this error and corruption creeping in, we are making plans
to start a new database for this Project Server.


Maybe this will help someone...
James Fraser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top