MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which was not supplied

[Brian Tkatch]

Project 2003 Server (I am not sure how to check which patch level)
Project Professional 2003 SP2

When assigning a task to a resource, the resource get an email. The
resource clicks the link in the email and updates his tasks. The
assigner get an email about the change telling him it is pending
approval, but when he clicks on the link, it says there is nothing to
approve.

The Application Event Log on the Project Server server records a
number of errors:

=======================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1066
Error Number: 0x80040e10
Description: <Description><![CDATA[Assert Detected for Virtual Root
'Projectserver2'. The error code was also included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Procedure
'MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which
was not supplied.]]></Description>

=======================================

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1187
Error Number: 0x80040e10
Description: <Description><![CDATA[Assert Detected for Virtual Root
'Projectserver2'. The error code was also included.]]></Description>

=======================================

And those are basically repeated. It seems the latter comes twice for
every one of the former, and this last time it repeated five times
(for a total of fifteen events).

We have tried the same series of events on a development server
(different project file as well), and that works as expected.

Any pointers here would be much appreciated.

B.

 

[Mike Glen]

Hi Brian,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[Brian Tkatch]

Hi Brian,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

Project 2003 Server (I am not sure how to check which patch level)
Project Professional 2003 SP2

When assigning a task to a resource, the resource get an email. The
resource clicks the link in the email and updates his tasks. The
assigner get an email about the change telling him it is pending
approval, but when he clicks on the link, it says there is nothing to
approve.

The Application Event Log on the Project Server server records a
number of errors:

=======================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1066
Error Number: 0x80040e10
Description: <Description><![CDATA[Assert Detected for Virtual Root
'Projectserver2'. The error code was also included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Procedure
'MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which
was not supplied.]]></Description>

=======================================

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1187
Error Number: 0x80040e10
Description: <Description><![CDATA[Assert Detected for Virtual Root
'Projectserver2'. The error code was also included.]]></Description>

=======================================

And those are basically repeated. It seems the latter comes twice for
every one of the former, and this last time it repeated five times
(for a total of fifteen events).

We have tried the same series of events on a development server
(different project file as well), and that works as expected.

Any pointers here would be much appreciated.

B.

OK. And here i thought since i wasusing both pro and server....

B.