Upgrade Failure "duplicate column name: DebugPreference"

Hello geofforlebeck,

Thank you for providing the upgrade details and complete stack trace.

The MSI installation appears to have completed, but the PSU service is failing during the SQLite schema migration. The error indicates that the migration is attempting to create the `DebugPreference` column when it is already present in the database.

I did not find an official requirement to install intermediate PSU versions before upgrading. For now, please do not manually delete the column or modify the `__EFMigrationsHistory` table, as this could leave the database in an unsupported state.

Could you please confirm the following?

* Is this a production, test, or development instance?
* Was PSU 5.5.0 starting successfully immediately before the upgrade?
* Do you have a backup of the SQLite database, repository, and configuration from before the upgrade?
* Were there any previous upgrade attempts or database restorations on this installation?
* Are you using the default SQLite database location or a custom path?

Please preserve a copy of the current database before attempting any rollback or additional upgrade.

Because this is a public forum, please sanitize all evidence before posting. Remove credentials, tokens, license keys, cookies, private keys, full connection strings, email addresses, usernames, customer data, tenant or account identifiers, internal domains, hostnames, IP addresses, and private URLs. Please do not upload unredacted HAR files, memory dumps, database backups, or complete configuration files to this public thread.

Best regards,
Ruben Tapia

To answer your questions:

