Trace.log as follows.
The Database connection timeout problem raises up after the DB statement (Executing DB Statemet in the trace.log).
It's not getting caught in the normal try catch block with db query or with SQL exception.
17/09/2021 12:36:09:299 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Using SCESession
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr servlet : parseismapi
17/09/2021 12:36:09:299 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Using SCESession
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr servlet : checkbiveh
17/09/2021 12:36:09:299 DEBUG -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Executing DB statement
: [SELECT DIM_MT_RENEWAL.POLICY_NO, DIM_MT_RENEWAL.MTR_SUBCLS,
DIM_MT_RENEWAL.MTR_XDATE, DIM_MT_RENEWAL.MTR_BSUMIN,
DIM_MT_RENEWAL.MTS_NCB_PCT FROM dbo.DIM_MT_RENEWAL WHERE ( (
DIM_MT_RENEWAL.MTS_VEHNO = ? ) AND ( DIM_MT_RENEWAL.MTR_XDATE >
'01-Jun-2020' ) )]
17/09/2021 12:36:26:691 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Removing session from
AvayaSessionTermination Servlet
17/09/2021 12:36:26:691 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Termination URL reply :
<?xml version="1.0" encoding="UTF-8"?>
<vxml version="2.1" xmlns="http://www.w3.org/2001/vxml"
xml:lang="en-us">
</vxml>
17/09/2021 12:36:26:691 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : HTTP Session lost
removing SCESession D9C9CB8B02760499B44E29EB8A4BC26F
17/09/2021 12:36:26:691 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : SCESession Removed
17/09/2021 12:36:26:691 DEBUG -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : Removing 1 session
stack frames.
17/09/2021 12:36:26:691 INFO -
D9C9CB8B02760499B44E29EB8A4BC26F:/mancusvr : ** Popped Stack Frame
[/mancusvr]
|