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.
No comments:
Post a Comment