Failed to build the OLAP cubes

[Ahmed Ghaith]

Hi,

I have problem in SQL Analysis Services project server 2007, could you help
me .

The following message has appear when project server build OLAP cube:

"Failed to build the OLAP cubes. Error: Analysis Services session failed
with the following error: Cannot overwrite an Olap database created outside
of Project Server or by another Project Server Site."

and the following email appear me:

"Your CBSRequest job failed.Its current state is FailedNotBlocking.It was 0%
complete.It entered the queue at 04/29/2009 17:41:50.

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: 17013
Error ID: 26000
"

Regards.

 

[Mike Glen]

Hi Ahmed ,

Try posting on the microsoft.public.project.server newsgroup (forum).
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[M]

Hi,

If the error message contains "<error id="17013"
name="CBSAttemptToOverwrite"...", it means the cube building service is
detecting duplicate names for the cube databases. This error usually occurs
when you have two instances, the production and test environments. The
solution I found to work for this problem is to delete all the records from
the Analysis Repository database (the Server and OlabObjects tables). Then
rebuild the cube and it should work (it also repopulates the tables above).

Be sure to backup the repository database before you clean in it, just in
case.