Answered by:
Failed to build the OLAP cubes (Project Server 2013)

Question
-
We are receiving errors when attempting to build our OLAP cubes. We've attempted to install the 2008 version of the SQL server native client 2008 but still the error appears. Please advise.
Configuration:
- Project Server 2013
- SharePoint 2012
- SQL Server 2012
Error Message:
===== Initiating OLAP database build process =====
[1/7/2014 2:00 AM] Cube build request message has been added to the Project Server queue ===== Verifying and running pre-build server event handler =====
[1/7/2014 2:00 AM] Verifying and running pre-build server event handler ===== Determining database and OLAP database structure =====
[1/7/2014 2:00 AM] Cube build initialization started ===== Building database and cubes =====
[1/7/2014 2:00 AM] Cube build session started ===== Verifying and running post-build server event handler =====
[1/7/2014 2:00 AM] Verifying and running post-build server event handler ===== Processing OLAP database =====
[1/7/2014 2:00 AM] Process OLAP database session started ===== Process Completed =====
[1/7/2014 2:00 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database OLAP_FTF on the XYZ 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 'Project List', Name of 'Project List' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Start Date' attribute of the 'Project List' dimension from the 'OLAP_FTF' database was being processed.
Internal error: The operation terminated unsuccessfully.
Server: The current operation was cancelled because another operation in the transaction failed.
Tuesday, January 7, 2014 4:12 PM
Answers
-
Hello, I had the same problem, solved by installing the SQL Server Native Client 2008 (http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409) in the SQL Server 2012. After this, the cube OLAP was build successfully.
André Barroncas
- Proposed as answer by André.Barroncas Tuesday, February 11, 2014 1:29 PM
- Marked as answer by Michael WhartonMVP Saturday, May 2, 2015 11:10 AM
Tuesday, February 11, 2014 1:29 PM
All replies
-
Hi Importek,
Please have a look to a similar threads that has been answered.
http://social.technet.microsoft.com/Forums/projectserver/en-US/420958bd-4613-451c-ac06-a1f149f64da9/problem-when-trying-to-build-the-cube?forum=projectserver2010general
Finally an article by Brian Smith:
This might be an issue of the SQL instance alias.
Guillaume Rouyre - MBA, MCP, MCTS
- Edited by Guillaume Rouyre [MBA, MVP, MCC]MVP Tuesday, January 7, 2014 4:31 PM
Tuesday, January 7, 2014 4:29 PM -
Thank Guillaume.
I've actually reviewed several of the blogs from Brian Smith. However, the team is apprehensive with implementing workaround which would require installing SQL Native Client 2008 on our Analysis Server running 2012 which is a shared environment.
Do you know if there are other workarounds or any certified solutions from Microsoft regarding this issue?
Tuesday, January 7, 2014 5:49 PM -
You're welcome.
I'm afraid that my Project Server skills don't go to this architecture technical level so I'll let other experts on the forum help you. But have you ensured that the alias is correct between SQL server and the Analysis service machine?
Guillaume Rouyre - MBA, MCP, MCTS
Tuesday, January 7, 2014 6:00 PM -
Yes, I've used XYZ as a placeholder for the actual server name.Tuesday, January 7, 2014 6:05 PM
-
Hello Importek
You can keep the SQL Native Client 2012 on SQL Server 2012.
The SQL Native Client 2008 R2 needs to be on the front-end and middle tiers for project server.
Cheers!
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesTuesday, January 7, 2014 9:29 PM -
Thanks Michael.
That is what we prefer to do, since our understanding is that native client 2012 is backwards compatible (apparently). We've tried only using the 2008 native client on the app and web front-end tiers but still run into this issue.
Tuesday, January 7, 2014 10:38 PM -
Have you reboot servers after installation of native client on project server.
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesTuesday, January 7, 2014 11:38 PM -
You indeed do have to install SQL Native Client 2008 on your Analysis Server.
the error is telling you that the Analysis Server cannot contact the SQL Server over the desired protocol.
"The provider 'SQLNCLI10' is not registered" means that SSAS cannot talk to SQL using the version 10 library calls.
simply install this component (do not uninstall any others as noted by Michael). it will correct the problem.
there is no issue with this being a shared resource. other systems that wish to communicate with the 11 version library calls will find the SQL 2012 components also installed and work fine.
this overall is due to Project Server 2013 still utilizing the 2008 R2 calls in the OLAP build process.
It is a necessary step in all my deployments which use SQL 2012. Clearly, a SQL 2008 R2 install will already have this component.
this component is not required on any other servers. (only the AS server, so it can communicate with the SQL server, even if they are on the same computer).
Hope this helps,
Thanks, Eric S. Pcubed
- Proposed as answer by Ahmed Madany Thursday, March 31, 2016 9:44 AM
Wednesday, January 8, 2014 2:09 AM -
Hi Importek,
I have recently experienced this issue and as Brian Smith has already explained the reason on his blog
Project Server 2013 still needs 2008 Native client to connect to Project database, similar as we needed earlier version of native client with OLAP via 2010. Only solution is to install SQL 2008 R2 native client on Analysys server. unfortunately no workaround
Hrishi Deshpande Senior Consultant
- Edited by Hrishi.Deshpande Wednesday, January 8, 2014 2:50 AM correction
Wednesday, January 8, 2014 2:49 AM -
My bad. I answered question to quickly. I looked at my SQL 2012 Server in my lab and saw 2012 Native Client installed and stop looking. I went back after reading ErockP3 answer and looked back my SQL server. I see 2008 R2 Native Client is also installed. Apparently you can install both on both on same server. Strange but true.
Cheers!
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesWednesday, January 8, 2014 2:53 AM -
Yes, we bounced the servers once we installed. No luck.Wednesday, January 8, 2014 10:45 PM
-
Did you install 2008 R2 native client on every server running with Project Application service in addition to SQL and Analysis server.
Once installed restart Project Application service before initiating OLAP cube build.
Hrishi Deshpande Senior Consultant
Wednesday, January 8, 2014 10:48 PM -
Thanks Hrishi, we've read this "workaround" as well. It just seems like a band-aid solution. We will attempt this in our DEV/FTE environment and conduct some compatibility testing. I'm really surprised that MS hasn't issued a fix for this yet...Wednesday, January 8, 2014 10:50 PM
-
I don't think this is an workaround. At the time of Project server 2013 release , SQL server 2012 was not released. At that time current version was SQL server 2008 R2, Support for SQL 2012 was added later.
Hence to me it makes perfect sense that though Project can work with SQL 2012 still some components requires 2008 R2 components, which is lot eaiser than re-writing the entire code.
Hrishi Deshpande Senior Consultant
Thursday, January 9, 2014 12:48 AM -
It is documented that Project Server 2013 is supported by SQL Server 2012 (64-bit) and SQL Server 2008 R2 with Service Pact 1 (SP1) (64-bit).
MS should have denoted that it was partially supported by using 2008 R2 components.
Thursday, January 9, 2014 7:00 PM -
Tried deleting the OLAP cube if it exists and put sure that the proper accounts are setup in the AD groups on the analysis server. Try rebuilding
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesSunday, January 12, 2014 12:01 AM -
Hello, I had the same problem, solved by installing the SQL Server Native Client 2008 (http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409) in the SQL Server 2012. After this, the cube OLAP was build successfully.
André Barroncas
- Proposed as answer by André.Barroncas Tuesday, February 11, 2014 1:29 PM
- Marked as answer by Michael WhartonMVP Saturday, May 2, 2015 11:10 AM
Tuesday, February 11, 2014 1:29 PM -
I agree that the fix is to download and install the SQL Server Native Client 2008 or SQL server Native Client 2008 R2 on the SQL Server.
Cheers!
But then I wonder if that breaks other apps. Talk with SQL DBA.
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesSaturday, May 2, 2015 11:13 AM -
Thanks for the answer, it is working nowThursday, August 20, 2015 1:47 PM