how to delete 2000000065,2000000066,2000000067 Tables??

kishi_g
kishi_g Member Posts: 162
edited 2008-06-18 in NAV/Navision Classic Client
Hi,
how can i delete the tables like 2000000065,2000000066,2000000067,
2000000068. is it possible to delete these objects with developer license.



Thanks & Regards,
Kishore.

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Those are system tables, you need them to be able to run NAV. Why would you want to delete those tables?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Belias
    Belias Member Posts: 2,998
    maybe a strange bku crash?if I remember well it happens to me too some time ago...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kishi_g
    kishi_g Member Posts: 162
    when i restore the backup it gets error.


    Thanks & Regards,

    Kishore.
  • Belias
    Belias Member Posts: 2,998
    If i remember, I had deleted and recreated the DB...Can you do it?
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kishi_g
    kishi_g Member Posts: 162
    But in that databse was not empty. it contains data. how can i take the backup regularly.






    Thanks & Regards,
    Kishore.
  • Belias
    Belias Member Posts: 2,998
    This issue happened to me only one time, hope to you too... :mrgreen:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kine
    kine Member Posts: 12,562
    These tables are specific for NAV 5.0. May be that you are restoring 5.0 backup in NAV 4.x version client?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kishi_g
    kishi_g Member Posts: 162
    This issue coming every time. when i take the backup it gets error.

    Is it possible to resolve this issue with out loss of data.




    Thanks & Regards,
    Kishore.
  • Belias
    Belias Member Posts: 2,998
    How did you restored the previous times?
    Can you post the error please?
    does the system ask you to restore a pending bku?
    (if i remember it was something like table 2000000... already exists)

    Suggestion:
    try to restore on a new db and then restore again and see if you still encounter this problem.

    my memory is a bit short, but if i remember, my bku crashed after creating these tables (or something like this), but it committed the creation of tables and when restoring, nav try to recreate these tables...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kishi_g
    kishi_g Member Posts: 162
    The error is

    There are errors in the text conversion (Text No. 1965-0 does not exist in the .stx file).

    Internal Error:47-1


    Earlier i took backup with out any problem. now it gets problem.


    Thanks & Regards,
    Kishore.
  • Belias
    Belias Member Posts: 2,998
    ouch #-o ...it's not the same issue as mine...sorry in this case I can't help you
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kine
    kine Member Posts: 12,562
    kishi_g wrote:
    The error is

    There are errors in the text conversion (Text No. 1965-0 does not exist in the .stx file).

    Internal Error:47-1


    Earlier i took backup with out any problem. now it gets problem.


    Thanks & Regards,
    Kishore.

    1) How you created this DB
    2) Which version of client you are using to create backup
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kishi_g
    kishi_g Member Posts: 162
    By using Nav4.0 SP3 i created the backup.




    Thanks & Regards,
    Kishore.
  • kine
    kine Member Posts: 12,562
    You cannot use NAV 4.00SP3 to create backup of NAV 5.0 DB. You need to export the needed objects into text file and merge them into your NAV 4.00SP3 database...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Gert_Barmentlo
    Gert_Barmentlo Member Posts: 29
    I have the same error. Nothing with a backup from 5.0 to 4.0SP3.

    What goes wrong?
  • RudiRutsche
    RudiRutsche Member Posts: 30
    You have to delete the tables manually on the SQL Server.

    First delete the tables.
    Then delete the associated lines in the table "object"

    It might be necessary to delete your fin.zup, too.


    Greetings!
  • ptech5443
    ptech5443 Member Posts: 28
    I am having the same issue and was wondering if anyone made any progress on this.

    I have a client that has a 75GB database, so create new db and restore not so easy. A user connected to the database using Jet reports after installing a 5.0 client. After opening excel and going to Jet, options, data sources, they updated the connection information and then selected company. They were moving from top to bottom so Navision client program folder was not set. Long wait with the hour glass running. They then received a message, Database successfully converted. The new tables now exist in the database and can not be removed. The database still opens using the 4.0 SP3 client but the back-up will not run now, error 'There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1'.
  • ptech5443
    ptech5443 Member Posts: 28
    I was able to resolve the issue and I thought I would pass it back to you in the event that others have the same issue. I found that if I deleted the fin.stx and fin.etx files in the ENU folder of the client install, C:\Program Files\Microsoft Business Solutions-Navision\client\ENU\ and then replaced them with the fin.stx and the fin.etx files from the newer version of the client install, in my case 5.0 SP1. This seems to resolve the issue since now the text no 1965-0 does exist. My back-up is now running without issue. I hope anyone that had this issue finds this information helpful.

    Now I need to figure out why my ExpandIT is not working. When I click on test from the launch utility it opens Navision to the logon screen and then after a short period exits stating it couldn't find the Navision application window.

Categories