Video: Introducing the New Microsoft Dynamics AX

Video about the new Dynamics AX (AX 7)

Publish reports on several SSRS servers

When updating more than one AOS with new code you probably want to publish new SSRS Reports to more than one SSRS Server. The following powershell script will help a lot.
Thanks to Allan Andersen


$SSRSServers = "SSRS-Test", "SSRS-Training", "SSRS-Demo", "SSRS-Prod"

ForEach ($SSRSServer in $SSRSServers)
{
    #create PowerShell Session
    $PSSession = New-PSSession -EnableNetworkAccess -Name $SSRSServer

    Invoke-Command -Session $PSSession -ArgumentList $SSRSServer -ScriptBlock
    {
        #load AX ManagementUtilities 
        .'c:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities\Microsoft.Dynamics.ManagementUtilities.ps1' 

        #publish report
        Publish-AXReport -Id $args[0] -ReportName * -ModifiedAfter (Get-Date).AddDays(-30) -Verbose
    }

    Remove-PSSession $PSSession
} 


Depending how you do deploy Reports in your Environment you can also use WSDL Port ( -ServicesAOSWSDLPor) or other parameters of the Publish-AXReports command.

DIXF refresh target entity mapping

If you need to update all target mappings in one go, the following job will help you :)

static void DIXFRefreshTargetEntityMap(Args _args)

{

    DMFEntity   entity;

    if (Box::yesNo('Are you sure you want to update all target mappings?', 
                 DialogButton::No) == DialogButton::Yes)

    {

        while select entity

        {

            DMFTargetXMLToEntityMap::generateMapping(entity, true);

        }

        info('done');

    }

}

Time and Attandance posts

Lately I found a very good blog that describes the whole time and attendance functionality in 31 blog posts. So if you need detailed information about this topic start reading here:

https://dynaxtips.wordpress.com/2015/03/01/time-and-attendace-get-started/

Management Reporter logs

The deployment logs of the Management Reporter can be found here:

C:\ProgramData\Microsoft Dynamics ERP\Management Reporter\Logs

SSRS: Install-AXReportInstanceExtensions MetadataServiceException

When you get the MetadataServiceException:


Install-AXReportInstanceExtensions -ReportServerInstanceName TWI -Credential TWI\axbcproxy

Install-AXReportInstanceExtensions : Für den Metadatendienst ist auf dem Client oder dem Server eine Ausnahme aufgetreten. Ausnahmedetails: Unable to log on to Microsoft Dynamics AX. 
In Zeile:1 Zeichen:1 + Install-AXReportInstanceExtensions -ReportServerInstanceName TWI -Credential TWI\axbcproxy ... 
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
    + CategoryInfo : NotSpecified: (:) [], MetadataServiceException 
    + FullyQualifiedErrorId : Microsoft.Dynamics.AX.Framework.Services.Client.MetadataServiceException 

while installing the AX ReportInstanceExtensions via AX Management Shell you should check the AX client configuration.
In the eventviewer is a warning that tells us to check the WCF configuration. So after changing the client configuration to an AX AOS that is available and accessible by the current user this message should disapper. Keep in mind to update WCF configuration after changing AOS Server and/or port.

SSRS: The report server installation is not initialized

On an azure environment I just got the error:

The report server installation is not initialized. (rsReportServerNotActivated) 

when opning the SSRS ReportServer site.

This can be fixed by creating a new Reporting Services database through the Reporting Services Configuration Manager - Change Database

It has to do with false entries in the ReportServer Database in table Keys that does not match the installation.

Stop and start SSRS service afterwards and everything is fine again.