Symptom
When attempting to open up an Item the following error is generated:
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- When opening up an Item warning is generated:
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. - Select OK and it will bring you into the Item record.
Cause
Error is generated by incorrectly formatted or possibly corrupt upload for the Item Thumbnail file.
Possible that when file was uploaded first it did not upload correctly.
Resolution
Remove the thumbnail file from the Item impacted.
Upload a new version of it. Ensure that it's in valid format and is not corrupted.
Keywords
SqlMapClient operation, uncategorized SQLException, executeQueryForObject, item thumbnail, thumbnail file, thumbnail , KBA , LOD-SF-LMS-ITE , Items , How To