AX 2012 Cumulative Update 3

For main link on Microsoft website click here. 

Live id required for logging in to Partnersource/CustomerSource

Microsoft Dynamics AX 2012 Cumulative Update 3 release notes

Installation

Update database schema

In the following cases, we recommend that model database schema is updated to the latest version in model database instances to which Microsoft Dynamics AX 2012 Cumulative Update 3 has to be applied:

• The model database is customized.
• The environment is running SQL Server 2012
• The environment is running SQL Server 2008 without any customizations applied to avoid potential issues during update installation.

To update database schema, follow these steps:

1. Make sure that the Management Utilities component is installed by using Dynamics AX 2012 or Dynamics AX 2012 Feature Pack 1 installation package.
2. Apply the update to the Components item by using the Dynamics AX 2012 Cumulative Update 3 package.
   
   Important Note Do not apply database updates at this point.
3. Run the following command:
   
   axutil.exe schema /db:target model database name
   
   Note Axutil.exe is installed with the Dynamics AX 2012 Management Utilities to the C:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities folder. You can start it by running the Administrative Tools control panel item and then clicking Microsoft Dynamics AX 2012 Management shell.
4. Apply Dynamics AX 2012 Cumulative Update 3 to the model database.

You receive SQL errors during compilation

Assume that you upgrade from Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 with Feature Pack 1 to Microsoft Dynamics AX 2012 Cumulative Update 3, or from Microsoft Dynamics AX 2012 Cumulative Update 2 or Microsoft Dynamics AX 2012 Cumulative Update 1 to Microsoft Dynamics AX 2012 Cumulative Update 3. After you apply the cumulative update, as a part of upgrade, you are prompted to run the software update checklist through the Model Store Modified form when you first start the client. You can also start the software update checklist directly. To do this, click System Administration, click Setup, click Checklists, and then click Software Update Checklist.When you perform compilation in the checklist, you receive the following error message that reports that update statement conflicts in the dbo.model table:

Cannot execute a stored procedure. The SQL database has issued an error.

 

To resolve this problem, follow these steps:

1. Restore a database backup of the environment.
2. Make sure that the Management Utilities component is installed by sing Dynamics AX 2012 or Dynamics AX 2012 Feature Pack 1 installation package.
3. Apply update to the Components item by using the Dynamics AX 2012 Cumulative Update 3 package.
   
   Important note Do not apply the application update at this point.
4. Run the following command:
   
   axutil.exe schema /db:target model database name
   Note Axutil.exe is installed with the Dynamics AX 2012 Management Utilities to the C:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities folder. You can start it by running the Administrative Tools control panel item and then clicking Microsoft Dynamics AX 2012 Management shell.
5. Apply Microsoft Dynamics AX 2012 Cumulative Update 3 to the model database.