When adding new users to the LMS an error is received:
When using the UI: an exceptionStackTrace error
When using a connector: Exception code 1220
SAP Successfactors Learning Management System (LMS)
Reproducing the Issue
- Set the Financial configurations to an invlid value as per below:
#The ShoppingAccountType indicates the default account type for newly created students and organizations. Valid values are "INTERNAL" or "EXTERNAL"
- Try to create a new user and experience the error.
After researching the stack trace error further, the following is found:
Caused by: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not addShoppingAccount
The ShoppingAccountTypes can only be and should be set to the valid values as specified being INTERNAL or EXTERNAL
SAP SF success factors learning lms create add users user ui connector error exception 1220 foreign key constraint violation application SQLException - Could not addShoppingAccount add shopping account type , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-COM , Commerce , Problem