AX 2012 Forms and .NET Business Connector Produce Error with SQL Server 2012 because of Deprecated FASTFIRSTROW Hint

Our application logs into AX2012 using business connector. I have upgraded from SQL Server 2008 R2 to SQL Server 2012. We have applied the hotfix 2680186 for AX2012 compatibility with SQL Server 2012.

The application fails when trying to login to AX using business connector. This is the error encountered:

 

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][SQL

Server]"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)

 

I cannot modify the view in my application. Furthermore, these are in AX tables, which we are not allowed to modify on customer end. What is the workaround to login to AX? The AX forms error out too with the same error.

  • The issue here is “"FASTFIRSTROW" is not a recognized table hints option”. 

     

    Microsoft is making this more clear in their documentation but the short version is you need to run the following command in Microsoft Dynamics AX 2012 Management Shell

    -----

    Axutil schema

    -----

    That will go through and update your schema and correct the FASTFIRSTROW hint.

  • In reply to Todd Pierpoint:

    Hi,

    I am also facing the same problem and i ran that command also but still it is showing the same error.

    Is there any other way to resolve it?

    Thanks in advance...

     

  • In reply to Ven:

    HI,

    M also gettiing same issue.We have changed Database schema and Axutil schema Command also we excuted.

    Still issue persists.

    Let me know if any recommended solution..

     

    Thanks in advance

Related
Recommended