AX2009 database sql sync not working

kwmkwm
kwmkwm Member Posts: 13
edited 2013-05-09 in Dynamics AX
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

Categories