Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
other
informationbridge
office.intranets
office.misc
office.setup
office.xml
officeupdate
onenote
photodraw.discussion
powerpoint
producer
proj.standard&server
project
project.developer
project.pro_and_serve
project.server
project.vba
project2000
publisher
publisher.prepress
publisher.programming
publisher.webdesign
visio
visio.createshapes
visio.database.modeling
visio.dev.diagrams
visio.dev.shapesheet
visio.dev.vba
visio.dev.vc
visio.developer
visio.general
visio.installation
visio.printing
visio.software.modeling
visio.troubleshoot
  
 
date: Wed, 28 Feb 2007 16:56:19 -0500,    group: microsoft.public.project.pro_and_server        back       


MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which was not supplied   
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.
date: Wed, 28 Feb 2007 16:56:19 -0500   author:   Brian Tkatch N/A

Re: MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which was not supplied   
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" <N/A> wrote in message 
news:i3ubu2da1le7vqnka7oope1k5u9994ue0v@4ax.com...
> 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.
>
date: Wed, 28 Feb 2007 22:45:57 -0000   author:   Mike Glen glenATmvps.org

Re: MSP_WEB_SP_QRY_CreateApprovalRecord' expects parameter '@p1', which was not supplied   
On Wed, 28 Feb 2007 22:45:57 -0000, "Mike Glen" <glenATmvps.org>
wrote:

>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" <N/A> wrote in message 
>news:i3ubu2da1le7vqnka7oope1k5u9994ue0v@4ax.com...
>> 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.
date: Thu, 01 Mar 2007 10:21:00 -0500   author:   Brian Tkatch N/A

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us