We are receiving this error on the Database Target activity
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Adeptia connection pool size is larger than the maximum number of cursors configured in the Oracle database.
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
Article is closed for comments.