Creating New Tables

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hello,

Up until noon, I could create simple (new table + 1-2 fields) tables just fine. Now whenever I try to open the table, I get a critical error message:

  • Cannot select a record in Species (VetSpeciesTable4). The SQL database has issued an error.
  • SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name ‘NAME’.
  • SQL statement: SELECT T1.SPECIESID,T1.NAME,T1.RECVERSION,T1.RECID FROM VETSPECIESTABLE4 T1 WHERE
    (DATAAREAID=?) ORDER BY T1.SPECIESID OPTION(FAST 19)

I tried making a different one and got the same error message. After some closing and reopening my remote desktop, the first table works now.

Thanks so much in advanced.

2

You should synchronize the table (Right click on table name > Synchronize). This ensures that AX metadata and database objects are in sync; otherwise AX tries to access a field that doesn’t exist in database.

3

Hai

“Cannot select a record in Species (VetSpeciesTable4). The SQL database has issued an error.” - This is an synchronization error

Try to synchronize the table…It will solve Ur problem.

if u still get the error…then try to synchronize In the following way

DAT(UR company)/Administration(Module)—periodic—Sql Administration

Then select ur error table ----Synchronize there…If it is a new table then truncate it and synchronize it…It will definitely resolves the issue

4

Martin,

Thank you for the reply. I certainly synched, but no luck. It also seems to be what I enter in the “name” and “label” properties. I forgot there may be reserved words I cannot use?

5

This really looks as a synchronization issue. The message says that AX tries to select Name field from DB but it is invalid (i.e. the field doesn’t exist in database).

6

Got it. It was a little funky the day before, but it seems to work now. Thank you :slight_smile: