When: Tuesday, September 25, 2012 at 9:00 AM – Wednesday, September 26, 2012 at 5:00 PM (GMT) Where: 1 Shottery Brook Office Park Timothy’s Bridge Road CV37 9NR Stratford Upon Avon United Kingdom Hosted By: Technology Associates Technology Associates is one of the leading IT solutions companies specialising in Microsoft Project and Enterprise Project Management Solutions. Since 1990, Technology Associates have provided deployment, consultancy, development and training services to more than 500 organisations including some of the world’s leading companies, and we have an international presence in countries in EMEA, USA, and APAC. Technology Associates have deployed hundreds of EPM solutions and deployed more than 2,000 Microsoft Project solutions. The company holds Microsoft Gold Competencies in Project & Portfolio Management, Application Integration and as an ISV, along with eight other silver competencies. With such a stong technical tour-de-force we have built a solid reputation for delivering high quality services and solutions, and providing exceptional value for money. Headquartered in the United Kingdom, with Offices in New York, San Francisco, India and Barcelona, and a strategic partner network covering AsiaPac, Middle East and ROW, we work internationally in delivering IT solutions to our customer base in over 39 countries. Find out more at www.techassoc.com Follow us on Twitter – https://www.twitter.com /TechAssoc Register for this event now at: https://taps2010admin250912-rss.eventbrite.com Event Details: Course Description: This course is designed to cover all the features and aspects of Project Server 2010 Administration. Attendance on the Introductory Project Professional 2010 course is an essential pre-requisite. Attendance on an advanced course with at least two to six weeks as a consolidation period is highly desirable . A ttendees ideally will have some experi ence of SQL Server, IIS, and SharePoint Server . Knowledge of network permissions, active directory and security models would be an advantage. Who Should Attend: Users who have a good knowledge of Microsoft Project 2010 and will be responsible for managing, maintaining and updating the Project 2010 Server database and user information. Course Content: Upon completion of the course, delegates will be able to: Understand EPM 2010 Administration Concepts & Setup · Understand the different areas of the PWA Home page and links from it. · Understand authentication – types and logins. · Understand how to set up e-mail notifications for users and their teams. · Demonstrate how to save Microsoft Project information offline. · Demonstrate how to view, edit, and update projects & tasks · Understand how to reject, create, and delegate task assignments. · Understand how to link documents , issues, risks and documents to tasks. · Describe the Outlook integration. · Show how to view projects in the Project Center & how to create and maintain the views. · Show how to view resources in the Resource Center & how to create the views. · Demonstrate how to view resource and assignment data related to one or more projects. · Understand how to edit enterprise resource information. · Describe how to revi ew an archive of object data. · View and update task changes to a Microsoft Project plan. · View and update calend ar changes. · Set up rules to automatically update projects. · View a historical archive of task updates. · Understand Check In/Check Out of Projects and resources. · Understand Outlook integration. · Understand Categories/Groups/Permissions & Security Templates and how to use these to configure the system. Essential for analyzing the business and how EPM can be adopted. · Understand how d ata is stored in Project Server Databases and in SharePoint. Project 2010 Server Administration · Understand the different Administration options. · Understand the communication and messaging process. · Understand the Task Views, Time Periods, Fiscal Periods and options. · Describe the provisioning process for creating workspaces. · Understand how to view and upload documents for projects and public documents. · Demonstrate searching of documents in the document libraries. · Understand how to create and edit an issue or risk. · Understand how to customize Issue and risk fields and views. · Describe what Microsoft Project Server is and what it is used for. · Demonstrate connecting Microsoft Project to Microsoft Project Server. · Understand the functionality of Microsoft Project Server. · Understand the different user types and the how they interact with Microsoft Project Server and the functionality of each, as well as how to modify permissions. · Understand the responsibilities of a Microsoft Project Server Administrator and adopt best practices. · Discuss the various views available, their purpose and how to customize them. · Understand the integration of SharePoint fr om the Microsoft administration perspective. · Understand the Databases in Project Server and how they interact. · Understand Reporting and Business Intelligence capabilities in EPM 2010. · Understand the Dashboard capability. · Understand customization of the Microsoft Project Web Access Client. · Describe license manag ement within Project Server 2010 · Discuss maintenance of clean data in the Microsoft Project Server database. · Understand how security works within Microsoft Project Server. · Demonstrate the process for setting permissions. · Under stand the process for time track ing and progressing updates. · Understand and edit the Resource Breakdown Structure. · Understand the Administration options in Project Server and how to use them. · Demonstrate and understand the significance of Outline code fields at Project, Task and Resource level. · Understand and apply the Portfolio capabilities and administer the settings in Project Server. · Understand ULS, Messaging logs, and the Queue services in Project Server. · Describe, understand and be able to apply Multi-value fields. · Recognise what the Active Cache is and how it works . · Understand the concept of web parts and SharePoint as a platform for Project Server.
Blog
Hello World, Hello The New Microsoft Project!
Following a week of staged announcements (and in case you missed it), we have disclosed the next version of your beloved project portfolio management (PPM) solution during the past week, a must read: The new Microsoft Project . It’s exciting to finally be able to talk about what we have been working on in Redmond for the past little while. It’s hard to contain my excitement and put in words what I think about this upcoming release! I have worked with Project Server since the 2002 version (shortly after Project Central) and the next Project and in particular Project Online is a LANDMARK release that will change the course of history, it’s a magical moment for all of us… Project Portfolio Management will never be the same. Regardless of your industry, your location, your role or your PPM maturity, this upcoming release (it’s a Preview) brings massive innovation to your day to day PPM activities. Demand management, portfolio analysis, ALM, apps, social, anywhere access on any device, resource management, multi-tenant SaaS, agile to name a few random key innovations… The breath and scale at which we will deliver multi-tenant PPM capabilities into a secure and reliable SaaS (Software as a Service) in unmatched in the industry! The new Project Pro for Office 365 service will change the project management world! I’ll stop talking and will provide you a few key links to help you get started and learn about the Preview. The journey just started last week and expect a lot more content in the coming weeks/months! The Project Online train is leaving the station, please don’t miss it! Sites Videos Project Preview Product Site Project Blog (please note the new URL) Get started with Project Online (please read) Register to Project Ignite training ! (see you in Sydney, Reston or Warsaw) TechNet: Project Server 2013 for IT Pros MSDN: Project For Developers Questions? Check out the Project Forums Get Started with Project Online (Overview) Get Started with Project Online (Demo) What’s new in Project Server 2013 for IT pros (overview) What’s new in Project 2013 for IT Professionals What’s new in Project 2013 for developers (Overview) Project Professional 2013 training for developers Project Server 2013 training for developers
Project Server 2010: Duplicated Outlook tasks after Exchange Sync–June CU
Thought it worth explaining some of the intricacies of the June 2012 Cumulative Update packages, especially for those of you waiting for the fix for the Exchange Sync issue where you see duplicated tasks in Outlook, or are having problems with editing categories in PWA if you have renamed projects in your archive. Maicco e-mailed asking about the Exchange fix – and thanks for bringing this to my attention. These two fixes were delivered in the June Cumulative Update cycle, but were not in the ‘default’ Project Server only package https://support.microsoft.com/kb/2598375 , but had their own hotfix – https://support.microsoft.com/kb/2598376 . Issues that this hotfix package fixes Consider the following scenario: You create a user account in Project Web Access (PWA), and you enable Exchange Synchronization for the user account. You create a new plan that contains many tasks in Project 2010. You assign the user account to all the tasks. You save and then publish the plan in Project Server 2010. You log on to the mailbox of the user account that you created to see whether the task list is synchronized. In this scenario, duplicate tasks are created in the task list in Microsoft Outlook. You cannot edit security categories that contain more than 1000 projects when one or more projects in the security categories are archived and then renamed. Just to add to the confusion this hotfix doesn’t explicitly say that it includes the 2598375 fixes – but it does. The reason for the split is that these two fixes needed some globalization changes – which you can see from the full description (Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp, Pjsrvmui-x-none.msp): June 26, 2012) where MUI is Multilingual User Interface. The file list also lists all of the language files. The complete Project Server 2010 June 2012 Cumulative Update package – https://support.microsoft.com/kb/2598355 – does include everything, and the KB does list both of the KB’s mentioned above. This hopefully clarifies things and explains what the two KBs listed in the full package article are all about. Thanks again Maicco, and in future I’ll keep my eye out for these split CU packages and we will add more details to the notification mail (and I’ll also add an update to the current posting).
Project Connect 2010 Administrator Training – 2nd August, 2012 (£495 + VAT)
When: Thursday, August 2, 2012 from 9:00 AM to 5:00 PM (GMT) Where: 1 Shottery Brook Office Park Timothy’s Bridge Road CV37 9NR Stratford Upon Avon United Kingdom Hosted By: Technology Associates Technology Associates is one of the leading IT solutions companies specialising in Microsoft Project and Enterprise Project Management Solutions. Since 1990, Technology Associates have provided deployment, consultancy, development and training services to more than 500 organisations including some of the world’s leading companies, and we have an international presence in countries in EMEA, USA, and APAC. Technology Associates have deployed hundreds of EPM solutions and deployed more than 2,000 Microsoft Project solutions. The company holds Microsoft Gold Competencies in Project & Portfolio Management, Application Integration and as an ISV, along with eight other silver competencies. With such a stong technical tour-de-force we have built a solid reputation for delivering high quality services and solutions, and providing exceptional value for money. Headquartered in the United Kingdom, with Offices in New York, San Francisco, India and Barcelona, and a strategic partner network covering AsiaPac, Middle East and ROW, we work internationally in delivering IT solutions to our customer base in over 39 countries. Find out more at www.techassoc.com Follow us on Twitter – https://www.twitter.com /TechAssoc Register for this event now at: https://tapcoadmin020812-rss.eventbrite.com Event Details: Course Content: Understand Project Connect 2010 Administration Concepts & Setup · Understand the different areas of the PWA Home page. · Understand how to set up e-mail notifications for users and their teams. · Demonstrate how to save Microsoft Project information offline. · Demonstrate how to view, edit, and update projects & tasks · Understand how to create, and delegate task assignments. · Understand how to create and link documents, issues, risks and documents to tasks. · Show how to view projects in the Project Center & how to create and maintain the views. · Show how to view resources in the Resource Center & how to create the views. · Demonstrate how to view resource and assignment data related to one or more projects. · Understand how to edit enterprise resource information. · View and update task changes to a Microsoft Project plan. · View and update calendar changes. · Understand Check In/Check Out of Projects, resources and documents. · Understand Outlook integration. · Understand User Types and what permissions each has. · Understand how data is stored in Project Server Databases and in SharePoint. Project Connect 2010 Administration · Understand the different Administration options. · Understand the communication and notifications process. · Understand the Task Views, Time Periods, Fiscal Periods and options. · Describe the provisioning process for creating worksites. · Understand how to view and upload documents for projects. · Demonstrate searching of documents in the document libraries. · Understand how to create and edit an issue or risk. · Understand the functionality of Microsoft Project Server (specifically within the Project Connect solution). Describe the differences between Project Connect and the full EPM solution. · Understand the responsibilities of an Administrator and adopt best practices. · Discuss the various views available, their purpose and how to customize them. · Understand the process for time tracking and progressing updates. · Demonstrate and understand the significance of Enterprise Custom Fields and Outline code fields at Project, Task and Resource level. · Understand the Messaging and the Queue services in Project Server. · Describe, understand and be able to apply Multi-value fields. · Recognise what the Active Cache is and how it works.
Project Server 2010: From August 2012 Cumulative Update onwards–you will also need to load SP1
If you haven’t already of course… Some early warning here to allow you to plan for any August 2012 or post August 2012 Cumulative Updates. For SharePoint Server 2010, and Project Server 2010 and the rest of the Office 2010 family you will need to have loaded Service Pack 1 (SP1) before you can install the Cumulative Update. This means really loading SP1 – not just relying on the fact that ‘almost all’ of SP1 has been included in patches since June 2011. If you remember we went through a similar stage with 2007 – and one of the most notable things is that the patch will shrink down to a much smaller size (The June 2012 roll-up patch was over 1.2GB!). I haven’t had a chance to try it out – but I suspect the error message if you haven’t loaded SP1 will be something along the lines of “There are no products affected by this package installed on this system” or “ The expected version of the product was not found on the system” – I’ll update once I get a chance to test. The reason behind this change is to do with our product support lifecycle (see Microsoft Support Lifecycle ) and the fact that we have reached what we term the end-of-life (or service pack support end date) for the original release of the 2010 Office family – which is around one year after release of Service Pack 1. For most customers you could see this first with the August 2012 Cumulative update – which will be something like build 14.0.6124.5000 – or potentially before if there are any special releases before that release (and after the June CU) – which would be something like 14.0.6123.5003. Other customers who do not necessarily load all cumulative updates may run into this much later, as it will be the ongoing requirement for future Cumulative Updates until the next service pack support end date – approximately one year after SP2 (and no – I do not know when SP2 will be coming along – before you ask!). Excellent references for Service Pack 1 can be found at the new-look Project blog – Announcing Service Pack 1 for Microsoft Project & Project Server 2010 , for the initial announcement, Announcing The Release Of Service Pack 1 (SP1) for Microsoft Project and Project Server 2010 for the release notification and particularly the TechNet article at https://technet.microsoft.com/en-us/library/hh272536.aspx – Deploy Service Pack 1 for Project Server 2010. And finally – to find out if you already have SP1 installed I’d suggest going to Control Panel, Programs, Programs and Features, Installed Updates – and you should see it listed there – Microsoft SharePoint and Project Server 2010 Service Pack 1 (SP1) https://support.microsoft.com/kb/2460047 .
The New Project Blog
The Project blog has moved! If you’d like to stay informed on the latest Microsoft Project news and announcements, head over to the new Project blog . We also have a new RSS feed so you can stay up-to-date. You’ll still be able to access previous posts here, but as of today, no new posts will appear. Special thanks to all our readers for tuning in and hope hear from you on our new blog at https://blogs.office.com/b/project/ .
Project Connect 2010 Administrator Training – 26th July 2012 (£495 + VAT)
When: Thursday, July 26, 2012 from 9:00 AM to 5:00 PM (GMT) Where: 1 Shottery Brook Office Park Timothy’s Bridge Road CV37 9NR Stratford Upon Avon United Kingdom Hosted By: Technology Associates Technology Associates is one of the leading IT solutions companies specialising in Microsoft Project and Enterprise Project Management Solutions. Since 1990, Technology Associates have provided deployment, consultancy, development and training services to more than 500 organisations including some of the world’s leading companies, and we have an international presence in countries in EMEA, USA, and APAC. Technology Associates have deployed hundreds of EPM solutions and deployed more than 2,000 Microsoft Project solutions. The company holds Microsoft Gold Competencies in Project & Portfolio Management, Application Integration and as an ISV, along with eight other silver competencies. With such a stong technical tour-de-force we have built a solid reputation for delivering high quality services and solutions, and providing exceptional value for money. Headquartered in the United Kingdom, with Offices in New York, San Francisco, India and Barcelona, and a strategic partner network covering AsiaPac, Middle East and ROW, we work internationally in delivering IT solutions to our customer base in over 39 countries. Find out more at www.techassoc.com Follow us on Twitter – https://www.twitter.com /TechAssoc Register for this event now at: https://tapcoadmin260712-rss.eventbrite.com Event Details: Course Content: Understand Project Connect 2010 Administration Concepts & Setup · Understand the different areas of the PWA Home page. · Understand how to set up e-mail notifications for users and their teams. · Demonstrate how to save Microsoft Project information offline. · Demonstrate how to view, edit, and update projects & tasks · Understand how to create, and delegate task assignments. · Understand how to create and link documents, issues, risks and documents to tasks. · Show how to view projects in the Project Center & how to create and maintain the views. · Show how to view resources in the Resource Center & how to create the views. · Demonstrate how to view resource and assignment data related to one or more projects. · Understand how to edit enterprise resource information. · View and update task changes to a Microsoft Project plan. · View and update calendar changes. · Understand Check In/Check Out of Projects, resources and documents. · Understand Outlook integration. · Understand User Types and what permissions each has. · Understand how data is stored in Project Server Databases and in SharePoint. Project Connect 2010 Administration · Understand the different Administration options. · Understand the communication and notifications process. · Understand the Task Views, Time Periods, Fiscal Periods and options. · Describe the provisioning process for creating worksites. · Understand how to view and upload documents for projects. · Demonstrate searching of documents in the document libraries. · Understand how to create and edit an issue or risk. · Understand the functionality of Microsoft Project Server (specifically within the Project Connect solution). Describe the differences between Project Connect and the full EPM solution. · Understand the responsibilities of an Administrator and adopt best practices. · Discuss the various views available, their purpose and how to customize them. · Understand the process for time tracking and progressing updates. · Demonstrate and understand the significance of Enterprise Custom Fields and Outline code fields at Project, Task and Resource level. · Understand the Messaging and the Queue services in Project Server. · Describe, understand and be able to apply Multi-value fields. · Recognise what the Active Cache is and how it works.
A New SQL Server–and some different cube building errors
At SP1 Project Server 2010 and SharePoint introduced support for SQL Server 2012. I had a question posted on some issues a customer had hit – so I thought I’d set my server up for building an OLAP cube against SQL Server 2012 – just to see if I could. I already knew I’d need to set up a few things – but as I wanted to see errors I just went for it – and started with a PWA instance that built successfully against my SQL Server 2008 R2 Analysis Services machine. My Project Server databases were also in this SQL Server 2008 R2 server – so that would add some other interesting things to consider. I should also point out that my SQL Server 2012 was sitting on a Windows Server 2012 RC machine – so not a supported scenario currently – but I like to live on the edge (I know – I should get a life instead…) Just to recap what goes on when we request to build a cube, which will help you understand where the errors might be coming from – and there may well be other errors you could see if things are configured differently to my scenario. A Cube Build request goes on the Project Server queue The details of the requested configuration are picked up – and the application server contacts the Analysis Services server (firewall permitting) with the cube details. Also the account running the queue service will need the right permissions to do this – needs to be added as server administrator on Analysis Server Once the Analysis Services server has the cube details then it will know where to get the data from (Reporting DB) so makes a connection. A couple of points here – if you are using an alias for the database server from your Project Server farm then this is the server name passed to AS – so it will also need to know what the alias refers to. This is true even if the AS machine is also the DB Server. And the account running Analysis Services needs data reader access to the reporting DB. So I’ve done none of that preliminary setup, so I’m expecting some errors. The first however, was unexpected: Error 1. [7/3/2012 7:00 AM] Failed to build the OLAP cubes. Error: Failed to connect to the Analysis Services server . Error: Deserialization failed: Requested value ‘EnterpriseCore64’ was not found. This was reported by the cube build – I’ll add the ULS and Event Log errors at the foot of the posting for the search engines to digest – and talking of search engines a quick Bing gave me the answer to this first issue – SQL Server 2012 Cumulative Update 1, which contains the fix described here – https://support.microsoft.com/kb/2683293 – Error message when you use AMO to connect to SQL Server 2012 Analysis Services: “Deserialization failed: Requested value ‘ ‘ was not found”. The ServerEdition could be one of EnterpriseCore64 (as mine was) EnterpriseCore BusinessIntelligence64 BusinessIntelligence The Cumulative Update itself can be found at https://support.microsoft.com/kb/2679368 – Cumulative update package 1 for SQL Server 2012. Installed the CU and moved on… Error 2. [7/3/2012 7:50 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database Test2012 on the server. Error: Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Resource Type’, Name of ‘Resource Type’ was being processed. Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Timesheet Status’, Name of ‘Timesheet Status’ was being processed. Server: The current operation was cancelled because another operation in the transaction failed. Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Timesheet Period Status’, Name of ‘Timesheet Period Status’ was being processed. This is very similar to an error you would see even before 2012, and refers to the Native Client for SQL Server SQNCLI10 – not being registered. This is where we need to be very specific – and the version of the native client is related to our client application code that is requesting the build than either the Analysis Services or the SQL Server version. Regardless of if you are running 2005 or 2008 or 2012 (or anywhere in between) you will need to have the 2008 Native Client installed from here – https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=8824 – Microsoft SQL Server 2008 Feature Pack, October 2008 – and specifically the sqlncli.msi which is about half way down the page – and the direct link to the X64 package is here . Also note that this is referring to the build FROM the Analysis Services server – and it is complaining about the Native Client being missing from there – which it needs to connect to my database server (which happens to be 2008 R2 – but that is irrelevant). If you look on the AS server you will see that the structure of the cube has been created – so we successfully connected to the server, but it could go off to the database server to get the data. In a fresh install against SQL Server 2012 you would also need to add the Native Client to the application server – but as it is one of the SharePoint pre-reqs this is normally taken care of. To confirm the native client requirement you can also look at the Connection string already created on the AS Server as part of the Project Reporting data source – Provider= SQLNCLI10 ;Data Source= ;Initial Catalog=ProjectServer_Reporting;Integrated Security=SSPI;Persist Security Info=False. I have seen some workarounds described suggesting changing the Provider here – and that would work if you were to rebuild from AS it would get over-written at the next build. Added the Native Client to my Analysis Services 2012 machine and continued… Error 3 [7/3/2012 8:33 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database Test2012 on the server. Error: Internal error: The operation terminated unsuccessfully. Server: The current operation was cancelled because another operation in the transaction failed. OLE DB error: OLE DB or ODBC error: Login failed for user ‘DOMAIN $’.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Task List’, Name of ‘Task List’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘Start Date’ attribute of the ‘Task List’ dimension from the ‘BriSmith2012’ database was being processed…. This error was longer – just repeated for different attributes of the dimension. The key to this is the Login Failed – and in this case it refers to a machine name (the $ on the end) as my Analysis Services is running as NT ServiceMSSQLServerOLAPService So the connection is via the machine name. Added the DOMAIN $ as a Login on the Databse Server with db_datareader role membership to my ProjectServer_Reporting database and continued. If your Analysis Services is runni
ng under some other credentials then you may need to enter these rather than a machine name. [7/3/2012 9:03 AM] Cube build request completed successfully. In my installation I didn’t hit any permissions issues regarding the AS administrator, or any firewall issues – just because my server and domain setup was already taking care of these potential problems – your mileage may vary. Overall, apart from the 1st error these are very similar, if not identical, to problems you could run into with any version of SQL Server – but hopefully a worthwhile reminder of the cube building process and the components and permissions it relies on. Only Bing and any other search engine needs to read on from here… Logs. Error 1 ULS Logs – a string of errors here – the first few were Medium, then a couple of criticals – I’ve just posted a couple – these should contain anything worth finding on a search.: 07/03/2012 07:00:21.46 Microsoft.Office.Project.Server (0x27B4) 0x2834 Project Server Analysis Cube Building myne Medium PWA: /PWA”> https:// /PWA , ServiceApp:Project Server Service Application, User:DOMAINUser, PSI: Error generating Project Server cubes. Error: ‘Failed to connect to the Analysis Services server . Error: Deserialization failed: Requested value ‘EnterpriseCore64′ was not found.’ 4c420a8a-c27c-47b8-88c9-46baaf8ab1ec 07/03/2012 07:00:21.47 Microsoft.Office.Project.Server (0x27B4) 0x2834 Project Server Analysis Cube Building 8swo Medium PWA: /PWA”> https:// /PWA , ServiceApp:Project Server Service Application, User:DOMAINUser, PSI: [CBS] Status message: ProjectServer BuildOlapCubes failed with exception: Microsoft.Office.Project.PI.CBSCommon.CBSProcessException: Failed to connect to the Analysis Services server brismith12-15. Error: Deserialization failed: Requested value ‘EnterpriseCore64’ was not found. —> Microsoft.AnalysisServices.XmlSerializationException: Deserialization failed: Requested value ‘EnterpriseCore64’ was not found. —> System.ArgumentException: Requested value ‘EnterpriseCore64’ was not found. at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) at Microsoft.AnalysisServices.DesignXmlReader.ReadPrimitive(Type type, XmlAttributes attributes) … 07/03/2012 07:00:21.47 Microsoft.Office.Project.Server (0x27B4) 0x2834 Project Server Analysis Cube Building 8icz Critical Standard Information:PSI Entry Point: Project User: DOMAIINUser Correlation Id: 4c420a8a-c27c-47b8-88c9-46baaf8ab1ec PWA Site URL: /PWA”> https:// /PWA SSP Name: Project Server Service Application PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=19d8edf4-019c-437a-a435-2fd160b71592 ASServerName= ASDBName=Test2012 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=07/02/2012 06:55:08 ToDate=07/02/2012 06:55:08 HighPriority=True 4c420a8a-c27c-47b8-88c9-46baaf8ab1ec The Application Event Log just shows a pretty generic Cube Building failure message. Source: Microsoft-SharePoint Products-Project Server Date: 7/3/2012 7:00:21 AM Event ID: 7682 Task Category: Analysis Cube Building Level: Error PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=19d8edf4-019c-437a-a435-2fd160b71592 ASServerName= ASDBName=Test2012 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=07/02/2012 06:55:08 ToDate=07/02/2012 06:55:08 HighPriority=True Event Xml: Error 2 ULS logs – plenty of errors here, mostly saying the same thing – so I’ll just post the critical one: 07/03/2012 07:49:52.90 Microsoft.Office.Project.Server (0x27B4) 0x12A4 Project Server Analysis Cube Building 8icz Critical Standard Information:PSI Entry Point: Project User: DOMAINUser Correlation Id: 5984d4c1-558e-4bb2-9373-68053f894a7d PWA Site URL: /PWA”> https:// /PWA SSP Name: Project Server Service Application PSError: CBSOlapProcessingFailure (17004) Cube build failed during an OLAP Processing operation. CBS queued message: Setting UID=19d8edf4-019c-437a-a435-2fd160b71592 ASServerName= ASDBName=Test2012 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=07/02/2012 06:55:08 ToDate=07/02/2012 06:55:08 HighPriority=True. Error: Failed to process the Analysis Services database BriSmith2012 on the brismith12-15 server. Error: Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Resource Type’, Name of ‘Resource Type’ was being processed. Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Timesheet Status’, Name of ‘Timesheet Status’ was being processed. Server: The current operation was cancelled because another operation in the transaction failed. Errors in the back-end database access module. The provider ‘SQLNCLI10’ is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Timesheet Period Status’, Name of ‘Timesheet Period Status’ was being processed. 5984d4c1-558e-4bb2-9373-68053f894a7d The Event Log entry was very similar – Source: Project Server Event ID was 7691 and Task Category Analysis Cube Building, followed by a generic Queue failure Event ID 7704. Error 3 Here is the critical one from the ULS logs: 07/03/2012 08:32:44.12 Microsoft.Office.Project.Server (0x27B4) 0x2CF4 Project Server Analysis Cube Building 8icz Critical Standard Information:PSI Entry Point: Project User: DOMAINUser Correlation Id: fdf04238-ff5a-4153-baca-723f634011cd PWA Site URL: /brismith8100/PWA”> https:// /PWA SSP Name: Project Server Service Application PSError: CBSOlapProcessingFailure (17004) Cube build failed during an OLAP Processing operation. CBS queued message: Setting UID=19d8edf4-019c-437a-a435-2fd160b71592 ASServerName= ASDBName=Test2012 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=07/02/2012 06:55:08 ToDate=07/02/2012 06:55:08 HighPriority=True. Error: Failed to process the Analysis Services database Test2012 on the server. Error: Internal error: The operation terminated unsuccessfully. Server: The current operation was cancelled because another operation in the transaction failed. OLE DB error: OLE DB or ODBC error: Login failed for user DOMAINSMachineName$’.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Project Reporting data source’, Name of ‘Project Reporting data source’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Task List’, Name of ‘Task List’ was being processed. …. Event log same as before the – Source: Project Server Event ID was 7691 and Task Category Analysis Cube Building, followed by a g
eneric Queue failure Event ID 7704.
Project and Project Server June 2012 Cumulative Update
The June CU is out for Project and Project Server – and we have the full details posted at https://blogs.technet.com/b/projectadministration/archive/2012/06/29/microsoft-project-server-and-sharepoint-server-2007-and-2010-june-2012-cu-announcement.aspx . Thanks Rob for the information. A couple of quick points worth mentioning: We have a delay on the roll-up package for 2010 – so if you usually use the roll-up and need to test Project Server fixes you can do this with the individual package until we get the rebuild – hopefully later this week. On the 2007 side the June CU for Project Server does include the fix for the Reporting Publish issue I wrote about at https://blogs.msdn.com/b/brismith/archive/2012/05/23/project-server-2007-reporting-project-publish-queue-job-fails-to-complete.aspx – so if you have been suffering with that one your wait is over. Sorry for the inconvenience that I know this issue caused many of our customers. Final point – and a frequently asked question – what is the difference between a hotfix and a cumulative update? In reality nothing – for Office and SharePoint the Cumulative Update is really just a hotfix released on a defined timetable – every other month, around the last Tuesday of the month. The KB article will always describe it as a hotfix – and it generally does not mention the term Cumulative Update. The TechNet Update Center is a great place to go for all information on the updates – https://technet.microsoft.com/en-us/office/ee748587.aspx . There is an RSS feed too!
Celebrate the top Project Partners!
The 2012 Microsoft Partner of the Year Award Winners were announced for all categories across Microsoft Partner competencies, products and regions by Jon Roskill, Corporate Vice President, Worldwide Partner Group, Microsoft. In our category – we recognize the best of the best Microsoft Project partners and award them the prestigious “ Project and Portfolio Management Partner of the Year ” award! This year – we have seen great case studies and stunning solutions that Microsoft Project partners have built – and all this underscores the great success and power of Project 2010! Please join us to celebrate the success of Project and Portfolio Management Partner (PPM) community and congratulate the winner and finalists! Project and Portfolio Management Partner of the Year 2012 – SharkPro Software ! SharkPro Software built a unique solution that reduces the time, cost, and complexity of project and portfolio management deployment – yet by building on top of the Project Server 2010 – customers can seamlessly grow in their Project and Portfolio Management maturity. SharkPro Projects offers flexibility to be easily accommodated to customer business needs and includes on-premise and hosted deployment options. The scale of SharkPro Software extends through PPM Partner community and it’s becoming a world-wide solution for Microsoft Project 2010. Shark Pro’s offering integrates with other Microsoft products – like Dynamics and SharePoint – and thus offering customers a complete platform experience. Three award finalists BrightWork allows organizations to instantly deploy an initial affordable amount of work, project and portfolio management on SharePoint. This delivers immediate visibility and control and then over time organizations can evolve and mature by adding more templates and dashboards as needed and as ready. This best practices template approach pioneered by BrightWork allows organizations to start small and to grow and mature as ready and as needed. BrightWork uniquely supports the management of the mix of projects (in Microsoft Excel, Microsoft Project, Microsoft SharePoint and Microsoft Project Server), by aggregating the projects to one central set of dashboards in a SharePoint Portal. Prosperi has been focusing on Microsoft Project Server and SharePoint solutions and Consulting since 2002. It has an impressive customer list that includes some of Brazil’s most prestigious enterprises and provides tailored solutions to companies in a range of different industries. EPMFAST : Project Server configured with project management methodology, carefully crafted to meet the requirements of diverse organizations. EPMFAST Mobile : Project Server dashboard for smartphones. METROwebpart : METRO style menu for SharePoint sites. UMT has consistently delivered innovative services and products that have helped transform the PPM industry. UMT has gained unparalleled understanding of customer needs by forming enduring relationships with Global 1000 organizations across a variety of industries. In June 2012, UMT announced the availability of the latest version of their financial management solution for Project Server 2010. UMT Project Essentials 2012 is arguably UMT’s most ambitious release to date providing powerful new capabilities including multi-currency support, financial snapshots, change request management and workflow design that seamlessly extend Project Server 2010. UMT Project Essentials is already being used by Project customers and partners around the world to gain visibility and control across project and portfolio financials. To learn more about this solution visit www.umtprojectessentials.com Honorable mentions solutions Number of solutions clearly stood out – some of them are listed below – featuring the Earned Value Management, Mobile Applications, Portfolio Management, Resource Management, Innovation Process Management and Line of the Business Integration. For more please refer to Microsoft Project 2010 Solution Spotlight . Honorable mentions case studies We have hand-picked 3 case studies in government and manufacturing built by the following partners. Click on the logo to learn more. For more Microsoft Project case-studies, please refer to Microsoft Project 2010 Customer Success . Jan Kalis https://blogs.msdn.com/jkalis/ , Twitter @MeetJKalis Product Marketing Manager | Microsoft Project/Visio Microsoft Corporation