Blog - Page 18 of 20

14 10, 2015

SQL data compression for Dynamics AX 2012 (Part 1)

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

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…)

7 10, 2015

SysOperation Framework Data contract parameter name

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

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…)

7 03, 2013

TFS 2010 List of deleted AX XPO files

By DAXRunBase|2015-11-23T17:50:18+01:00March 7th, 2013|Categories: TFS|Tags: AX 2009, AX 2012, C#, deleted files, TFS, XPO|0 Comments

Recently our company had a need to create a clean TFS project for a new AX environment, and I have found out that there is no simple way of listing objects that were deleted from the repository. We had to make sure that these objects do not land in the new AX environment, so I had to figure out how to collect these objects.

I came across this blog post on how to use the Team Foundation Server API in .Net C#, which turned me in the right direction to be able to list the deleted XPO files:
http://blogs.microsoft.co.il/blogs/shair/archive/2011/08/03/tfs-api-part-39-show-deleted-items-in-source-control.aspx

(more…)

12 12, 2012

Silent metadata synchronization

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

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…)

30 11, 2012

Team Foundation Server and AX labels

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

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…)