Monday, October 30, 2017

The client id must be unique across all clients - Dynamics 365 for Finance & Operations On Premises Installation

Hi Guys

To the same Customer I'm going to install the second On Premise Environment.

During the "Step 18 - Configure AD FS" I had run the following command in order to create the new Application:

 .\Publish-ADFSApplicationGroup.ps1 -HostUrl 'https://ax.d365foENVNAME.onprem.contoso.com' -ApplicationName 'Microsoft Dynamics 365 for Operations On-premises ENVNAME'

 Here I raised the error "The client id must be unique across all clients"

I checked the log wrote in the same folder as the script and I notice that the process failed to the script "D365FO-OP\D365FO-OP-ADFSApplicationGroup.psm1” at line 199

Here the "workflowClientId" is set with a fixed ID value.

I guess is a error so, I changed the line in:

"$workflowClientId = ([guid]::NewGuid())"

Before rerun the script, delete the partial Application created before through the ADFS Management Console

Till Soon!



Sunday, October 29, 2017

Setup the AOS Balancing on AIF WEB Services or WHS Mobile Portal - AX 2012

Hi Guys

In an AX Environment with a huge AX Services workload, it is suggested to enable the AX Services Balance.

In order to do that, you have to:
  1. First, enable the NLB or ILB if you are working in Azure
  2. If you want enable the Balance through:

    • AIF Web Services
    • Remote Desktop Host Server
    • SSRS Services
    • Management Reporter

      You have to follow the standard link High Availability best practices for Dynamics AX 2012 in order to setup the Balance through the Dynamics AX Configuration Utility.
      You have to do that on each Servers listed above.

      Practically you have to:
    • Through the Dynamics AX Configuration Utility create a new Configuration on “Local Client” and on “Business Connector” Target. You can named it “Balance”
    • On both Configurations, in the Connection Tab fill “Server Name” with the IP or Name of the Balance
    • Through the Registry (HKEY_CURRENT_USER and HKEY_LOCAL_MACHINE) at the path “\Software\Microsoft\Dynamics\6.0\Configuration\new_configuration_name” create two key “wcflbservername” and “wcflbwsdlport” and fill them respectively with the Balance IP or name and the Wsdl Port
      “new_configuration_name” will be the new AX Configuration created
    • Come back to the AX Configuration Utility and refresh both configurations with the “Refresh Configuration” button


  3. If you are using the WHS Mobile Portal, modify the “Web.config” file that usually is store at “C:\Dynamics60\Warehouse Mobile Devices Portal\00” and modify the endpoint with your “Balance” IP or Name:


Talking about AIF Web Services or WHS Mobile Portal, in some cases, you have to create also an IIS Farm in order to balance the IIS Connections. If you are working on Azure you have to use the Azure Application Gateway in order to do that.

Till Soon!

Tuesday, October 24, 2017

High Availability AX 2012 Links

Hi All

I would like to share some useful links about how to handle the High Availability through AX 2012:


  1. High Availability best practices for Dynamics AX 2012
  2. Configure SSRS for load balancing in your Azure deployment
In the next days I will share in detail how to setup the "Services High Availability", in order to balance the WHS Mobile Portal and the AIF Web Services, especially in Azure using the ILB (Internal Load Balancer).

Till Soon!

Sunday, October 22, 2017

Empty Database in your VHD All-in-one Machine - Microsoft Dynamics 365 for Finance & Operations

Hi All

As you know, in an Azure Sandbox Environment you can decide if create it with or without Data.

This is not possible when you download the VHD All-in-one machine.

In order to achieve this result from my understanding there are two options:
  1. André post, https://kaya-consulting.com/how-to-start-with-empty-ax-database-in-your-local-vm/ where you have to create before the Env in Azure with an Empty Database, Backup it and move to your VHD
  2. I have Play around to the VHD Disk C and I notice a folder named “EmptyDataset” with inside a Database backup named “AxBootstrapDB_Empty.BAK”
    I have simply restore this backup file against the AX Database and set the right GUID and email id retrieved from the “old” AX Demo Data.

Till soon!

Saturday, October 21, 2017

Microsoft Dynamics 365 for Finance & Operations - Change the standard URL in a VHD Machine

Hi All

In a Business scenario, we can setup several VHD all-in-one box Environments in the same Datacenter for various purpose.
One issue is the standard base URL that usually is https://usnconeboxax1aos.cloud.onebox.dynamics.com/ for all Envs.

In order to change it and allow the team to reach the different Envs, for each Dev Box replace “usnconeboxax1aos” with the desired URL like “XXXXXXX”:

1-  Modify Endpoint URL on IIS

2- Modify web.config files in the C:\AOSService\webroot and replace all standard “url name” entries with the new one (XXXXX)

3- Modify wif.services.config as per the previous step 

4- Modify “Host” file on C:\Windows\System32\drivers\etc like that:
127.0.0.1           xxxxx.
cloud.onebox.dynamics.com

5-  Change the “hosts” file on C:\Windows\System32\drivers\etc in your Laptop, like:XX.XX.XX.XX     xxxx.cloud.onebox.dynamics.com 
where XX.XX.XX.XX will be the IP of the VHD Box
You have to add an entry for each VHD URL Env.

6- As the last step, make the Admin User Provisioning


Till Soon!


Wednesday, July 26, 2017

Microsoft Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) - Installation PART 2

Hi

Again here with the second part about the D365FO On-premise installation.

Before to Create the AppFabric Cluster, modify the ClusterConfig.json file created before and set the "diagnostics file share" path. This one will be use during the Installation process through all AppFabric nodes.

If during the Cluster installation you raised the error "Request is Invalid" check if the Primary NodeType (Orchestrator) have at least 3 Nodes!



Again, if during the Cluster installation you raised the error "Timed out waiting for Installer Service to complete for machine..."


You have to:

1- Verify if the Certificate are been installed in the Local Machine Node

2- Add the NETWORK SERVICE account for all certs used by Service Fabric.
In order to do this you have first download and install in all Cluster Nodes the WinHttpCertCfg.exe tool, Windows HTTP Services Certificate Configuration Tool (WinHttpCertCfg.exe)
Lastly, run the command for all Certificates in all Cluster Nodes, like "C:\Program Files (x86)\Windows Resource Kits\Tools\WinHttpCertCfg.exe" -g -c LOCAL_MACHINE\MY -s "client.xxxxx.com" -a "NetworkService"

Till soon!

Microsoft Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) - Installation PART 1

Hi Guys

As you know, Microsoft released D365FO Local Business Data, aka On-Premise release.
Here the link Set up and deploy on-premises environments

I played around and I found the first issues.

During the creation of the group managed service accounts (gMSAs) through the Powershell scripts, "Create gMSAs" section, you can raise the follow error: "Key not found"

In this case you have to create a "KDS root key" using the following commands:

1- Add-KDSRootKey –EffectiveImmediately
2- Add-KdsRootKey –EffectiveTime ((get-date).addhours(-10));


During the ClusterConfig.json file generation, you can raise the following error, “Failed to Download Cluster Configuration Template”, see below error.

In this case you have to download the Service Fabric standalone installation package and copy the "ClusterConfig.X509.MultiMachine.json" file into the LCS InfrastructureScripts folder.
Again run the .\New-SFClusterConfig.ps1 -InputXml .\ConfigTemplate.xml command.

Finally, I test the ClusterConfig file through the command .\TestConfiguration.ps1 -ClusterConfigFilePath .\clusterConfig.json











Next step is Deploy the Cluster!

Till soon!

Monday, July 3, 2017

AX 2012: Forms on opening hide behind in the back - 2° part

Hi Guys

About this topic the Microsoft workaround in some case doesn't helped me.
So, below you can find the code that definitely fix the issue!

Modify the StartupPost method of the Application Class and add these two lines:

if (hasGUI())
        Application::DisableWindowGhosting();


Lastly, created the "DisableWindowGhosting" static method like this:

client static void disableWindowGhosting()
{
    DLL DLL;

    DLLFunction DLLFunction;

    container con = WinAPI::getVersion();

    if (conpeek(con, 1) == 6) //Vista and Win7/Win2008R2 only
    {
        //this will disable window ghosting for this process only, for its lifespan only

        DLL = new DLL("USER32");

        DLLFunction = new DLLFunction(DLL,"DisableProcessWindowsGhosting");

        DLLFunction.call();
    }
}

