Network Error IOException: No Buffer Space Available (maximum connections reached?)

Document created by sheng_liao462475 Employee on Jul 21, 2016Last modified by chris_stevens on Jul 28, 2016
Version 2Show Document
  • View in full screen mode

Error:

Unable to open database connection. Network error IOException: No buffer space available (maximum connections reached?): connect; Caused by: Network error IOException: No buffer space available (maximum connections reached?): connect; Caused by: No buffer space available (maximum connections reached?): connect (com.boomi.process.ProcessException)

This error usually indicates the database connection pool does not have enough space for more connections. It happens when processing large amount of data.

 

Solutions:

  • Use a Flow Control shape with option "Run as Batches of XX Documents".
  • Enable connection pooling for database connection so that the resources are better available.

 

Additional information may be found here:

Attachments

    Outcomes