Cannot Start Alteryx Service After Server Upgrade

Question

I have upgraded our Alteryx Server in Sandbox environment from 2023.1 to 2025.1.

Before the upgrade:

Stopped Alteryx Service in the Worker server.

Stopped Alteryx Service in the Controller server.

Stopped MongoDB service in the user-managed 3 MongoDB servers (replica set).

Upgrade:

Upgraded Controller Server.

Upgraded Worker Server.

After the upgrade:

Manually started MongoDB service in the user-managed 3 MongoDB servers (replica set).

Manually started Alteryx Service in the Controller server - FAILED.

Manually started Alteryx Service in the Worker server - FAILED.

Navigated through the System Settings in the Controller server - COMPLETED.

Navigated through the System Settings in the Worker server - FAILED. Encountered again the error "Alteryx Service and Client are incompatible" on the Remote Controller settings.

ALTERYX SERVICE LOG

2025-05-22 11:05:04.551000,ERROR,1448,AlteryxService,,,,,,,,,"S:\Alteryx\Service\AlteryxService_Client\src\RunAlteryxServerMigrator.cpp: 138. Server Migrator failed with exit code <3762504530>. See Migrator Logs for detailed error message. This error must be addressed in order for the service to start."

2025-05-22 11:05:04.806000,INFO,1448,AlteryxService,,,,,,,,,"ServicePoolController_Shutdown_Stop: Stopping plugin "

2025-05-22 11:05:04.806000,ERROR,1448,AlteryxService,,,,,,,,,"AlteryxService_SvcReportEvent: App message . See Migrator Logs for detailed error message. This error must be addressed in order for the service to start.>"

2025-05-22 11:05:04.806000,ERROR,1448,AlteryxService,,,,,,,,,"AlteryxService_LogStartupError: There was an error starting the Alteryx Service . See Migrator Logs for detailed error message. This error must be addressed in order for the service to start.>"

alteryx-service-migration.csv

Date,LogLevel,ThreadId,ProcessName,LoggerName,Location,Message,Exception

2025-05-22 11:05:01.810582,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Alteryx Server Migrator is initialized.,

2025-05-22 11:05:01.841832,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Server Mongo Database migrations will not be run via ServerMigrator.,

2025-05-22 11:05:01.841832,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Server SQL Db Migrations are not run as no connection string was provided.,

2025-05-22 11:05:01.873091,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Beginning Service Mongo Db Migrations,

2025-05-22 11:05:02.972236,FATAL,1,AlteryxServerMigrator,migrationLogger,VerifyDatabaseVersion,Database version 45 is newer than the code version 7.,

Same issues were encountered when I tried to upgrade from 2023.1 to 2024.1. I just performed rollback and decided to upgrade directly to 2025.1.

fmvizcaino · Answer

Hi @danielacaba ,

I have never seen this error before, probably because I have never upgraded a user-managed MongoDB. I would suggest opening a ticket with Alteryx Support.

Having said that, the error seems to be related to the MongoDB schema version, as you can see below. It appears to be a confusion between the AlteryxService schema version and the AlteryxGallery schema version

Maybe during the last upgrade or the current one, the collection containing the version was incorrectly updated, like adding 45 to the AlteryxService version.

I have never changed anything on this collection but you can give it a try and if it doesn`t work, wait for Alteryx support or just roll back once again.

Inside both AlteryxService and AlteryxGallery, there is a collection called versions. There, you will find the database schema version. I guess if you edit the number and add the correct one, it might fix your issue. Your 23.1 AlteryxService should be version 1 and AlteryxGallery 45.

https://help.alteryx.com/20231/en/server/configure/mongodb-management/mongodb-schema-reference/alteryxservice-mongodb-schema.html?lang=en#versions

https://help.alteryx.com/20231/en/server/configure/mongodb-management/mongodb-schema-reference/alteryxgallery-mongodb-schema.html#idp388910

My server is on 23.2, so the AlteryxService schema version is 2. (Using MongoDB Compass to access it)

See if this helps.

Best,

Fernando Vizcaino