Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Alteryx Service is unstable

asma_rez
8 - Asteroid

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

 

 

9 REPLIES 9
JoeS
Alteryx
Alteryx

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
8 - Asteroid

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
8 - Asteroid

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
8 - Asteroid

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
Alteryx
Alteryx

Is there definitely not anything else running on port 80?

asma_rez
8 - Asteroid

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
6 - Meteoroid

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

StephenR
Alteryx
Alteryx

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.

Regards,
Stephen Ruhl
Principal Customer Support Engineer

asifk
8 - Asteroid

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 

 

asifk_0-1655499602892.png

 

 

 

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