Cannot select a record in Customers (CustTable). Name: 0. The SQL database has issued an error.

After Compiling AX 2012 R2 Application i started getting this error for all forms and card “The SQL database has issued an error.”

After searching for this issue is related to DB sync after compiling, i followed below steps which solved my problem

“Admin – Periodic – SQL administration – Table Actions – Synchronize database”