Cannot select a record- Microsoft Dynamics


When select a record in Micorosoft dynamics The SQL database has issued an error. Error occurs  -------- Cannot select a record in Items (InventTable). Item code: , . The SQL database has issued an error.


Open  Sql database but in invent table shown record but dynamics cannot fetch this.

In this case I get a one solutions mentioned below
>> after  Run a full database sync on all of my tables dynamic fetch the record successfully

Below mention steps of how to sync full database on all tables 

1) Open a Microsoft Dynamics
2) Go to  Administration   see below snap of this steps

3)Select under Periodic >SQL administration
see below snap of this steps

4)Select All Tables > Table action and click on Synchronize database
see below snap of this steps
after sync successfully fetch records from SQL.


Related Post

Next
Previous
Click here for Comments

0 comments: