I
I-Ali
Hi All:
When I look at the Actual Work field in Project Center "Summary" View, all
the projects show with Actual Work as zero (0h). I looked at the data in the
backend SQL tables MSP_VIEW and MSP_WEB tables, they look fine. The Task
actual work and Assignment actual work shows non-zero values.
However, the eventviewer shows the following set of errors chronologically.
It looks like a blend of SQL DB errors and application error. I am not able
to decipher it correctly.
I would appreciate it if you can help me why I am seeing the Actual Work as
zero and also why these errors are showing up.
Error1:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1053
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: Violation of PRIMARY KEY constraint
'PK_MSP_WEB_VIEW_REPORTS_FIELDS_WVIEW_ID_WFIELD_ID'. Cannot insert duplicate
key in object 'MSP_WEB_VIEW_REPORTS_FIELDS'.
Error 2:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjBusObj
File: C:\Proj10\WebClient\source\server\pjbusobj\PjAdminBusObj.cpp
Line: 759
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 3:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjBusObj
File: C:\Proj10\WebClient\source\server\pjbusobj\PjAdminBusObj.cpp
Line: 885
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 4:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1172
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 5:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1168
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Your help is appreciated.
Thanks,
I-Ali
When I look at the Actual Work field in Project Center "Summary" View, all
the projects show with Actual Work as zero (0h). I looked at the data in the
backend SQL tables MSP_VIEW and MSP_WEB tables, they look fine. The Task
actual work and Assignment actual work shows non-zero values.
However, the eventviewer shows the following set of errors chronologically.
It looks like a blend of SQL DB errors and application error. I am not able
to decipher it correctly.
I would appreciate it if you can help me why I am seeing the Actual Work as
zero and also why these errors are showing up.
Error1:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1053
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: Violation of PRIMARY KEY constraint
'PK_MSP_WEB_VIEW_REPORTS_FIELDS_WVIEW_ID_WFIELD_ID'. Cannot insert duplicate
key in object 'MSP_WEB_VIEW_REPORTS_FIELDS'.
Error 2:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjBusObj
File: C:\Proj10\WebClient\source\server\pjbusobj\PjAdminBusObj.cpp
Line: 759
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 3:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjBusObj
File: C:\Proj10\WebClient\source\server\pjbusobj\PjAdminBusObj.cpp
Line: 885
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 4:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1172
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Error 5:
The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1168
Error Number: 0x80040e2f
Description: Assert Detected. The error code was also included.
Your help is appreciated.
Thanks,
I-Ali