SAP Knowledge Base Article - Public

3072698 - Error when unmarking check "require for item completion" for a course - executeQueryForObject returned too many results.

Symptom

When unmarking check "require for item completion" for a course the following error is being seen -

Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.

Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results.

Environment

SAP SuccessFactors Learning

Cause

  • There is a survey related to the item twice.
  • This does NOT show at the user level or item record level under Surveys.
  • It can only be seen in -
  1. Content
  2. Surveys
  3. Search for the survey ID
  4. Edit
  5. Item usage tab
  6. Search for item ID and you will see a duplicate.

Resolution

Navigate to:

  1. Content
  2. Surveys
  3. Search for the survey ID
  4. Edit
  5. Item usage tab
  6. Search for your item ID
  7. You will see a duplicate
    (If following along Cause steps, you may already opened the survey in View mode, you will see a check box next to the items otherwise please click on EDIT to show the check boxes.)
  8. Select the box next to one of the duplicated item {See NOTE below first}
  9. Click Remove

IMPORTANT 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 make changes to the new revision. Please refer to KBA 2546182 for more information. 

See Also

2358359 - Add Learning History error

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

Keywords

require for item completion, item completion,  executeQueryForObject returned too many results, Survey , KBA , LOD-SF-LMS-EVA , Surveys , LOD-SF-LMS-ITE , Items , Problem

Product

SAP SuccessFactors HXM Core 2105