Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    Error trying to upgrade

    Scheduled Pinned Locked Moved Support
    6 Posts 4 Posters 30 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R Offline
      Russell.Kahler_4399
      last edited by

      Trying to upgrade from 5.2.32 to 6.0.9 and I get errors when it comes to applying sql scripts and I cannot figure out how to find what is erroring out. I tried to run manually with the errors command but that does not provide any details on the error. Below is a part of the install log.

      ** Update Database Schema **
      ** Execute inedosql.exe update SqlScripts.zip --connection-string="$DbConnectionString" in $WorkingDirectory **
      DEBUG: Process: D:\Program Files\ProGet\SqlScripts\inedosql.exe
      DEBUG: Arguments: update SqlScripts.zip --connection-string="Data Source=(local);Initial Catalog=ProGet;Integrated Security=False;User ID=ProGet;Password=EUz-TDkAG83G86@y"
      DEBUG: Working directory: D:\Program Files\ProGet\SqlScripts
      DEBUG: Ensuring that D:\Program Files\ProGet\SqlScripts exists...
      INFO: Executing D:\Program Files\ProGet\SqlScripts\inedosql.exe...
      ERROR: Use the "errors" command to view unresolved errors, or use the --force argument to run anyway.
      ERROR: Scripts not executed; at least one script has unresolved errors.
      ERROR: Process exited with code: -1 (failure)

      1 Reply Last reply Reply Quote 0
      • Dan_WoolfD Offline
        Dan_Woolf inedo-engineer
        last edited by

        Hi @Russell-Kahler_4399,

        If you open InedoHub you should see logs for the failed upgrade. Can you please look in there and tell us what database scripts failed to run?

        Thanks,
        Dan

        1 Reply Last reply Reply Quote 0
        • R Offline
          Russell.Kahler_4399
          last edited by

          All I see is the above segment. it does not tell me what failed and why. if someone can point me to where the log of that would be....

          ** (unnamed scope) **
          ** (unnamed scope) **
          ** Stop $ServiceName service **
          INFO: Stopping service INEDOPROGETSVC...
          INFO: Service is already stopped.

          ** Stop $WebServiceName service **
          INFO: Stopping service INEDOPROGETWEBSVC...
          INFO: Service INEDOPROGETWEBSVC does not exist.

          ** Sleep for 5 seconds **
          INFO: Sleeping for 5 seconds...
          INFO: Done sleeping.

          ** Deploy Program Files **
          ** Deploy package to $WorkingDirectory **
          DEBUG: Deploying D:\Program Files\ProGet\Extensions\AWS.upack...
          DEBUG: Deploying D:\Program Files\ProGet\Extensions\Azure.upack...
          DEBUG: Deploying D:\Program Files\ProGet\Extensions\InedoCore.upack...
          DEBUG: Deploying D:\Program Files\ProGet\Extensions\Sonatype.upack...
          DEBUG: Deploying D:\Program Files\ProGet\Service\BouncyCastle.OpenPgp.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Gibraltar.Agent.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\ICSharpCode.SharpZipLib.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.Agents.Client.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.Agents.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.DbUpdater.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.ExecutionEngine.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.Loupe.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.SDK.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.ServiceMessaging.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Inedo.UPack.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\InedoLib.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Lucene.Net.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Newtonsoft.Json.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\NuGet.Frameworks.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\ProGet.Service.exe...
          DEBUG: Deploying D:\Program Files\ProGet\Service\ProGet.Service.exe.config...
          DEBUG: Deploying D:\Program Files\ProGet\Service\ProGetCoreEx.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\Quartz.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\SharpCompress.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Buffers.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Collections.Immutable.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Data.SQLite.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Memory.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Reflection.Metadata.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Runtime.CompilerServices.Unsafe.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.Threading.Tasks.Extensions.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\System.ValueTuple.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\YamlDotNet.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\ZstdSharp.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\x64\SQLite.Interop.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Service\x86\SQLite.Interop.dll...
          DEBUG: Deploying D:\Program Files\ProGet\SqlScripts\SqlScripts.zip...
          DEBUG: Deploying D:\Program Files\ProGet\SqlScripts\inedosql.exe...
          DEBUG: Deploying D:\Program Files\ProGet\Web\Web.config...
          DEBUG: Deploying D:\Program Files\ProGet\Web\Web_appSettings.config...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\BouncyCastle.OpenPgp.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Gibraltar.Agent.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ICSharpCode.SharpZipLib.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.Agents.Client.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.Agents.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.ExecutionEngine.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.Loupe.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.SDK.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.ServiceMessaging.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Inedo.UPack.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\InedoLib.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Lucene.Net.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Newtonsoft.Json.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\NuGet.Frameworks.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ProGet.WebApplication.deps.json...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ProGet.WebApplication.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ProGet.WebApplication.pdb...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ProGetCoreEx.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ProGetCoreEx.pdb...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\Quartz.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\SharpCompress.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Buffers.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Collections.Immutable.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Data.SQLite.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Memory.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Reflection.Metadata.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Runtime.CompilerServices.Unsafe.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.Threading.Tasks.Extensions.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\System.ValueTuple.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\YamlDotNet.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\ZstdSharp.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\x64\SQLite.Interop.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\bin\x86\SQLite.Interop.dll...
          DEBUG: Deploying D:\Program Files\ProGet\Web\Resources\Tools\pdbstr.exe...

          ** Write SQL Connection String to $DbConnectionString **

          ** Update Database Schema **
          ** Execute inedosql.exe update SqlScripts.zip --connection-string="$DbConnectionString" in $WorkingDirectory **
          DEBUG: Process: D:\Program Files\ProGet\SqlScripts\inedosql.exe
          DEBUG: Arguments: update SqlScripts.zip --connection-string="Data Source=(local);Initial Catalog=ProGet;Integrated Security=False;User ID=ProGet;Password=xxx"
          DEBUG: Working directory: D:\Program Files\ProGet\SqlScripts
          DEBUG: Ensuring that D:\Program Files\ProGet\SqlScripts exists...
          INFO: Executing D:\Program Files\ProGet\SqlScripts\inedosql.exe...
          ERROR: Use the "errors" command to view unresolved errors, or use the --force argument to run anyway.
          ERROR: Scripts not executed; at least one script has unresolved errors.
          ERROR: Process exited with code: -1 (failure)

          1 Reply Last reply Reply Quote 0
          • rhessingerR Offline
            rhessinger inedo-engineer
            last edited by

            Hi @Russell-Kahler_4399,

            Are you able to see the log from the error on the first time you upgrade and it failed? That log would most likely show us the script with the error.

            The other option is you can download InedoSQL and run the command:

            inedosql.exe errors --all --connection-string="Data Source=(local);Initial Catalog=ProGet;Integrated Security=False;User ID=ProGet;Password=xxx"

            That will tell us what scripts failed and their error.

            Thanks,
            Rich

            Products Engineer, Inedo

            1 Reply Last reply Reply Quote 0
            • R Offline
              Russell.Kahler_4399
              last edited by

              this what I get from errors --all

              7f7fb186-62be-4934-a448-6f3532a4d825 DDL-DML/v4/0174. 4.7.2/10. Add context to logs.sql
              a16588b2-4a08-43a8-b603-8592ee1b6644 DDL-DML/v4/0172. 4.7.0/20. VSIX Feeds.sql
              cd26745f-75cd-4c97-bdb2-6150995e642e DDL-DML/v4/0172. 4.7.0/10. Add License Filters.sql
              f6b74e90-0aeb-497b-9861-b23a9d60aa40 DDL-DML/v4/0172. 4.7.0/10. Add download retention.sql

              atrippA 1 Reply Last reply Reply Quote 0
              • atrippA Offline
                atripp inedo-engineer @Russell.Kahler_4399
                last edited by

                Hi @Russell-Kahler_4399 ,

                It looks like there was an error running the upgrade scripts to v4.7. That would have been a long time ago, and it's hard to guess what it could be, and it'd require a bit of analysis to figure out.

                I'd recommend migrating to a new instance; you can use Feed Importers in the latest version to pull all the content from your existing instance.

                It's possible to bypass the errors with inedosql resolve-error --all but I really wouldn't recommend it, since it could lead to more problems.

                Cheers,
                Alana

                1 Reply Last reply Reply Quote 0

                Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                With your input, this post could be even better 💗

                Register Login
                • 1 / 1
                • First post
                  Last post
                Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation