Please login or register to access secure site features.

Note: By continuing to use DevConnect Program Services you agree to our latest Registered Member Terms.

Sign in using DevConnect ID

Forgot password?

Trouble logging in?

Submit a ticket for Registration Support.

I have an SSO ID

?
sign in

Don't have a DevConnect or SSO ID ?

Create a DevConnect account or join the program.

register now
^
New DevConnect members must have forum permissions in order to post messages.
If the Reply and New Post buttons are not available to you, please request access using a General Support request ticket.
Forum Index » Avaya Orchestration Designer » database operation timeout increase   XML
 
Author Message
maspandel



Joined: 22/04/2020 11:39:16
Messages: 32
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: 06/11/2013 14:29:24
Messages: 3878
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: 22/04/2020 11:39:16
Messages: 32
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: 06/11/2013 14:29:24
Messages: 3878
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: