SAP Knowledge Base Article - Public

2778353 - Learning login not available ORA-01000: maximum open cursors exceeded

Symptom

When attempting to log on to LMS, users intermittenlty receive an Error Message:

Error message = com.plateausystems.elms.util.helper.ElmsUncheckedException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1000]; 
--- The error occurred while applying a parameter map.
--- Check the SearchPreference.searchPreferencePKMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred while applying a parameter map.
--- Check the SearchPreference.searchPreferencePKMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

A code issue preventing multiple temp DB tables from being closed when system under heavy load & usage by end users.

Resolution

  • Resolved in 1905 and 1902p6
  • Workaround provided by Operations to increase DB temp table (cursor) limit until code fix.

See Also

LRN-54917 & PTCH-29912

Keywords

SAP SF Success Factors Learning LMS ORA-01000: maximum open cursors exceeded user login log on system down , KBA , LOD-SF-LMS-PER , Learning Performance Issues , Problem

Product

SAP SuccessFactors HCM Core 1902