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
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.
SAP Knowledge Base Article - Preview