Veridata 11.2 Hangs After Creating Group With Large Number Of Compares, returns to Welcome screen, Exception occurred while getting connection (Doc ID 1544962.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 3.0.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Sept-2014***

Symptoms

Veridata v11.2.1.0.0 UI becomes unresponsive and returns to Welcome screen while running a job with 300 compares.

The Veridataweb.log shows:

WARN (2013-03-04 09:21:46,694)  [VeridataSessionLogger:log, line 92] -  
Local Exception Stack:

Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
 Error Code: 29
 Call: SELECT t0.COMPARE_PAIR_ID, t1.COMPARE_PAIR_ID, t0.PKEY_SYSTEM_MAPPED,
 t0.TARG_TABLE_NAME, t0.TARG_PARTITION_ID, t1.SRC_CATALOG_NAME,
 t0.SRC_TABLE_NAME

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms