Friday, 3 August 2012

Installing AX 2012 with SQL Server 2012 - Model store schema creation or update failed

When trying to install Microsoft AX 2012 on Windows 2008 R2 running SQL Server 2012 I received a problem installing the Database element

The error in the Windows Application View was as follows:

AXUtil operation failed : Schema

Model store schema creation or update failed.
 

"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.

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.


To resolve a Hotfix was required to be installed and a patch copied to the updates folder where the AX 2012 Installation files are kept. This updates the AXUtil version to 6.0.1108.152

Request and download the Dynamics AX hotfix  2680186 from Microsoft using the link below.  You will need a login to the Microsoft Partnersource website

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2680186

2 comments:

  1. Just FYI - After applying / installing this patch on the AOS server, the Enterprise Portal stopped working with an error -
    ===============================
    Error

    An unexpected error has occurred.


    Troubleshoot issues with Microsoft SharePoint Foundation.

    Correlation ID: e4af85df-1d07-4c6c-a49e-d8eeb7862856

    Date and Time: 10/30/2012 11:20:26 AM

    Go back to site
    ===============================

    I re-ran the SharePoint setup to repair it and was able to bring it back into previous working state but this problem "FASTFIRSTROW is not a recognized table hints option." remains! Any thoughts?

    ReplyDelete
  2. Hi, thanks for sharing this post with us. Installing Microsoft Dynamics can appear complicated to a person who doesn't have much knowledge in IT. But hey, there's always support team who will do the work for you.
    In my case, the software works great - the dynamics 365 development is significant and it will help your company grow fast.

    ReplyDelete