AX OLAP Cube Setup – Transaction Date not Saved

Today I saw an issue with the AX Cube definition manager not saving a new value for “Transaction date” on the measures tab. A user makes a change but when they go back to check it’s not saved. This only occurs when the user follows a specific sequence of actions, the steps to recreate and the solution…

1

Performance – SysDeletedObjects40 – Keep updated Objects

One of the key performance improvements that can be implemented for AX4 (and should apply to AX2009 also) is to disable the SysDeletedObjects40 (label is “keep updated objects” in en-us) configuration key. In older version of AX, memo fields were used on a lot of the main tables (memo field can cause performance issues), in…

1

Performance – memo/ntext fields

Performance issues in AX can be some of the most difficult to troubleshoot. Particularly as there’s so many different areas which can potentially be the cause/solution to the issue. This post will just talk about one of the potential causes of bad performance, no doubt we’ll cover some more performance issues in later posts. One…

1

AOT Query Browser – same as Table Browser

There is a really handy tool available from the axaptapedia site, it allows you to run a table browser type form against AOT query objects:If you’re creating queries in the AOT,it’s useful to be able to see the data they return before you go to the trouble of building the object that will use the…

1

AX Client Crashes on Startup

I had a problem where for a certain user the AX Client would crash on startup, because of the nature of the problem it was difficult to get in to debug to see what the cause was.After a bit of digging around it turns out that info.workspaceWindowCreated() was the source of the problem, some dodgy…

1

ODBC DSN not appearing 64 bit OS

This one had me stumpped for a bit, thanks to my colleague for getting to the bottom of this one. Running a 64 bit OS, set up an ODBC DSN, but can’t select it in my 32 bit application, which is of course the AX server configuration utility for AX4. This is weird because the…

2

AX Data Import Performance

This one comes up fairly often for me, importing a large volume of data into AX, it performs badly, what on earth can I do to make it faster?? Well there are a few options, here’s the details that I give to people when they ask: Optimise the dat file method of export/import, there are…

1

AOS Service out of memory

This week I saw an issue with an AOS which was consuming too much memory (~1.8gb) and then throwing users off.Put simply this was because in the server configuration utility, database tuning tab, the maximum buffer size was set too high. In my experience this is a commnon mistake. The field is actually held in…

2

Welcome!

To the EMEA AX Support team blog, hopefully you will this a valuable source of information as it develops over the coming weeks and months.

0