SAP Knowledge Base Article - Public

2816064 - Unable to add new users to LMS


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

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


SAP SuccessFactors Learning all versions