SAP Knowledge Base Article - Public

2793162 - Error message. SQLException "Could not add Component Training event due to SQLException"

Symptom

When an admin is attempting to record a Learning Event, the following error is generated:

Error

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: [1300]: 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): [1300] (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): [1300](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.

Environment

SAP SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

RECORD COMPLETION AS AN ADMIN:

  1. User > Tools > Record Learning - Multiple
  2. Item > Enter item id
  3. User > enter user id
  4. Enter completion date, total hours and credit hours
  5. 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
6. Submit
7. Mark status to Complete
8. Confirm

Cause

There are duplicate mappings of item from the survey.

Resolution

To resolve, an admin should

  1. Navigate to Learning > Questionnaire Survey > Search for the survey id > Edit Survey > Go to Item Usage and search for the Item id
  2. Select the duplicate mappings and remove them.
  3. Add the item back to the survey and make sure that there is only one mapping between the item and survey.

NOTE:

The preventive measure to stop admins from adding duplicate items under survey -> item usage section will be included on the 1908 release.

See Also

LRN-60812, LRN-53082

Keywords

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 , Admin Tools , LOD-SF-LMS-ITE , LMS Items , Problem

Product

SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SAP SuccessFactors Learning 1802 ; SAP SuccessFactors Learning 1805 ; SAP SuccessFactors Learning 1808 ; SAP SuccessFactors Learning 1811 ; SAP SuccessFactors Learning 1902 ; SUCCESSFACTORS LEARNING 1905 ; SUCCESSFACTORS LEARNING 1908