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 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Sept-2014***
Veridata v126.96.36.199.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 -
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,
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