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

PanzeriElena
PanzeriElena Member Posts: 21
edited 2014-02-19 in NAV Three Tier
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

Comments

  • geordie
    geordie Member Posts: 655
    Any event viewer entry to check?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • PanzeriElena
    PanzeriElena Member Posts: 21
    In the time log, the systems stops in some tables: Job, Job Planning Line, Purchase Line, ...
  • PanzeriElena
    PanzeriElena Member Posts: 21
    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
    geordie Member Posts: 655
    After object delete did you change the compatibility level of the database (100 for SQL 2008 and 2008 R2, 110 for SQL 2012)?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • Maaax
    Maaax Member Posts: 14
    I agree with geordie, i had the same with a customer. This error seem to be a compatibility problem.
    Hope it will be helpfull !
    Maxime JUND
    Talent Business Solutions
    Technical Expert of Microsoft Dynamics 365 Business Central
    Website | Mail | LinkedIn
  • PanzeriElena
    PanzeriElena Member Posts: 21
    The compatibility level is setted to 100 for SQL 2008.
    Here attached the print screen.

    Thank you,
    Elena
  • geordie
    geordie Member Posts: 655
    When you run the transfer data page are connected at the right service?
    In dev. env. option instance name and company are properly filled?
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories