Dynamics 365

BACPAC import failure fix

It is a common task to move databases between a Microsoft-managed environment and a self-service machine. From Azure SQL we can only take a BACPAC export, which needs to be imported/converted into Microsoft SQL Server format. With the recent changes and improvements of security, you may be facing an error message when trying to move the database backups. Let’s have a look at the BACPAC import and export failure fix to address the following error message:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)

The tool to process the BACPAC file is called SqlPackage. You should install the latest DAC version first for to have the benefit of fixed and performance improvements.

Example of a BACPAC export from your MSSQL DB:

.\SqlPackage.exe /Action:export /ssn:SourceServerName /sdn:AXDB_source /tf:F:\Backup\AXDB.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false /SourceTrustServerCertificate:true

Example of a BACPAC import into your MSSQL DB:

.\SqlPackage.exe /Action:Import /sf:C:\DynamicsTools\Sandbox.bacpac /tsn:TargetServerName /tdn:AXDBname /p:CommandTimeout=0 /TargetTrustServerCertificate:true

As you can see, now you have to enforce trusting the server certificates to pass the error message above.

DynamicsMinds 2023 conference speaker

I am happy to announce that I have been selected as a DynamicsMinds 2023 conference speaker. It is going to be one of the biggest events for Business Applications in Europe, with dozens of Microsoft product teams and MVPs and some of the best experts in the industry.

DynamicsMinds is going to be held in the lovely city of Portoroz, Slovenia between 22-24th of May, 2023. The main areas to cover are Finance & Operations, Business Central, Customer Engagement and Power Platform.

As usual my session is going to be a bit more on the technical side. Titled “Advanced D365FO Developer tooling and Technologies for XppGroupies”, you can guess that I would like to cover the history of, and the possible future of X++ development.

DynamicsMinds 2023 - Advanced D365FO developer tooling and technologies for XppGroupies - Vilmos Kintera

Looking forward to meet new people and to see all my friends, fellow professionals, partners and customers. See you at DynamicsMinds!

Microsoft is embracing AI

It has been no secret that Microsoft wanted to make something extraordinary by investing $1-billion in the OpenAI company. This was a message to the world that Microsoft is embracing AI. And in the past couple of days we have seen that they took it seriously indeed!

Using the Codex machine learning model developed at OpenAI, and Microsoft is applying their approach to all across their product range. We have previously seen GitHub Copilot which is now being incorporated into Visual Studio 2022. Then came the Microsoft 365 Copilot to assist with our document creation and editing, and communication needs covering a wide range of products including Word, Excel, Teams, and a lot more.

But the biggest news for our community is that AI is entering the Business Applications segment with Microsoft Dynamics 365 Copilot.

 

 

There changes are not just applied to a single product, but across the board, with different capabilities. I really love the idea of the AI which scans the news portals for any events which might impact our Supply Chain, and makes actionable suggestions to contact vendors and procure goods ahead of the market.

I am looking forward to using some of the advancements that comes with the boom of using artificial intelligence in our everyday life. It is great that Microsoft is embracing AI and moves forward by such innovations.

Self-service VM is slow when getting latest changes

We have  deployed a cloud-hosted environment in our Azure subscription which is of type Build/Test. When we wanted to remote in and use Visual Studio Team Explorer, we have noticed that the self-service VM is slow when it tries to fetch changes from the server.

It was because the Dynamics 365 VSOAgent had already fetched our source code. When we tried to get the latest changes, VS tried to move the files from the VSOAgent folder to our target location under K:\AosService\PackagesLocalDirectory, but have been denied acces.

Self-service VM is slow

The solution was to purge the C:\DynamicsSDK\VSOAgent\_work\ folder contents, which has increased the server fetch speed dramatically.

DMF TransferStatus to check entity processing

When we work with a Data Entity in D365FO, it can get tricky to track how transfers are going and how much is left. Here is a quick SQL snippet to query staging tables to figure out DMF TransferStatus:

select
  executionid,
  transferstatus,
  case
    when transferstatus = 0 then 'Not started'
    when transferstatus = 1 then 'Completed'
    when transferstatus = 2 then 'Error'
    when transferstatus = 3 then 'Validated'
    when transferstatus = 4 then 'Duplicate'
  end AS StatusTxt,
  count(*) from [dbo].[CUSTCUSTOMERV3STAGING]
group by executionid, transferstatus

This snippet can tell us how many records have been completed, has an error, or still remaining to be processed. It only works if a staging table is being used for the data entity export/import.

Go to Top