Table synchronization issue – Cannot select a record in table

We may get this below error message sometimes when we remove the existing field.

My case I have removed the field “TestField”. After I removed the field, I got the below error message when I open the form.

That form using my modified table as form data source. After I removed the field the synchronization is not happened correctly. So, I right clicked the modified table and clicked synchronize. It worked.

If the above solution is not working, then you may need to do the full DB synchronization.

Error message:
Cannot select a record in Hari_TestTable (Hari_TestTable).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'TESTFIELD'.
SQL statement: SELECT T1.MODIFIEDDATETIME,T1.MODIFIEDBY,T1.CREATEDDATETIME,T1.CREATEDBY,T1.RECVERSION,T1.PARTITION,T1.RECID FROM HARI_TESTTABLE T1 WHERE (((PARTITION=?) AND (DATAAREAID

Unretrieved value in form field

Unretrieved value in form field

When we add new fields in the table, it will synchronize with database and new fields will be created in SQL table. Sometimes, In the form level we couldn’t see newly added field value, instead it will show the value "Unretrieved”.

If we check table browser, it will show the correct value. To refresh the form field value, we need to select the field and press the Ctrl+F5.

To resolve this issue, we can do the following steps.

1. Tools -> Caches -> Refresh elements
2. If the first point is not resolve this issue, restart the AOS. Restarting AOS will resolve this issue. My case first point not worked.

Disk space - error message "Error in file - while writing in record"

Windows error “Error in file” message when we open AX rich client application

Sometimes, we will get this below error message. It is coming because of AX AOS server’s disk space issue. My case it is showing C:\ drive. To resolve this issue, we need to clear disk space.

Error message:
---------------------------
Warning
---------------------------
Error in file: C:\Users\Hari~1\AppData\Local\Temp\$tmp00030007.$$$ while writing in record = 5FE00
Windows error:  =
Error code: 112 = Unknown error

Try again?

---------------------------
Yes   No
---------------------------