Issues with DBsync step during deploy


Today, when I was deploying customization package to a newly deployed config environment, I had an issue with a step not working correctly. The environment had not yet been used for anything so I hadn´t even copied a database to it. When I deployed the customization package to it I got the following error in the runbook log and the deploy failed:

Table Sync Failed for Table: SQLDICTIONARY. Exception: System.NotSupportedException: TableID not yet generated for table: AmcBankReconciliations

The sync step in the runbook is failing because there is no TableID for the table AmcBankReconciliations. And I thought that was exactly what the sync process was supposed to do (??).

Having no clue about why this happened I first turned to Google (as one does) and when I could not find anything there I asked my awesome colleagues and one of the said:

“I have seen newly deployed environments behaving strangely and my solution usually is to start Visual Studio and perform a DB Sync”

This was a bit strange since it was the Sync Step that failed but I thought I would give it a try. Since this was a config environment that is not going to use Visual Studio, I instead opted for using the amazing [d365fo.tools](GitHub – d365collaborative/d365fo.tools: Tools used for Dynamics 365 Finance and Operations) to do the sync

Invoke-D365DBSync -Verbose

When the sync had finished I tried resuming the deploy and to my surprise it finished perfectly… Nice 🙂

Enabling Batch Alerts in Dynamics 365 for Finance and Operations

Today we will look at Alerts in Dynamics. First you need to set up SMTP in Dynamics.

  1. Go to System Administration – Setup – Email – Email Parameters
  2. Configure settings for your email service, in our case Office 365

    SNAGHTMLeed53c

  3. Click Save

Now it is time to prepare your user account

  1. In Dynamics 365 for Operation click Settings (the little gear in the top right corner) – User options – Account –  Email Provider Selection
  2. Set Email provider SMTP and set an email adress.

    SNAGHTML1038418

To enable alerts for a batch job:

  1. Go to System Administration – Inquiries –  Batch Jobs
  2. Click BATCH JOB – Alerts
  3. Check the Alerts you want to send and check Email and verify your email adress

    SNAGHTML108bc56