The following SQL error was unexpected: Invalid column name 'Session Unique ID'

OpenNav

 

I seem to get this error a lot lately.

 

I have found out that it is due to discrepancies between the version of the objects and the schema. So all you have to do is go to the Development Environment and run the “Sync. Schema for all Tables” function, right?

 

image

 

No – sorry – same error.

 

image

 

The last resort is to go to Powershell. Open the Dynamics NAV Administration as an administrator and run the Sync-NAVTenant Command.

 

image

 

And now all is well:

 

image

 

And now the Synchronization runs fine in the development.

 

image

 

If there are  any destructive changes in the objects the synchronization will fail. It is possible though to correct each object in the Development Environment. Just make sure that you use the “Later” option when saving and compiling the object.

 

image

 

Then synchronize again and everything will work fine.

 

image4

Anonymous
Related