Workflows not executed on the Server

asma_rez — Thu, 18 Jul 2019 12:38:32 GMT

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

Re: Workflows not executed on the Server

MichalM — Thu, 18 Jul 2019 14:33:17 GMT

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

topic Re: Workflows not executed on the Server in Alteryx Server Discussions

Workflows not executed on the Server

Re: Workflows not executed on the Server