SAP Knowledge Base Article - Public

2166498 - Exception in enrollToProgram() - SF LMS

Symptom

SF (SuccessFactors) LMS (Learning Management System) User receives a similar Java stacktrace when attempting to enroll into a new Learning Program:

com.plateausystems.elms.bo.program.api.ProgramServiceException: Exception in enrollToProgram() for:22c62cfd-6043-480e-8fae-089581514356 at com.plateausystems.elms.bo.program.impl.UserProgramServiceImpl.enrollUserIntoProgram(UserProgramServiceImpl.java:1013)
...
java.lang.Thread.run(Thread.java:789) Caused by: org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL []; --- The error occurred while applying a parameter map. --- Check the UserProgramEntity.enrollToProgramParamMap. --- Check the statement (update procedure failed). --- Cause: java.sql.SQLDataException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ORA-06512: at "WYN_PROD_TMS.PKG_PROGRAM", line 443 ORA-06512: at line 1 ; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the UserProgramEntity.enrollToProgramParamMap. --- Check the statement (update procedure failed). --- Cause: java.sql.SQLDataException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ORA-06512: at "WYN_PROD_TMS.PKG_PROGRAM", line 443 ORA-06512: at line 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
...

Environment

  • LMS b1502+ (either Cloud or On-Premise)

Resolution

Your Learning Credit History days within one of the sections of your Program is configured too high (has been reproduced when set to "10000").  Set this value to something more reasonable, like 30 days.  Any value over 365 (a full year) will cause this Java stacktrace.

Keywords

KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SuccessFactors Learning 1408