• This is a production instance (uses free license as I'm using solely as a job scheduler)
• PSU 5.5.0 is running fine and is running okay prior the upgrade attempt
• Yes, I have backups of everything. This is a VM so I've been using VM snapshots to restore back to v5.5.0 when upgrade fails
• I believe there was one or two version upgrades, but cannot say with 100% certainty.
• Default SQLite ("C:\ProgramData\UniversalAutomation\database.db")

Hello geofforlebeck,

Thank you for confirming those details. Since PSU 5.5.0 is working after restoring the VM snapshot, and you have a reliable rollback available, I recommend performing the next test only on a cloned copy of that working snapshot rather than on the production VM.

Please use the following controlled upgrade path:

1. Restore the known-working PSU 5.5.0 snapshot.
2. Clone the VM and keep the production instance unchanged.
3. On the clone, confirm that the PSU service starts normally and that the schedules are available.
4. Stop the PSU service and create an additional copy of `C:\ProgramData\UniversalAutomation`.
5. Upgrade the cloned instance from PSU 5.5.0 to PSU 5.6.13 using the MSI.
6. Start the service once and confirm whether the `duplicate column name: DebugPreference` error appears.
7. If 5.6.13 starts successfully, upgrade the same clone from 5.6.13 to 2026.2.3.0 and test again.

This intermediate test is intended to identify during which upgrade stage the database migration conflict occurs. It is not currently confirmed that an intermediate version is mandatory.

If either stage fails, please stop the service and do not delete the `DebugPreference` column or modify the `__EFMigrationsHistory` table. Please provide the exact stage that failed, the Windows Server version, and the sanitized log from the first failed service start.

Because this is a public forum, please sanitize all evidence before posting. Remove credentials, tokens, license keys, cookies, private keys, full connection strings, email addresses, usernames, customer data, tenant or account identifiers, internal domains, hostnames, IP addresses, and private URLs. Please do not upload unredacted HAR files, memory dumps, database backups, or complete configuration files to this public thread.

Best regards,
Ruben Tapia

Ruben,

I was not able to specifically find v5.6.13, but I did attempt using 5.6.1 MSI and it still failed.

• The failure occurred at the point the MSI installer tries to start the service (i.e., the very last step of the MSI installer).
• This is running on a up-to-date patched Windows Server 2022 installation.

The error upon starting:

2026-07-29 20:26:26.809 -07:00 [FTL] Fatal error starting PowerShell Universal.
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'duplicate column name: DebugPreference'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.Execute(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean beginTransaction, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.<>c.<ExecuteNonQuery>b__3_1(DbContext _, ValueTuple`6 s)
   at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateImplementation(DbContext context, String targetMigration, MigrationExecutionState state, Boolean useTransaction)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c.<Migrate>b__20_1(DbContext c, ValueTuple`4 s)
   at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
   at PowerShellUniversal.SQLite.DatabaseFeature.InitializeDatabase(IConfiguration configuration, ILogger logger) in D:\a\universal\universal\src\PowerShellUniversal.SQLite\Plugin.cs:line 70
   at Universal.Server.Services.SystemPluginService..ctor(IConfiguration configuration) in D:\a\universal\universal\src\Universal.Server\Services\SystemPluginService.cs:line 48
   at Universal.Server.Startup.ConfigureServices(IServiceCollection services) in D:\a\universal\universal\src\Universal.Server\Startup.cs:line 72
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
   at System.Reflection.MethodBaseInvoker.InvokeWithOneArg(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.InvokeCore(Object instance, IServiceCollection services)
   at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.UseStartup(Type startupType, HostBuilderContext context, IServiceCollection services, Object instance)
   at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass7_0.<UseStartup>b__0(HostBuilderContext context, IServiceCollection services)
   at Microsoft.Extensions.Hosting.HostBuilder.InitializeServiceProvider()
   at Microsoft.Extensions.Hosting.HostBuilder.Build()
   at Universal.Server.Program.Main(String[] args) in D:\a\universal\universal\src\Universal.Server\Program.cs:line 37
2026-07-29 20:26:35.257 -07:00 [INF] Using database connection string: Data Source=C:\ProgramData\UniversalAutomation\database.db

Hello geofforlebeck,

Thank you for testing the upgrade to PSU 5.6.1 and confirming that the same error occurs when the MSI attempts to start the service.

Since the failure occurs during the SQLite migration, the next step is to review the complete logs from the failed startup attempt. Please restore the known-working PSU 5.5.0 snapshot, reproduce the upgrade once on the cloned VM, and then collect the following:

* Windows Event Viewer logs from **Windows Logs > Application**
* Windows Event Viewer logs from **Windows Logs > System**
* PowerShell Universal logs from the failed startup attempt
* The approximate date, time, and time zone when the failure occurred
* The exact PSU version used during the failed test

Please export only the relevant Event Viewer time range as `.evtx` files and send the files directly to:

ruben.tapia@ironmansoftware.com

Please include case number **55723** in the email subject.

Do not attach `database.db`, complete configuration files, credentials, tokens, license information, or other customer data unless specifically requested after the initial log review.

Best regards,

Ruben Tapia

Hi Ruben, I reproduced the failure and captured the logs generated. I've emailed them to you.

Hello geofforlebeck,

Thank you for sending the ZIP file. We were able to extract and review the PSU log and Windows Event Viewer files successfully.

The evidence confirms that PSU 5.5.0 shut down normally before the installation. PSU 5.6.1 then failed repeatedly during its initial SQLite migration with the same `duplicate column name: DebugPreference` exception.

The MSI and Service Control Manager errors are secondary results of the PSU process terminating. The evidence does not currently indicate a Windows service permission or MSI installation problem. The remaining question is whether the existing SQLite schema and its Entity Framework migration history are out of sync.

Please perform the following only on a cloned VM restored from the working 5.5.0 snapshot:

1. Stop the PowerShell Universal service.
2. Create another backup copy of `C:\ProgramData\UniversalAutomation\database.db`.
3. Open only the copied database with a SQLite management tool.
4. Run these read-only queries:

PRAGMA quick_check;

SELECT name, sql
FROM sqlite_schema
WHERE type = 'table'
AND sql LIKE '%DebugPreference%';

SELECT MigrationId, ProductVersion
FROM __EFMigrationsHistory
ORDER BY MigrationId;

Please send the complete query results by replying to the same email thread. Do not modify the database, remove the `DebugPreference` column, or add records to `__EFMigrationsHistory`.

As an additional control on the cloned VM, after preserving the original database, you may temporarily move `database.db` outside the active directory and start PSU 5.6.1 once with a new database. Please let us know whether the service starts successfully. This test will help determine whether the problem is isolated to the existing database rather than the PSU installation or Windows service.

Please do not send the complete database unless we specifically request it.

Best regards,
Ruben Tapia

Ruben, I've performed the request above and sent you the details. Also confirming 5.6.1 started without issue when letting it create a fresh DB.

Hello geofforlebeck,

Thank you for completing the tests and providing the database query results.

The results confirm that PSU 5.6.1 starts successfully with a newly created database, while the upgrade failure remains isolated to the existing SQLite database.

We will consult with our Development team to determine whether it is viable to apply a specific correction to the existing database and, if so, what the supported procedure would be. At this stage, we cannot confirm that a database fix will be possible, and we do not have an estimated timeframe for their review.

For now, please continue using the restored PSU 5.5.0 environment and preserve the original database and VM snapshot. Please do not modify the database schema, remove the `DebugPreference` column, or manually change `__EFMigrationsHistory`.

We will update the thread after we receive guidance from Development.

Best regards,
Ruben Tapia

Hello geofforlebeck,

I apologize for the delay in following up on this case.

Based on the troubleshooting completed so far, including the SQLite migration results and the successful test with a newly created database, I have now escalated the case internally for further review.

The purpose of the escalation is to determine whether a supported correction can be applied to the existing database and, if so, what the safest procedure would be. At this point, I do not want to recommend any manual changes to DebugPreference, the database schema, or __EFMigrationsHistory until we receive guidance.

For now, please continue using the restored PSU 5.5.0 environment and preserve the existing database and VM snapshot unchanged.

I will update the thread once I receive additional guidance from the internal review.

Best regards,