Symptom
When modifying a survey on an item such as enabling/disabling "require for item completion", an error occurs:
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 -
- Content
- Surveys
- Search for the survey ID
- Edit
- Item usage tab
- Search for item ID and you will see a duplicate.
Resolution
Navigate to:
- Content
- Surveys
- Search for the survey ID
- Edit
- Item usage tab
- Search for your item ID
- 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.) - Select the box next to one of the duplicated items {See NOTE below first}
- Click Remove. This will remove both the item records on the survey.
- It is now possible to add the survey on the item without the error.
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