[TABLE]
[TR]
[TD]
Again. Here is the query that initially gets created by the JAS engine. This query is fine, no errors.
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] SELECT * --field list editted/ommitted for brevity
FROM DVDTA.F4215 T1
INNER JOIN DVDTA.F4941 T0 ON T1.XHSHPN = T0.RSSHPN
LEFT OUTER JOIN DVDTA.F4942 T2 ON T1.XHSHPN = T2.ISSHPN
LEFT OUTER JOIN DVDTA.F5649421 T3 ON T2.ISKCOO = T3.ADKCOO AND T2.ISDOCO = T3.ADDOCO AND T2.ISDCTO = T3.ADDCTO AND T2.ISLNID = T3.ADLNID
LEFT OUTER JOIN DVDTA.F564311T T4 ON T2.ISDOCO = T4.DTDOCO AND T2.ISKCOO = T4.DTKCOO AND T2.ISDCTO = T4.DTDCTO AND T2.ISLNID = T4.DTLNID
WHERE (((((T1.XHSSTS >= ? AND T1.XHSSTS <= ? ) AND T0.RSLDNM < ? ) AND T1.XHMCU = ? )))
ORDER BY T1.XHSHPN ASC , T0.RSRSSN ASC
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] SQL statement parameter marker values are :
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] Param1 : 10_Types.VARCHAR,
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] Param2 : 99_Types.VARCHAR,
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] Param3 : 99999999_Types.NUMERIC,
29 May 2020 10:22:11,449 [APP ] ERILEY - [JDBJ] Param4 : 166300_Types.VARCHAR,
And here is the SAME query after it is re-issued with NO LOCK qualifiers by the JAS engine after the initial query times out. You will notice that it misplaces the “WITH (NO LOCK)” clauses, specifically it adds NO LOCK clauses after the join clauses in addition to the ones placed after the table identifiers.
29 May 2020 10:22:31,470 [SEVERE] ERILEY - [JDBJ] MS SQL query failed to execute within the specified timeout of 10000 ms. MS SQL query has been retried with this timeout 2 times. MS SQL query will now be executed with the NOLOCK option.
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] SELECT * --field list editted/ommitted for brevity
FROM DVDTA.F4215 T1 WITH (NOLOCK)
INNER JOIN DVDTA.F4941 T0 WITH (NOLOCK) ON T1.XHSHPN = T0.RSSHPN WITH (NOLOCK)
LEFT OUTER JOIN DVDTA.F4942 T2 WITH (NOLOCK) ON T1.XHSHPN = T2.ISSHPN WITH (NOLOCK)
LEFT OUTER JOIN DVDTA.F5649421 T3 WITH (NOLOCK) ON T2.ISKCOO = T3.ADKCOO AND T2.ISDOCO = T3.ADDOCO AND T2.ISDCTO = T3.ADDCTO AND T2.ISLNID = T3.ADLNID WITH (NOLOCK)
LEFT OUTER JOIN DVDTA.F564311T T4 WITH (NOLOCK) ON T2.ISDOCO = T4.DTDOCO AND T2.ISKCOO = T4.DTKCOO AND T2.ISDCTO = T4.DTDCTO AND T2.ISLNID = T4.DTLNID
WHERE (((((T1.XHSSTS >= ? AND T1.XHSSTS <= ? ) AND T0.RSLDNM < ? ) AND T1.XHMCU = ? )))
ORDER BY T1.XHSHPN ASC , T0.RSRSSN ASC
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] SQL statement parameter marker values are :
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] Param1 : 10_Types.VARCHAR,
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] Param2 : 99_Types.VARCHAR,
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] Param3 : 99999999_Types.NUMERIC,
29 May 2020 10:22:31,477 [APP ] ERILEY - [JDBJ] Param4 : 166300_Types.VARCHAR[/TD]
[/TR]
[/TABLE]