Cannot open/convert 5.0 database in NAV 6.0 / 2009

Votuc
Votuc Member Posts: 206
edited 2010-11-02 in NAV/Navision Classic Client
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<

Comments

  • mihail_kolev
    mihail_kolev Member Posts: 379
    have you tried to disable the keys in the Item Ledger Entry (leave just the PK)?
    -Mihail- [MCTS]
  • Votuc
    Votuc Member Posts: 206
    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
    Administrator Member, Moderator, Administrator Posts: 2,506
    [Topic moved from 'NAV Three Tier' to 'NAV/Navision Classic Client' forum]

Categories