My Oracle Support Banner

Error Occurs when Entering SES SMS GUI Screen : "An SQL Error has occured. The error reported is 'Max cursors open'" (Doc ID 1325707.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Communications Network Charging and Control - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

The following error is reported when opening "SES Service" via SMS (Service Management System) Screen (SMS -> Services -> SES Service) :

An SQL Error has occured. The error reported is 'Max cursors open'


The error pictured below:



Java debug log will also contain the following backtrace output:

Please refer to <Document 452853.1> for how to view the Java Console and enable tracing for Sun JRE

 

Cursor Statement SQL: BEGIN OPEN ? FOR SELECT ID, NAME, ACTIVE, EXPIRY, PRIORITY, TEXT, CHANGE_USER, CHANGE_DATE, CHANGE_TERM FROM SES_MESSAGE WHERE id = 83 ; END;
network: Cache entry not found [url: http://<IP>/Ses_Service/error/Default/30000, version: null]
network: Connecting http://<IP>/Ses_Service/error/Default/30000 with proxy=DIRECT
java.sql.SQLException: Max cursors open
at UserScreens.PreparedStatementManager.getCallableStatement(PreparedStatementManager.java:115)
at com.eservglobal.ses.dbClasses.BaseIO.cursorSelect(BaseIO.java:557)
at com.eservglobal.ses.model.Message.getMessage(Message.java:96)
at com.eservglobal.ses.model.OutboundMessage.getMessageName(OutboundMessage.java:91)
at com.eservglobal.ses.screens.OutboundMessagePanel.formatTableRow(OutboundMessagePanel.java:330)
at com.eservglobal.ses.screens.OutboundMessagePanel.addTableRow(OutboundMessagePanel.java:313)
at com.eservglobal.ses.screens.OutboundMessagePanel.displayMessages(OutboundMessagePanel.java:127)
at com.eservglobal.ses.screens.OutboundMessagePanel.initGUI(OutboundMessagePanel.java:104)
at com.eservglobal.ses.screens.OutboundMessagePanel.<init>(OutboundMessagePanel.java:72)
at com.eservglobal.ses.screens.ConfigurationWindow.initGUI(ConfigurationWindow.java:83)
at com.eservglobal.ses.screens.ConfigurationWindow.<init>(ConfigurationWindow.java:45)
at Ses_Service.Ses_Service.actionPerformed(Ses_Service.java:73)
at java.awt.MenuItem.processActionEvent(Unknown Source)
at java.awt.MenuItem.processEvent(Unknown Source)
at java.awt.MenuComponent.dispatchEventImpl(Unknown Source)
at java.awt.MenuComponent.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
null
java.sql.SQLException: Max cursors open
at UserScreens.PreparedStatementManager.getCallableStatement(PreparedStatementManager.java:115)
at com.eservglobal.ses.dbClasses.BaseIO.cursorSelect(BaseIO.java:557)
at com.eservglobal.ses.model.Message.getMessage(Message.java:96)
at com.eservglobal.ses.model.OutboundMessage.getMessageName(OutboundMessage.java:91)
at com.eservglobal.ses.screens.OutboundMessagePanel.formatTableRow(OutboundMessagePanel.java:330)
at com.eservglobal.ses.screens.OutboundMessagePanel.addTableRow(OutboundMessagePanel.java:313)
at com.eservglobal.ses.screens.OutboundMessagePanel.displayMessages(OutboundMessagePanel.java:127)
at com.eservglobal.ses.screens.OutboundMessagePanel.initGUI(OutboundMessagePanel.java:104)
at com.eservglobal.ses.screens.OutboundMessagePanel.<init>(OutboundMessagePanel.java:72)
at com.eservglobal.ses.screens.ConfigurationWindow.initGUI(ConfigurationWindow.java:83)
at com.eservglobal.ses.screens.ConfigurationWindow.<init>(ConfigurationWindow.java:45)
at Ses_Service.Ses_Service.actionPerformed(Ses_Service.java:73)
at java.awt.MenuItem.processActionEvent(Unknown Source)
at java.awt.MenuItem.processEvent(Unknown Source)
at java.awt.MenuComponent.dispatchEventImpl(Unknown Source)
at java.awt.MenuComponent.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Message.getMessage(83) failed: com.eservglobal.ses.dbClasses.BaseIOSQLException: Max cursors open

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.