Dynamcis AX 2012 CU6

The last CU update version for AX 2012 R2 was CU1 and the latest version is CU6. Wondering if you have missed a lots of updates in between have no concern. Microsoft is consolidating all versions of the AX 2012, FP & R2, so the next updates would be in a single sequential series rather than individual updates for each version. So it is perfectly ok to update your new AX 2012 R2 instance to CU6 after the CU1.

The direct partnersource link for the downloading the update is at https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb%3ben-us%3b2850972

The version of the application will be set to 6.2.1000.1437, which means
6 - Dynamics AX Major Version

2 - Minor Version
1000 - Build Number
1437 - Revision released for CU 6

UtilElements Table - SQL Database Error

SQL Error Message:

 "Cannot select a record in Application Model (UtilElements). The SQL database has issued an error. SQL error description: [Microsoft][SQL Server Native Client 10.0][SQLServer]"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90."

SQL statement: SELECT T1.NAME,T1.RECORDTYPE,T1.PARENTID,T1.UTILLEVEL,101090 FROM UTILELEMENTS T1 WHERE ((RECORDTYPE=?)

AND (NAME=?)) OPTION(FAST 20)

Reason:

UtilElements table is not properly synchronized with the DB server, this issue is most likely to occur when you are transferring and restoring AX in another environment or server. To fix you would need to re-initialize the model store schema. Can be achieved by using either Powershell or AxUtil commands

Resolution:

Power Shell Command(Preferred for AX 2012 R2)

Start the Dynamics AX 2012 Powershell window

Initialize-AXModelStore

AXUtil Command(esp AX 2012 RTM)

Start MS command prompt and navigate to the axutil exe location, it is normally available at

C:\Program Files\Microsoft Dynamics AX\60\Server\AXR2_DEV\bin or under Management utilities,  then execute the below command

Command :- axutil schema

Shrink the Dynamics AX Database Log Files

The Database log(.ldf) can be shrunk to recover some of the disk space on the DB server. Just ensure you have appropriate backups of the data file(.mdf)

The command can be executed when the database recovery option is set to Simple. The recovery option can be found under Database Properties > Options > Recovery Model

Just be mindful these settings should not be changed in the production without consulting DBA as it will affect the recovery time incase of a crash. More appropriate to do it on Test or Development machines to catch up on disk space.

Use <DatabaseName>

GO

DBCC SHRINKFILE(Database_Log,100)

GO

The first parameter is the logical name for the DB log, which can be found from the Database Properties > Files > Logical Name Column. The second parameter is for size in MB to be set.

Microsoft Dynamics AX Build numbers and Versions

A single place to look up for all the versions released and build numbers, extremely useful if you are doing an upgrade and wanted to know the Hot fixes/Cumulative updates/Application/Kernel build numbers installed. Refer here http://blogs.msdn.com/b/axsupport/archive/2012/03/29/overview-of-ax-build-numbers.aspx