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 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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.