Skip to content
Microsoft Dynamics 365

Data Management: Missing Entities 

If you find that you are missing entities listed in the Data entities form, you can try the following steps. Run the following SQL Script: — — This source code or script is freeware and is provided on an “as is” basis without warranties of any kind, — whether express or implied, including without limitation...

Read more

Improved High Availability Support for SQL Clusters 

[Updated March 31 2017 for R2 Kernel] The following kernel hot-fixes for Microsoft Dynamics AX 2012 R3 and R2, KB 3141722 (R3) & KB 4017756 (R2) , improve the way we handle the tables created in TempDB. As you may be aware, TempDB is a transient database, that means when SQL is started or after a cluster...

Read more

Microsoft Dynamics AX 2012 Upgrade – Using the State Transfer Tool with AX 2009, you can potentially have duplicate records created within table Shadow_DirPartyRelationship 

  This specific issue occurs only when using the state transfer tool in AX 2009. The problem is as follows: We create new records in the Shadow_DirPartyRelationship. The unique index on this references RefRecId. The RefRecId will become the RecId for DirPartyRelationship during the bulk copy in AX 2012. We use the SystemSequences NextVal from...

Read more

You may get message “Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics” during an upgrade or in-place upgrade with Microsoft Dynamics AX 2012 

This error message can be a little misleading as it implies that it is related to some security permissions not being configured correctly. In some cases this can be the case, however it can also be a problem with running CIL code. This can especially occur when you are going through the code upgrade steps....

Read more

Capturing an AX User’s SQL SPID over multiple AOS servers in AX 2009 

Resolving a SQL SPID to an AX user can be useful when trying to diagnose performance or blocking issues on the database server. As some of you are aware, in AX 2012 it is now possible to track an AX user to a specific SQL SPID. This is documented here: http://technet.microsoft.com/en-us/library/hh699644.aspx As you are also...

Read more