Alteryx Service is unstable

[asma_rez]

Hello Community,

i have installed one full node of Alteryx server. I created a DNS and Virtual ip accessible via F5 in order to access the gallery (Please see attachment Alteryx1)

After doing that Alteryx server goes down. When I try to start it it never happen, then it will started and stopped without a reason so it is very unstable. (Alteryx2)

D:\Program Files\Alteryx\bin>alteryxservice stop
AlteryxService Stopped

D:\Program Files\Alteryx\bin>alteryxservice start
Service failed to start: Win32 Error: An instance of the service is already running. (1056)

D:\Program Files\Alteryx\bin>alteryxservice start
Service failed to start: Win32 Error: An instance of the service is already running. (1056)

D:\Program Files\Alteryx\bin>AlteryxService test
AlteryxService version: 2018.4.4.54346 PID: 3080 main thread: 5460
Requested log path exists <D:\ProgramData\Alteryx\Service\AlteryxServiceLog.log> using <D:\ProgramData\Alteryx\Service\AlteryxServiceLog_1.log>.
Local logging enabled level <7> path <D:\ProgramData\Alteryx\Service\AlteryxServiceLog_1.log>.
Starting Logging service...
There was an error starting the Alteryx Service:
Failed to register Service URL (183).
Please contact your Systems Administrator to ensure that port 80 is unused and open for inbound connections,
and verify that the Alteryx Service is not already running on this system.

D:\Program Files\Alteryx\bin>alteryxservice start
The Service is not starting in a timely manner.

Any idea please?

How can I open an incident to the support team?

Many thanks

Asma

[JoeS]

Hi Asma,

In your URL you are using HTTPS so should look to check "Enable SSL" rather than just adding the s to the Base Address.

This will make it use port 443 rather than 80.

Let me know how that goes.

[asma_rez]

Hello

Thanks  for your answer

I did not use certificate SSL

I am using the URL via F5 , so F5 is running on HTTPS So even for this I should check Enable SL too?

Thanks

Asma

[asma_rez]

I have checked the Enable SSL but I have still this message

D:\Program Files\Alteryx\bin>AlteryxService test
AlteryxService version: 2018.4.4.54346 PID: 2872 main thread: 416
Requested log path exists <D:\ProgramData\Alteryx\Service\AlteryxServiceLog.log> using <D:\ProgramData\Alteryx\Service\AlteryxServiceLog_1.log>.
Local logging enabled level <7> path <D:\ProgramData\Alteryx\Service\AlteryxServiceLog_1.log>.
Starting Logging service...
There was an error starting the Alteryx Service:
Failed to register Service URL (183).
Please contact your Systems Administrator to ensure that port 80 is unused and open for inbound connections,
 and verify that the Alteryx Service is not already running on this system.

Thnx

Asma

[asma_rez]

to register Service URL (183). Please contact your Systems Administrator to ensure that port 80 is unused and open for inbound connections,  and verify that the Alteryx Service is not already running on this system."
2018-12-14 15:40:05.685000,ERROR,5460,AlteryxService,Main,,alteryxservice,,,,,"AlteryxService_SvcReportEvent: App <AlteryxService> message <Failed to register Service URL (183). Please contact your Systems Administrator to ensure that port 80 is unused and open for inbound connections,  and verify that the Alteryx Service is not already running on this system.>"
2018-12-14 15:40:05.687000,ERROR,5460,AlteryxService,Main,,alteryxservice,,,,,"AlteryxService_LogStartupError: There was an error starting the Alteryx Service <Failed to register Service URL (183). Please contact your Systems Administrator to ensure that port 80 is unused and open for inbound connections,  and verify that the Alteryx Service is not already running on this system.>"
2018-12-14 16:10:25.017000,ALERT,6444,AlteryxService,Main,,alteryxservice,,,,,"AlteryxService starting version <2018.4.4.54346> PID <808> Main thread <6444> Command <AlteryxService test>"

[JoeS]

Is there definitely not anything else running on port 80?

[asma_rez]

