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
Last updated on OCTOBER 26, 2016
Applies to:BI Publisher (formerly XML Publisher) - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
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