NAV 5.1 RU Testing of Database

nilesh20

Hello All,

I am doing Migration from 5.1 to 2009 R2 Russian Version.

for the first step i want to test the database.

but i get the Error like

---

Microsoft Dynamics NAV

---

The Item table has no primary key constraint in the SQL Server table description.

---

OK

---

Can anyone have an idea about this?

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

The error lets me think that the item table some problem with the indexes in SQL. You should check in SQL if the primary key is ok there. If it is not, you need to fix that manually (maybe not maintaining the key in SQL in the NAV key properties and saving the object and then maintaining it again and saving the object will fix the issue).