Symptom
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
Environment
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"
shoppingAccountTypeStudent=N/A
shoppingAccountTypeOrganization=N/A - Try to create a new user and experience the error.
Cause
After researching the stack trace error further, the following is found:
Caused by: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not addShoppingAccount
Resolution
The ShoppingAccountTypes can only be and should be set to the valid values as specified being INTERNAL or EXTERNAL
Keywords
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