mistakenly nav update

icobani

Hi,

I was upgrade mistakenly NAV 2009 from NAV 5.0. I try from backup database with this sql.

UPDATE [$ndo$dbproperty]
 
SET [databaseversionno] = (SELECT [databaseversionno] FROM [NAVTEST].dbo.[$ndo$dbproperty]),
 
[chartable] = (SELECT CAST([chartable] AS VARBINARY(8000)) 
 
FROM [NAVTEST].dbo.[$ndo$dbproperty])

We can open navision with nav 5.0 version. But today, we get this error

---

Microsoft Dynamics NAV

---

There are errors in the text conversion (text no. 1968-13 does not exist in the .stx file).

Internal error: 47-1

---

OK

---

I debug this code and i see error below line in navision code

NumberOfFields := Field.COUNT;

i think this sql code is not enough. Who know any solution for this.


thanks.

Chinmoy

Did you check this?

viewtopic.php?f=23&t=45668

icobani

Yes but i dont want to copy stx file any client.

vaprog

The error occurs because your system tables have been upgraded.

If possible update your clients. If this is not possible, the only guaranteed save option is to restore from your most recent true 5.0 backup.

You might try the following (no liabilities accepted):

• make an fbk of your complete database
• create a new, empty database
• from the object designer import all objects. Use a backup from the 5.0 database. 2009 object are binary incompatible to earlier versions. I am unsure whether the incompatibility comes in only when you compile an object in 2009. Do not replace nor merge the system tables (2000000000 and above)
• restore data from all companies
• Test!