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
- Learning Management System (LMS)
- Admin side > Users > Tools > Record learning wizards
- 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
- 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.
- Select the box next to one of the duplicate item
- Click Remove
- Start the record learning again
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