mibuso.com
Home› SQL Performance

Error when trying to create a backup

gvolkovgvolkov Member Posts: 196
edited 2009-06-30 in SQL Performance
Here is a situation: i am trying to backup a SQL based NAV database. But getting this error

There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1
Microsoft Certified Technology Specialist
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Business Management Solutions Specialist
http://www.navisiontech.com

Comments

  • strykstryk Member Posts: 645
    Hi!
    Hmmm ... looks like an issue with your NAV client ... which version/build do you use?
    And: why do you create the backup via NAV - it would be easier, quicker and safer to do this with SQL features (this has been discussed several times here)? With SQL backup this error should not occur ...
    Regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • kinekine Member Posts: 12,562
    It seems that you are backing up NAV 5.0 database by older version of NAV (like some NAV 5.0 restored into NAV 4.0).

    Fin.stx from NAV 5.0:
    // Send-To Program Table
    01965-00000-030-1: Send-To Program
    01965-00001-030-1: Program ID
    01965-00002-030-1: Executable
    01965-00003-030-1: Parameter
    01965-00004-030-1: Name
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kinekine Member Posts: 12,562
    Today my friend has simlar problem but with Native DB. I have found that in the database, which is NAV 4.0SP3, was created table 2000000068 Record Link. When you scrolled down in object designer, it showed the error about missing text (the text is the table name, which is doesn't exists in NAV 4.x). It seems that when someone tries to open NAV 4.x DB with NAV 5.0 client, the "upgrade" process willc reate some tables regardless you click that you want to upgrade the database...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • gvolkovgvolkov Member Posts: 196
    Thats rigtht, the problem was the fact that there was no reference to these tables in STX files. So i deleted the tables from SQL and from Objects table. This has solved the issue. I guess this might have happened when someone has tried to open the database with version 5.
    Microsoft Certified Technology Specialist
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified Business Management Solutions Specialist
    http://www.navisiontech.com
  • ridczakridczak Member Posts: 8
    kine wrote:
    Today my friend has simlar problem but with Native DB. I have found that in the database, which is NAV 4.0SP3, was created table 2000000068 Record Link. When you scrolled down in object designer, it showed the error about missing text (the text is the table name, which is doesn't exists in NAV 4.x). It seems that when someone tries to open NAV 4.x DB with NAV 5.0 client, the "upgrade" process willc reate some tables regardless you click that you want to upgrade the database...


    How is it possible to get rid of this tables? The DB is native.
Sign In or Register to comment.