Cannot open/convert 5.0 database in NAV 6.0 / 2009

Votuc

Hi,

I am trying to convert a 5.0 database to be able to be opened in 6.0 so I can do an object upgrade.

When I try to open and convert the database in NAV 6.0 I get:

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name "database name $Item Ledger Entry $VSIFTDX......

(Please see attached image).

I have tried doing a NAV level backup then a restore to try to rebuild the SIFT tables but am still getting the same error.

Any ideas on how to fix this? [-o<

mihail_kolev

have you tried to disable the keys in the Item Ledger Entry (leave just the PK)?

Votuc

mihail_kolev wrote:

have you tried to disable the keys in the Item Ledger Entry (leave just the PK)?

That's a good idea :thumbsup: I will try that and report back....

Administrator

[Topic moved from 'NAV Three Tier' to 'NAV/Navision Classic Client' forum]