Cube Build Failure

K

Kevin

I am attempting to build the OLAP Cubes for the first time and failing. I
have several user accounts in play with MOSS and Project server 2007 for
security reasons. How do I know which user it is trying to use to execute
this job?

Failure Message:
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 10/15/2008 23:00:02.

To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="cf347b3b-d77a-4c16-a8dd-2724ed1856b3" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DHRM-DEV-SQL
ASDBName=PRJ07Analysis ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/15/2008 16:35:36 ToDate=10/15/2008 16:35:36
HighPriority=False" Error="Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DHRM-DEV-SQL. Error: Your permissions on the server computer do not allow you
to administer this Analysis server.

Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="bdc3cadb-f43a-4402-bf4c-0c10330076d3"
JobUID="68bc0565-fceb-4ee1-9545-20087b83bd20" ComputerName="DHRM-VMDEV-PRJ0"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

System Info:
DEV-SQL server running SQL Server 2005 + latest SPs
• The SQL Server Analysis Services user is SQLServiceAgent. This user has
User Mappings for the reporting database = db_datareader

DEV-PRJ07 server running Project 2007 + MOSS 2007 + Server 2008
• Of the many users I’ve setup to get Project 2007 running, SQLServerAgent
is not one of them. How do I learn which user is being used to build the
cubes and what other authority I need to give?
• The Database user for this configuration is not SQLServiceAgent.

Thanks for the help.
 
P

Paul Conroy

The cube build runs under the security identity of the SSP associated to PWA.
Ensure this account has admin permissions in AS.
 
K

Kevin

I made sure that my SSP user had db_datareader for the Reporting database.
Server roles are dbcreator, public and securityadmin. What other permissions
would constitute admin permissions to AS specifically?
Thanks.
 
K

Kevin

I did go into the properities of my AS and make sure my SSp was added to
security section. I restared the SQL Server Analysis Services and re-ran the
cube build (see below error). What permisions, if any, does the SQL Server
Analysis Services user need to have?

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server
DHRM-DEV-SQL. Error: Your permissions on the server computer do not allow you
to administer this Analysis server. Error:
 
K

Kevin

More detail but still no answer:

I verified my SSP account (it was what I thought it was).

I signed into the SQL Studio Manager with my SSP account. Clicked on
properties for Analysis Services. SSP cradentials seem to check out.

I turned on verbose logging for project server – general. Below is the
error I noticed:
PWA Site URL: http://dhrm-vmdev-prj08/PWA SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the
Analysis Services server. Verify the data source connection is valid. Error:
Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DHRM-DEV-SQL
ASDBName=PRJ07Analysis ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/22/2008 14:16:22 ToDate=10/22/2008 14:16:22

How do I validate the data source connection?
 
K

Kevin

Still strugling with this. I've rebooted the SQL box and cannot seem to
figure out the root problem "Error: Your permissions on the server computer
do not allow you to administer this Analysis server. "

My SSP use is part of the OLAP group. Do I need to create a shared folder
for Analysis Services? I read that in a post and didn't know if it was
really necessary.
 
B

Brant

Kevin,
I have also had a similar problem. I ran the setup described in this
article and made sure all permssions were setup to analysis services as it
described. I am stuck on ---- Cannot open database "Analysis Services
Repository" requested by the login.
 

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