Problem Using Project 2003 PDS

[Ed Gabele]

I am trying to update the remaining work for a given assignment and set it
to 0. When attempting the AssignmentsSave call I get back Status=9515 and
nothing is updated. The following is being logged in the event log on the
server:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/11/2005
Time: 4:09:46 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: AGWIN2K3
Description:

Component: PDS
Line: 0
Error Number: 0x252b
Description: <Description><![CDATA[CDataAccess.GetAssignmentsInfo; 3265 :
Item cannot be found in the collection corresponding to the requested name
or ordinal.]]></Description>

I cannot find any documentation on any error codes other than what is found
in the PDS Reference.

Thanks, Ed.

Please send replies to the newsgroup.

 

[Gord Schmidt]

Hi Ed,

The following is from:
http://msdn.microsoft.com/library/en-us/pjsdk/html/pdsErrorCodes.asp?frame=true#exception

9300 - 9599 are data access exception errors, and are not enumerated. Status
error codes over 9300 are the result of something going wrong while accessing
the database. You can use the Project Server Tracing Service or the SQL
Profiler, or both, to help figure out what is happening. For more
information, see Project Server 2003 SetTracing Utility, and Monitoring with
SQL Profiler in Microsoft SQL Server Books Online.

Good luck,
Gord

 

[Ed Gabele]

Thank you for replying. I have grabbed the set tracing utility and run it
to log errors, warnings, and informational msgs to a text file. This has
yielded no additional information. I then ran the SQL Profiler tool so I
can get information about what SQL stmts and stored procedures were being
run while this is executing. I see where the MSP_PDS_AssignmentsGetData SP
is being run and the parameters being used. I ran it from Query Analyzer
and received the row of data that I would expect. This is the area in which
the event log msg says it has a failure. I am confused as to what would
cause the failure since I get data back.

Any additional help is greatly appreciated.

Ed.

Hi Ed,

The following is from:
http://msdn.microsoft.com/library/en-us/pjsdk/html/pdsErrorCodes.asp?frame=true#exception

9300 - 9599 are data access exception errors, and are not enumerated. Status
error codes over 9300 are the result of something going wrong while accessing
the database. You can use the Project Server Tracing Service or the SQL
Profiler, or both, to help figure out what is happening. For more
information, see Project Server 2003 SetTracing Utility, and Monitoring with
SQL Profiler in Microsoft SQL Server Books Online.

Good luck,
Gord
--
http://www.DoMoreThanManage.com

I am trying to update the remaining work for a given assignment and set it
to 0. When attempting the AssignmentsSave call I get back Status=9515 and
nothing is updated. The following is being logged in the event log on the
server:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/11/2005
Time: 4:09:46 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: AGWIN2K3
Description:

Component: PDS
Line: 0
Error Number: 0x252b
Description: <Description><![CDATA[CDataAccess.GetAssignmentsInfo; 3265 :
Item cannot be found in the collection corresponding to the requested name
or ordinal.]]></Description>

I cannot find any documentation on any error codes other than what is found
in the PDS Reference.

Thanks, Ed.

Please send replies to the newsgroup.