- Oracle APEX Version: 24.2.17
- Database: Oracle Autonomous Transaction Processing (ATP)
- ORDS: Oracle-Managed ORDS
Problem Description: We have an APEX application that integrates with JasperReportsIntegration by executing outbound REST API requests using apex_web_service.make_rest_request_b.
Recently, whenever a report execution is triggered, the web service call fails with the following runtime error:
“java.lang.RuntimeException: Could not connect via JDBC: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use - [ 50”
Notes:
- The main APEX application continues working fine, but any call to reports fails.
Has anyone run into this issue with outbound REST requests holding onto connection pool resources? How can we properly debug or release these connections on ATP?
Thank you!