This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SecurID® Governance & Lifecycle Knowledge Base

Find answers to your questions and identify resolutions for known issues with knowledge base articles written by SecurID Governance & Lifecycle experts.

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

Article Number

000034161

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:

 
Image descriptionImage description

View an existing Report:
 
Image descriptionImage description

 
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

 
Tags (77)
0 Likes
Was this article helpful? Yes No
No ratings

In this article

Version history
Last update:
‎2020-12-12 08:55 AM
Updated by:
Administrator Administrator

Related Content

© 2023 RSA Security LLC or its affiliates. All rights reserved.