Two sets of tables in database

BarfolomeusBarfolomeus 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_VanDyckLuc_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)
  • DenSterDenSter 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
  • BarfolomeusBarfolomeus Member Posts: 5
    Thanks. 8)
  • GoMaDGoMaD 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!
Sign In or Register to comment.