Index fragmentation on xRef tables

Building cross-references for code in Dynamics AX creates millions of records in xRef tables. It has also very negative impact on fragmentation of database indexes. This is an example of indexes on xRefReferences table from a customer’s environment after rebuilding all cross references. And here the same set of indexes a few minutes later after …

Continue reading ‘Index fragmentation on xRef tables’ »

Instrumentation and tracing

Regardless of how hard we try to write flawless software, sooner or later something goes wrong and we must identify where exactly the problem lies (to be able to fix it). One option is using the debugger, but it’s not always possible – we can’t reproduce the problem, for example. Another way is inserting some …

Continue reading ‘Instrumentation and tracing’ »

«Expr» in SSRS reports

Do you like report designs that look like this? Me neither. It may print the right data, but it’s difficult (= expensive) to maintain. Fortunately you can easily show something descriptive instead of «Expr». Right-click the value and pick Placeholder Properties… and type a description of the placeholder to Label: The designer will then display …

Continue reading ‘«Expr» in SSRS reports’ »

(In)valid conversion

X++ compiler is very benevolent when dealing with types – much more than it should be. It happily accepts code that can’t succeed at run-time, as I’ll will demonstrate in a minute. It’s unfortunate, because some errors could have been detected at compile-time and they aren’t. And that’s not all – the X++ runtime is …

Continue reading ‘(In)valid conversion’ »

Access denied: SysOperationServiceController

I unexpectedly got Access denied: SysOperationServiceController when trying to call a method through the SysOperation framework in Dynamics AX 2012. It was just a piece of research code and I didn’t want to bother with my own controller, therefore I created and executed a menu item with the following properties: Property Value ObjectType Class Object …

Continue reading ‘Access denied: SysOperationServiceController’ »