Cube Build Error. 4 of the NT accounts could not be added to OLAP

[Shawn Everingham]

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Sander]

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Sander]

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

Sorry, but I'm no dba...can you be a little more specific on how to connect
to Analysis Services?

What I see when I connect the db server which houses our MSPS databases, I
see folders beneath the server name...
Databases
Security
Server Objects
Replication
Management
Notification services...

under databases we have one for ProjectServer_Archive, Draft, Pulished,
Reporting, Shared Services Admin, shared services db, sharepoint ...etc...

nothing that says Analysis Services...so where do I connect? under file new
connection?

Help a brother learn how to fish...thanks in advance!

--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?



:

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

duhh...nevermind...disregard last post...

now let me see if I can follow along. stay posted for log...
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?



:

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

looks good from here...here's the log....

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>MSPS_PROD_Cube_072508</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Database 'MSPS_PROD_Cube_072508' completed successfully.
Start time: 7/28/2008 2:49:55 PM; End time: 7/28/2008 2:49:55 PM;
Duration: 0:00:00

--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?



:

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

hmmm...

my queue building is still failing.

===== Initiating cube build process =====
[7/28/2008 2:59 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/28/2008 2:59 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/28/2008 2:59 PM] Cube build initialization started
[7/28/2008 2:59 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/28/2008 2:59 PM] Cube build session started
[7/28/2008 2:59 PM] Analysis Services session started
[7/28/2008 3:00 PM] 4 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/28/2008 3:00 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/28/2008 3:00 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/28/2008 3:00 PM] Process OLAP database session started
[7/28/2008 3:00 PM] Analysis Services session started
[7/28/2008 3:01 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072008
on the AIMDBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/28/2008 3:01 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072008 on the AIMDBCL02A server. Error:
Server: The operation has been cancelled.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Shawn Everingham]

I went to personal settings, then my queued jobs, found where it errorred out
and copied the log to the clipboard...

here it is...

Error summary/areas:
CBS message processor failed
CBSOlapProcessingFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="9657d2ef-00e9-4ad9-8f6c-60c9e870243d" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DBCL02A
ASDBName=MSPS_PROD_Cube_072008 ASExtraNetAddress= RangeChoice=1 PastNum=6
PastUnit=2 NextNum=12 NextUnit=2 FromDate=07/29/2008 12:39:35
ToDate=07/29/2008 12:39:35 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072008 on the DBCL02A server. Error: Server:
The operation has been cancelled.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="59afb1c5-ef5e-4630-9994-7f7b01e72d9e"
JobUID="f4dd13d7-6087-4c3d-bf0b-d848fbd7e687" ComputerName="PROJECT01"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?



:

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!

 

[Sander]

Hi Shawn,

WHat I notice
the error in the queue log is talking about analysis services database
MSPS_PROD_Cube_072008 (Failed to process the Analysis
Services database MSPS_PROD_Cube_072008 )

While the cube you processed in Management Studio is called
MSPS_PROD_Cube_072508 ( Database 'MSPS_PROD_Cube_072508' completed
successfully)


Question:
how many analysis databases do you see in Management Studio and what are the
names?

You could try to configure ProjectSErver to build the MSPS_PROD_Cube_072508
Cube which is working manually.
Also to try is to manually process the MSPS_PROD_Cube_072008 in Management
studio.

hope you get along little bit further now...

Sander

I went to personal settings, then my queued jobs, found where it errorred out
and copied the log to the clipboard...

here it is...

Error summary/areas:
CBS message processor failed
CBSOlapProcessingFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="9657d2ef-00e9-4ad9-8f6c-60c9e870243d" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=DBCL02A
ASDBName=MSPS_PROD_Cube_072008 ASExtraNetAddress= RangeChoice=1 PastNum=6
PastUnit=2 NextNum=12 NextUnit=2 FromDate=07/29/2008 12:39:35
ToDate=07/29/2008 12:39:35 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072008 on the DBCL02A server. Error: Server:
The operation has been cancelled.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="59afb1c5-ef5e-4630-9994-7f7b01e72d9e"
JobUID="f4dd13d7-6087-4c3d-bf0b-d848fbd7e687" ComputerName="PROJECT01"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003

when in the Management studio , connect to Analysis services. Then exapnd the
object explorer to the OLAP databases. Right click on the one that belongs to
you project server and choose option 'process'. In next screen klik ok and it
will process (refresh data) the cube. It will give you errors which you can
copy and paste here (i hope)

let us know how it goes..

and, how exactly do you do that? I have full access to the database via Sql
Management Studio, so if you'd be so kind as to point me in the right
direction, tha'td be appreciated.


Don't know why I have to recreate the cube. I rebuild the cube via PWA
server settings every monday morning to build timesheet reports in
dataanalysis.

This past monday morning, (post reboot) I got this error. I've had a similar
build error before (but not the same) so...smarty pants me, made a new cube
as that is what resolved it last time...upon further investigation, the
message was 4 nt accounts...now I'm stuck...

S.
--
Technology, like art, is a soaring stretch of our imagination...Daniel Bell.
1919
------------------------------
MSPS 2007
MS Server 2003


:

Hi Shawn,

To get to you first question, what is the situatiion when you reboot the
server. Why did you conclude to build another cube. It should not be a
problem after a reboot.

For your other problem. The message about the 4NT accounts is not preventing
your cube being build. It means that you have active user accounts in your
project server defined with NT accounts that are not in the AD anymore. They
cannot be added to the cube, because the accounts do not exist.
The reason that your cube is not building is little bit tricky as there is
not enough info in this log. Could you try to process the cube manually from
the SQl management studio and provide us with the error details it gives
there?



:

Had a cube error trying to rebuild it.

It seems like everytime we reboot the server I have to create another cube...

question 1: Why?

so...having gone down this path before, you simply rebuild the cube giving
it a new name.

well....this time it didn't work...

here's my log and I'm stuck...

===== Initiating cube build process =====
[7/25/2008 1:54 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[7/25/2008 1:54 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[7/25/2008 1:54 PM] Cube build initialization started
[7/25/2008 1:54 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[7/25/2008 1:54 PM] Cube build session started
[7/25/2008 1:54 PM] Analysis Services session started
[7/25/2008 1:55 PM] 4 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/25/2008 1:55 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[7/25/2008 1:55 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[7/25/2008 1:55 PM] Process OLAP database session started
[7/25/2008 1:55 PM] Analysis Services session started
[7/25/2008 1:55 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database MSPS_PROD_Cube_072508
on the DBCL02A server. Error: Server: The operation has been cancelled.

===== Process Completed =====
[7/25/2008 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database MSPS_PROD_Cube_072508 on the DBCL02A server. Error: Server:
The operation has been cancelled.

THANK YOU IN ADVANCE!!!! NEED SOME HELP PLEASE!!