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

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

    [7/27/2010 1: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 1:11 PM] Verifying and running pre-build server event handler

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

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

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

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

    [7/27/2010 1:16 PM] Cube build session started

    [7/27/2010 1:16 PM] Analysis Services session started

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

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

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

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

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

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

    [7/27/2010 1:45 PM] Analysis Services session failed with the following error: Failed to process the Analysis Services database on the XXXXXXXX server. Error: Internal error: The operation terminated unsuccessfully.

    Internal error: The operation terminated unsuccessfully.

    OLE DB error: OLE DB or ODBC error: The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases; 42000; The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases; 42000.

    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.

    Server: The operation has been cancelled.

    I have tried all the tips in diff questions, but still.........no light...........

    • Edited by P Daniel Tuesday, July 27, 2010 5:35 PM
    Tuesday, July 27, 2010 1:55 PM

Answers

  • Hello Daniel,

    This forum is for System Center Essentials related issues. For this question is only related with Project Server, please use the following Microsoft public newsgroup, which would be the best resource for your question.

    Project Server General Questions and Answers
    http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/threads

    Thanks,


    Yog Li -- Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Yog Li Tuesday, August 3, 2010 10:06 AM
    Wednesday, July 28, 2010 9:45 AM

All replies

  • As i browsed through the error and found that The transaction log for database 'tempdb' is full: i have changed the path of the tempdb to  an another harddrive and build the cube once again

    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 !!

    Tuesday, July 27, 2010 5:32 PM
  • Hello Daniel,

    This forum is for System Center Essentials related issues. For this question is only related with Project Server, please use the following Microsoft public newsgroup, which would be the best resource for your question.

    Project Server General Questions and Answers
    http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/threads

    Thanks,


    Yog Li -- Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Yog Li Tuesday, August 3, 2010 10:06 AM
    Wednesday, July 28, 2010 9:45 AM