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

Dynamics AX Retail Store DB is not able available

A quick post on troubleshooting issues for the connectivity between the AX 2012 Retail POS and Store DB.   

This error thrown by the application is "Dynamics AX Retail Store DB is not able available", You might run into this issues especially if the components communicating are located in different domains. 

Check first the POS config file, focus on the value for the StoreDataBaseConnectionString attribute. If you think that the issue might be due to domain issues, complete avoid the Domain authentication and try to leverage on the SQL login id/password in the connection string.

Example:- 

<?xml version="1.0" encoding="utf-8"?>

<configuration>

    <configSections>

        <section name="AxRetailPOS" type="LSRetailPosis.Settings.ConfigFile.AppConfiguration, SystemSettings, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856adxxxxxx" />

    </configSections>

    <AxRetailPOS OfflineDatabaseConnectionString="" StoreDatabaseConnectionString="Data Source=XXXXXX;Initial Catalog=AXRetailXXXX;User id=sa;Password=XXXXXX"

        StoreId="Store" TerminalId="Term-01" DATAAREAID="CERW" />

</configuration>

I have left just the important settings in the connection string like Server name, Database name, SQL Id and Password.

Now if you notice that the application connects to the database properly work with your networking team to identify and resolve the domain authentication failure issue. And finally make sure to change back the settings in the config with the appropriate security level.

Cumulative Update 1 (KB2807685) Released for AX 2012 R2

Cumulative update 1 for the Dynamics AX 2012 R2 has been released. It is very important to download and update this fix for your AX 2012 R2 environments as it has all the previous hotfixes for the known issues resolved in this cumulative update.

As usual the Cumulative update is accessible via Partnersource or Customersource, for complete release notes, setup installation and the hotfixes covered, visit the CU1 release page.

There will be two self extracting Exe's for this Cumulative update, one for Binary files and the second one for the Application. After the environment is update with CU1 the build number would be 6.2.1000.156

Release of Cumulative update 4 for Dynamics AX 2012 & R1

Just around the launch of Dynamics AX 2012 R2, coincidentally we have the latest Cumulative update 4 (KB2765124) for Dynamics AX 2012 and Dynamics AX 2012 Feature Pack. This update is very important as it includes all other cumulative updates and hot fixes that were previously available. This is mainly important for Customers who are about to deploy AX 2012 and to secure them with all the issues that were resolved in that release. Do note that this CU4 release is not applicable for Dynamics AX 2012 R2, and it would have it's own releases for Cumulative updates.

The original details of the Dynamics AX 2012 was released on Dynamics AX Sustained Engineering Team

Ironically the release for the new Cumulative update is not available in the List of all Hotfixes/Cumulative updates for AX 2012 page until now, hope they consolidate it in one location.

Here is the direct link to download the AX 2012 CU4 from Partnersource