I\u2019m a huge fan of CloudShare. You get quick access to great template environments and all the key development tools.<\/p>\n
I recently loaded up MS-Project Server 2013 on SharePoint 2013 with SQL Server 2012, and found the PWA OLAP Cubes failed. Here\u2019s the issues, and how to complete the configuration:<\/p>\n
Queue Service not working<\/strong> If you are patching the server, you\u2019ll find the Config Wizard fails. The admin password is not configured correctly. You can fix it by using this command; have your credentials ready: OLAP Cube failure<\/strong> Performance<\/strong> Patching<\/strong> AppFabric errors; ignored these for now.<\/p>\n MS-Project<\/strong> Excel Services<\/strong> Configuring MS-Project Server 2013 in CloudShare I\u2019m a huge fan of CloudShare. You get quick access to great template environments and all the key development tools. I recently loaded up MS-Project Server 2013 on SharePoint 2013 with SQL Server 2012, and found the PWA OLAP Cubes failed. Here\u2019s the issues, and how to complete the […]<\/p>\n","protected":false},"author":5,"featured_media":1458,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[52,15],"tags":[],"class_list":["post-1456","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-server-and-web-access","category-sharepoint-information-architecture-services"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1456"}],"version-history":[{"count":2,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1456\/revisions"}],"predecessor-version":[{"id":1460,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1456\/revisions\/1460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1458"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Needed to restart the queue service in services.msc including re-entering the credentials<\/p>\n
Set-SPManagedAccount -UseExistingPassword -identity AD2012Administrator<\/p>\n
The OLAP cube failed for quite a list of reasons:
1. OLAP Cube configuration is not configuring to point to the SQL Server Instance
2. SQL Client v10 (2008R2) is not installed. PWA depends on this older version, and it is needed on both Project Server as well as SQL Server.
3. Project Server also requires AMO for SQL Server 2008 R2 (SQLSERVER2008_ASAMO10)
4. The SQL Server SSAS account needs to have access to the Project Server database in order to extract source data to build the cube.<\/p>\n
For performance I have disabled the following service on server, which seems to make it faster, as they do not relate to Project Server:
\u2013 Access Services
\u2013 Access Database Service 2010
\u2013 Machine Translation
\u2013 Foundation incoming email
\u2013 PowerPoint Conversion Service
\u2013 Visio Graphics service
\u2013 Word Automation Service<\/p>\n
This CloudShare template is RTM, so I recommend applying the March 2013 CU, followed by the two MS-Project Server CUs. You will want to run the SharePoint Config Wizard after the March CU, as there\u2019s a DB schema change; same after applying both Dec 2013 CUs.<\/p>\n
Configure default MS-Project client behavior in: C:ProgramDataMicrosoftWindowsStart MenuProgramsMicrosoft Office 2013Office 2013 Tools, Project server accounts.<\/p>\n
Note Excel Services is oddly not enabled, as that\u2019s useful for a range of BI including PowerPivot. If you enable Excel Services, you\u2019ll most likely want to also configure Secure Store, and also configure Excel Services trusted locations for the Excel files, and also trusted data connection libraries.<\/p>\n","protected":false},"excerpt":{"rendered":"