Update - debugging it again and it appears to be hanging on a SELECT statement. It tries once, times out 17 times as per the jde.ini setting then hangs.
It's been doing nothing for 90 minutes so far. I <think> when this happens it adds WITH (NOLOCK) to the joins in the Select and retries, I suspect that's what it's hanging on.
Last entries in the jdedebug.log as follows, it's currently 1:59pm:-
Feb 08 12:11:56.239020 - 4124/5056 UNKNOWN SELECT DISTINCT T0.YTAN8, T0.YTPRTR, T0.YTCO, T0.YTHMCU, T0.YTMCU, T0.YTGMCU, T0.YTGOBJ, T0.YTGSUB, T0.YTPHRW, T0.YTPDBA, T0.YTDGL, T0.YTDWK, T0.YTEXR, T0.YTGICU, T0.YTAID, T0.YTALT0, T0.YTCRCD, T0.YTCRDC, T1.MCMCU, T1.MCAN8O, T1.MCDL01, T1.MCRP25, T1.MCANPA, T1.MCMCUS, T2.GLKCO, T2.GLDCT, T2.GLDOC, T2.GLDGJ, T2.GLJELN, T2.GLEXTL, T2.GLPOST, T2.GLICU, T2.GLCO, T2.GLAID, T2.GLMCU, T2.GLOBJ, T2.GLSUB, T2.GLLT, T2.GLCRCD, T2.GLAA, T2.GLU, T2.GLODOC, T2.GLALT1, T2.GLBC, T2.GLBCRC, T2.GLCRRM, T3.ABAN8, T3.ABALPH FROM JDE_PRODUCTION.PRODDTA.F0618 T0,JDE_PRODUCTION.PRODDTA.F0006 T1,JDE_PRODUCTION.PRODDTA.F0911 T2,JDE_PRODUCTION.PRODDTA.F0101 T3 WHERE ( ( T0.YTGOBJ = '501010' AND T2.GLPOST = 'P' ) AND ( T0.YTDWK >= 116336 AND T1.MCRP25 = '1400' AND T0.YTDWK <= 116366 AND T1.MCRP25 = '1400' ) ) AND ( T0.YTUSER NOT BETWEEN 'JOBHR ' AND 'JOBJR ' ) AND ( T1.MCUSER NOT BETWEEN 'JOBHR ' AND 'JOBJR ' ) AND ( T2.GLUSER NOT BETWEEN 'JOBHR ' AND 'JOBJR ' ) AND ( T3.ABUSER NOT BETWEEN 'JOBHR ' AND 'JOBJR ' ) AND ( T0.YTGMCU = T1.MCMCU AND T0.YTGMCU = T2.GLMCU AND T0.YTGOBJ = T2.GLOBJ AND T0.YTGSUB = T2.GLSUB AND T0.YTGICU = T2.GLICU AND T0.YTAN8 = T3.ABAN8 ) ORDER BY T0.YTAN8 ASC,T0.YTDWK ASC,T0.YTPRTR ASC
Feb 08 12:11:56.239021 - 4124/5056 UNKNOWN Entering DBPerformRequest
Feb 08 12:11:56.239022 - 4124/5056 UNKNOWN ODBC:S DBPerformRequest req=27722890 con=0B545838 env=00EAAEA8 dbc=00EAAF20 spid=94 TOCPDBERP A (MSIUSER@TOCPDBERP)
Feb 08 12:11:57.241000 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7856] wSQLExecute failure. rc = -1
Feb 08 12:11:57.241001 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7856] STMT:00 [HYT00][0] [Microsoft][SQL Server Native Client 11.0]Query timeout expired
Feb 08 12:11:57.241002 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7893] wSQLCloseCursor - warning: invalid cursor state failure. rc = -1
Feb 08 12:11:57.241003 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7893] STMT:00 [24000][0] [Microsoft][SQL Server Native Client 11.0]Invalid cursor state
<repeated 17 times>
Feb 08 12:12:12.681002 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7893] wSQLCloseCursor - warning: invalid cursor state failure. rc = -1
Feb 08 12:12:12.681003 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7893] STMT:00 [24000][0] [Microsoft][SQL Server Native Client 11.0]Invalid cursor state
Feb 08 12:12:13.786000 - 4124/5056 UNKNOWN ODBC[JDBODBC.C,7856] wSQLExecute failure. rc = -1