Database SQL sync not working in AX2009

Created table ArchSetBack and when accessing it recreived the following error:

Error Message (01:18:18 pm) Cannot select a record in Arch Fraction (ArchSetback). Input fraction: , .

The SQL database has issued an error.

Info Message (01:18:18 pm) SQL error description: [Microsoft][SQL Native Client][SQL Server]Invalid object name ‘ARCHSETBACK’.

Info Message (01:18:18 pm) SQL statement: SELECT A.INPUTFRACTION,A.OUTPUTFRACTION,A.DECIMALFRACTION,A.RECVERSION,A.RECID FROM ARCHSETBACK A WHERE ((DATAAREAID=?) AND (OUTPUTFRACTION=?)) ORDER BY A.DATAAREAID,A.INPUTFRACTION

The DBA tried Admin - Periodic - SQL administration - Table Actions - Synchronize database from the application but says it froze for hours.

Any ideas as far as the next step?

K

Try to synchronize tables one by one:

Dictionary dict = new Dictionary();
TableId tableId;
;

setPrefix("DB synchronization");
tableId = dict.tableNext(0);

while (tableId)
{
    setPrefix(tableId2Name(tableId));
    try
    {
        appl.dbSynchronize(tableId, false);
    }
    catch {}
    tableId = dict.tableNext(tableId);
}

That was a good solution. I ended up with a simpler one, right clicking the table in the AOT and picking ‘sync’ from the choices, i didnt know it was there. Thanks!