8 Common Errors in Dual-write

• 502 Bad Gateway: when the target application is not ready to handle the incoming request 
• 401 Unauthorized / 403 Forbidden: This error occurs when there is a permission issue
• 503 Service Unavailable: This error occurs when the application is down 
• 400 Bad Request: This error occurs when Dynamics 365 FO is restarting 
• 429 Too Many Requests: This error occurs when there is throttling 
• Application Error: when there is a Data validation error happening in the background 
• Any other HTTP Error: Any other errors related to the HTTP tagged to this type of error category

POSTMAN D365

 Postman is useful to test the behavior of different OData class from/to D365FO. In this post we will see the steps to setup Postman with D365FO.

Step 1: Register D365FO in Azure Platform. Please refer to previous post to view the steps for App registration.

 Application registration of D365FO with Azure 

Step 2: Launch Postman and create a new collection and give a name (say) Devbox.

Step 3: Click on the three dots and click on Add request of type POST and name the request as Authorization.

Step 4: Capture the TenantId from the Azure portal and POST command would be

https://login.microsoftonline.com/tenantId/oauth2/token

Step 5: Select tab Body and click on form-data radio button.

Step 6: Provide below details in the Body tab

Key	Value
client_Id	ClientID value from Azure portal after App registration.
grant_type	client_credentials
resource	D365FO URL
client_secret	Client secret value from Azure portal after App registration

Step 7: Click on Send button to receive the access token with status as 200.

This completes the Postman setup with D365FO.

Reference: https://dynamics365musings.com/setup-postman-to-call-d365-data-entities/

Debug the Sandbox/Test environment in D365FO

 Above mentioned steps can be reduced to only one step i.e refresh of production DB to sandbox via LCS and later we can connect to sandbox environment directly from the development environment for debugging using below guide

Time required 20 minutes.

Steps

1. Enable access for your IP address

   Go to lcs ->sandbox environment page. To connect to test environment RDP, you need to create Whitelist rule for your IP address 

2. Connect RDP and open SSMS
   

   Connect to SQL server using Server name from LCS and add the prefix to SQL server name – servername.database.windows.net

3. Create a new query to test DB

   Below query will create a new user that will be used for debugging
   CREATE USER devtempuser WITH PASSWORD = ‘pass@word1’
   EXEC sp_addrolemember ‘db_owner’, ‘devtempuser’
   
   

4. Whitelist your IP address

   Select new query against Master DB
   exec sp_set_firewall_rule N’DEVNAME’, ‘IP’, ‘IP’ 

5. Stop IIS, WWW service and Batch Service

   Open IIS and stop the service. Open run and enter services.msc and stop WWW and Microsoft D365 batch service
   

6. Edit Web config

   Go to C:\AosService\webroot\web.config and save the original file somewhere else as backup. Modify 4 Keys as per the below screenshot.
   You can either comment original configuration or delete it and add new configuration of the sandbox environment

7. Start IIS and WWW services

   Start IIS and WWW service stopped in step 5. Don’t start batch service.
   

8. Open the development environment AX URL

   If you get 503 unavailable error, go to CMD(as admin) and type IISRESET
   

9. Debug

   Now sandbox environment is connected to your development environment. You can simply open Visual studio to add breakpoints to X++ object and attach w3wp.exe service to debug.

10. Thanks Pawan Deep SinghI 

11. Reference: https://axparadise.com/how-to-debug-the-sandbox-test-environment-in-d365fo/

cannot create a record in customers (custtable the record already exists)

Go to SQL as Admin, AXDB database:

pass your table(Custable) and run below query:

DECLARE @MaxRecID BIGINT

DECLARE @NextVal BIGINT

 

SELECT @MaxRecID = MAX(RECID)

FROM custtable

 

SELECT @NextVal = NEXTVAL

FROM SYSTEMSEQUENCES

INNER JOIN SQLDICTIONARY

ON SQLDICTIONARY.FIELDID = 0

AND SQLDICTIONARY.name = 'custtable'

AND SQLDICTIONARY.TABLEID = SYSTEMSEQUENCES.TABID

 

IF (@NextVal > @MaxRecID)

BEGIN

PRINT 'custtable did not need to be updated.'

END

ELSE

BEGIN

PRINT 'Updated custtable from ' + CONVERT(VARCHAR(MAX), @NextVal) + '' to '' + CONVERT(VARCHAR(MAX), @MaxRecID + 1)

UPDATE SYSTEMSEQUENCES

SET NEXTVAL = @MaxRecID + 1

FROM SYSTEMSEQUENCES

INNER JOIN SQLDICTIONARY

ON SQLDICTIONARY.FIELDID = 0

AND SQLDICTIONARY.name = 'custtable'

AND SQLDICTIONARY.TABLEID = SYSTEMSEQUENCES.TABID

END

Creating new D365FO Business Event for Customer & CRUD notifications using Power Automate.

Main contract class: 

// This is a BusinessEventContract class for Customer

/// </summary>

[DataContract]

class VKCustTableBusinessEventContract extends BusinessEventsContract

{

    SysAppCRUDOperation                action;

    CustAccount                        custAccount;

    DataAreaId                        dataAreaId;

 

    private void initialize(CustTable _custTable, SysAppCRUDOperation _action)

    {

        custAccount    = _custTable.AccountNum;

        dataAreaId    = _custTable.DataAreaId;

        action        = _action;

    }

 

    /// <summary>

    /// Create new VKCustTableBusinessEventContract from CustTable and action

    /// </summary>

    /// <param name = "_custTable">CustTable table</param>

    /// <param name = "_action">Action</param>

    /// <returns>a new VKCustTableBusinessEventContract</returns>

    public static VKCustTableBusinessEventContract newFromCustTable(CustTable _custTable, SysAppCRUDOperation _action)

    {

        VKCustTableBusinessEventContract    contract    = new VKCustTableBusinessEventContract();

        contract.initialize(_custTable, _action);

        return contract;

    }

 

    protected void new()

    {

    }

 

    [DataMember('CustAccount'), BusinessEventsDatamember("CustAccount")]

    public CustAccount parmCustAccount(CustAccount _custAccount = custAccount)

    {

        custAccount = _custAccount;

        return custAccount;

    }

 

    [DataMember('Action'), BusinessEventsDatamember("Action")]

    public SysAppCRUDOperation parmAction(SysAppCRUDOperation _action = action)

    {

        action = _action;

        return action;

    }

 

    [DataMember('DataAreaId'), BusinessEventsDatamember("DataAreaId")]

    public DataAreaId parmDataAreaId(DataAreaId _dataAreaId = dataAreaId)

    {

        dataAreaId = _dataAreaId;

        return dataAreaId;

    }

 

}




Business event class:

/// <summary>

/// This is a BusinessEvent class for Customer

/// </summary>

[BusinessEvents(classStr(VKCustTableBusinessEventContract),

    "Customers CU",

    "Event for create, update",

    ModuleAxapta::General)]

class VKCustTableBusinessEvent extends BusinessEventsBase

{

    private CustTable custTable;

    SysAppCRUDOperation action;

 

    /// <summary>

    /// Create new VKCustTableBusinessEvent from CustTable and action

    /// </summary>

    /// <param name = "_custTable">CustTable table</param>

    /// <param name = "_action">Action</param>

    /// <returns>a new VKCustTableBusinessEvent</returns>

    public static VKCustTableBusinessEvent newFromCustTable(CustTable _custTable, SysAppCRUDOperation _action)

    {

        VKCustTableBusinessEvent businessEvent = new VKCustTableBusinessEvent();

        businessEvent.parmAction(_action);

        businessEvent.parmCustTable(_custTable);

        return businessEvent;

    }

 

    private CustTable parmCustTable(CustTable _custTable = custTable)

    {

        custTable = _custTable;

        return custTable;

    }

 

    private SysAppCRUDOperation parmAction(SysAppCRUDOperation _action = action)

    {

        action = _action;

        return action;

    }

 

    protected void new()

    {

    }

 

    [Wrappable(true), Replaceable(true)]

    public BusinessEventsContract buildContract()

    {

        return VKCustTableBusinessEventContract::newFromCustTable(custTable, action);

    }

 

}

Extension to CustTable table to trigger insert/update events:

/// <summary>

/// Extension class for Custtable table

/// </summary>

[ExtensionOf(tableStr(CustTable))]

final class VKCustTable_Extension

{

    public void insert(DirPartyType _partyType, Name _name,boolean _updateCRM)

    {

        next insert(_partyType, _name, _updateCRM);

 

        if (BusinessEventsConfigurationReader::isBusinessEventEnabled(classStr(VKCustTableBusinessEvent)) && !CustTable::vkSkipByUserFilter())

        {

            VKCustTableBusinessEvent::newFromCustTable(this, SysAppCRUDOperation::Create).send();

        }

    }

 

    public void update(boolean _updateSmmBusRelTable, boolean _updateParty)

    {

        next update(_updateSmmBusRelTable, _updateParty);

 

        if (BusinessEventsConfigurationReader::isBusinessEventEnabled(classStr(VKCustTableBusinessEvent)) && !CustTable::vkSkipByUserFilter())

        {

            VKCustTableBusinessEvent::newFromCustTable(this, SysAppCRUDOperation::Update).send();

        }

    }

 

    /// <summary>

    /// Whether to skip sending business event or not

    /// </summary>

    /// <returns>true to skip sending BE</returns>

    public static boolean vkSkipByUserFilter()

    {

        boolean ret = false;

 

        // Use there real user id, which will be used for integration to avoid triggering update business event when external system updates the entity

        if ('Admin' == curUserId())

        {

            ret = true;

        }

 

        return ret;

    }

 

}

Configuration:

- Build

- System administration / Setup / Business events / Business events catalogue

- Manage / Rebuild business event catalogue

You should be able to find your Business Event in the list in specified category 

Power Automate:

- Create new

- Automated cloud flow

- Set Flow name and click Skip button

- In Search input type "Dynamics"

- Select Fin & Ops Apps

- Select Whan a Business Event occurs

- Select three dots in the right top corner and in My connecions section select "Add new connection"

- Select Connect with service principal

- Fill in Connection name, Client ID, Client Secret and Tenant (which is Licensed to in D365FO About)

- Select three dots in the right top cornerand choose corrrect connection

- Select right Instance

- Select General as Category

- Select Customer CU as Business event

- Add new step

- Type "Parse JSON" in search input

- Select "Parse JSON"

- Set body of previouse step as a Content

- Click Generate from sample button and pase there Schema from Business event (System administration / Setup / Business events / Business events catalogue / find the record / click Download schema button)

- Add additional steps with required actions

Troubleshooting:

There is a bug in Power Automate that it is not possible to select your business event if you place it in a category with existing standard business events, for example "Accounts Receivable". It shows duplicating record in the category dropdown and then there is no option to select your newly created business event:

Category dropdown:

Reference: : https://www.youtube.com/watch?v=my155UP0Wmg