Error - ORA-01000: maximum open cursors exceeded

Error:

We are receiving this error on the Database Target activity

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Cause:

Adeptia connection pool size is larger than the maximum number of cursors configured in the Oracle database.

Recommendation:

1) Increase the maximum number of cursors limit in the Oracle Database

2) Enable connection pooling in the Database Info activity that connects to the Oracle database and keep the maximum connection to 5 or below

Note: If you enable connection pooling while the error is occurring, you'll need to restart the Adeptia Services to reset the cursor count