Two sets of tables in database

Barfolomeus
Barfolomeus Member Posts: 5
edited 2004-04-22 in Navision Attain
Hi.

All tables in my DB appears tvo times. For example:
Table nr. 3; "payment terms" also appears as: Table nr. 1000000003;"payment terms".

I don´t have any access to these tables

Does anyone know what is causing this ?

I´m running 3.60 on native database.

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    I believe this is caused by a restore of a database that was not completed (eg. because the database size was too small to contain all the data from the fbk-file).
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • DenSter
    DenSter Member Posts: 8,307
    That is correct. All you need to do is finish the restore process (maybe after expanding the database to make some room for the data) and Navision will remove those tables. If for some reason you can't do this, you're SOL, because you'll have to create a new database. No license will allow you to remove those objects manually.

    hth
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Barfolomeus
    Barfolomeus Member Posts: 5
    Thanks. 8)
  • GoMaD
    GoMaD Member Posts: 313
    It is possible to do a "rollback" on the restore operation.

    When you select Restore from the "Tools" menu the system will ask you to continue on the restore. When you click no the system will ask you if you want to remove all the imported data. Click yes to remove all the "restore" tables.

    Regards,
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!

Categories