none
olap cube build error RRS feed

  • Question

  • ===== Initiating OLAP database build process =====
    [11/2/2011 5:32 AM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [11/2/2011 5:32 AM] Verifying and running pre-build server event handler
    ===== Determining database and OLAP database structure =====
    [11/2/2011 5:32 AM] Cube build initialization started
    [11/2/2011 5:32 AM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [11/2/2011 5:32 AM] Cube build session started
    ===== Verifying and running post-build server event handler =====
    [11/2/2011 5:32 AM] Verifying and running post-build server event handler
    ===== Processing OLAP database =====
    [11/2/2011 5:32 AM] Process OLAP database session started
    ===== Process Completed =====
    [11/2/2011 5:32 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database Sony_EPM on the USCULSQLDE06 server. Error:
    OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'MSP_EpmResource_OlapView_00007829-4392-48B3-B533-5A5A4797E3C9',
    database 'ProjectServer_Reporting_Dev', schema 'dbo'.; 42000.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Sony_EPM', Name of 'Resource Base Calendar' was being processed.
    Server: The operation has been cancelled.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Sony_EPM', Name of 'Timesheet Period' was being processed.
    Thursday, November 3, 2011 9:11 AM

Answers

  • Hi,

    Was it  working before?

    Check the service account used by analysis server has read access on ProjectServer_Reporting database

     

    Thanks,

    Hrishi

     

    Thursday, November 3, 2011 3:02 PM
    Moderator

All replies

  • Hi,

    Was it  working before?

    Check the service account used by analysis server has read access on ProjectServer_Reporting database

     

    Thanks,

    Hrishi

     

    Thursday, November 3, 2011 3:02 PM
    Moderator
  • Hi,

    Thanks Working fine.

     

    Regards,

    Joliyo

     

    Saturday, November 5, 2011 6:00 PM