D:\Program Files\Alteryx\bin>netstat -aon | findstr :80

D:\Program Files\Alteryx\bin>alteryxservice start
The Service is not starting in a timely manner.

D:\Program Files\Alteryx\bin>netstat -aon | findstr :80
  TCP    0.0.0.0:80             0.0.0.0:0              LISTENING       4
  TCP    alteryxserverip:52154    alteryxserverip:80       SYN_SENT        992
  TCP    alteryxserverip:52158    alteryxserverip:80       SYN_SENT        992
  TCP    127.0.0.1:80           127.0.0.1:52127        TIME_WAIT       0
  TCP    127.0.0.1:80           127.0.0.1:52149        TIME_WAIT       0
  TCP    127.0.0.1:80           127.0.0.1:52150        TIME_WAIT       0
  TCP    127.0.0.1:80           127.0.0.1:52155        ESTABLISHED     4
  TCP    127.0.0.1:80           127.0.0.1:52156        ESTABLISHED     4
  TCP    127.0.0.1:80           127.0.0.1:52157        ESTABLISHED     4
  TCP    127.0.0.1:52155        127.0.0.1:80           ESTABLISHED     7160
  TCP    127.0.0.1:52156        127.0.0.1:80           ESTABLISHED     2932
  TCP    127.0.0.1:52157        127.0.0.1:80           ESTABLISHED     992
  TCP    [::]:80                [::]:0                 LISTENING       4

[rajeshvarmar]

how did you resolve this? any updates further? because I'm also facing the same issue. Thanks.

[StephenR · Accepted solution]

Hello @asma_rez , what is happening is that you are terminating SSL at F5.

When you log in an oauth signature is created from the URL you are using. If you use https, and then are routed to port 80 on Gallery, the oauth signature will not match, since the oauth signature was created using https, and the Gallery is expecting an oauth signature created with http.

So, it is important when using SSL, to terminate SSL at the Gallery and port 443, not somewhere before.

[asifk]

Good day, 

I am also experiencing a similar issue , have upgraded from 2020.3 to v2021.4

I have also updated the system settings and changed the port to 8080. This has improved/ resolved but the Alteryx Service is still not starting up 

Spoiler

