Synchronization enhancements in Dynamics Ax 2009

This post covers the Synchronization functionality in Dynamics Ax 2009 and some of the enhancements that were made from the previous release. Check Synchronize feature in Dynamics AX 2009 You may have noticed the changes when Synchronizing during Upgrade or maybe you have seen a Synchronize database form when making a change to an AOT table that would permanently…

0

Troubleshooting orphaned sessions and SPIDS in Dynamics Ax

After my last post was published I got some questions on how orphaned SQL processes (SPIDs) are cleaned up in Ax when an AOS or client crashes. A simple answer to that would be that the behavior is different depending on what crashed and what that process was doing at that instant of time. Let’s…

2

Troubleshooting blocked SPIDS in AOS

In this blog post I will provide some details on how the AOS server manages it SQL connections and some tips on troubleshooting blocked connections in the database. All of my description is based on the SQL Server backend but similar techniques are applicable for Oracle also, only the DB tools are different. Let’s first…

5

What’s new in Set based operations in Dynamics Ax 2009

   In this blog post we will provide some details on some of the enhancements that were added to the various set based operations in Dynamics Ax 2009. X++ language contains three operators for set based data manipulation: 1. INSERT_RECORDSET 2. UPDATE_RECORDSET 3. DELETE_FROM These operators have been significantly enhanced in Dynamics Ax 2009. This…

0