Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bram van den Bogaard 4 posts 35 karma points
    Jun 21, 2022 @ 19:04
    Bram van den Bogaard
    0

    Error during Installation: Transaction has completed, it is no longer usable (V10)

    Hi everyone, I've ran into an issue unfortunately. I created a new database for Umbraco 10 but when running the installer I get an error that is not known to me and the "fixes" found online (restarting database, creating a new one from scratch etc.) are not working. The error happens during the ZombieCheck on the database.

    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.\r\n ---> System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.\r\n at Microsoft.Data.SqlClient.SqlTransaction.ZombieCheck()\r\n at Microsoft.Data.SqlClient.SqlTransaction.Commit()\r\n at NPoco.Database.CompleteTransaction()\r\n at Umbraco.Cms.Infrastructure.Scoping.Scope.DisposeLastScope()\r\n at Umbraco.Cms.Infrastructure.Scoping.Scope.Dispose()\r\n at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.CreateSchemaAndData()\r\n at Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseInstallStep.ExecuteAsync(Object model)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Span 1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.ExecuteStepAsync(InstallSetupStep step, Object instruction)\r\n at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall(InstallInstructions installModel)

    Is anyone here familiar with this error?

    Thanks in advance :)

  • Chris Fitz-Avon 3 posts 95 karma points c-trib
    Jun 22, 2022 @ 13:52
    Chris Fitz-Avon
    101

    I've just worked through the exact same error. In my case the database user that I configured didn't have the permission to create tables and so the install failed.

    After granting the user membership of the db_owner role the install completed successfully.

  • Bram van den Bogaard 4 posts 35 karma points
    Jun 28, 2022 @ 18:27
    Bram van den Bogaard
    1

    Hi Chris,

    I'm sorry for my late reply, I've only just now gotten to working on this project again unfortunately. Your solution is correct and the issue has been fixed! Thanks a lot for the help :)

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies