RSS

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

14 Jun

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.

Solution:

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

SQL Error1.PNG

 

2.Execute SQL script generated by step 1 on Dynamics AX database

sql error 2.PNG

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. 🙂

 

 

 

Advertisements
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: