Tech hub

technolgy,education ,health,entertainment,windowstips,smartphone tips and tricks,android tips and tricks,iphon

Join Us

ads
Responsive Ads Here

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.


No comments:

Post a Comment