000034161 - 'ORA--01000: maximum open cursors exceeded' error when running, viewing or editing Reports in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Oct 11, 2016Last modified by RSA Customer Support on Aug 25, 2020
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000034161
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 6.9.1 P09, P10, P11, 7.0.0
 
IssueAfter 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.)


 
CauseThis is a known issue reported in engineering ticket ACM-61635.
 
ResolutionThis 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

 

Attachments

    Outcomes