The SQL database has issued an error in AX 2012

Cannot edit a record in ***Table Name*** (***Table Name***). The SQL database has issued an error in AX 2012

 

When you add any customized fields in Table or created a new Table in AX, sometimes AX will show you this type of error.

Reason:

                This table is not getting full Synchronization is not completed. So that its getting this type of issue.

Solution:

                Synchronize the ***Table Name*** which table you are getting that same error.

Go to AOT >> DATA Dictionary >> Tables >> ***Table Name*** >> Right Click Synchronize button