OLAP Cube failed to build

  • Thread starter Capt. Devendra Naidu
  • Start date
C

Capt. Devendra Naidu

Hi All,

I need your help folks, please...

I am running Project Server 2003 on SQL Server 2005 Enterprise installed on
a Cluster Server. I tried building the OLAP cube using PWA. After some time
when I check the status it gives me a message "The cube scheduled to be built
on ..... at .... failed. (0)". Can anyone please help me in solving this.

Some time back when I did the installation on the same h/w setup the cube
was building. I faced some problem with PWA and called Microsoft for support.
After they set the problem right I have never been able to build the cube.

When I connect to the SQL Enterprise Management Studio and check the
Analysis Services, I am able to see the prviously built cubes.

Can anyone help me please... (Thanks in advance for the help)
 
C

Capt. Devendra Naidu

Hi Paul,

Thanks for your prompt response. I searched thru all the articles posted by
you. The only thing I could try is the Backward compatibility components. I
am not too sure how relevant this would be to my setup since my database is
on 2005 only. I haven't migrated from SQL 2000.

I shall be grateful if you could please help me.

Regards,

Capt. Devendra Naidu.
 
C

Capt. Devendra Naidu

Hi Paul,

As a follow up, I also checked that the SQL BAckward Compatibility
components is installed.

Need your help.

Thanks.
 
P

Paul Conroy

The reason why AS2005 does not work with PS2003 is that it does not use a
repository. You should be able to create a repository manually by following
the steps below:-


If running Analysis Services 2005 (Service Pack 1 is required), you need to
setup a repository for DSO to write to. If you have migrated the Analysis
Services 2000 repository to the Analysis Services 2005 server, no additional
steps are required.

The instructions below detail how to migrate the repository or create a new
one:

1. On the server with Analysis Services 2005 installed, go to \Program
Files\Microsoft SQL Server\MSSQL.2\OLAP

2. Create a directory called ‘DSO9’
3. Share it as MSOLAPREPOSITORY$

4. Give the SQLServer2005MSOLAPUser$<MACHINENAME>MSSQLSERVER administrative
access to the share

5. Copy the file msmdrep.mdb into the DSO9 directory previously created
This file can be found in the Analysis Services 2000, and by copying it to
this directory you will be migrating it to Analysis Services 2005. If you
don’t have an Analysis Services 2000 server, you should create a new (empty)
..mdb file and add it to the DSO9 directory (you should use the name above or
edit the <DSO> section below).

6. Navigate to the \Program Files\Microsoft SQL Server\MSSQL.2\Config
directory

7. Edit msmdsrv.ini file and replace DSO section with the following (make
sure to fill out the appropriate <MACHINENAME>):

<DSO>
<RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\<MACHINENAME>\MSOLAPRepository$\msmdrep.mdb;Persist Security
Info=False</RemoteRepositoryConnectionString>
<RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb;Persist Security
Info=False</RepositoryConnectionString>
<RemoteLocksDirectory>\\<MACHINENAME>\MSOLAPRepository$</RemoteLocksDirectory>
<LocksDirectory>C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\DSO9</LocksDirectory>
</DSO>

If the cubes will be built on Analysis Services 2005, you need to install
the following components:
1. Microsoft SQL Server Native Client (sqlncli.msi)
2. Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)
3. Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)
 
S

Scott Tanaka

Has anyone found that msmdrep.mdb is missing from their MSSQL directories
after all of the installs (include backwards compat)?
I can't seem to find the file
Any thoughts?
Thanks,
Scott
 
P

Paul Conroy

Hi Scott

This file isn't installed with the BC components. Either copy one from an
existing 2000 AS server, or drop me a mail [email protected] and I'll
email you a copy of one.

Paul
 
S

Scott Tanaka

Thanks Paul...could have saved me the support call...appreciate the
information (you were right on...) - the support engineer at microsoft
emailed me one today.
Thanks!
Scott
 
Top