My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.