Cant't build OLAP Cube

M

Marc

Hi,

i have a virtual Server with SQL Server 2005 SP1 (including Analysis Server)
and Project Server 2007 BTR.

Now i want to build a OLAP Cube in Project Server.

I get following error:
[11/9/2006 8:48 AM] Cube build session started
[11/9/2006 8:48 AM] Analysis Services session started
[11/9/2006 8:48 AM] Analysis Services session failed with the following
error: Invalid object name 'OlapObjects'.

Can anybody heln me?

Thanks
Marc
 
P

Paul Conroy

Unless you know how to create an OLAP repository and install the SQL 2005
backward compatibiity tools, cube build in BTR will not work. I believe this
is fixed in RTM.

Paul
 
S

Sumit

Marc,
Do install backward compatability components and then try this:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit.

Marc said:
Hi,

i have a virtual Server with SQL Server 2005 SP1 (including Analysis Server)
and Project Server 2007 BTR.

Now i want to build a OLAP Cube in Project Server.

I get following error:
[11/9/2006 8:48 AM] Cube build session started
[11/9/2006 8:48 AM] Analysis Services session started
[11/9/2006 8:48 AM] Analysis Services session failed with the following
error: Invalid object name 'OlapObjects'.

Can anybody heln me?

Thanks
Marc
Click to expand...
 
M

Marc

Hi thanks for answering my question.

The problem is, that i have only SQL Server 2005.
So i can't get a msmdrep.mdb from a AS2000.

Is there another way to build reports (over all projects)??


Thanks a lot!
Marc

Sumit said:
Marc,
Do install backward compatability components and then try this:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit.

Marc said:
Hi,

i have a virtual Server with SQL Server 2005 SP1 (including Analysis Server)
and Project Server 2007 BTR.

Now i want to build a OLAP Cube in Project Server.

I get following error:
[11/9/2006 8:48 AM] Cube build session started
[11/9/2006 8:48 AM] Analysis Services session started
[11/9/2006 8:48 AM] Analysis Services session failed with the following
error: Invalid object name 'OlapObjects'.

Can anybody heln me?

Thanks
Marc
Click to expand...
Click to expand...
 
T

thylocene

I am having exactly the same problem. I have BTR installed and th
error that I get when building the cubes is:

===== Initiating cube build process =====
[5/12/2006 9:46 AM] Cube build request message has been added to th
Project Server queue
===== Verifying and running pre-build server event handler =====
[5/12/2006 9:46 AM] Verifying and running pre-build server even
handler
===== Determining database and cube structure =====
[5/12/2006 9:46 AM] Cube build initialization started
[5/12/2006 9:46 AM] OLAP database and cube structure was determine
successfully
===== Building database and cubes =====
[5/12/2006 9:46 AM] Cube build session started
[5/12/2006 9:46 AM] Analysis Services session started
[5/12/2006 9:47 AM] Analysis Services session failed with the followin
error: Invalid object name 'OlapObjects'.
===== Process Completed =====
[5/12/2006 9:47 AM] Failed to build the OLAP cubes. Error: Analysi
Services session failed with the following error: Invalid object nam
'OlapObjects'.

The msmdrep.mdb from a AS2000 article has no relevance here since it i
for SQL 2000 (and is an Access database)

Can anyone please help!!!!!!!!!!!!!!
 
S

Sander.P.Bult

thylocene said:
I am having exactly the same problem. I have BTR installed and the
error that I get when building the cubes is:

===== Initiating cube build process =====
[5/12/2006 9:46 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[5/12/2006 9:46 AM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[5/12/2006 9:46 AM] Cube build initialization started
[5/12/2006 9:46 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[5/12/2006 9:46 AM] Cube build session started
[5/12/2006 9:46 AM] Analysis Services session started
[5/12/2006 9:47 AM] Analysis Services session failed with the following
error: Invalid object name 'OlapObjects'.
===== Process Completed =====
[5/12/2006 9:47 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Invalid object name
'OlapObjects'.

The msmdrep.mdb from a AS2000 article has no relevance here since it is
for SQL 2000 (and is an Access database)

Can anyone please help!!!!!!!!!!!!!!!


--
thylocene
------------------------------------------------------------------------
thylocene's Profile: http://www.officehelp.in/member.php?userid=5400
View this thread: http://www.officehelp.in/showthread.php?t=1256152

Posted from - http://www.officehelp.in
Click to expand...

I had same problem. Fortunately i also had a server with AS2000
installed. I copied the database files from that repository to the 2005
machine and attached them as database. Then I changed the repository
connection to that database and everything was running.

I just cannot beleive that we need to have and older version of AS to
get 2005 running..
 
S

Sander.P.Bult

[email protected] said:
thylocene said:
I am having exactly the same problem. I have BTR installed and the
error that I get when building the cubes is:

===== Initiating cube build process =====
[5/12/2006 9:46 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[5/12/2006 9:46 AM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[5/12/2006 9:46 AM] Cube build initialization started
[5/12/2006 9:46 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[5/12/2006 9:46 AM] Cube build session started
[5/12/2006 9:46 AM] Analysis Services session started
[5/12/2006 9:47 AM] Analysis Services session failed with the following
error: Invalid object name 'OlapObjects'.
===== Process Completed =====
[5/12/2006 9:47 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Invalid object name
'OlapObjects'.

The msmdrep.mdb from a AS2000 article has no relevance here since it is
for SQL 2000 (and is an Access database)

Can anyone please help!!!!!!!!!!!!!!!


--
thylocene
------------------------------------------------------------------------
thylocene's Profile: http://www.officehelp.in/member.php?userid=5400
View this thread: http://www.officehelp.in/showthread.php?t=1256152

Posted from - http://www.officehelp.in
Click to expand...

I had same problem. Fortunately i also had a server with AS2000
installed. I copied the database files from that repository to the 2005
machine and attached them as database. Then I changed the repository
connection to that database and everything was running.

I just cannot beleive that we need to have and older version of AS to
get 2005 running..
Click to expand...

PS
Found statement from microsoft site:
In SQL Server 2000 the Analysis Services repository was shipped as a
Microsoft Access database, but Analysis Services 2005 does not contain
a metadata repository. Instead, the Analysis Services database metadata
information are stored as XML files and are managed by Analysis
Services. These XML files can be placed under source control, if
desired.
 
P

Pablo

Hi!

I´m having the same problem.
I have only SQL Server 2005.
So i can't get a msmdrep.mdb from a AS2000.

There is a default repository for AS2005?

I have tried AS2005_Repository, but didn´t work.
How can i create the repository on AS2005 (i´m not migrating from AS2000)


Thanks
Pablo

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
Top