Unable to retrieve timesheet data using PDS web service

  • Thread starter Microsoft Centre Of Excellence
  • Start date
M

Microsoft Centre Of Excellence

I am using the PDS web service that comes with Microsoft Project Server 2003.

I have entered data for Resources for different Tasks in the timesheet
through the Project Web Access. Now when I try to view the data using the PDS
Timesheet method - 'AssignmentsGet' - it shows the error with code '9531'.
When I checked in the event viewer the error message comes as
Component: PDS
Line: 0
Error Number: 0x253b
Description: <Description><![CDATA[CDataAccess.ExecuteSP; -2147217900 :
Procedure or function MSP_PDS_GetAvailableAssignments has too many arguments
specified.]]></Description>

Through the SQL profiler i can see that an extra parameter - a zero
is being passed to the stored proocedure ' MSP_PDS_GetAvailableAssignments'
along with the other required parameters and hence the error is occuring.

Also I am unable to approve the timesheet through the Project Web
Access. I get the error ''.

Why is this happening and what is the solution for retrieving the
timesheet data? Kindly advise.
 

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