KB-1475 Appian loses connectivitiy to Oracle database with "ORA-01000: maximum open cursors exceeded" error

Symptoms

Appian loses connectivity to the database and the following error is observed in the application server log:

ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01000: maximum open cursors exceeded

Cause

The cause of this error has been discussed in Oracle's documentation.

Action

Follow the steps in the article above.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: January 2018