SAP Knowledge Base Article - Public

2271099 - Error returned when adding user via webservice api

Symptom

  • The following error is returned when adding a new user via the webservice
  • com.plateausystems.elms.util.helper.ElmsCreateException: com.plateausystems.elms.util.helper.ElmsCreateException: java.sql.SQLException: ORA-20001: PT_BIU_STUD_USER: invalid USER_ID - parent key not found (PA_USRRF_STUD)
    ORA-06512: at "{schemaName}.PT_BIU_STUD_USER", line 17
    ORA-04088: error during execution of trigger '{schemaName}.PT_BIU_STUD_USER'

Environment

  • SuccessFactors Learning Management System

Reproducing the Issue

  • Add a user to the LMS via the webservice api with similar properties as the below user.
    • {
      "studentID":"123456",
      "jobPositionID":"1111111",
      "employeeStatusID":"ACTIVE",
      "firstName":"John",
      "lastName":"Smith",
      "jobTitle":"Manager",
      "organizationID":"13456789",
      "employeeTypeID":"MGR01",
      "timeZone":"America/NewYork",
      "locale":"English",
      "currencyID":"USD",
      "domainID":"PUBLIC",
      "roleID":"LEARNING_USER",
      "notActive":"N",
      "customColumn":[{
        "value":"132456789",
        "id":"11223344",
        "columnNumber":520
        },{
        "value":"987654321",
        "id":"12346579",
        "columnNumber":530
        },{
        "value":"1008",
        "id":"BR2542547",
        "columnNumber":160
        }]
      }

Cause

  • When you add the user it will execute a 'trigger' in the DB to make sure the data for the user gets added to various tables in order for it to remain consistent. The trigger here is the PT_BIU_STUD_USER and it is responsible for checking the custom columns to determine if they are referenced values or not. The trigger queries the PA_USRCL_STUD table to find out if the user has any custom columns that contain reference values. It will then in turn query the PA_USRRF_STUD to find out if it contains those entries for that user. In this case it does not and that is why the error is returned.

Resolution

  • Prior to adding the user to the LMS ensure that all custom columns being used for the user are part of the user record.

Keywords

KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning 1511