SAP Knowledge Base Article - Public

3421920 - Error when LMS Admin attempts to open Item entity

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

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

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

Product

SAP SuccessFactors Learning all versions