1. Home
  2. Categories
  3. Support
  4. Error trying to upgrade

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

  • R

    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)

    0
  • Dan_Woolf
    inedo-engineer

    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

    0
  • R

    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)

    0
  • rhessinger
    inedo-engineer

    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

    0
  • R

    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

    0 atripp 1 Reply
  • atripp
    inedo-engineer

    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

    0
Log in to reply
 
Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation