OLAP Cube stuck at initiating, never builds.

R

robert.b.walden

Hello,

Here is the setup.

Server 1: Project Server 2003 Web Server
Server 2: Project Server 2003 Views Processing
Server 3: SQL 2005 Analysis Services
Server 4: SQL 2005 (contains project server DB)

The OLAP Cube used to build just fine and I'm not sure what happened
but it now gets stuck at "The cube building process was initiated on
"date" at "time"". I've searched the forums far and wide and tried a
great many things with no success. We were using SQL AS 2000 but were
getting this problem, so we tried AS 2005. Same issue occurs. I've
gone through the process and all the steps required for getting Project
Server 2003 to work with AS 2005, including copying over msmdrep.mdb
and editing the correct files and permissions, so I don't believe thats
an issue. I've run PSCOMPLUS, I've tested the service account and it
can login fine on a workstation so there is no problem with the
account. It's part of the OLAP Admin group as well as local
administrator on all of the boxes. I've tried deleting all of the xml
files from the shared viewdrop folder then restarting the proper
services. I've done so many things I can't even remember all of the
rest. I'll post the event log errors below. Any suggestions on where
to go from here without doing a complete reinstall would be very
appreciated. The next step is to open a Microsoft Support Ticket and I
would rather not go there. Thanks.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the
object is closed.]]></Description>



-----------------------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp</File><Line>105</Line><Number>0x800a0e78</Number><Description><![CDATA[Assert
Detected. The error code was also
included.]]></Description><Error><Component>ADODB.Recordset</Component><Description><![CDATA[Operation
is not allowed when the object is
closed.]]></Description></Error></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 90
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>


----------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp</File><Line>90</Line><Number>0x80004005</Number><Description><![CDATA[Assert
Detected. The error code was also included.]]></Description></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

robert.b.walden

Anyone?


Hello,

Here is the setup.

Server 1: Project Server 2003 Web Server
Server 2: Project Server 2003 Views Processing
Server 3: SQL 2005 Analysis Services
Server 4: SQL 2005 (contains project server DB)

The OLAP Cube used to build just fine and I'm not sure what happened
but it now gets stuck at "The cube building process was initiated on
"date" at "time"". I've searched the forums far and wide and tried a
great many things with no success. We were using SQL AS 2000 but were
getting this problem, so we tried AS 2005. Same issue occurs. I've
gone through the process and all the steps required for getting Project
Server 2003 to work with AS 2005, including copying over msmdrep.mdb
and editing the correct files and permissions, so I don't believe thats
an issue. I've run PSCOMPLUS, I've tested the service account and it
can login fine on a workstation so there is no problem with the
account. It's part of the OLAP Admin group as well as local
administrator on all of the boxes. I've tried deleting all of the xml
files from the shared viewdrop folder then restarting the proper
services. I've done so many things I can't even remember all of the
rest. I'll post the event log errors below. Any suggestions on where
to go from here without doing a complete reinstall would be very
appreciated. The next step is to open a Microsoft Support Ticket and I
would rather not go there. Thanks.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the
object is closed.]]></Description>



-----------------------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp</File><Line>105</Line><Number>0x800a0e78</Number><Description><![CDATA[Assert
Detected. The error code was also
included.]]></Description><Error><Component>ADODB.Recordset</Component><Description><![CDATA[Operation
is not allowed when the object is
closed.]]></Description></Error></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 90
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>


----------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp</File><Line>90</Line><Number>0x80004005</Number><Description><![CDATA[Assert
Detected. The error code was also included.]]></Description></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

Langhorne

I'm having a similar problem, with no success yet. But I did discover that
my PS Service Account wasn't a member of the OLAP Administrators group, so I
didn't have sufficient access. That didn't fix it, sadly, but it's at least
worth checking your setup for that.

Anyone?


Hello,

Here is the setup.

Server 1: Project Server 2003 Web Server
Server 2: Project Server 2003 Views Processing
Server 3: SQL 2005 Analysis Services
Server 4: SQL 2005 (contains project server DB)

The OLAP Cube used to build just fine and I'm not sure what happened
but it now gets stuck at "The cube building process was initiated on
"date" at "time"". I've searched the forums far and wide and tried a
great many things with no success. We were using SQL AS 2000 but were
getting this problem, so we tried AS 2005. Same issue occurs. I've
gone through the process and all the steps required for getting Project
Server 2003 to work with AS 2005, including copying over msmdrep.mdb
and editing the correct files and permissions, so I don't believe thats
an issue. I've run PSCOMPLUS, I've tested the service account and it
can login fine on a workstation so there is no problem with the
account. It's part of the OLAP Admin group as well as local
administrator on all of the boxes. I've tried deleting all of the xml
files from the shared viewdrop folder then restarting the proper
services. I've done so many things I can't even remember all of the
rest. I'll post the event log errors below. Any suggestions on where
to go from here without doing a complete reinstall would be very
appreciated. The next step is to open a Microsoft Support Ticket and I
would rather not go there. Thanks.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the
object is closed.]]></Description>



-----------------------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp</File><Line>105</Line><Number>0x800a0e78</Number><Description><![CDATA[Assert
Detected. The error code was also
included.]]></Description><Error><Component>ADODB.Recordset</Component><Description><![CDATA[Operation
is not allowed when the object is
closed.]]></Description></Error></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 90
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>


----------------------------------------------------------------------------------

Event Type: Error
Event Source: PjTraceSvc
Event Category: None
Event ID: 2
Date: 1/18/2007
Time: 10:07:17 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SOCAL01
Description:
Tracing Provider 'PjTraceProviders.TextFileProvider.1' Failed to
process the following error document:

2ÿ1000ÿ<Error><Component>PjSvrNPE</Component><File>C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp</File><Line>90</Line><Number>0x80004005</Number><Description><![CDATA[Assert
Detected. The error code was also included.]]></Description></Error>

The Provider returned the following error:

<Error><Component>Microsoft Project Server Tracing Textfile
Provider</Component><File>C:\Office\dev\project\WebClient\source\server\pjtraceproviders\TextFileProvider.cpp</File><Line>261</Line><Number>0x80004003</Number><Description><![CDATA[Could
not open the output file
'e:\ProjectServer.log']]></Description></Error>


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

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

Top