Multiple sites and OLAP cubes

[marina.claassens]

Hi,

I have one server with 3 instances of Project Server running. The cubes
used to build without any issues, now we receive errors when trying to
build 2 of the three cubes. The newest instance build without any
errors.

I get the following errors:
Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
Description:
Component: Unknown Component Name
File:
C:\Office\dev\project\WebClient\source\server\pjnpesvc\PjNpeSvc.cpp
Line: 147
Error Number: 0x80020009
Description: <Description><![CDATA[Cube Processing
Failed]]></Description>


Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
Description:
Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80040e14
Description: <Description><![CDATA[An error occured within AD Connector
for Matrix]]></Description>
___________________________________

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80040e14
Description: <Description><![CDATA[An error occured within AD Connector
for Matrix]]></Description>
___________________________________

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80040e14
Description: <Description><![CDATA[Method '~' of object '~'
failed]]></Description>

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
Description:
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1073
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'Matrix'. 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: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
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_CBE_RES1'.]]></Description>

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
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>
___________________________________

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 13/06/2006
Time: 09:45:12
User: NT AUTHORITY\LOCAL SERVICE
Computer: KWTMSP01
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>

I've run PSCommplus.exe utility, I've ensured that all the instances
use the same credentials in all the databases. And OLAPAdmin does have
sufficient rights.

Please help,

Thanks!
Millicent