Error: Table 2000000009 has no name

If you get following error:

then the database is corrupted. In detail it means sql view “Session” is missing in the database! This can be a result of a crashed backup/restore process or a failed conversion process.

It can be, that View “Database File” is also missing. Although it is possible to restore the missing view e.g. from a (not changed) default cronus database, it won’t help, but you can give it a try. You can restore a new cronus database from the nav 2009 setup, subfolder SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\60\Database.

In most cases it’s needed to restore the database from an earlier backup. If you do not have a backup strategy for your databases – but you should have – then export all changed nav objects as text files from the current, crashed database and start with a new database on base of a cronus database. then import/migrate the changed nav objects. after that re-compile all nav objects and restart the nav service.

Helpful Links:
http://saurav-nav.blogspot.co.at/2012/02/metadata-for-object-of-type-table-with.html

cheers

One thought on “Error: Table 2000000009 has no name”

  1. In SQL EDIT
    Table = $ndo$dbproperty
    Field = Identifiers

    Value should be

    2000000001=”Object”,1=”Type”,2=”Company Name”,3=”ID”,4=”Name”,5=”Modified”,6=”Compiled”,7=”BLOB Reference”,8=”BLOB Size”,9=”DBM Table No_”,10=”Date”,11=”Time”,12=”Version List”,40=”Locked”,50=”Locked By”;2000000009=”Session”,1=”Connection ID”,2=”User ID”,3=”My Session”,5=”Login Time”,6=”Login Date”,16=”Database Name”,17=”Application Name”,18=”Login Type”,19=”Host Name”,20=”CPU Time (ms)”,21=”Memory Usage (KB)”,22=”Physical I_O”,23=”Blocked”,24=”Wait Time (ms)”,25=”Blocking Connection ID”,26=”Blocking User ID”,27=”Blocking Host Name”,28=”Blocking Object”,29=”Idle Time”;2000000010=”Database File”,1=”No_”,2=”File Name”,3=”Size (KB)”

    Bad one looks like this

    2000000001=Object,1=Type,2=Company Name,3=ID,4=Name,5=Modified,6=Compiled,7=BLOB Reference,8=BLOB Size,9=DBM Table No_,10=Date,11=Time,12=Version List,40=Locked,50=Locked By

    Also if you need to create a script form another Database for the “Session” and “Database Files” Views Then make sure you Add the $ndo$shadow Permissions to the view after you create them, just look at any other Table for the permissions that should be there in SQL

    Rod Smith
    Rrsmith@sentechgroup.com

    Like

    Reply

Leave a comment