Hi Gary,
I am facing same problem on another server as well, when i tried to publish
New and chnaged Assignments from Pro 2003, I am getting the following entries
in the application event Log.
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 841
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: ADODB.Recordset
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1909
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1506
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1097
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1164
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure call
or argument
Additional Information: An error occured processing the following view :-
<ViewsDropData><ProjectData><EntProjectName><![CDATA[sql1.Published]
]></EntProjectName><EntProjectID>6</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>103</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2004-10-05T15:57:49</TimeStamp></ViewsDropData>
]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 212
Error Number: 0x800a0005
Description: <Description><![CDATA[The views processor failed to process the
following document:
<ViewsDropData><ProjectData><EntProjectName><![CDATA[sql1.Published]
]></EntProjectName><EntProjectID>6</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>103</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2004-10-05T15:57:49</TimeStamp></ViewsDropData>
]]></Description>
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 10/5/2004
Time: 3:57:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 207
Error Number: 0x800a0005
Description: <Description><![CDATA[View scheduler received error while
scheduling views]]></Description>
___________________________________
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure call
or argument
Additional Information: An error occured processing the following view :-
<ViewsDropData><ProjectData><EntProjectName><![CDATA[sql1.Published]
]></EntProjectName><EntProjectID>6</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>103</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2004-10-05T15:57:49</TimeStamp></ViewsDropData>
]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 841
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: ADODB.Recordset
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1060
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 6200
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4849
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2386
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2386
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:39 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 588
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 841
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: ADODB.Recordset
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1060
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 6200
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4849
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2386
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 1100
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 10/5/2004
Time: 3:58:56 PM
User: NT AUTHORITY\SYSTEM
Computer: SVRMMC026
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 588
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Let us know how we can fix this probelm. we are unable to find what is
causing the problem. How the system is getting corrupted.
Thanks,
Vani
Vani said:
Hi Gary,
The following are the application log messages which are related Project
Server. Thease messages I can see repeatedly in the application log.
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Could not find stored procedure
'MSP_WEB_SP_QRY_GetNotificationAdminInfo'.]]></Description>
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 56
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Could not find stored procedure
'MSP_WEB_SP_QRY_GetNotificationAdminInfo'.]]></Description>
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 56
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Hope this helps in resovling the problem.
Thanks,
Vani
Gary L. Chefetz (MVP) said:
Vani:
It's not that you're being ignored, but you're asking a question that can
only be answered by a thorough examination of your installation. You're out
of news group diagnosis range with a problem like this. What are you seeing
in the server application event log? Post each error entirely; maybe that
will give us more of a clue, but no promises.
--
Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com
-