SAP Knowledge Base Article - Public

2358359 - Add Learning History error

Symptom

Admins or instructors are unable to Add Learning History (record learning) for a particular class (scheduled offering) or item.

One of the similar errors are received:

Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "XXXX_PROD_TMS.PKG_QUESTIONNAIRESURVEY", line 1370
ORA-06512: at "XXXX_PROD_TMS.PKG_LEARNINGHST", line 2241
ORA-06512: at line 1

or

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1300]: fetch returns more than requested number of rows:
search table error: "XXXX_PROD_TMS"."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:
"XXXX_PROD_TMS"."PKG_QUESTIONNAIRESURVEY_INITIATE_SURVEY_PROCESS": line 74 col 3 (at pos 2841):
[1300] (range 3) fetch returns more than requested number of rows exception: fetch returns more than requested number of rows

or

Error message = SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException.
Ticket No = 2047
ErrorFingerprint [exceptionRootCauseTag=6be9b13c00eddf72aa57150191001b5e2cb9fb15, exceptionStackTraceTag=6f766f7290aaf93de94e929dc6ecbcd4a9e1ce5b]

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

In LMS Administration:

  1. Navigate to Manage User Learning > Add Learning History (either option)
  2. Try to record learning for a user following wizard' steps
  3. Error message displayed

Cause

  • There is a survey related to the item twice.
  • This does NOT show at the user level or item record level under Surveys.
  • It can only be seen in Content > Surveys > search for the survey ID & Edit > Item usage tab > search for your item ID and you will see a duplicate:
    survey.png

Resolution

  1. Navigate to Content > Surveys > search for the survey ID & Edit > Item usage tab > search for your item ID and you will see a duplicate
    (If following along Cause steps, you may already opened the survey in View mode, you will see a check box next to the items otherwise please click on EDIT to show the check boxes.)
  2. Select the box next to one of the duplicated item {See NOTE below first}
  3. Click Remove
  4. Start the record learning again
    survey_remove.png

NOTE:  when deleting the survey association the item usage information will be lost, so you might want to create a new revision of the item and then making changes to the new revision. Please refer to KBA 2546182 for more information. 
The preventive measure to stop admins from adding duplicate items under survey -> item usage section included on the 1908 release; but no data was corrected.

See Also

2546182 - Item Usage no longer shows data for survey for an item
LRN-60812 & LRN-53082

Keywords

SF. success, factors, successfcators, learning, lms, Cannot, record, learning, record, learning, financial, multiple, ORA-01422, exact fetch returns more than requested number of rows, java.sql.SQLException, PKG_QUESTIONNAIRESURVEY, PKG_LEARNINGHST, ORA-06512, Could not add Component Training event due to SQLException, LRN-60812, LRN-53082, 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, Error recording completion for the component ID, surveys, evaluation, add, learning, history , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS-EVA , Surveys , Problem

Product

SAP SuccessFactors Learning all versions