JDBC Gateway connection failed

Question

Question

@Vicky Li
@Thanongsak Chamung
@Warlin Garcia
@Eduard Lebedyuk
@Enrico Parisi
@Luis Angel Pérez Ramos

We are getting this error. All the drivers, URL and credential are tested and existed. it works fine sometime but also getting this error more often. Please advise the root cause and its respective solution. The business service that is using out of the box Java service (classname: EnsLib.JavaGateway.Service adapter classname: EnsLib.JavaGateway.ServiceAdapter) is throwing this error.

The configured "SOMEDSN" has passed the JDBC Connection test successfully with the external database (ORACLE)
Type: Error

Text: Error initializing result update service. tSC=ERROR #JDBC Gateway connection failed for "SOMEDSN": Unknown status code: <UserErrors>JDBC Gateway connection failed for "SOMEDSN)

Session: (none)

Job: 27421

$$^zProcessInput+12 ^Ens.BusinessService.1 +1

$$^zOnTask+1^Ens.InboundAdapter.1 +1

$$^zOnTask+29^Ens.BusinessService.1 +1

DO^zStart+62^Ens.Job.1 +2

Product version: Ensemble 2017.1

Discussion (3)1

Log in or sign up to continue

Eduard Lebedyuk · Apr 16

Do you have Stay Connected setting equal to -1? Try setting it to a lower value, i.e. 30.

0 0

score 0 · Answer 1 · 2024-04-17T14:48:46-04:00

@Eduard Lebedyuk do you think this would the cause of this error? What i am thinking is the DB connection open and Close is not in sync. It tries to open the DB connection while it is not closed properly or not even closed.

Is there a way i can check the connection is open or not before initiating/opening it again or establishing the connection with an external DB?.

score 2 · Answer 2 · 2024-04-17T15:43:00-04:00

Eduard Lebedyuk · Apr 17

Longrunning tcp connections might be an issue. I would definitely try setting it to something lower.

2 0