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 SEPTEMBER 16, 2016

Applies to:

Oracle Communications Network Charging and Control - Version: 3.1.0 and later   [Release: 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://xx.xx.xx.xx/Ses_Service/error/Default/30000, version: null]
network: Connecting http://xx.xx.xx.xx/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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms