locked
Issues with OLAP Build in Project Server 2007 RRS feed

  • Question

  • My cube builds were working fine a week ago (Project server 2007).  Now I am getting the following error

    Now the error was :

    ===== Initiating cube build process =====

    [7/27/2010 6:11 PM] Cube build request message has been added to the Project Server queue

    ===== Verifying and running pre-build server event handler =====

    [7/27/2010 6:11 PM] Verifying and running pre-build server event handler

    ===== Determining database and cube structure =====

    [7/27/2010 6:11 PM] Cube build initialization started

    [7/27/2010 6:11 PM] OLAP database and cube structure was determined successfully

    ===== Building database and cubes =====

    [7/27/2010 6:17 PM] Cube build session started

    [7/27/2010 6:17 PM] Analysis Services session started

    [7/27/2010 6:22 PM] Analysis Services session completed successfully

    ===== Verifying and running post-build server event handler =====

    [7/27/2010 6:22 PM] Verifying and running post-build server event handler

    ===== Processing OLAP database =====

    [7/27/2010 6:22 PM] Process OLAP database session started

    [7/27/2010 6:22 PM] Analysis Services session started

    [7/27/2010 7:33 PM] Analysis Services session failed with the following error: Failed to process the Analysis Services database on the server.

    Error: Internal error: The operation terminated unsuccessfully.

    OLE DB error: OLE DB or ODBC error: Unspecified error.

    Errors in the OLAP storage engine:

    An error occurred while processing the 'Assignment Timephased' partition of the 'Assignment Timephased' measure group for the 'Assignment Timephased' cube from the database.

    Internal error: The operation terminated unsuccessfully.

    Server: The operation has been cancelled.

    So desperate in  solving this .......hope some can help !!

     

    Wednesday, July 28, 2010 9:10 AM

Answers

All replies

  • Wednesday, July 28, 2010 9:27 AM
  • Thanks Ben, for the suggestions... i have increased the 3600 to 36000.

    Cube buid was success when i have used Project Dimension fields. (But it took almost 2 hours to build a cube)

    Now i have added the rest of the dimensions and build the cube. After 3 hours it has throwed an error

    Error Message:

    ===== Initiating cube build process =====
    [7/28/2010 5:24 PM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [7/28/2010 8:21 PM] Verifying and running pre-build server event handler
    ===== Determining database and cube structure =====
    [7/28/2010 8:21 PM] Cube build initialization started
    [7/28/2010 8:21 PM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [7/28/2010 8:27 PM] Cube build session started
    [7/28/2010 8:27 PM] Analysis Services session started
    [7/28/2010 8:27 PM] Analysis Services session failed with the following error: Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site.
    ===== Process Completed =====
    [7/28/2010 8:27 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Cannot overwrite an Olap database created outside of Project Server or by another Project Server Site.


    Wednesday, July 28, 2010 5:36 PM
  • Try this...

    http://proj2007.blogspot.com/2008/07/olap-database-created-outside-of.html 

    I've also seen this before, I think it was when both OLAP cubes from two instances were building at the same time - AS gets confused. 

    Do you have SQL maintenace plans in place?


    Ben Howard [MVP] http://appleparkltd.spaces.live.com/
    Wednesday, July 28, 2010 11:23 PM
  • Thanks Ben!!

    It worked !!

    But it took almost two hours and even opening the OLAP via excel is taking huge time and finally found that i have lost all my total hors of work and the Olap report says total hours is only Xhrs instead of XX,XXXhrs.

     

    Thursday, July 29, 2010 7:17 AM