That's it!

Sunday, July 2, 2017

MVP Dynamics AX/365 Renewal - Fourth time!

Hi Guys

For the fourth time I was able to remain MVP on Dynamics AX/365 for Finance and Operations.
Today We Kick Off Our First Annual Award Cycle. Congratulations to all Renewing MVPs!

It is not easy to balance career and remain an technology expert.
I guess that my trick is the passion!

Again is a pleasure stay on touch with the others MVP, meet them, share experiences, etc.

At the end, we became really a good friends!

See you on the next technical conferences, community websites, etc.

Lastly with the release of the Dynamics 365 for Financial and Operations on-premise, I guess we will have a lot of fun in the next months.

Friday, June 23, 2017

Microsoft Dynamics 365 Local Business Data aka On-Premise - Database Topology

Greetings

As you know Microsoft have release Dynamics 365 LBD - On premise version.

Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements

About Database the main question is use SQL Server 2016 Standard or Enterprise Edition.
Obviously, refer to the Microsoft link in order to check the features supported by the SQL Server editions.

In a medium and not complex Project, my suggestion is to use the Standard Edition.
With the standard version is possible to setup an Always On Availability Group Cluster with a limit of two replicas (Primary and Secondary).

From a Business Intelligence perspective, we can setup a SQL snapshot on the Secondary replica and link to the snapshot the Reporting activities.

Stay Tuned!


Friday, June 9, 2017

Microsoft Dynamics 365 useful links

Hi

Below some useful links about Dynamics 365:

General Links:

1- Microsoft Dynamics 365 – Launch Portal

2- Introduction to Dynamics 365 for Operations

3- Overview of Microsoft Dynamics 365 for Operations for Developers and IT Pros

SaaS Evaluation Copy:

1- Get an evaluation copy
2- Try out Dynamics 365 for Operations now for free!
3- Have you given Microsoft Dynamics 365 for Finance & Operations, Enterprise Edition a try?
4- Microsoft Dynamics 365 for Finance and Operations, Enterprise edition deployment options

Database Management:

1- Copy a Dynamics 365 for Operations database from Azure SQL Database to a SQL Server environment For instance update Data from the UAT Environment to a Sandbox Environment.

On-Premise:

1- Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements
2- Set up and deploy on-premises environments
3- On-premises deployment landing page
4- Features not implemented in on-premises deployments
5- Purchase Dynamics 365 for Finance and Operations, Enterprise edition (on-premises)

Setup Dynamics 365 Virtual Machine

1- Setup Dynamics 365 for Operations Virtual Machine
2- Setting up a personal Dynamics 365 For Operations development environment
3- Virtual Machine(VM) setup to access Dynamics 365 for Operation instance
4- Running AX7 VM on Oracle VirtualBox
5- Download VirtualBox Guest Additions
6- How to Fix VirtualBox “UUID already exists” Errors
7- Access instances
8- How to rename a D365 virtual machine, link it to LCS, and optionally join it to a domain - Dynamics 365 for Finance and Operations, Enterprise edition
9- Rename a local environment to enable access to Visual Studio Team Services

Visual Studio Team Services

1- Setting Up Version Control in Dynamics 365 for Operations with Visual Studio
2- Rename a local environment to enable access to Visual Studio Team Services
3- Visual Studio Team Services integration with Lifecycle Services
4- Setting up a development branch and build
5- Continuous delivery home page

Environment Setup

1- Importing users in D365 Operations using Excel

Power BI

1- Accessing Analytical Workspaces and Reports on 1Box environment
2- Activate the new Power BI Embedded Reports for Dynamics 365 for Finance and Operations

Hotfixes

1- Upgrades, Updates and Hotfixes in AX7
2- Install a metadata hotfix

Debug

1- Debug X++ against a copy of a production database

Warehouse App

1- Announcing Dynamics 365 for Operations – Warehousing
2- Install and configure Microsoft Dynamics 365 for Finance and Operations – Warehousing
3- Customizing the Warehousing Mobile App

