3072698 - Error when modifying a survey on an item - executeQueryForObject returned too many results.

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.

SAP SuccessFactors Learning

• 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.

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 items {See NOTE below first}
9. Click Remove. This will remove both the item records on the survey.
10. 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. 

2358359 - Add Learning History error

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

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