Error during Upgrade to NAV 2013 R2

Business Central/NAV Developers Forum
1

In step 1 “Prepare the existing data for the upgrade” / task 4 “Data conversion” I always get an error while I’m converting the NAV2013 database to NAV 2013 R2. The message is:

The following SQL Server error or errors occured:

4924,“42S22”,[Microsoft][SQL Server Native Client 10.0][SQL Server]Fehler bei ALTER TABLE ALTER COLUMN, da die ‘Version List’-Spalte in der Object-Tabelle nicht vorhanden ist.

SQL:

ALTER TABLE [dob].[Object] ALTER COLUMN[Version List]VARCHAR NOT NULL

It’s the last step of processing an upgrade from version 2.60.A to 2013 R2. Does anybody have an idea how to fix it?

In the NAV Development Environment I cannot change the field name in the object table 2000000001. And when I change the field name in the SQL table, I got the error "The Version List field on the Object table does not exist in the SQL Server table or view.

2

I found at last the solution! I think it was a language layer problem. I replaced the fin.stx and fin.etx in the client directory by those versions from the …\ENU subdirectory and it worked!

I made this for both clients (2009R2 and 2013). Therefore I don’t know, if this have been really necessary or if it would have been sufficent to replace then in 2013.