What's New

1- Microsoft Dynamics 365 Roadmap
2- What's new or changed

Unit Test

1- July 2017 update: Form Adaptors Replaced by Type Providers

Common Data Services

1- COMMON DATA SERVICES (CDS), DATA INTEGRATOR AND DYNAMICS 365, WHAT WILL YOU DO?

Ideas

1- IDEAS

FastTrack

1- FastTrack Dynamics 365 for Finance & Operations - Enterprise Edition - Tech Talks


This page will be update frequently!

Enjoy!

Sunday, February 19, 2017

AX 2012 - TFS multiple workspaces

Hi All

AX 2012 support only a single TFS workspace that mean a Dynamics AX Developer Box (SQL Server, AOS, etc.) for each developer.

Many of us use a Shared AX Environment, so many Developers connected to the same Dynamics AX Environment. More details at Microsoft Dynamics AX 2012 White Paper: Developing Solutions in a Shared AOS Development Environment

For this reason Martin Dráb created a custom Solution in order to help us to achieve this result, TFS workspaces in AX2012

This solution is fantastic.
The only issue is when an object is in check-out mode also other developers can modified it also if the check-in can only be handled by the check-out Owner.

In order to fix the behavior I have created a new method and modified another one in the SysVersionControlSystemFileBased Class.

Therefore:


Create a new method like “isCheckedOut” like this:

// AddaxWorkspaces
// Denis 20170219 - Check if the current Object is check-out by the current user
boolean isCheckedOut_dlx(Filename         _filenameCurrentLayer)
{
    Set                         checkedOutObjects = new Set(Types::String);
    SysVersionControlTmpItem    items;
    SysVersionControlSystem     sysVersionControlSystem;
    SysVersionControlParameters parameters = SysVersionControlParameters::find();

    str                         checkFileName;

    sysVersionControlSystem = SysVersionControlSystem::newType(parameters.vcsType);
    sysVersionControlSystem.init(parameters);

    if (sysVersionControlSystem)
    {
        items = sysVersionControlSystem.getCheckedOutItems();

        while select items
        {
            checkFileName = items.Filename;
            checkFileName = strReplace(checkFileName, parameters.AppRoot + '$\\' + parameters.TfsProject + "\\", "");

            if ( _filenameCurrentLayer == checkFileName )
                Return True;
        }

    }

    return false;
}

Modified the allowEdit method like this:

