Project Server 2003 - PDS - AssignmentsSave - ReplyStatus 9529

[Mike]

Hi all,

the AssignmentsSave Method returns ReplyStatus 9529, if i activate the
UpdateProjectManager Flag.

This errorcode is undocumented, so i dont know, what's going wrong.

I would be very glad, if someone could give me more information.

With best thanks,

Mike

 

[Jim Corbin [MSFT]]

PDS Status error codes over 9300 are always 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.

See
http://www.microsoft.com/downloads/...C72-4FA6-9CDF-6A796BDE2882&displaylang=en
for the tracing tool, and "Monitoring with SQL Profiler" in SQL Server Books
Online.

 

[Mike]

Hi Jim,

thank you VERY MUCH for your help

I tried the Project Server Tracing Service and got the following
event:

Component: PDS
Line: 0
Error Number: 0x2539
Description: <Description>
<![CDATA[CDataAccess.ExecuteSQLMSP_WEB_SP_QRY_AddNewTaskTransaction
519,0,0,0,'2004-07-16 11:48:31',103, 0; -2147217913 : Fehler beim
Konvertieren von Datentyp varchar in datetime.]]>
</Description>

The stored procedure (SP) looks like this:
/* Query #35000 */
CREATE PROCEDURE dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction
@p0 INT,
@p1 INT,
@p2 INT,
@p3 INT,
@p4 DATETIME,
@p5 INT,
@p6 INT
AS
INSERT INTO MSP_WEB_TRANSACTIONS
(WASSN_ID,WTRANS_TYPE,WTRANS_STATE,WTRANS_ACTION,WTRANS_DATE,WRES_ID_TRANS_SENDER,WDELEG_ID)
VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6) RETURN(0)
GO

I tested the SP in the SQL Query Analyzer and got the following
results:

failure: dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction 519,0,0,0,
'2004-07-16 11:48:31',103, 0

success: dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction 519,0,0,0,
'16.07.2004 11:48:31',103, 0

So, the SP seems to need a european (german) date format.

I think for the moment it's the best, to execute the SP manually,
after the PDS-Request.

BTW i have a question about the Project Server Tracing Service
Settings (i did not find a help file). What does the value 20480 mean?

Again, thank you very much for your help.

With kind regards from Cologne.

Mike

 

[Jim Corbin [MSFT]]

The SetTracing.exe comes with Project Server SetTracing Utility.doc, which
is the only documentation available. It notes:

Error Indicates that a significant problem, such as loss of data, has
occurred. This utility may load with a default value of 20480, which also
indicates maximum logging.

Hi Jim,

thank you VERY MUCH for your help

I tried the Project Server Tracing Service and got the following
event:

Component: PDS
Line: 0
Error Number: 0x2539
Description: <Description>
<![CDATA[CDataAccess.ExecuteSQLMSP_WEB_SP_QRY_AddNewTaskTransaction
519,0,0,0,'2004-07-16 11:48:31',103, 0; -2147217913 : Fehler beim
Konvertieren von Datentyp varchar in datetime.]]>
</Description>

The stored procedure (SP) looks like this:
/* Query #35000 */
CREATE PROCEDURE dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction
@p0 INT,
@p1 INT,
@p2 INT,
@p3 INT,
@p4 DATETIME,
@p5 INT,
@p6 INT
AS
INSERT INTO MSP_WEB_TRANSACTIONS
(WASSN_ID,WTRANS_TYPE,WTRANS_STATE,WTRANS_ACTION,WTRANS_DATE,WRES_ID_TRANS_S
ENDER,WDELEG_ID)
VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6) RETURN(0)
GO

I tested the SP in the SQL Query Analyzer and got the following
results:

failure: dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction 519,0,0,0,
'2004-07-16 11:48:31',103, 0

success: dbo.MSP_WEB_SP_QRY_AddNewTaskTransaction 519,0,0,0,
'16.07.2004 11:48:31',103, 0

So, the SP seems to need a european (german) date format.

I think for the moment it's the best, to execute the SP manually,
after the PDS-Request.

BTW i have a question about the Project Server Tracing Service
Settings (i did not find a help file). What does the value 20480 mean?

Again, thank you very much for your help.

With kind regards from Cologne.

Mike


"Jim Corbin [MSFT]" <[email protected]> wrote in message

PDS Status error codes over 9300 are always 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.

See
http://www.microsoft.com/downloads/...C72-4FA6-9CDF-6A796BDE2882&amp;displaylang=en
for the tracing tool, and "Monitoring with SQL Profiler" in SQL Server Books
Online.

 

[kadampravin]

*Hi all,

the AssignmentsSave Method returns ReplyStatus 9529, if i activate
the
UpdateProjectManager Flag.

This errorcode is undocumented, so i dont know, what's going wrong.

I would be very glad, if someone could give me more information.

With best thanks,

Mike *

I am using asp to manipulate data in sql server for ms project 2003.
Basically new ibterface to add efforts actual time for a specific
project. and I am successful in doing that.

But, the process when PM approves / accept the efforts and clicks
update, I ned to know which tables that process affects OR is there
anyway by which I can automate this service????