Cube Building process was Initiated on DATE at Time & Error Messag

F

FaisalM

Environment:

Project Server 2003 with SP2a environment with 2 front-end, 1 VNS, 1
Analysis Services Server & 1 SQL 2000 Sp3 server.

I'm looking for description on these error messages plus the issue when the
cube status says "Cube Building process was Initiated on DATE at Time"
without any error. Application server has logged these errors/warnings.

Error 1

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 5433
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>


Error 2

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 4919
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Error 3

Event Type: Information
Event Source: W3SVC
Event Category: None
Event ID: 1074
User: N/A
Computer: MyServer
Description:
A worker process with process id of '2777' serving application pool
'PS2003AppPool' has requested a recycle because the worker process reached
its allowed processing time limit.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Error 4

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 461
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Transaction (Process ID 90) was
deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.]]></Description>


Error 5

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 676
Error Number: 0x8c040012
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Error 6

Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 919
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>


Error 7

vent Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 919
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Error 8

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 516
Error Number: 0x8c040017
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Error 9

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: TwoWeeksOldError
User: N/A
Computer: MyVNSServer
Description:
The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective action
will be taken in 60000 milliseconds: Restart the service.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Following are my assumptions:

a. Error 5 with Error # 0x8c040012 is logged for plans with Inactive Resoruces
b. Error 8 with error # 0x8c040017 is logged for plans with local resouces
when manager don't have rights to create resoruces.

MY INPUT:
a. Error 6 & 7 (Error showing [VERIFYINPTR(NULL)] & 0x80004003) are occuring
very often in event viewer, sometimes every second for long time.
b. Two weeks back VNS server logged Error 9 saying Project Server Scheduled
Process service terminated unexpectedly. It happend even after roobot.
Haven't seen it after that.

I'M LOOKING FOR:
a. details on errors (ignore two of my assumtption above If those are right)
b if these errors could cause cube issues.

AT LEAST once a week (sometimes more) the cube's status doesn't show as
being built last night & displays this message:

"Cube Building process was Initiated on DATE at Time"


SO FAR DONE:
a. Successful manual rebuild
b. Restarting of VNS, P.Schedule, OLAP services
c. Truncating Cube Tables
d. Rebooting boxes
e. KB articles

I've done these things & the cube works for few days. Some days later it
happens again.

Thanks
 
G

Gary L. Chefetz [MVP]

Faisal:

You've got multiple failures going on here, lots of authentication failures
on your "myserviceaccount" or accounts as the case may be. It's difficult to
have a discussion as such. The fact that the OLAP cube is the in "initiated"
state indefinitely indicates that the build request isn't making it to the
scheduler. Most often this is caused by the OLAP Admin account you're using
in COM+ is disabled or password expired.




FaisalM said:
Environment:

Project Server 2003 with SP2a environment with 2 front-end, 1 VNS, 1
Analysis Services Server & 1 SQL 2000 Sp3 server.

I'm looking for description on these error messages plus the issue when
the
cube status says "Cube Building process was Initiated on DATE at Time"
without any error. Application server has logged these errors/warnings.

Error 1

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 5433
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>


Error 2

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 4919
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Error 3

Event Type: Information
Event Source: W3SVC
Event Category: None
Event ID: 1074
User: N/A
Computer: MyServer
Description:
A worker process with process id of '2777' serving application pool
'PS2003AppPool' has requested a recycle because the worker process reached
its allowed processing time limit.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Error 4

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 461
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Transaction (Process ID 90) was
deadlocked on lock resources with another process and has been chosen as
the
deadlock victim. Rerun the transaction.]]></Description>


Error 5

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 676
Error Number: 0x8c040012
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Error 6

Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 919
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>


Error 7

vent Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 919
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Error 8

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
User: MyDomain\MyServiceAcct
Computer: MyServer
Description:
Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 516
Error Number: 0x8c040017
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Error 9

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: TwoWeeksOldError
User: N/A
Computer: MyVNSServer
Description:
The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective
action
will be taken in 60000 milliseconds: Restart the service.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Following are my assumptions:

a. Error 5 with Error # 0x8c040012 is logged for plans with Inactive
Resoruces
b. Error 8 with error # 0x8c040017 is logged for plans with local resouces
when manager don't have rights to create resoruces.

MY INPUT:
a. Error 6 & 7 (Error showing [VERIFYINPTR(NULL)] & 0x80004003) are
occuring
very often in event viewer, sometimes every second for long time.
b. Two weeks back VNS server logged Error 9 saying Project Server
Scheduled
Process service terminated unexpectedly. It happend even after roobot.
Haven't seen it after that.

I'M LOOKING FOR:
a. details on errors (ignore two of my assumtption above If those are
right)
b if these errors could cause cube issues.

AT LEAST once a week (sometimes more) the cube's status doesn't show as
being built last night & displays this message:

"Cube Building process was Initiated on DATE at Time"


SO FAR DONE:
a. Successful manual rebuild
b. Restarting of VNS, P.Schedule, OLAP services
c. Truncating Cube Tables
d. Rebooting boxes
e. KB articles

I've done these things & the cube works for few days. Some days later it
happens again.

Thanks
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Errors in Application Log of Event Viewer 10
untypical errors in EventLog / Project Server 2003 - SP3 0
OLAP Cube Problems...The cube building process was initiated ... 1
ARRGGHHH!! Error Number: 0x8c040012 1
Some Assignments do not show in the OLAP Cube 9
2003 SP2: Cube Building Issues 1
Message based assert detected errors in Project Server 2003. 0
Cube build fails, security check failure 11

Top