SAP Knowledge Base Article - Public

2803689 - Admin receives a SQLException when trying to record learning event.

Symptom

An SQLException is thrown when the admin is trying to record learning.

Environment

Success Factors Learning Management System (LMS)

Reproducing the Issue

  1. Go to Users > Tools > Record Learning - Multiple;
  2. Try to record learning for an item;
  3. The system will throw a SQLException;
  4. expand the text/scroll down and look for the caused by information, it should mention the following:

    com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1300]: fetch returns more than requested number of rows: search table error:
    "fetch returns more than requested number of rows exception: fetch returns more than requested number of rows: search table error: "COMPANY_SCHEMA"."PKG_QUESTIONNAIRESURVEY_INITIATE_SURVEY_PROCESS": line xx col xx (at pos xxx): [1300] (range x) fetch returns more than requested number of rows exception: fetch returns more than requested number of rows"

Cause

This issue happens when admins are adding item to survey in the system and they click on Add button in quick succession/more then once (while the system is still processing the request).

This scenario has been addressed as part of  in b1908 release as a preventive measure.

Resolution

For the existing duplicate survey item assignments, please follow below steps:

  1. go to Questionnaire Survey > Search for the questionary survey associated with the respective item > Edit Survey > Go to Item Usage and search for the affected item ID;
  2. select both duplicate mappings of item from the survey and remove them
  3. add the item back to survey OR update the item with survey and ensure that there is only mapping between specific item and survey.

NOTE:  when deleting the survey association the item usage information will be lost, so you might want to create a new revision of the item and then making changes to the new revision. Please refer to KBA 2546182 for more information.

See Also

2546182 - Item Usage no longer shows data for survey for an item

Keywords

LMS, SAP, SURVEY, ERROR, SQLEXCEPTION, RECORD, LEARNING, EVENT, MULTIPLE, ITEM, QUESTIONNAIRESURVEY , KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions