11g Business Intelligence Reports Fail with Error 'Pool is suspended cannot allocate resources to applications' As Datasource Is Suspended During BI Publisher Peak User Load (Doc ID 2194640.1)

Last updated on OCTOBER 26, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal


E-Business Suite Business Intelligence Publisher, Enterprise Admin Datasource issues

 

 

BI Publisher reports fail due to datasource related errors.

The following errors are reported by users running reports:

“Pool is suspended cannot allocate resources to applications” 

The issue appears load related (eg. occurs during peak user load), and the data source connection must be manually resumed when the problem occurs.

Further investigation shows low heap settings of Xms256m Xmx1024m for the memory.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms