Creating New Tables

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.

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.

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

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?

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).

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