Good day,
I tend to get these errors often. SQL connections are closed. The web app also accepts API connections from Mobile App
Any ideas why this happens?
I tend to get these errors often. SQL connections are closed. The web app also accepts API connections from Mobile App
Any ideas why this happens?
Error Log:
03/24/2022 10:30:20 SQLExecuteMaps 2:
select isp.*, prd.productname,prd.productcode from outbound_delivery_products isp inner join products prd on prd.id = isp.productid
where deliveryid = 29181 and productidactive = 1 AND isp.verifiedby IS NOT null AND isp.pickedby IS NOT null order by createddate desc LIMIT 0, 10000
(MyMap) {phase=outverify, clienttype=External, productcode=SASOLWAX_M3B_PPE20, producttypeflag=2, bayno=NA, palletno=1, isexported=0, packeddate=, producttype=2, productidactive=1, isdamaged=0, productbatch=2201WD2034, labno=, deliveryid=29181, hku=100000000000157218, warehouseid=4, productquantity=35.0, productdeliveryno=85114176, movement=0, remarks=}
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:24 SQLExecuteMap 1: SELECT * FROM outbound_delivery WHERE id= ? AND deliveryactive= ?
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11614
Svr Current Thread: 100
1313
(MyMap) {action=[Ljava.lang.String;@45d25624, pdata=[Ljava.lang.String;@25199514, post2=[Ljava.lang.String;@e8a9f7c, post1=[Ljava.lang.String;@455e7dc9}
(HttpInputOverHTTP) HttpInputOverHTTP@126a7030[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
java.lang.RuntimeException: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:96)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:130)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doPost(JServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:482)
at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:327)
at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:297)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:531)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:579)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:553)
at anywheresoftware.b4j.objects.SQL.ExecQuery2(SQL.java:365)
at za.co.irays.slms.abmshared._sqlexecutemap(abmshared.java:18631)
at za.co.irays.slms.abmshared._sqlrecordread(abmshared.java:19156)
at za.co.irays.slms.svrinboundschedule._loadoutbounddeliverydetails(svrinboundschedule.java:2793)
at za.co.irays.slms.svrinboundschedule._handle(svrinboundschedule.java:1546)
at jdk.internal.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:567)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
... 54 more
Caused by: java.lang.InterruptedException
at java.base/java.lang.Object.wait(Native Method)
at java.base/java.lang.Object.wait(Object.java:320)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:569)
... 66 more
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11631
Svr Current Thread: 99
1323
(MyMap) {action=[Ljava.lang.String;@1e667f9b, schstatus=[Ljava.lang.String;@5b64e233, pagecount=[Ljava.lang.String;@3fb98cf8, userid=[Ljava.lang.String;@6af53aaf}
(HttpInputOverHTTP) HttpInputOverHTTP@4687c3f1[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11626
Svr Current Thread: 99
1324
(MyMap) {action=[Ljava.lang.String;@73e5a79d, pdata=[Ljava.lang.String;@359ef848, post2=[Ljava.lang.String;@425cd6c0, post1=[Ljava.lang.String;@4dcdd7b9}
(HttpInputOverHTTP) HttpInputOverHTTP@13ca58d2[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
java.lang.RuntimeException: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:96)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:130)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doPost(JServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:482)
at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:327)
at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:297)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:531)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:579)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:553)
at anywheresoftware.b4j.objects.SQL.ExecQuery2(SQL.java:365)
at za.co.irays.slms.abmshared._sqlexecutemap(abmshared.java:18631)
at za.co.irays.slms.abmshared._sqlrecordread(abmshared.java:19156)
at za.co.irays.slms.svrinboundschedule._loadoutbounddeliverydetails(svrinboundschedule.java:2793)
at za.co.irays.slms.svrinboundschedule._handle(svrinboundschedule.java:1546)
at jdk.internal.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:567)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
... 54 more
Caused by: java.lang.InterruptedException
at java.base/java.lang.Object.wait(Native Method)
at java.base/java.lang.Object.wait(Object.java:320)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:569)
... 66 more
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11630
Svr Current Thread: 99
1325
(MyMap) {action=[Ljava.lang.String;@5d14770, pdata=[Ljava.lang.String;@123ee5fe, post2=[Ljava.lang.String;@341e64e7, post1=[Ljava.lang.String;@6a1b98cb}
(HttpInputOverHTTP) HttpInputOverHTTP@79009f3e[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11623
Svr Current Thread: 99
1316
(MyMap) {action=[Ljava.lang.String;@2c69bad4, pdata=[Ljava.lang.String;@65ef557, post2=[Ljava.lang.String;@24a3283c, post1=[Ljava.lang.String;@1b427b5f}
(HttpInputOverHTTP) HttpInputOverHTTP@7a9ccdf9[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11622
Svr Current Thread: 99
1317
(MyMap) {action=[Ljava.lang.String;@4488a0f0, schstatus=[Ljava.lang.String;@47436bc3, pagecount=[Ljava.lang.String;@531fb5e4, userid=[Ljava.lang.String;@6fac6d73}
(HttpInputOverHTTP) HttpInputOverHTTP@588efbd5[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11628
Svr Current Thread: 99
1319
(MyMap) {action=[Ljava.lang.String;@7fdd1e6f, pdata=[Ljava.lang.String;@562c050c, post2=[Ljava.lang.String;@3a376fb7, post1=[Ljava.lang.String;@76c666d7}
(HttpInputOverHTTP) HttpInputOverHTTP@61ff2006[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11505
Svr Current Thread: 99
1273
(MyMap) {cc=[Ljava.lang.String;@3e87a323, action=[Ljava.lang.String;@28c08c89, ver=[Ljava.lang.String;@66a3290f, pdata=[Ljava.lang.String;@10d97644, uname=[Ljava.lang.String;@134441c7}
(HttpInputOverHTTP) HttpInputOverHTTP@3f4c33e2[c=626,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
IsAuthorized is null
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11583
Svr Current Thread: 99
1303
(MyMap) {action=[Ljava.lang.String;@3586a272, schstatus=[Ljava.lang.String;@457525f1, pagecount=[Ljava.lang.String;@1d21cb6c, userid=[Ljava.lang.String;@20868510}
(HttpInputOverHTTP) HttpInputOverHTTP@20933640[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11603
Svr Current Thread: 99
1310
(MyMap) {action=[Ljava.lang.String;@4d094e4e, pdata=[Ljava.lang.String;@601a6910, post2=[Ljava.lang.String;@7f132a7e, post1=[Ljava.lang.String;@5a30f9b9}
(HttpInputOverHTTP) HttpInputOverHTTP@5d4ca78f[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52 SQLExecuteMaps 2:
select isp.*, prd.productname,prd.productcode from outbound_delivery_products isp inner join products prd on prd.id = isp.productid
where deliveryid = 29181 and productidactive = 1 order by createddate desc LIMIT 0, 10000
03/24/2022 10:30:52 SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
from outbound_delivery ins
inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
FROM outbound_delivery_products idp
WHERE idp.productidactive = 1
GROUP BY idp.deliveryid) idp
ON idp.deliveryid = ins.id
where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33)
GROUP BY ins.id
order by updateddate desc LIMIT 0 , 50
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52 SQLExecuteMaps 2:
select isp.*, prd.productname,prd.productcode from outbound_delivery_products isp inner join products prd on prd.id = isp.productid
where deliveryid = 29181 and productidactive = 1 order by createddate desc LIMIT 0, 10000
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52 SQLExecuteMaps 2:
select productquantityperpackage,producttype from products
where productcode = 'HKQ205_P' and productactive = 1 AND producttype = 32
03/24/2022 10:30:52 SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
from outbound_delivery ins
inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
FROM outbound_delivery_products idp
WHERE idp.productidactive = 1
GROUP BY idp.deliveryid) idp
ON idp.deliveryid = ins.id
where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33,4,5)
GROUP BY ins.id
order by updateddate desc LIMIT 0 , 50
03/24/2022 10:30:52 SQLExecuteMaps 2:
select isp.*, prd.productname,prd.productcode from outbound_delivery_products isp inner join products prd on prd.id = isp.productid
where deliveryid = 29181 and productidactive = 1 order by createddate desc LIMIT 0, 10000
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52 SQLExecuteMaps 2:
select productquantityperpackage,producttype from products
where productcode = 'H1PJ700_N' and productactive = 1 AND producttype = 1
03/24/2022 10:30:52 SQLExecuteMaps 2:
select productquantityperpackage,producttype from products
where productcode = 'HRV140_P' and productactive = 1 AND producttype = 32
03/24/2022 10:30:52 SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
from outbound_delivery ins
inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
FROM outbound_delivery_products idp
WHERE idp.productidactive = 1
GROUP BY idp.deliveryid) idp
ON idp.deliveryid = ins.id
where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33)
GROUP BY ins.id
order by updateddate desc LIMIT 0 , 50
03/24/2022 10:30:52 SQLExecuteMaps 2: SELECT * FROM products WHERE productactive= ? AND productcode= ? AND producttype= ?
(ArrayList) [29181, 744, 2201WD2034, 35.0, 100000000000157218]
Select id from outbound_delivery_products where productidactive=1 AND deliveryid =? AND productid = ? AND productbatch=? AND productquantity=? AND hku=?
(MyMap) {clienttype=External, productcode=SASOLWAX_M3B_PPE20, producttypeflag=2, bayno=NA, palletno=1, isexported=0, packeddate=, producttype=2, productidactive=1, isdamaged=0, productbatch=2201WD2034, labno=, deliveryid=29181, hku=100000000000157218, warehouseid=4, productquantity=35.0, productdeliveryno=85114176, movement=0, createddate=1648110652700, userid=160, productid=744, source=2}
Pool Data : pool connections = 42 out of a max. 100
Pool Data : pool connections = 45 out of a max. 100
03/24/2022 10:30:52 SQLExecuteMap 1: SELECT * FROM drpw_users WHERE email= ?
AppPackage za.co.sammarlogistics.live
Pool Data : pool connections = 45 out of a max. 100