…..
        //Has the file been checked out
        if (!bitTest(WinAPI::getFileAttributes(filenameCurrentLayer), #FILE_ATTRIBUTE_READONLY)
        &&  this.isCheckedOut_dlx(filenameCurrentLayer)       // Denis 20170219 - AddaxWorkspaces
           )
            return true;

Thanks again to Martin and Stay Tuned!


Saturday, February 4, 2017

AX 2009 – SSRS Unable to connect to http://server/ReportServer/ReportService2005.asmx

Hi Folks

As you know, starting from AX 2009 was possible to use the SSRS Report instead of the Morphx Reports.

In the last weeks, I faced an issue during the Report Deployment. The error was:

Unable to connect to http://server/ReportServer/ReportService2005.asmx as specified in the config file for the report server at C:\…\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report server is configured correctly.


Therefore, after some investigation and with help of Microsoft Support, I have fixed the issue.

Below what verify in priority order:

1-      Check if the Antivirus is enabled and in detail the Real-time scan. Disable it or create the relative rules

2-   Update the LanguageTable Table, field LabelFile. Only the languages with 1 on the LabelFile field will be deployed
            a.       select distinct LANGUAGE, HELPLANGUAGE from USERINFO
            b.   select * into LANGUAGETABLE_Backup from LANGUAGETABLE
            c.   update LANGUAGETABLE set LabelFile = 0 where LanguageId not in ('en-us', ‘it’)               //add any language found from first query

3-     Extend timeout settings
a.       Report Manager->Site settings->Report Execution Timeout->select “do not timeout report execution”.

b.      Increase the Timeout, so:
                                                               i.      Open “C:\Program Files\Microsoft SQLServer\MSSQL\ReportingServices\ReportManager\Web.config” and “C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\Web.config”
Search for httpRuntime executionTimeout="18000"

                                                             ii.      Open “C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\rsreportserver.config”
Search for:
1.       Add Key="SQLCommandTimeoutSeconds" Value="300"
2.      Add Key="MaxActiveReqForOneUser" Value="60"
3.       Add Key="DatabaseQueryTimeout" Value="300"

                                                            iii.      Increase these values as above, Restart SSRS Services and then test it.

c.       Update machine.config to speedup .net performance
                                                               i.      In C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\MACHINE.CONFIG, replace processModel autoConfig="true" with processModel maxWorkerThreads="100" maxIoThreads="100" minWorkerThreads="50"

                                                             ii.     In C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\WEB.CONFIG, locate the "system.web" Tag. Add the following as a child tag httpRuntime minFreeThreads="352" minLocalRequestFreeThreads="304" appRequestQueueLimit="5000"


Take care to make a backup of the configuration files before any modification!

Stay tuned!

Sunday, January 15, 2017

AX 2012 – TFS Build Error: The AXUtil command was started in the mode: export. Working against model store SQLServerName /ModelDatabaseName. ERROR: The file exists

Hi Guys

I am using the CodeCrib Library in order to handle my TFS Build Process.

During the last run, I faced the follow error:

Exception Message: Error exporting model: AXUtil 6.3 - Microsoft Dynamics AX Admin Utility (6.3.3000.2948) (c) Copyright, Microsoft Corporation, 2011. All rights reserved. The AXUtil command was started in the mode: export. Working against model store XXXXXX/XXXXXXX_model. ERROR: The file exists. (type Exception) Exception Stack Trace: at CodeCrib.AX.Manage.ModelStore.ExportModelShell(String modelName, String modelPublisher, String modelFile, String strongNameKeyFile) in c:\Users\xxxxxxxx\Documents\Visual Studio 2013\Projects\MainAxTFSLib\CodeCrib.AX.Manage\CodeCrib.AX.Manage\ModelStore.cs:line 144 at CodeCrib.AX.Manage.ModelStore.ExportModel(String modelName, String modelPublisher, String modelFile, String strongNameKeyFile) in c:\Users\ xxxxxxxx\Documents\Visual Studio 2013\Projects\MainAxTFSLib\CodeCrib.AX.Manage\CodeCrib.AX.Manage\ModelStore.cs:line 84 at CodeCrib.AX.TFS.ExportModel.Execute(CodeActivityContext context) in c:\Users\ xxxxxxxx\Documents\Visual Studio 2013\Projects\MainAxTFSLib\CodeCrib.AX.TFS\CodeCrib.AX.TFS\ModelStore.cs:line 96 at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
An error occurred while copying diagnostic activity logs to the drop location. Details: The file exists.

Resolution: You have to clean the TEMP folder related to the Agent User that will run the Build Process. 
Something like C:\Users\xxxxxxx\AppData\Local\Temp. After many TFS Build run, this folder contains a lot of files and an certain point the process try to create a file that already exist.

If possible, create a batch process that clean this folder at regular basis.

That is it!

Sunday, January 1, 2017

AX 2012 - TFS Build Failed, Timeout during XPO Import

Hi Guys

Let me say, start the New Year with a post is a good start. What do you say?

Back to us, if the TFS Build fail, the causes could be many.

However, from my experience if fails with a Timeout during the XPO Import (you can achieve this through the Build Txt log), the reasons can be two:


1-    Someone delete an AOT object without commit the operation on TFS. Afterward someone else create a new AOT object and add it to TFS. This one could have the same GUID of the deleted object.

2-    Someone rename an AOT object but on TFS (through TFS Solution Explorer), the object have the new name but inside the XPO is present the old name (In my opinion this is a Microsoft bug)!!!

In both case the TFS Build fails.

In order to understand which object create the issue you have to:


1-    Restore the AX Baseline Database (the DBs without any AX Customizations) on your TFS Build AX Environment
2-    Run the XPO Import process manually and verify the error
3-    Fix the error on Dynamics AX or TFS as mentioned above
4-    Rerun the TFS Build Process

Happy New Year!