OLAP Cube Build Issue

[Dominic]

I am working with a customer where we have installed Project Server 2007 in
MOSS 2007. The customer has a named instance of SQL on a separate server, we
have followed the instructions in the Cube Building Service Guide for Project
Server 2007 document to the letter and keep encountering problems with the
OLAP Cube build.

This is the error message we have had:

CBS message processor failed
CBSASConnectionFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="81a120d1-e490-44b7-854d-772de300f3d4" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=sql-bitc1\BITCINTRANET
ASDBName=BITCCUBE ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=12/16/2009 16:35:29 ToDate=12/16/2009 16:35:29
HighPriority=True" Error="Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server
sql-bitc1\BITCINTRANET. Error: ActiveX component can't create object" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="81d32be0-83ae-461e-8cdd-3f15633c8f08"
JobUID="5cc1f9ed-7a6c-420a-9130-3f24ff8e4d99" ComputerName="SHAREPT-BITC1"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

We have also checked the msmdredir.ini file to determine the port number and
have the following information.

<Instances>
<Instance>
<Name>BITCINTRANET</Name>
<Port>3025</Port>
</Instance>
</Instances>

Any suggestions on how to resolve this challenge?

 

[Dominic]

Bit more info on this just in case anyone can help.

We worked through the Cube Building Service guide and elected for Option 2
"create the repository by creating a SQL Server 2005 database". All attempts
to get a cube to build result in failure - we are using named instances and
have done things on SQL Surface Area Config and SQL Browser Service to no
effect.

We are now exploring the Jet Database option and have created the DSO9
folder and obtained the msmdrep.mdb file - in following the instructions in
step 8 on page 31 they stipulate "add the account running the project server
queue service" which we have done but there is no explanation as to why this
is required.

In step 5d on page 32 of the guide it stipulates enter the account
information for the database - no instructions as to which account. we have
tried several accounts and keep getting a failure message when we click the
"Test Connection" button. We are loathe to put in an account which might work
when we don't fully appreciate the implications of this action.

At the moment we are at an impasse on this and I would greatly appreciate
any help anyone can offer.

 

[Gary Chefetz]

Dominic:

The error message indicates that you're failing to connect to the Analysis
Services. Are you certain that you added the Shared Service Provider (SSP)
service account to the SQL Server OLAP User role? Has it been added to the
Analysis Services Server role? Does this account have access to the
repository database and Project Server reporting databases? There are lots
of little steps that must be completed to make this work.

 

[Dominic]

Dear Gary,

We have the ssp account in the correct roles on the Analysis Services server
and the correct roles on the Analysis Services Repository and Project Server
Reporting Databases.

We keep getting the same message, I can only assume it is down to the named
instance of SQL - we have set SQL Surface Area Configuration remote
connections to be both TCP/IP and named pipes. We found out the port number
from the msmdredir.ini file, not sure what to do with that information though.