Set-up database schema with parent/child relationship. After updating schema and database binding, we executed Application Analysis Ruleset BPS.
When executing AARS BPS, the process took > 10 minutes and we received an error. In this scenario we were querying an Oracle database via JDBC connection.
EXTOL error message:
[INFO] - Starting Comm
[INFO] - Invoking Interface Adapter.
[INFO] - Name : select using SQL.Select.Adapter ver. 1.0
[INFO] - Version : auto
[INFO] - Interaction : Select
[ERROR] - Error executing adapter - GC overhead limit exceeded
[ERROR] - java.lang.OutOfMemoryError: GC overhead limit exceeded
[INFO] - Ending Interface Adapter invocation.
[INFO] - Completed Task.
In EXTOL Business Integrator we updated Schema Key set-up. Also with assistance of DBA, we createdSQL Index over Oracle database table.
In some cases this did not work and we needed to added more memory to the EXTOL Server.
By: Sean Hoppe on