SA-14841

Summary

SQLException: The Network Adapter could not establish the connection, observed in the PegaRULES log.

Error Messages

2015-09-12 21:04:30,235 [  PegaRULES-Batch-43] [  STANDARD] [    (  internal.access.DatabaseImpl) ERROR   - There was a problem with the database when getting a list:
com.pega.pegarules.pub.database.ConnectionException: Database-General     Problem encountered when getting connection for database pegarules                20           61000    The Network Adapter could not establish the connection
From: (B20B04A899843DC73EA5FFDBFC3E8ED2B)
Caused by SQL Problems.
Problem #1, SQLState 61000, Error code 20: java.sql.SQLException: The Network Adapter could not establish the connection
                at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:163)
                ...
Caused by: java.sql.SQLException: The Network Adapter could not establish the connection

Steps to Reproduce

There is no specific use case to reproduce this behavior.

Root Cause

A defect or configuration issue in the operating environment.
​

Resolution

Here’s the explanation for the reported behavior:

1. When a client connects to an Oracle server, it first connects to the Oracle listener service. It often redirects the client to another port. Hence, the client has to open another connection on a different port, which might be blocked by the firewall. There might be a firewall problem due to Oracle port redirection. It should be possible to diagnose it with a network monitor on the client machine or with the firewall management software on the firewall.

2. Check if the Oracle listener is running.