{"id":370,"date":"2015-08-20T12:38:36","date_gmt":"2015-08-20T12:38:36","guid":{"rendered":"http:\/\/www.exploreax.com\/blog\/?p=370"},"modified":"2015-08-20T12:38:36","modified_gmt":"2015-08-20T12:38:36","slug":"role-centers-analysis-services-report-server-ax-cannot-load-the-axadomd-extension","status":"publish","type":"post","link":"http:\/\/www.exploreax.com\/blog\/blog\/2015\/08\/20\/role-centers-analysis-services-report-server-ax-cannot-load-the-axadomd-extension\/","title":{"rendered":"Role Centers \/ Analysis Services: Report Server (AX) cannot load the AXADOMD extension."},"content":{"rendered":"

Let me say at the outset that I am very new to Dynamics AX role centers and analysis services and really have a lot to learn. However I thought I would share the following problem with setting up role centers and the associated solution that I found.<\/p>\n

Problem description:\u00a0<\/strong>After installing role centers on AX2012 RTM CU 3 with SQL Server 2012 the following error is displayed “An attempt has been made to use a data extension ‘AXADOMD’ that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)”\u00a0<\/em><\/p>\n

\"2015-08-19_1410\"<\/a><\/p>\n

 <\/p>\n

The Event log on the SSRS machine says the following:\u00a0Role Centers \/ Analysis Services: Report Server (AX) cannot load the AXADOMD extension.<\/em><\/p>\n

 <\/p>\n

Problem resolution \/ investigation:\u00a0<\/strong>After chasing my tail on this one for quite a while (including multiple re-installation etc)\u00a0trying to figure out why the “AXADOMD” SSRS datasource extension was not installed I discovered that the problem did not lie with “AXADOMD” being missing but rather it might be having issues when it was loading.<\/p>\n

Looking at the SSRS log files (C:\\Program Files\\Microsoft SQL Server\\MSRS11.AX\\Reporting Services\\LogFiles<\/em>) I discovered the following message:<\/p>\n

ERROR: Exception caught instantiating AXADOMD report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.<\/em>
\nFile name: ‘Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’<\/em>
\n at Microsoft.Dynamics.Framework.Reports.AxAdomdConnection..ctor()<\/em><\/p>\n

This lead me to think something might be wrong with the\u00a0Microsoft.AnalysisServices.AdomdClient\u00a0<\/em>itself despite the AX installation validation showing up that it was installed already.<\/p>\n

Paying a quick visit to C:\\Windows\\Assembly revealed that only AdomdClient version 11.0.0.0 was installed<\/p>\n

\"2015-08-20_1433\"<\/a><\/p>\n

The simple solution to this issue was to install the 10.0.0.0 client from\u00a0http:\/\/www.microsoft.com\/en-za\/download\/details.aspx?id=23089<\/a>\u00a0after which SSRS no longer complained.<\/p>\n

\"2015-08-20_1431\"<\/a><\/p>\n

I hope this saves somebody some of the hassle and time that I have spent on figuring this one out.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Let me say at the outset that I am very new to Dynamics AX role centers and analysis services and really have a lot to learn. However I thought I would share the following problem with setting up role centers and the associated solution that I found. Problem description:\u00a0After installing role centers on AX2012 RTM…Read more Role Centers \/ Analysis Services: Report Server (AX) cannot load the AXADOMD extension.<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,5,96,3],"tags":[99,100,97,98],"_links":{"self":[{"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/posts\/370"}],"collection":[{"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/comments?post=370"}],"version-history":[{"count":2,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":376,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/posts\/370\/revisions\/376"}],"wp:attachment":[{"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/media?parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/categories?post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.exploreax.com\/blog\/wp-json\/wp\/v2\/tags?post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}