Cube database problems-Help me

[Len]

we have project server 2007 with new SP. The cube build process is working
fine everyday. Recently I tried to access data analysis service, But this did
not work. I ran the cube building process and following is the log. The cube
database is missing from the Analysis service database. I could not build the
database from the cube building process. Please let me know if you have any
suggestions

Thanks
Len




===== Initiating cube build process =====
[7/20/2009 11:39 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[7/20/2009 11:40 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/20/2009 11:40 AM] Cube build initialization started
[7/20/2009 11:40 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/20/2009 11:40 AM] Cube build session started
[7/20/2009 11:40 AM] Analysis Services session started
[7/20/2009 11:42 AM] 5 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[7/20/2009 11:42 AM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/20/2009 11:42 AM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/20/2009 11:42 AM] Process OLAP database session started
[7/20/2009 11:42 AM] Analysis Services session started
[7/20/2009 11:44 AM] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[7/20/2009 11:44 AM] Verifying and running post-process server event handler
===== Process Completed =====
[7/20/2009 11:44 AM] Cube build request completed successfully.

 

[Ben Howard]

Hi Len,

The post below indicates nothing is wrong. Can you be more specific.

 

[CQ]

We are having the same problem except my message has 10 NT accounts. This
causes the cube to fail. (Ben - the issue is in the sentence "5 of the NT
accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'")

Hi Len,

The post below indicates nothing is wrong. Can you be more specific.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

we have project server 2007 with new SP. The cube build process is working
fine everyday. Recently I tried to access data analysis service, But this did
not work. I ran the cube building process and following is the log. The cube
database is missing from the Analysis service database. I could not build the
database from the cube building process. Please let me know if you have any
suggestions

Thanks
Len




===== Initiating cube build process =====
[7/20/2009 11:39 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[7/20/2009 11:40 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/20/2009 11:40 AM] Cube build initialization started
[7/20/2009 11:40 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/20/2009 11:40 AM] Cube build session started
[7/20/2009 11:40 AM] Analysis Services session started
[7/20/2009 11:42 AM] 5 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[7/20/2009 11:42 AM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/20/2009 11:42 AM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/20/2009 11:42 AM] Process OLAP database session started
[7/20/2009 11:42 AM] Analysis Services session started
[7/20/2009 11:44 AM] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[7/20/2009 11:44 AM] Verifying and running post-process server event handler
===== Process Completed =====
[7/20/2009 11:44 AM] Cube build request completed successfully.

 

[CQ]

Hi Len,

Ben is correct in that the cube itself finishes with no problems. The NT
account "error message" is just a note to you - it doesn't really cause the
cube to fail.

I documented this in more detail at this location:
http://pmpspecialists.com/Blog/?p=207

 

[CQ]

Correcting myself - the message about the NT Accounts does NOT cause the cube
to fail. See my response to original post by Len.

We are having the same problem except my message has 10 NT accounts. This
causes the cube to fail. (Ben - the issue is in the sentence "5 of the NT
accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'")

Hi Len,

The post below indicates nothing is wrong. Can you be more specific.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

we have project server 2007 with new SP. The cube build process is working
fine everyday. Recently I tried to access data analysis service, But this did
not work. I ran the cube building process and following is the log. The cube
database is missing from the Analysis service database. I could not build the
database from the cube building process. Please let me know if you have any
suggestions

Thanks
Len




===== Initiating cube build process =====
[7/20/2009 11:39 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[7/20/2009 11:40 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/20/2009 11:40 AM] Cube build initialization started
[7/20/2009 11:40 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/20/2009 11:40 AM] Cube build session started
[7/20/2009 11:40 AM] Analysis Services session started
[7/20/2009 11:42 AM] 5 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[7/20/2009 11:42 AM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/20/2009 11:42 AM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/20/2009 11:42 AM] Process OLAP database session started
[7/20/2009 11:42 AM] Analysis Services session started
[7/20/2009 11:44 AM] Analysis Services session completed successfully
===== Verifying and running post-process server event handler =====
[7/20/2009 11:44 AM] Verifying and running post-process server event handler
===== Process Completed =====
[7/20/2009 11:44 AM] Cube build request completed successfully.