topic Re: Alteryx Service is unstable in Alteryx Server Discussions

Alteryx Service is unstable

asma_rez — Fri, 14 Dec 2018 15:50:25 GMT

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

Re: Alteryx Service is unstable

JoeS — Fri, 14 Dec 2018 15:58:39 GMT

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.

Re: Alteryx Service is unstable

asma_rez — Fri, 14 Dec 2018 16:05:00 GMT

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

Re: Alteryx Service is unstable

asma_rez — Fri, 14 Dec 2018 16:12:41 GMT

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

Re: Alteryx Service is unstable

asma_rez — Fri, 14 Dec 2018 16:26:15 GMT

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

Re: Alteryx Service is unstable

JoeS — Fri, 14 Dec 2018 16:29:34 GMT

Is there definitely not anything else running on port 80?

Re: Alteryx Service is unstable

asma_rez — Fri, 14 Dec 2018 16:43:46 GMT

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

Re: Alteryx Service is unstable

rajeshvarmar — Wed, 27 Mar 2019 05:54:11 GMT

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

Re: Alteryx Service is unstable

StephenRuhl — Tue, 02 Apr 2019 13:58:55 GMT

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.

Re: Alteryx Service is unstable

asifk — Fri, 17 Jun 2022 20:58:33 GMT

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

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