X++ Archives - Page 8 of 9

Find missing objects behind menu items

As part of our code cleanup exercise we have discovered that there were menu items pointing to objects which no longer exists in our environments, ie. legacy reports which were upgraded to SSRS but their menu items were never removed.

The following job could be used to identify such missing objects for any of your menu items. I would also recommend to double-check the xRef references to find connected objects, like security privileges/roles, to completely remove whatever you do not need.

(more…)

By DAXRunBase|2015-11-23T17:42:08+01:00October 27th, 2015|Categories: AX 2012|Tags: AOT, AX 2012, menu items, migration, X++, xRef|0 Comments

SQL data compression for Dynamics AX 2012 (Part 1)

Data compression for tables and indexes are beneficial, especially for large tables within your SQL DB, where you are doing more read operations than writes. In Microsoft Dynamics AX you are advised to do this via the client, otherwise your settings would be lost during the Data Synchronization.

Unfortunately there is another case of hardcoded value from Microsoft, the SysSQLSetupHelper class is checking the version and the edition of SQL Server. Since Compression is a feature supported by version SQL Server 2008 (v10) and up, the code needs to be changed to cater for SQL 2012+ as per below:

(more…)

By DAXRunBase|2015-11-23T17:46:24+01:00October 14th, 2015|Categories: AX 2012|Tags: AX 2012, compression, metadata, SQL, synchronize, tables, X++|1 Comment

SysOperation Framework Data contract parameter name

With so many new AX 2012 R3 implementations and upgrades and the soon-to-be-released AX 7 (Rainier) around the corner I thought it is time to get back in business to publish interesting articles, now using a new home for hosting my blog:

http://www.daxrunbase.com/

It is always recommended to write best practice error-free code, however in some cases Microsoft forces our hands to fall back to hardcoded values. This is the case with today’s topic as well, when we would like to override values in a SysOperation Framework Data contract.

The SysOperationServiceController.getDataContractObject() method has an optional parameter, where they expect the value of ‘_dataContract’ in the example below. However we can choose to refrain from hardcoding and extract the value with Reflection.

(more…)

By DAXRunBase|2015-11-23T17:49:00+01:00October 7th, 2015|Categories: AX 2012|Tags: AOT, AX 2012, Global, SysOperation Framework, X++|0 Comments

Silent metadata synchronization

When we use the Microsoft Dynamics AX command line parameters to trigger a startup command with running the client, it is a very common situation that our metadata is altered.

There could be many scenarios where the metadata change requires user interaction (like a possible index violation, removing fields, etc) on a form, where you could review the changes before it is permanently committed to the database. This is not ideal if you would like to do automated tasks, like running a workflow step on a Team Foundation Server build controller (code / metadata synchronization, XPO import).

Fortunately there is a way of suppressing this user interaction, by setting a global variable.

(more…)

By DAXRunBase|2015-11-23T17:51:14+01:00December 12th, 2012|Categories: AX 2012|Tags: AOT, AX 2012, cache, metadata, synchronize, tables, TFS, X++|0 Comments

Team Foundation Server and AX labels

Today we will cover the topic of using labels with the Team Foundation Server (TFS) as our Microsoft Dynamics AX Version Control System (VCS).

If you set up a new environment from scratch and your repository is empty, you can import your existing ALD label files to AX and add it to VCS in 2 easy steps.

1) You may use the standard “ALDImport” startup command with the AX client and pass in your labels one by one, or use the following code to import all files from a specific folder with the help of .Net managed code:

(more…)

By DAXRunBase|2015-11-23T17:52:10+01:00November 30th, 2012|Categories: TFS|Tags: ALD, AOT, AX 2009, AX 2012, label, TFS, X++|0 Comments