Designer and Scheduler Only user-managed SQL db persistence issue

[tamas_ondero]

I'm using Designer and Scheduler only and want to switch from SQLite to user-managed SQL DB for persistence.

The 2022 SQL server runs on the same machine where the Alteryx runs.

After the SQL connection string is provided the AlteryxService tries to restart and the tables are created in the database, but the AlteryxService stops.

This is the error in the Event Viewer:

Server Migrator failed with exit code <2993>. See Migrator Logs for detailed error message. This error must be addressed in order for the service to start.

These are the migrator log entries:

2025-05-12 19:51:02.608829;6;Staging path is not specified
2025-05-12 19:51:02.612949;6;Begining <Migration to 22.3> migration at <2025-05-12 17:51:02 W. Europe Standard Time> local time
2025-05-12 19:51:02.612985;6;Begining <RuntimeSettings migration> migration at <2025-05-12 17:51:02 W. Europe Standard Time> local time
2025-05-12 19:51:02.618492;7;Loaded <C:\Program Files\Alteryx\bin\RuntimeData\RuntimeSettings.xml> and <C:\ProgramData\Alteryx\RuntimeSettings.xml> for migration
2025-05-12 19:51:02.618541;5;RuntimeSettings have already been migrated; skipping RuntimeSettings migration
2025-05-12 19:51:02.618736;6;Ending <RuntimeSettings migration> migration at <2025-05-12 17:51:02 W. Europe Standard Time> local time. Total duration was approximately <0> seconds
2025-05-12 19:51:02.618760;7;All migrations successful
2025-05-12 19:51:02.618773;6;Ending <Migration to 22.3> migration at <2025-05-12 17:51:02 W. Europe Standard Time> local time. Total duration was approximately <0> seconds

And this is in the CSV file:

Date	LogLevel	ThreadId	ProcessName	LoggerName	Location	Message
51:04.1	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Alteryx Server Migrator is initialized.
51:04.1	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Server Mongo Db Migrations are not run as no connection string was provided.
51:04.2	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Server SQL Db Migrations are not run as no connection string was provided.
51:04.2	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Service Mongo Db Migrations are not run as no connection string was provided.
51:04.2	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Service Sql Db Migrations are not run as no connection string was provided.
51:09.4	INFO	1	AlteryxServerMigrator	migrationLogger	DoMigrateDatabase	No migration needed for Sqlite.
51:09.4	INFO	1	AlteryxServerMigrator	migrationLogger	UseParsedArguments	Finished SqLite Db Migrations
51:09.4	INFO	1	AlteryxServerMigrator	migrationLogger	WithParsed	Alteryx Server Migrator process has completed.

What is problem here?

Thanks,

Tamas

[KGT]

What instructions are you following? I'm surprised this is even allowed, let alone possible. It would mean that there has been significant development on the desktop automation, which hadn't had development for 10 years, and as of a couple years ago, wasn't planned to due to the myriad of situations it wouldn't work under. I can't find any info as to it having changed, and so presume that it is still SQLite only.

If this is something where you're trying to use the server migration tool designed for Server, then I don't think that will work.

[tamas_ondero]

hi KGT,

Thanks for the clarification, I thought it can be used for Designer + Scheduler too. Indeed the instructions are from the Server documentation.