Side Bar Is Not Visible Due To Not Suficient Open Cursors In Oracle

Still need help?

The Atlassian Community is here for you.

Ask the community


The left side bar in Confluence is blank and the following error message appear in Confluence logs:

XXXX-XX-XX 12:44:09,913 ERROR [active-objects-init-system tenant-0] [] handleUpdateError Exception executing SQL update <ALTER TABLE "AO_187CCC_SIDEBAR_LINK" MODIFY ("DEST_PAGE_ID" DEFAULT 0)>
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4C8Oall.processError(
	at oracle.jdbc.driver.T4CTTIfun.receive(


The current number of cursors in Oracle is not sufficient for the SQL Alter table command as we can see above.

There is a good documentation stating this issue in


Increase the number of of available cursors in Oracle. In our test, increasing to 1000 available cursors allowed the Alter table to finish successfully.

ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;
Last modified on Oct 7, 2015

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.