RE: Job is stuck on TIMW - how can i nudge it along? Kind a urgetm

The program is executing an SQL HTTP_POST request out to Vertex. We had connection issues last night and now the last request went out and never returned.

112600 // Send request & receive response. Move response into responseText
112700 //* exec sql
112800 //* values qsys2.HTTP_POST (trim(:url), :requestText)
112900 //* into :responseText;
112900 SQL_00197 = %ADDR(REQUESTTEXT);
112900 SQL_00198 = %ADDR(RESPONSETEXT);
112900 SQL_00196 = URL;
112900 SQLER6 = -4;
112900 SQLROUTE_CALL(
112900 SQLCA
112900 : SQL_00191
112900 );
112900 IF SQL_00194 = '1';
112900 ENDIF;
113000




Paul Therrien
Ext. 2230
ptherrien@xxxxxxxxxxx

-----Original Message-----
From: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
Sent: Saturday, June 21, 2025 10:16 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: midrange-l@xxxxxxxxxxxxxxxxxx; Paul Therrien <ptherrien@xxxxxxxxxxx>
Subject: Re: Job is stuck on TIMW - how can i nudge it along? Kind a urgetm

What is it waiting on? If it’s a resource that’s no longer available then the only option is to end it


Jim Oberholtzer
Agile Technology Architects

On Jun 21, 2025, at 8:52 AM, Paul Therrien via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:


I have a job that is on TIMW status and has not moved in over 8 hours. I am loathe to cancel it.
How can I get it to proceed?


Paul Therrien
Ext. 2230
ptherrien@xxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
n=lists.midrange.com or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.