'ORA--01000: maximum open cursors exceeded' error when running, viewing or editing Reports in RSA Identity Governance & Lifecycle
Originally Published: 2016-10-07
Last Modified: 2023-10-06
Article Number
000044832
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 6.9.1 P09, P10, P11, 7.0.0
 
Issue
After upgrading to RSA Identity Governance & Lifecycle 6.9.1 P09, P10, P11 or 7.0.0, the following error occurs when generating new Reports, viewing existing Reports, or modifying existing Reports. In the user interface go to Reports > Tabular > {Report name} > Edit / Run Report / {View Report Result name.}

ORA-01000: maximum open cursors exceeded
 
EXAMPLES:
 
Modify an existing Report:

 
User-added image

View an existing Report:
 
User-added image

 
The following error is logged to the aveksaServer.log file:
  
02/29/2016 16:24:14.466 ERROR (WebContainer : 1) [com.aveksa.server.report.Report] 
com.aveksa.server.runtime.ServerException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	at com.aveksa.server.report.BaseReport.getAllDisplayColumns(BaseReport.java:730)
	at com.aveksa.server.report.Report.getAllDisplayColumns(Report.java:2437)
	at com.aveksa.server.report.Report.isValidScopeType(Report.java:2171)
	at com.aveksa.server.report.Report.isValidScope(Report.java:2162)
	at com.aveksa.gui.objects.report.GuiReport.isValidScope(GuiReport.java:211)
	at com.aveksa.gui.objects.report.GuiReport.getScopesForReport(GuiReport.java:819)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.makeScopeSelect
(ReportPropertiesView.java:266)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.makeScopeFld
(ReportPropertiesView.java:258)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.makeTypeFields
(ReportPropertiesView.java:79)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.printContent
(ReportPropertiesView.java:52)
	at com.aveksa.gui.pages.base.view.DialogPageView.makeContent(DialogPageView.java:134)
	at com.aveksa.gui.pages.base.view.DialogPageView.handleRequest(DialogPageView.java:34)
	at com.aveksa.gui.pages.base.data.PageData.drawView(PageData.java:99)
	at com.aveksa.gui.pages.base.data.PageData.handleRequest(PageData.java:91)
	at com.aveksa.gui.pages.base.data.dialog.EditableDialogPageData.handleRequest
(EditableDialogPageData.java:69)
	at com.aveksa.gui.pages.base.data.wizard.WizardDialogData.handleRequest
(WizardDialogData.java:64)
	at com.aveksa.gui.pages.base.data.wizard.TabbedWizardDialogData.handleRequest
(TabbedWizardDialogData.java:79)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.
BaseEditTabularReportWizard.handleRequest(BaseEditTabularReportWizard.java:121)
	at com.aveksa.gui.pages.PageManager.forwardRequest(PageManager.java:559)
	at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:323)
	at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:254)
	at com.aveksa.gui.core.MainManager.handleRequest(MainManager.java:176)
	at com.aveksa.gui.core.MainManager.doGet(MainManager.java:125)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
	at com.aveksa.gui.core.filters.LoginFilter.doFilter(LoginFilter.java:67)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
	at com.aveksa.gui.util.security.XSSFilter.doFilter(XSSFilter.java:20)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
	at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
	at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
	at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
	at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
	at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
	at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
	at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
	at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
	at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
	at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
Caused by: 
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

...

02/29/2016 16:24:21.659 ERROR (WebContainer : 1) [com.aveksa.server.report.Report] get all display cols
com.aveksa.server.runtime.ServerException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	at com.aveksa.server.report.BaseReport.getAllDisplayColumns(BaseReport.java:730)
	at com.aveksa.server.report.Report.getAllDisplayColumns(Report.java:2437)
	at com.aveksa.server.report.Report.loadDesign(Report.java:1543)
	at com.aveksa.server.report.Report.getPageHeight(Report.java:496)
	at com.aveksa.gui.objects.report.GuiReport.getPage(GuiReport.java:323)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.
makePageSizeSelectField(ReportPropertiesView.java:288)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.
makeTypeFields(ReportPropertiesView.java:80)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.ReportPropertiesView.
printContent(ReportPropertiesView.java:52)
	at com.aveksa.gui.pages.base.view.DialogPageView.makeContent(DialogPageView.java:134)
	at com.aveksa.gui.pages.base.view.DialogPageView.handleRequest(DialogPageView.java:34)
	at com.aveksa.gui.pages.base.data.PageData.drawView(PageData.java:99)
	at com.aveksa.gui.pages.base.data.PageData.handleRequest(PageData.java:91)
	at com.aveksa.gui.pages.base.data.dialog.EditableDialogPageData.handleRequest(EditableDialogPageData.java:69)
	at com.aveksa.gui.pages.base.data.wizard.WizardDialogData.handleRequest(WizardDialogData.java:64)
	at com.aveksa.gui.pages.base.data.wizard.TabbedWizardDialogData.handleRequest(TabbedWizardDialogData.java:79)
	at com.aveksa.gui.pages.report.report_definition.edit.tabular.BaseEditTabularReportWizard.
handleRequest(BaseEditTabularReportWizard.java:121)
	at com.aveksa.gui.pages.PageManager.forwardRequest(PageManager.java:559)
	at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:323)
	at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:254)
	at com.aveksa.gui.core.MainManager.handleRequest(MainManager.java:176)
	at com.aveksa.gui.core.MainManager.doGet(MainManager.java:125)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
	at com.aveksa.gui.core.filters.LoginFilter.doFilter(LoginFilter.java:67)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
	at com.aveksa.gui.util.security.XSSFilter.doFilter(XSSFilter.java:20)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
	at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
	at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
	at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
	at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
	at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
	at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
	at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
	at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
	at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
	at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
Caused by: 
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs.)

 
Cause
This is a known issue reported in engineering ticket ACM-61635.
 
Resolution
This issue is resolved in the following RSA Identity Governance & Lifecycle versions and/or patch levels: 
  • RSA Identity Governance & Lifecycle 6.9.1 P12
  • RSA Identity Governance & Lifecycle 7.0.0 P03
  • RSA Identity Governance & Lifecycle 7.0.1
  • RSA Identity Governance & Lifecycle 7.0.2

 

Related Articles

Trending Articles

Don't see what you're looking for?