2022-06-17 20:45:29.172000,DEBUG,6504,AlteryxService,EmbeddedMongoManager,,,,,,,,"EmbeddedMongoManager_DoWork_StartedPipe: PID <6808> command line <""E:\Program Files\Alteryx\bin\AlteryxService_MongoController.exe"" InputPipe=\\.\pipe\80b85382-cc0e-45ff-816e-2500bcc109ed_In OutputPipe=\\.\pipe\80b85382-cc0e-45ff-816e-2500bcc109ed_Out ServerName=localhost:8080 ServerSecretEncrypted=201000000D08C9DDF0115D1118C7A00C04FC297EB01000000D07131FEE81AE94389BC8ADE5BE2BC9B0400000008000000500057004400000003660000C00000001000000056503B2A08B64D19C3B7C620223F76FD0000000004800000A000000010000000A17B592D51FBB6FD3FECC9F4D428D97D58000000FCC020EE90A7CE99DCD1D52655110C3F70B71725E815BC76AD0FE11D2BD3F8ED865702DAFA14CD636F9BEAEF73066D2FF0FDA39A27BDD22A04F2C878FD95EE4BF535DCC222EED6E3F3095E1CFF1FCA6414815667D7CD3DF514000000C6CFF2C5B01A91DA779ECC904D30EE033D5E1562 MongoRoot=""E:\Program Files\Alteryx\bin\\"" DBName=AlteryxService DBRoot=""E:\Alteryx Data\Service\Persistence\MongoDB"" Port=27018 EnableReplSet=0>"
2022-06-17 20:45:29.172000,DEBUG,5720,AlteryxService,MongoController,,,,2022-06-17 20:45:29.170366,za01alteryxprd,6808,3288,"MongoDaemon_ReadCredentials: Path <E:\Alteryx Data\Service\Persistence\MongoDB\ASCredentials.bin>"
2022-06-17 20:45:29.174000,INFO,4940,AlteryxService,MongoController,,,,2022-06-17 20:45:29.171354,za01alteryxprd,6808,3288,"MongoController_InitDaemon_Exiting: Exiting InitDaemon."
2022-06-17 20:45:29.619000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePluginEmbeddedMongo_WaitForStartupImpl: Waiting for startup, mongo manager state <1>"
2022-06-17 20:45:30.120000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePluginEmbeddedMongo_WaitForStartupImpl: Waiting for startup, mongo manager state <1>"
2022-06-17 20:45:30.176000,DEBUG,6672,AlteryxService,MongoController,,,,2022-06-17 20:45:30.174618,za01alteryxprd,6808,660,"MongoPool_Connect_NewConnection: Made new pool connection, id <local>"
2022-06-17 20:45:30.621000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePluginEmbeddedMongo_WaitForStartupImpl: Waiting for startup, mongo manager state <1>"
2022-06-17 20:45:31.122000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePluginEmbeddedMongo_WaitForStartupImpl: Waiting for startup, mongo manager state <1>"
2022-06-17 20:45:31.624000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePluginEmbeddedMongo_WaitForStartupImpl: Waiting for startup, mongo manager state <1>"
2022-06-17 20:45:31.628000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"MongoPool_Connect_NewConnection: Made new pool connection, id <AlteryxService>"
2022-06-17 20:45:31.628000,DEBUG,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"PersistenceContainer_MongoDBImpl_VerifyConnection_Success: Connection succeeded."
2022-06-17 20:45:31.628000,NOTICE,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"PersistenceContainer_MongoDBImpl_Init: Creating index cache for collection <AS_Galleries>"
2022-06-17 20:46:00.177000,ERROR,5916,AlteryxService,MongoController,,,,2022-06-17 20:46:00.175480,za01alteryxprd,6808,660,"MongoDaemon_PingImpl_SocketError: Error <No suitable servers found: `serverSelectionTimeoutMS` expired: [Failed to connect to target host: localhost:27018]: generic server error> code <mongodb:13053>"
2022-06-17 20:46:00.179000,WARN,5720,AlteryxService,MongoController,,,,2022-06-17 20:46:00.175480,za01alteryxprd,6808,660,"MongoDaemon_Ping_Failed: Ping failed to server <localhost:27018> db <local>"
2022-06-17 20:46:00.181000,WARN,4940,AlteryxService,MongoController,,,,2022-06-17 20:46:00.175480,za01alteryxprd,6808,660,"MongoController_DoWork_PingFailed: Ping failed, fail count <1>."
2022-06-17 20:46:01.625000,ERROR,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"S:\Alteryx\Service\AlteryxService_Client\src\Persistence_MongoDB.cpp: 407. Mongo error: ""No suitable servers found: `serverSelectionTimeoutMS` expired: [Failed to connect to target host: localhost:27018]: generic server error"" code: <mongodb:13053>"
2022-06-17 20:46:01.625000,INFO,3208,AlteryxService,Main,,zsvcalteryx,,,,,,"ServicePoolController_Shutdown_Stop: Stopping plugin <EmbeddedMongo>"
2022-06-17 20:46:01.626000,INFO,6504,AlteryxService,EmbeddedMongoManager,,,,,,,,"EmbeddedMongoManager_DoWork_Cancel: Mongo manager requesting cancel."
2022-06-17 20:46:01.628000,INFO,6672,AlteryxService,MongoController,,,,2022-06-17 20:46:01.626862,za01alteryxprd,6808,3288,"MongoController_StartPipes_Out_Cancel: Cancel requested by host."
2022-06-17 20:46:01.631000,INFO,5916,AlteryxService,MongoController,,,,2022-06-17 20:46:01.627865,za01alteryxprd,6808,3288,"MongoController_Stop_Entered: MongoContoller::Stop entered."

Please can you urgently assist me

Regards,
Asif