Upgrade NAV "The SqlTransaction has been rolled back..."

PanzeriElena

I'm trying to upgrade NAV version, from 2009 R2 to 2013.
1) Merge objects ok
2) NAV 2009 - run form 104001 for transfer data and delete objects
3) NAV 2013 - converted database
4) NAV 2013 - imported merged objects (standard + custom) and compiled all with success
5) NAV 2013 - run page 104002 for transfer data but I have an error message:
The SqlTransaction has been rolled back or committed; it is no longer usable

Which can be the problem? I can't go on with procedure...

Thank you,
Elena

geordie

Any event viewer entry to check?

PanzeriElena

In the time log, the systems stops in some tables: Job, Job Planning Line, Purchase Line, ...

PanzeriElena

In the event viewer, I have:
Type: System.InvalidOperationException
Message: La SqlTransaction è completata e non può più essere utilizzata.
StackTrace:
in System.Data.SqlClient.SqlTransaction.ZombieCheck()
in System.Data.SqlClient.SqlTransaction.Commit()
in Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteAction(Action action, NavSqlCommand command)
Source: System.Data

geordie

After object delete did you change the compatibility level of the database (100 for SQL 2008 and 2008 R2, 110 for SQL 2012)?

Maaax

I agree with geordie, i had the same with a customer. This error seem to be a compatibility problem.
Hope it will be helpfull !

PanzeriElena

The compatibility level is setted to 100 for SQL 2008.
Here attached the print screen.

Thank you,
Elena

geordie

When you run the transfer data page are connected at the right service?
In dev. env. option instance name and company are properly filled?