SAP Knowledge Base Article - Preview

2358359 - An error occurred while adding the learning history

Symptom

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

One of the similar errors are received:

Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "XXXX_PROD_TMS.PKG_QUESTIONNAIRESURVEY", line 1370ORA-06512: at "XXXX_PROD_TMS.PKG_LEARNINGHST", line 2241ORA-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.


Read more...

Environment

SAP SuccessFactors Learning

Product

SAP SuccessFactors Learning all versions

Keywords

Cannot record learning, add learning history, learning history, add component training event, could not add component training event due to SQLException, error recording completion, error recording completion for component ID, unable to record completion, com.sap.db.jdbc.exceptions.JDBCDriverException, JDBCDriverException, PKG_QUESTIONNAIRESURVEY, PKG_LEARNINGHST, LRN-60812, LRN-53082, addComponentTrainingEvent,  , 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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.