Table 1000000001 to 1099008535 a copy of standard table

sendohsendoh Member Posts: 207
hi guys,

these is really weird on Client Current DB there are tables 1000000001 to 1099008535 which is the copy of standard Table
e.g
3                 Payment Terms
1000000003 Payment Terms

what's These?
Sendoh
be smart before being a clever.

Comments

  • sendohsendoh Member Posts: 207
    1000000003 to 1099008535

    This is Really weird, I can't open or delete it because the system tell's me that I don't have permission on to these tables .. ](*,) ](*,) ](*,) what should be the cause of these weird features of nav? :mrgreen: I search to google regarding these problem and I cannot find any related topic...one thing the object name is the same which is navision did'nt allowed when there's already exist..but in this case why? ](*,)

    Example..

    27 Item
    1000000027 Item

    23 Vendor
    1000000023 Vendor


    ](*,) ](*,) ](*,)
    Sendoh
    be smart before being a clever.
  • kinekine Member Posts: 12,562
    This is mark of incomplete backup restore. Run the Tool-Restore function. It will continue in restoration. If it ask just for a file, it means that problem is somewhere else...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • strykstryk Member Posts: 645
    Hi!

    this could happen if you restore a FBK into a database and this restore has not finished succesfully.

    When importing/restoring an FBK, NAV copies all tables, here adding 1000000000 to the original ID (T3 Payment Terms = T1000000003). The data is firstly imported into these tables, once the restore is finished - succesfully - the "new" tables replace the "old" ones, the 1000000000+ objects are removed.
    If a restore failes, sometimes NAV could not remove these tables ...

    To fix this, simply select "Tools - Restore" and CONTINUE to former restore.

    Best regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • sendohsendoh Member Posts: 207
    thanks a lot guys now I run the restore and see for the result...thanks again........................... :P
    Sendoh
    be smart before being a clever.
  • sendohsendoh Member Posts: 207
    Everythings fine now...Thanks a lot guys =D>
    Sendoh
    be smart before being a clever.
Sign In or Register to comment.