PerformancePoint services error code 10115

Question

PerformancePoint services error code 10115

sco gordo 301

Hi all,
I'm not getting any of the dbs on the datasource server. Checked Events on WFE, "The data source provider of type "ADOMD.NET' is not registered." It's listing the User as the account running the service, not the unattended account I've set up.
I'm running SP16, with a WFE, APP, and SQL server. SQL is 2016.
Just making sure as most of what I'm finding online is for SP10 or 13. For SP16:

which versions of ADOMD.NET need to be installed?
on which servers?

0 comments

Answer accepted by question author

3 additional answers

Your answer

Answer 1

Jerry Xu-MSFT 7,961

Hi, scogordo-2057 ,

As the original download link has expired, if you are installing the SQL Server 2016 Reporting Services in SharePoint mode on your application server, this file is included. Also you can have a try with this.

If the answer is helpful, please click Accept Answer and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 comments

Answer 2

Tom Phillips 17,786

I suggest you read:

https://learn.microsoft.com/en-us/sharepoint/administration/software-requirements-for-business-intelligence#software-requirements-for-performancepoint-services-in-sharepoint-server-2016

sco gordo 301 Reputation points

2020-11-02T22:00:46.483+00:00

Thanks Tom.
So it looks like I need ADOMD.net version 11 installed on my WFE and APP server?
Dumb question: downloaded https://www.microsoft.com/en-us/download/details.aspx?id=55264, checked Microsoft.AnalysisServices.DLL properties and it looks like it's version 13. Where can I download 11?
Thanks all.

Answer 3

sco gordo 301

Commented out the bindingRedirect and replaced with newVersion

    <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" culture="neutral" />
    <!--<bindingRedirect oldVersion="9.0.0.0" newVersion="10.0.0.0" />-->
<bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0" />

Working!

Much thanks!

Jerry Xu-MSFT 7,961 Reputation points

2020-11-10T01:11:01.31+00:00

Hi, @sco gordo ,
Glad to hear you get it work. And thanks for your update, it will help other community members in similar situations.

Answer 4

sco gordo 301

Thanks JerryXu,

I'm requred to install the absolute minimum necessary to get this working.

I checked the link and saw checkboxes for

SQL_AS_ADOMD.msi (6mb)

SQL_AS_ADOMD.msi (3mb)

The Version: 11.0.7001.0 looks promising.

Are these what I need to install?

And... which one? It's a Win2012 server.

Again, appreciate your input.

Jerry Xu 256 Reputation points

2020-11-04T02:09:13.343+00:00

Hi, @sco gordo ,

According to the instruction, they are X86 and x64 Package(SQL_AS_ADOMD.msi), please try to install the 6mb file as it contains both x86 and x64 files.

BTW, as part of the best practice in this Q&A forum, please comment under the reply if you have anything questions/update about it. It will make it easier to read and an reply can always be recognized as a new answer.
sco gordo 301 Reputation points

2020-11-04T16:11:58.59+00:00

Again, much thanks.
APP server is sufficient? Not WFE?
Also, checked the APP server, Microsoft.AnalysisServices.AdomdClient.dll is already there, properties looks like version 9. Will this file overwrite the existing version? If so, is backwards compatibility a concern?
I did see this: https://learn.microsoft.com/en-us/sharepoint/troubleshoot/administration/sharepoint-installs-obsolete-sql-server-product, but erring heavily on the side of caution/experience ;).
Jerry Xu-MSFT 7,961 Reputation points

2020-11-05T01:31:15.007+00:00

Hi, @sco gordo ,
I have done some tests, just like the article said, it is an obsolete product which will not be removed or updated. After installing the new version, I find two ADOMD installation in the Programs and Features . Thus you will need to remove and install the proper version manually. Per my knowledge, APP server shall be enough.
sco gordo 301 Reputation points

2020-11-05T18:02:01.913+00:00

Will do. Much thanks. I'll report back.
sco gordo 301 Reputation points

2020-11-06T15:17:57.2+00:00
Installed and verified

Microsoft SQL Server 2012 ADOMD.NET
Size 9.58MB
Version 11.4.7001.0

installed on APP, still getting error code 10115, still unable to list databases.

Followed up by

Removing the old version of ADOMD.NET

Adding v 11.4.7001.0 to WFE as well

IISRESETS, reboots, etc, still no results returned, still getting error. What did I miss?
sco gordo 301 Reputation points

2020-11-06T18:53:08.933+00:00

Checked my SharePoint SQL 2016 server properties.

Microsoft Analysis Services Client Tools 13.0.1700.441
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft .NET Framework 4.0.30319.42000

Would it be required to match the versions of ADOMD.NET and any other components to the SQL versions?
Jerry Xu-MSFT 7,961 Reputation points

2020-11-09T01:29:27.87+00:00

Hi, @sco gordo ,

It seems be better to open a ticket for your issue. The support team will be able to have a more in-depth investigation against your farm.

Share via

PerformancePoint services error code 10115

3 additional answers

Your answer