Table 1000000001 to 1099008535 a copy of standard table

sendoh · 2008-05-02

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 · 2008-05-02

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?

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

](*,) ](*,) ](*,)

kine · 2008-05-02

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...

stryk · 2008-05-02

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

sendoh · 2008-05-02

thanks a lot guys now I run the restore and see for the result...thanks again........................... :P

sendoh · 2008-05-02

Everythings fine now...Thanks a lot guys =D>

Table 1000000001 to 1099008535 a copy of standard table

Comments

Categories