3604909 - Error when deleting duplicate Withdrawal Reason ID

The Withdrawal Reason ID was created twice, and now cannot be deleted due to Application error:

• Error message = 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: 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.

SAP SuccessFactors Learning

1. Learning Administration
2. References > Learning Activities > Withdrawal Reason
3. Search for duplicated Withdrawal Reason ID
4. Edit affected Withdrawal Reason ID to delete
5. Application Error encountered

The issue was caused by a system error related to HANA indexes, which prevented the deletion of the duplicate Withdrawal Reason ID.

• Issue is resolved 2505 release
• Moving forward, please avoid creating the same Withdrawal Reason ID (or any similar Reference IDs) to prevent duplicates

SF, Success Factors, LMS, learning, references, Withdrawal Reason ID, delete, duplicate entity, HANA indexes , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem