tables

Improve AX performace by fixing bad Query plans

Sometimes the Purchase invoicing department has complained that posting took a very long time to complete. We could correlate this with the slow performing SQL statements alert explained in my previous post to identify the cause, now it is time to improve AX performace by fixing bad Query plans. My colleague, Peter Prokopecz provided some great insights on resolving this problem.

Either an AX trace, or the SQL alert could reveal the bad code. In our case it was the standard functionality of matching Tax transactions with the General journal entries, which can be found in \Data Dictionary\Tables\TaxTransGeneralJournalAccountEntry\Methods\create. It is a very large insert_recordset statement with multiple inner and exists joins:

taxtransgeneraljournalaccountentry

(more…)

By |2016-01-08T17:57:45+01:00January 8th, 2016|Categories: AX 2012|Tags: , , , , , , , , |4 Comments

AIF port changes without deactivating

For troubleshooting the Application Integration Framework in AX sometimes we have to enable logging of all XML document messages. However the AIF inbound ports cannot be edited by default without deactivating them first. It is a common misbelief that you need to do this.

If you deactivate and reactivate a port, in the background it just regenerates the server-side WCF settings in table AIFWCFConfiguration, that stores the XML string in a container field. Most of the values in there does not actually relate to a lot of fields that you should be able to change. In our case the LoggingMode field was in the scSC parent table of AIFPort.

What we could do instead of deactivating and reactivating our service in question to switch the logging on and off was to simply edit the record in the table browser, which does in fact take immediate effect and the logging will commence or get suspended once you save the row. Please keep in mind that for other fields such as user restrictions or service operations you should do your own research in a Test environment first to decide if it is safe to go ahead with the modification.

By |2015-11-23T17:43:17+01:00October 15th, 2015|Categories: AX 2012|Tags: , , |0 Comments