error building cube

R

Roberto Di Lello

i have some errors when i try to build the cube.
I make all the steps that i do on a VM and it doesnt work.

the log file show:
===== Initiating cube build process =====
[3/17/2008 5:36 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/17/2008 5:37 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/17/2008 5:37 PM] Cube build initialization started
[3/17/2008 5:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/17/2008 5:37 PM] Cube build session started
[3/17/2008 5:37 PM] Analysis Services session started
[3/17/2008 5:37 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server SRVPRJ01. Error:
Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
===== Process Completed =====
[3/17/2008 5:37 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server SRVPRJ01. Error: Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.



Any ideas? Could anyone help me? thanks in advance. Robert.
 
G

Gary L. Chefetz [MVP]

It appears that you are using Project Server 2007, which you do not specify,
but you certainly need to tell us what version of SQL you are using. What
did you do to setup the OLAP repository? Using PS2007 with SQL2005 requires
quite a bit of configuration. What directions did you follow?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
R

Roberto Di Lello

Sorry for the missing information.
Its a project server 2007 with sql 2005 sp2.

I configure the DSO properties in the analisys services, using a blank mdb.

Really i dont know why it doesnt works. In a VM works fine.

Any ideas?

Thanks in advance, Robert.



--
Roberto Di''Lello|MCSE 2008 / 2003 - MCSA Messaging 2003 - MCTS|
www.radians.com.ar


Gary L. Chefetz said:
It appears that you are using Project Server 2007, which you do not specify,
but you certainly need to tell us what version of SQL you are using. What
did you do to setup the OLAP repository? Using PS2007 with SQL2005 requires
quite a bit of configuration. What directions did you follow?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Roberto Di Lello said:
i have some errors when i try to build the cube.
I make all the steps that i do on a VM and it doesnt work.

the log file show:
===== Initiating cube build process =====
[3/17/2008 5:36 PM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/17/2008 5:37 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/17/2008 5:37 PM] Cube build initialization started
[3/17/2008 5:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/17/2008 5:37 PM] Cube build session started
[3/17/2008 5:37 PM] Analysis Services session started
[3/17/2008 5:37 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server SRVPRJ01. Error:
Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is already
opened exclusively by another user, or you need permission to view its
data.
===== Process Completed =====
[3/17/2008 5:37 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the Analysis
Services server SRVPRJ01. Error: Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is already
opened exclusively by another user, or you need permission to view its
data.



Any ideas? Could anyone help me? thanks in advance. Robert.
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

Robert:

The Analysis Session Failed error can have a number of causes. Go back
step-by-step through the following article to determine what you missed.
http://technet.microsoft.com/en-us/library/cc197552.aspx

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Roberto Di Lello said:
Sorry for the missing information.
Its a project server 2007 with sql 2005 sp2.

I configure the DSO properties in the analisys services, using a blank
mdb.

Really i dont know why it doesnt works. In a VM works fine.

Any ideas?

Thanks in advance, Robert.



--
Roberto Di''Lello|MCSE 2008 / 2003 - MCSA Messaging 2003 - MCTS|
www.radians.com.ar


Gary L. Chefetz said:
It appears that you are using Project Server 2007, which you do not
specify,
but you certainly need to tell us what version of SQL you are using. What
did you do to setup the OLAP repository? Using PS2007 with SQL2005
requires
quite a bit of configuration. What directions did you follow?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Roberto Di Lello said:
i have some errors when i try to build the cube.
I make all the steps that i do on a VM and it doesnt work.

the log file show:
===== Initiating cube build process =====
[3/17/2008 5:36 PM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/17/2008 5:37 PM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[3/17/2008 5:37 PM] Cube build initialization started
[3/17/2008 5:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/17/2008 5:37 PM] Cube build session started
[3/17/2008 5:37 PM] Analysis Services session started
[3/17/2008 5:37 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server SRVPRJ01.
Error:
Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is
already
opened exclusively by another user, or you need permission to view its
data.
===== Process Completed =====
[3/17/2008 5:37 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server SRVPRJ01. Error: Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is
already
opened exclusively by another user, or you need permission to view its
data.



Any ideas? Could anyone help me? thanks in advance. Robert.
Click to expand...
Click to expand...
Click to expand...
 
R

Roberto Di Lello

Thanks for your help i solve this issue.
--
Roberto Di''Lello | MCSE 2003 - MCSA Messaging 2003 | www.radians.com.ar


Gary L. Chefetz said:
Robert:

The Analysis Session Failed error can have a number of causes. Go back
step-by-step through the following article to determine what you missed.
http://technet.microsoft.com/en-us/library/cc197552.aspx

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Roberto Di Lello said:
Sorry for the missing information.
Its a project server 2007 with sql 2005 sp2.

I configure the DSO properties in the analisys services, using a blank
mdb.

Really i dont know why it doesnt works. In a VM works fine.

Any ideas?

Thanks in advance, Robert.



--
Roberto Di''Lello|MCSE 2008 / 2003 - MCSA Messaging 2003 - MCTS|
www.radians.com.ar


Gary L. Chefetz said:
It appears that you are using Project Server 2007, which you do not
specify,
but you certainly need to tell us what version of SQL you are using. What
did you do to setup the OLAP repository? Using PS2007 with SQL2005
requires
quite a bit of configuration. What directions did you follow?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


message i have some errors when i try to build the cube.
I make all the steps that i do on a VM and it doesnt work.

the log file show:
===== Initiating cube build process =====
[3/17/2008 5:36 PM] Cube build request message has been added to the
Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/17/2008 5:37 PM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[3/17/2008 5:37 PM] Cube build initialization started
[3/17/2008 5:37 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/17/2008 5:37 PM] Cube build session started
[3/17/2008 5:37 PM] Analysis Services session started
[3/17/2008 5:37 PM] Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server SRVPRJ01.
Error:
Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is
already
opened exclusively by another user, or you need permission to view its
data.
===== Process Completed =====
[3/17/2008 5:37 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to connect to the
Analysis
Services server SRVPRJ01. Error: Cannot connect to the repository.

Analysis server: SRVPRJ01

Error:
The Microsoft Jet database engine cannot open the file 'C:\Program
Files\Microsoft SQL Server\MSSQL.2\OLAP\DS09\msmdrep2.mdb'. It is
already
opened exclusively by another user, or you need permission to view its
data.



Any ideas? Could anyone help me? thanks in advance. Robert.
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

OLAP Cube build error 6
Troubleshooting Project Server 2007 Cube Building 4
Cube building in MPP Server 2007 Standalone 4
Cube buiding error - Analysis Services permissions 3
Cube Building 1
Cube Build Error. 4 of the NT accounts could not be added to OLAP 9
Getting error after deleting MDX Expressions and building OLAP cub 1
Olap Cube Build Error...can't seem to get the cube to build 5

Top