2358359 - Record Learning error: ORA-01422

SAP Knowledge Base Article - Public

2358359 - Record Learning error: ORA-01422

Symptom

Admins are unable to record learning for a particular scheduled offering.

The error received is:

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

Environment

  • Learning Management System (LMS)
  • Admin side > Users > Tools > Record learning wizards

Cause

  • There is a survey related to the item twice for some reason.
  • This does not show at the item record level (related/more > evaluations)
  • It can be seen in Learning > Questionnaire Surveys > search for the survey ID > Item usage tab > search for your item ID and you will see a duplicate

survey.PNG

Resolution

  1. If you already opened the survey in Edit 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 duplicate item
  3. Click Remove
  4. Start the record learning again

survey_remove.PNG

Keywords

cannot record learning, record learning financial, record learning multiple, ORA-01422, exact fetch returns more than requested number of rows, java.sql.SQLException, PKG_QUESTIONNAIRESURVEY, PKG_LEARNINGHST, ORA-06512 , KBA , LOD-SF-LMS-ADM , Admin Tools , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Problem

Product

SAP SuccessFactors Learning 1602