SAP Knowledge Base Article - Preview

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.


Read more...

Environment

SAP SuccessFactors Learning

Product

SAP SuccessFactors Learning all versions

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

About this page

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

Search for additional results

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