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