Friday, September 27, 2013

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

No comments:

Post a Comment