mibuso.com
Home› NAV/Navision Classic Client

how to delete 2000000065,2000000066,2000000067 Tables??

kishi_gkishi_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

  • DenSterDenSter Member Posts: 8,305
    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
  • BeliasBelias 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_gkishi_g Member Posts: 162
    when i restore the backup it gets error.


    Thanks & Regards,

    Kishore.
  • BeliasBelias 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_gkishi_g Member Posts: 162
    But in that databse was not empty. it contains data. how can i take the backup regularly.






    Thanks & Regards,
    Kishore.
  • BeliasBelias 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
  • kinekine 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_gkishi_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.
  • BeliasBelias 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_gkishi_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.
  • BeliasBelias 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
  • kinekine 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_gkishi_g Member Posts: 162
    By using Nav4.0 SP3 i created the backup.




    Thanks & Regards,
    Kishore.
  • kinekine 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_BarmentloGert_Barmentlo Member Posts: 29
    I have the same error. Nothing with a backup from 5.0 to 4.0SP3.

    What goes wrong?
  • RudiRutscheRudiRutsche 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!
  • ptech5443ptech5443 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'.
  • ptech5443ptech5443 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.
Sign In or Register to comment.