My Oracle Support Banner

"Too many files open" Error with SMTP Connections Increasing and Not Being Released in ODI (Doc ID 2022479.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

Using the Oracle Data Integrator (ODI) and a custom Jython script to establish SMTP connections. The connections are not being released at the end of associated ODI Session, and the ODI Agent / Scenario finally fails with "Too many files open" error.

Restarting the ODI Agent / Scenario releases the held SMTP connections.

There are no issues when using OdiSendMail, and all connections are released.

Also, the same custom code and procedure had no issues when exeucted in previous ODI Release.

Changes

Upgrade from ODI 10g to ODI 12c.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.