When an admin is attempting to record a Learning Event, the following error is generated:
An application error has occurred. Please try again.
No search results were found based on this error code.
If you have further questions or issues regarding this error, please provide the error details below to your support group.
Error message = SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException.<br>Ticket No = 87012675<br>ErrorFingerprint [exceptionRootCauseTag=f67869c2a3951c1e3f777fe60106982dc0b71fd2, exceptionStackTraceTag=ea07d098a63256a39d0577d25e8ef2997b9fc086]<br>Timestamp = <customer timestamp> <br>Stack trace = com.plateausystems.elms.util.helper.ElmsCreateException: SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException.at com.plateausystems.elms.bo.trainingevent.impl.TrainingEventServiceImpl.addLearningComponentTrainingEvent(TrainingEventServiceImpl.java:338)at
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: : fetch returns more than requested number of rows: search table error: "DATABASE_SCHEMA"."PKG_LEARNINGHST_FULL_PROCESS_CPNT_EVTHST": line 1305 col 13 (at pos 61947):  (range 3) fetch returns more than requested number of rows exception: fetch returns more than requested number of rows: search table error: "DATABASE_SCHEMA"."PKG_QUESTIONNAIRESURVEY_INITIATE_SURVEY_PROCESS": line 72 col 3 (at pos 2778): (range 3) fetch returns more than requested number of rows exception: fetch returns more than requested number of rows at com.sap.db.jdbc.exceptions.
SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
Reproducing the Issue
RECORD COMPLETION AS AN ADMIN:
- User > Tools > Record Learning - Multiple
- Item > Enter item id
- User > enter user id
- Enter completion date, total hours and credit hours
- Submit and the error is generated
RECORD COMPLETION AS AN INSTRUCTOR:
1. Navigate to Learning
2. My Classes
3. Authorized to teach
3. Locate course
4. Record Completion
5. Add User
7. Mark status to Complete
There are duplicate mappings of item from the survey.
To resolve, an admin should
- Navigate to Learning > Questionnaire Survey > Search for the survey id > Edit Survey > Go to Item Usage and search for the Item id
- Select the duplicate mappings and remove them.
- Add the item back to the survey and make sure that there is only one mapping between the item and survey.
The preventive measure to stop admins from adding duplicate items under survey -> item usage section will be included on the 1908 release.
SQLException; addComponentTrainingEvent; Questionnaire Survey; An application error has occurred; No search results were found based on this error code; Could not add Component Training event; com.sap.db.jdbc.exceptions.JDBCDriverException; error recording completion; instructor unable to record learning; Error recording completion for the component ID , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-ITE , Items , Problem