When Bulk File With High Number of Records Is Uploaded, OBDx Application Shows Down With Error In Logs As "No resources currently available in pool xxxx to allocate to applications" (Doc ID 2583340.1)

Last updated on JUNE 16, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
OBDx Application Server response slows down when host alerts are being processed

EXPECTED BEHAVIOR
-----------------------
Server should not slow down or hang when host alerts are being processed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Keep the current DIGX pool size at 50.
2. Upload a bulk file of say 3000 records. On processing of same, FCUBS will send debit/credit alerts.
3. Once host alerts start getting processed, the connection count gradually increases till 50.
5. The server also goes into warning state and is extremely slow.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, application server slows down and is not able to service requests of users.

Changes

Cause

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