Reporting in AX 2012 R3 CU12 with SQL Server 2016

I recently had the task to fix reporting for an AX 2012 R3 CU12 environment. The database server is SQL Server 2016.

Supported?

We knew it was supported. Microsoft Dynamics AX 2012 System Requirements document was updated in 2017 June with SQL 2016 support related information.

Dynamics AX 2012 System Requirements SQL 2016 SMO

Dynamics AX Reporting Services Extension install crash

SSRS and AX were just not set up when I first checked. After many normal setup stuff and errors that I do not detail here, I decided to reinstall Dynamics AX Reporting Services Extension. Well, that just did not work. It crashed while installation or asked for inserting another disk.

AxSetup.exe iso insert disk at report extension install
AxSetup.exe reporting extension install crash

Event log holds 2 errors at this time:

  1. “Faulting application name: AxSetup.exe. … Faulting module name: KERNELBASE.dll…”
  2. “The description for Event ID 139 from source Dynamics .NET Business Connector 6.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event:

    6.0:
    Error 2 during access to C:\Program Files\Microsoft Dynamics AX\60\SetupSupport\axsysHU.ktd.

    The specified resource type cannot be found in the image file”

Found this on LCS issue search:

LCS issue

So we downloaded the package from here and installed Shared Management Objects x64 from it on the SQL server. We also slipstreamed this to our AX install folder KB3216898. After these, we could do the extension installation.

Sharepoint integration mode issue

One step forward, but reports still did not work. They could be deployed, but could not be opened from AX.
Message instead of the reports: “WARNING: Make sure that SQL Server Reporting Services is installed correctly on this machine. Verify that all prerequisites are installed and services are running before installing the Business Intelligence Components for Microsoft Dynamics AX.”
Same for PowerShell command: ‘Test-AXReportServerConfiguration -id Default’.
Validation failed at line 20 of this method: \Forms\SRSServersForm\Methods\checkIfSharepoint.
The call in that line which gives the error calls out of AX: isSharepoint = proxy.queryWMIForSharePointIntegratedMode(serverName, serverUrl);
Well, we knew that our SSRS is in Native mode, not SharePoint integrated mode so, for now, we replaced this validation with returning false and reports started to work (after CIL compile).

Hope this will be useful for someone out there.

 

10 thoughts on “Reporting in AX 2012 R3 CU12 with SQL Server 2016”

  1. Many thanks for the tipp – Shared Management Objects were the solution.
    I was struggling to install them, seems an incorrect version of the CLR Types were already installed before. Once that was settled and SMO was installed, AX 2012 R3 SSRS extensions could be installed.

Leave a Reply

Your email address will not be published. Required fields are marked *