none
Falied "Configure OLAP cubes for Project Web App" in Project Server 2013 RRS feed

  • Question


  • Hi

    I'm trying to use the PS2013's capability for generate SSAS Cubes; but after I execute the steps described on Configure OLAP cubes for Project Web App (http://technet.microsoft.com/en-us/library/jj943761.asp)”  the only thing achieved is that the state being "Processing…" and the log:

    ===== Initiating OLAP database build process =====

    [10/11/2013 2:48 PM] Cube build request message has been added to the Project Server queue

    ------


    When I check the jobs, the one who is associated with the cube creation is on "Succeeded" state but the OLAP database is never created. There is no evidence I think on the Sharepoint log. For notice:


    10/11/2013 14:36:24.41 w3wp.exe (0x1A70)                       0x1848  Project Server                   Analysis Cube Building                        8ida        Information        Standard Information:PSI Entry Point:   Project User: PROJECTSERVER\system  Correlation Id: 0cea4e03-a432-e311-9401-001cc094718e  PWA Site URL: http://<server-name>/sites/Walkthroughs  SA Name: Project Server Service Application  PSError: NoError (0) Cube build request was placed on the Project Server Queue.  afaf4b9c-57d6-7004-2661-c95edeacab11

    10/11/2013 14:36:24.43 w3wp.exe (0x1A70)                       0x1848  Project Server                   Analysis Cube Building                        8swo     Medium               PWA:http://<server-name>/sites/Walkthroughs, ServiceApp:Project Server Service Application, User:PROJECTSERVER\system, PSI: [CBS] Status message: Cube build request message has been added to the Project Server queue, LogLevelManager Warning-ulsID:0x3873776F has no entities explicitly specified.                afaf4b9c-57d6-7004-2661-c95edeacab11


    Wednesday, October 16, 2013 3:29 PM

Answers

  • Seems like an error occurred during site collection provisioning with the project server features. The provisioning process was interrupted from a system error and doesn't recovered after system restart.

    I just created and provisioned a new site collection and everything is working now.

    ===== Initiating OLAP database build process =====

    [10/16/2013 5:57 PM] Cube build request message has been added to the Project Server queue

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

    [10/16/2013 5:57 PM] Verifying and running pre-build server event handler

    ===== Determining database and OLAP database structure =====

    [10/16/2013 5:57 PM] Cube build initialization started

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

    [10/16/2013 5:57 PM] Cube build session started

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

    [10/16/2013 5:58 PM] Verifying and running post-build server event handler

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

    [10/16/2013 5:58 PM] Process OLAP database session started

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

    [10/16/2013 5:59 PM] Verifying and running post-process server event handler

    ===== Process Completed =====

    [10/16/2013 5:59 PM] Cube build request completed successfully.

    • Marked as answer by nilsandrey Friday, October 18, 2013 2:02 PM
    Friday, October 18, 2013 1:07 PM

All replies

  • It takes time to complete the cube build job, click on the "Processing" link you will see more details  and if you click on Refresh status job you will see current cube build activity.


    Hrishi Deshpande Senior Consultant

    Wednesday, October 16, 2013 3:41 PM
    Moderator
  • I have the same symptom with the only one log and the "Processing" state entry in several days.

    I followed this to deploy and provision a PWA in a existing site collection. I also followed the "Configure OLAP cubes for Project Web App" guidance. When I build the cube nothing happens.

    Wednesday, October 16, 2013 4:13 PM
  • Hi Hrishi... sorry but still confirm the same situation, also like Igr.
    • Edited by nilsandrey Wednesday, October 16, 2013 6:13 PM bad use of a word
    Wednesday, October 16, 2013 5:58 PM
  • Seems like an error occurred during site collection provisioning with the project server features. The provisioning process was interrupted from a system error and doesn't recovered after system restart.

    I just created and provisioned a new site collection and everything is working now.

    ===== Initiating OLAP database build process =====

    [10/16/2013 5:57 PM] Cube build request message has been added to the Project Server queue

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

    [10/16/2013 5:57 PM] Verifying and running pre-build server event handler

    ===== Determining database and OLAP database structure =====

    [10/16/2013 5:57 PM] Cube build initialization started

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

    [10/16/2013 5:57 PM] Cube build session started

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

    [10/16/2013 5:58 PM] Verifying and running post-build server event handler

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

    [10/16/2013 5:58 PM] Process OLAP database session started

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

    [10/16/2013 5:59 PM] Verifying and running post-process server event handler

    ===== Process Completed =====

    [10/16/2013 5:59 PM] Cube build request completed successfully.

    • Marked as answer by nilsandrey Friday, October 18, 2013 2:02 PM
    Friday, October 18, 2013 1:07 PM
  • Just came across this post as I was getting the same error (it was stuck there overnight).

    ===== Initiating OLAP database build process =====

    [10/11/2013 2:48 PM] Cube build request message has been added to the Project Server queue

    ------

    I didn't want to recreate the site just yet, so I put that part on hold. Then, I realized the time was not in sync while applying updates. So, for me it was either 1) time sync issue or 2) the server just needed to be rebooted.

    Hope this helps somebody.

    Monday, February 3, 2014 7:52 PM