NAV 2009 - Metadata for object of type Table with id 2000000073 is in a failed state.

Hi all,

With NAV 2009, while using web services we face a common issue related to Metadata of the Table with Id 2000000073.

Let's see the reasons behind it and how to resolve it.


Error Message -

<faultstring xml:lang="en-US">
Metadata for object of type Table with id 2000000073 is in a failed state. This is caused by a previous exception: Metadata for object of type Table with id 2000000071 is in a failed state. This is caused by a previous exception: There are errors in the text conversion because text no. 1971-27 does not exist in the .stx file. Internal error: 47-1
</faultstring>
<detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">
Metadata for object of type Table with id 2000000073 is in a failed state. This is caused by a previous exception: Metadata for object of type Table with id 2000000071 is in a failed state. This is caused by a previous exception: There are errors in the text conversion because text no. 1971-27 does not exist in the .stx file. Internal error: 47-1
</string>

Reason -

1. You might have an exe upgrade from Version 5/4/previous to NAV 2009.
2. Incorrect Hotfix Update.

Resolution -

1. Take a Navision backup of the Database.

2. Create a New Database in the Navision (say 2009/2009SP1/2009R2).

3. Restore the backup taken in step 1 into the database.

4. Stop Services (Web Service & RTC Service).

5. Configure the Service tier to point to New Database.

6. Start the Services (Web Service & RTC Service).

Hope this help as i am getting so many queries for the same.

Regards,
Saurav Dhyani
www.sauravdhyani.com