SAP Knowledge Base Article - Public

2816064 - Unable to add new users to LMS

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

  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"
    shoppingAccountTypeStudent=N/A
    shoppingAccountTypeOrganization=N/A
  2. 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 , Admin Tools , LOD-SF-LMS-COM , Commerce , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions