Interview Questions

Tuesday, October 24, 2017

How to find SQL server version through AX 2012

Hi All,

If any person wants to check SQL server version through AX then please follow below path:

Go to: System Administration > Inquiries > Database > Database information.
Open that form and go to ODBC tab and find DBMS _VER.

Monday, October 23, 2017

"Argument to method getfieldValue out of range" error in DMF in AX 2012

Hi All,

If any person will find error "Argument to method getfieldValue out of range" then we need to fill "Title Field 1 and Title Field 2" table properties of staging table created in private project:


It will solve your error.

Sunday, October 22, 2017

"SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'AX2012R2CU6_model.dbo.SYSMODELELEMENT" error while selecting table in lookup in ax 2012

Hi Guys,

If any person is getting error related with SQL:
"SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'AX2012R2CU6_model.dbo.SYSMODELELEMENT"

Then for this error we need to compile a "View" from AOT named "DMFModelElement".
It will solve your issue.

Other alternates is "Reinstall the DMF tool". (But in many cases this solution didn't worked)