Tips and Tricks for Microsoft Dynamics AX, now Microsoft Dynamics 365 for Finance and Operations, also formerly known as Dynamics AX 4.0, 2009, 2012 and even Axapta.
Monday, February 5, 2018
AX 2012 Database Synchronization Warnings and Errors
After making a change to the data dictionary AX will synchronize to the SQL database. If you have turned off configuration keys the window which pops up shows many warnings, most of which can be ignored every time. How do you know which of the warnings should be reviewed?
Open SQL Server and run the following command. It lists the warnings and errors in one consolidated grid and it ignores any configuration key warnings which can be disregarded.
select TableName,
[Text],
ID,
ParentID,
case MessageType
when 0 then 'Header'
when 1 then 'Warning'
when 2 then 'Error'
else Convert(nvarchar(5), MessageType)
end as MessageType,
SyncTable,
WarningOK,
[Sequence]
from SqlSyncInfo
where MessageType <> 0 -- remove headers
and [Text] not like '%disabled%' -- disabled configuration keys can be ignored
order by MessageType, [Sequence]
Thursday, February 1, 2018
Performance Tweaks for AX2012 Demo VM
Open the VM Profile Manager within the VM, and change the default profile to "AX2012Minimum."
Look at VM profile to see what order it starts and stops things. Take note and disable anything you do not plan on using.
Enable SQL Trace flags T4136 and T4199.
Disable SharePoint Search and Timer, and/or the services themselves (especially if you are not planning on using Enterprise Portal.
Look at VM profile to see what order it starts and stops things. Take note and disable anything you do not plan on using.
Enable SQL Trace flags T4136 and T4199.
Disable SharePoint Search and Timer, and/or the services themselves (especially if you are not planning on using Enterprise Portal.
Subscribe to:
Posts (Atom)