Author Message
maspandel
Joined: Apr 22, 2020
Messages: 40
Offline
Hi guys.

I can hear "The system is experiencing technical difficulties" every time the timeout for a database operation occurs on my application.

is it possible to increase that timeout ? Any change to modify that message ?

Thanks in advance.
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
There are difference timeouts that might have caused the error message. You have to make sure which one it is and apply the workaround accordingly. First take a look at the app trace.log. The error in the log would give you an indication.
maspandel
Joined: Apr 22, 2020
Messages: 40
Offline
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]

WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
I don't see a db timeout here. It looks more like the query is taking too long and you get a fetchtimeout from the VoiceBrowser on the EP side.
Go to:   
Mobile view