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.

Workflows not executed on the Server

asma_rez
8 - Asteroid

Hi All,

 

In my company, the deployed workflows are scheduled to be executed daily. We have observed that during two days, workflows were not executed.

The architecture is : Alteryx Serve Full Installation + second server with only worker

In logs I have found these errors : 

 

2019-07-12 05:58:01.199000,INFO,4804,AlteryxService,ServiceThreadPool,,,,,,,"QueueHandler::Handle_GetJob() passing job ID <5d28216941932114f0052607> to worker <Server_Name|E3826659>"
2019-07-12 05:58:01.202000,INFO,4804,AlteryxService,ServiceThreadPool,,,,,,,"QueueHandler::Handle_GetJob() updated record <5d28216941932114f0052607>"
2019-07-12 05:58:01.209000,DEBUG,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"SlaveStatusThread: Starting worker <Server_Name|E3826659> server <localhost:80> queue id <5d28216941932114f0052607>"
2019-07-12 05:58:01.308000,ERROR,8164,AlteryxService,ServiceThreadPool,,,,,,,"EncryptBody.cpp: 31. Error responding to client: HttpSendHttpResponse error (22)"
2019-07-12 05:58:01.311000,ERROR,8164,AlteryxService,ServiceThreadPool,,,,,,,"PersistenceHandler_SendResponse_Error: Error in persistence container <Error responding to client: HttpSendHttpResponse error (22)>, resetting and rethrowing."
2019-07-12 05:58:01.312000,ERROR,8164,AlteryxService,ServiceThreadPool,,,,,,,"EncryptBody.cpp: 29. The client disconnected: Request id <15348267540816145179>"
2019-07-12 05:58:01.312000,ERROR,8164,AlteryxService,ServiceThreadPool,,,,,,,"EncryptedQlzOutput_SendPacket_Error: Error sending packet <The client disconnected: Request id <15348267540816145179>>"
2019-07-12 05:58:01.312000,WARN,8164,AlteryxService,ServiceThreadPool,,,,,,,"InProcessHandler_HttpSendResponse_Error: After SendResponse request id <15348267540816145179> URL <http://localhost:80/AlteryxService/Persistence/> Error <Error responding to client: HttpSendHttpResponse error (22)>"
2019-07-12 05:58:01.397000,ERROR,1664,AlteryxService,ServiceThreadPool,,,,,,,"EncryptBody.cpp: 29. The client disconnected: Request id <15348267540816145181>"
2019-07-12 05:58:01.401000,ERROR,1664,AlteryxService,ServiceThreadPool,,,,,,,"PersistenceHandler_SendResponse_Error: Error in persistence container <The client disconnected: Request id <15348267540816145181>>, resetting and rethrowing."
2019-07-12 05:58:01.402000,ERROR,1664,AlteryxService,ServiceThreadPool,,,,,,,"EncryptBody.cpp: 29. The client disconnected: Request id <15348267540816145181>"
2019-07-12 05:58:01.402000,ERROR,1664,AlteryxService,ServiceThreadPool,,,,,,,"EncryptedQlzOutput_SendPacket_Error: Error sending packet <The client disconnected: Request id <15348267540816145181>>"
2019-07-12 05:58:01.402000,WARN,1664,AlteryxService,ServiceThreadPool,,,,,,,"InProcessHandler_HttpSendResponse_Error: After SendResponse request id <15348267540816145181> URL <http://localhost:80/AlteryxService/Persistence/> Error <The client disconnected: Request id <15348267540816145181>>"
2019-07-12 05:58:01.551000,DEBUG,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"SlaveThread_DoWork_RunningJob: Worker <Server_Name|E3826659> job <5d28216941932114f0052607> localApplication <0> setting job status to running."
2019-07-12 05:58:01.554000,DEBUG,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"SlaveThread_DoWork_Staging: Staging directory <D:\ProgramData\Alteryx\Service\Staging\5360_a1f13e2e561b45e7aa2294eccc523459\> workflow name <AMP Group - Monthly.yxwz>"
2019-07-12 05:58:01.554000,INFO,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"SlaveThread_DoWork_RunWizard: Worker <Server_Name|E3826659> job <5d28216941932114f0052607> calling AlteryxExecute_RunWizard."
2019-07-12 05:58:01.555000,INFO,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"AlteryxExecute_RunWizard: Running workflow <AMP Group - Monthly.yxwz> fixed params <<Parameters> <TempFiles>D:\ProgramData\Alteryx\Service\Staging\5360_a1f13e2e561b45e7aa2294eccc523459\__StageTemp</TempFiles> <AllowPersistentTempFiles>True</AllowPersistentTempFiles> <RunMode>Standard</RunMode><RestrictedDataMode>False</RestrictedDataMode><ForceUpdateOnly>False</ForceUpdateOnly><Timeout>0</Timeout><DisableTempFolderCleanup>True</DisableTempFolderCleanup><Username>alteryxservice</Username> <PasswordEncrypted>201000000D08C9DDF0115D1118C7A00C04FC297EB0100000046AD7F2CEACC0345963C85A4061103460400000008000000500057004400000003660000C00000001000000075178E2A3EBD379810FAD0349010EE620000000004800000A000000010000000AC17F1134A926C19279544E489131CA6180000005DEABACE0F0530BA82A160B6EC8EA3652002B8D876BA054614000000040B55C1DAB72B402FE38C52CA00AE79C2260262</PasswordEncrypted> <Domain>LU</Domain> <SortJoinMemory>8191</SortJoinMemory> <RunAtLowerPriority>False</RunAtLowerPriority><ReportSingleProgress>True</ReportSingleProgress></Parameters> >"
2019-07-12 05:58:01.555000,DEBUG,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"AlteryxExecute_RunWizard_Wizard: Analytic App values <<WizardValues><Value name=""Radio Button (75)"">True</Value><Value name=""Radio Button (76)"">False</Value><Value name=""Drop Down (77)"">LU26527555 - B176559 - AMP_Capital_Investors_(IDF_II_JPY_N°2)_S.à_r.l.</Value><Value name=""Numeric Up Down (78)"">2019</Value><Value name=""Numeric Up Down (79)"">4</Value><Value name=""File Browse (88)""><![CDATA[In_5d28214041932114f0052603\VAT compliance spreadsheet - IDF II JPY No2 - Apr19.xlsm|`Sales_Services_No Invoice$`]]></Value><Value name=""File Browse (93)""><![CDATA[]]></Value><Value name=""Date (95)"">2019-04-30</Value><Value name=""File Browse (99)""><![CDATA[In_5d28215d41932114f0052606\VAT compliance spreadsheet - IDF II JPY No2 - Apr19.xlsm|`Purchases_Services_Invoice$`]]></Value></WizardValues>>"
2019-07-12 05:58:02.982000,NOTICE,320,AlteryxService,RenderQueue,,,,,,,"ServicePluginMapTile::AdjustThreads: Growing thread pool count to <0>"
2019-07-12 05:58:03.427000,INFO,4856,AlteryxService,Server_Name|E3826659,9b2118fad7d24a97a8363f129174db79,5c7d53fab730e522a46ae9b9,,,,,"SlaveThread_DoWork_Complete: Worker <Server_Name|E3826659> job <5d28216941932114f0052607> complete, engine status <1> approx. engine time <1> seconds"
2019-07-12 05:58:03.450000,NOTICE,7712,AlteryxService,ServiceThreadPool,,,,,,,"QueueHandler::GrowServicePoolThreads: Growing thread pool count to <4>"
2019-07-12 05:58:03.450000,DEBUG,7712,AlteryxService,ServiceThreadPool,,,,,,,"QueueHandler_ReadBody_WorkerCommand: Command <GetJob> worker <Server_Name|E3826659>"
2019-07-12 05

 

Any help will be appreciated

Thanks and regards

1 REPLY 1
MichalM
Alteryx
Alteryx

@asma_rez 

 

I'd suggest you send the log, details of the version of Alteryx you're running and the Server configuration (RuntimeSettings.xml which can be found in C:\ProgramData\Alteryx) to support@alteryx.com and they will be able to help you out.