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 laterInformation 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 openChanges
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 |