I have imported a model in Microsoft Dynamics AX 2012 R3 CU9 enviornment and model was imported successfully without any error but when i tried to open customized table or form developed in new Model then it throws me an error
Cannot select a record in Students (CMCStudent). Name: 0. The SQL database has issued an error.
when i executed query at SQL of database MicrosoftDynamicsAX then found table CMCStudent does not exists that why AX tries to access table CMCStudent that does not exist in DB yet.
I googled multiple places and everyone suggested to perform “Administration – Periodic – SQL administration – Table Actions – Synchronize database” but its didn’t work for me.
1.Administration – Periodic – SQL administration – Table Actions –Select Table->Generate SQL scripts->…. for creating tables.
it will generate a script that you can use to add the selected tables to the database
2.Execute SQL script generated by step 1 on Dynamics AX database
3.Now restart AX service and try to open form related to table or browse table.You will be able to open table without any error.
Happy Daxing. 🙂