[PS7] Cube Not even being started

C

CQ

I searched and found a post or two about this topic, but nobody had an
answer. I receive two errors - the one from Project Server and the email it
sends. Here is the error from Project Server:

===== Initiating cube build process =====
[9/27/2007 3:25 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[9/27/2007 3:25 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[9/27/2007 3:25 PM] Cube build initialization started
[9/27/2007 3:25 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[9/27/2007 3:25 PM] Cube build session started
[9/27/2007 3:25 PM] Analysis Services session started
[9/27/2007 3:25 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sbs2003r2. Error:
Your permissions on the server computer do not allow you to administer this
Analysis server.

Error:
===== Process Completed =====
[9/27/2007 3:25 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbs2003r2. Error: Your permissions on the server computer do
not allow you to administer this Analysis server.

Error:

(Yes, it ends with "error")
Here is the error message in the email:
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 09/27/2007 15:19:04.

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="b573c1e5-83a0-44f6-9bca-fbe597db4771" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=sbs2003r2
ASDBName=P7DemoACube ASExtraNetAddress=sbs2003r2 RangeChoice=0 PastNum=1
PastUnit=0 NextNum=1 NextUnit=0 FromDate=09/27/2007 13:07:16
ToDate=09/27/2007 13:07:16 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbs2003r2. 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="02dfe22c-608d-4f0c-9041-68ee1364eac7"
JobUID="53aff40f-0d76-460b-8301-a73884d94469" ComputerName="2003VSERVER"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

You can do the following:
1. Try troubleshooting using the error IDs, error XML.
2. Contact administrator with your jobID
(53aff40f-0d76-460b-8301-a73884d94469) and error XML.

To turn off these notifications, go to Project Web Access, click Personal
Settings on the left menu, and then click Manage My Alerts and Reminders.

From this page, you can clear the check box for those notifications you no
longer want to receive.

Microsoft Office Project Server


I have Project Server on one computer. I have SQL Server 2005 on another
server. I have followed the instructions from the following link to the
letter, two separate times, and still no joy.
http://technet2.microsoft.com/Offic...701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

Anything that perhaps that article is missing or some little setting
somewhere that has to be checked/unchecked or otherwise modifed?

Thanks.
 
B

Ben Howard

This is a permissions error. Are your SBS server and SQL server in the same
domain? I'm not sure the domain matters, but there must be some level of
trust between the two servers.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



CQ said:
I searched and found a post or two about this topic, but nobody had an
answer. I receive two errors - the one from Project Server and the email it
sends. Here is the error from Project Server:

===== Initiating cube build process =====
[9/27/2007 3:25 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[9/27/2007 3:25 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[9/27/2007 3:25 PM] Cube build initialization started
[9/27/2007 3:25 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[9/27/2007 3:25 PM] Cube build session started
[9/27/2007 3:25 PM] Analysis Services session started
[9/27/2007 3:25 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server sbs2003r2. Error:
Your permissions on the server computer do not allow you to administer this
Analysis server.

Error:
===== Process Completed =====
[9/27/2007 3:25 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbs2003r2. Error: Your permissions on the server computer do
not allow you to administer this Analysis server.

Error:

(Yes, it ends with "error")
Here is the error message in the email:
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 09/27/2007 15:19:04.

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="b573c1e5-83a0-44f6-9bca-fbe597db4771" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=sbs2003r2
ASDBName=P7DemoACube ASExtraNetAddress=sbs2003r2 RangeChoice=0 PastNum=1
PastUnit=0 NextNum=1 NextUnit=0 FromDate=09/27/2007 13:07:16
ToDate=09/27/2007 13:07:16 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server sbs2003r2. 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="02dfe22c-608d-4f0c-9041-68ee1364eac7"
JobUID="53aff40f-0d76-460b-8301-a73884d94469" ComputerName="2003VSERVER"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

You can do the following:
1. Try troubleshooting using the error IDs, error XML.
2. Contact administrator with your jobID
(53aff40f-0d76-460b-8301-a73884d94469) and error XML.

To turn off these notifications, go to Project Web Access, click Personal
Settings on the left menu, and then click Manage My Alerts and Reminders.

From this page, you can clear the check box for those notifications you no
longer want to receive.

Microsoft Office Project Server


I have Project Server on one computer. I have SQL Server 2005 on another
server. I have followed the instructions from the following link to the
letter, two separate times, and still no joy.
http://technet2.microsoft.com/Offic...701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

Anything that perhaps that article is missing or some little setting
somewhere that has to be checked/unchecked or otherwise modifed?

Thanks.
 

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