Symptom
User connector fails with below example error (column number might be different), this will lead to complete failure of connector and it will not process any records.
Error message:
Column doesn't exists :COL_NUM16_VAL in tables [pa_conn_stud_user, pa_conn_student]
Environment
SAP SuccessFactors Learning
Reproducing the Issue
1) Copy the default mapping from the connector field mapping for custom column, (you will only find them till column number 15)
e.g. COL_NUM15_VAL=CUSTOM15
2) Change the number 15 to for example 16
e.g. COL_NUM16_VAL=CUSTOM16
3) Paste in the same section in the CONNECTOR configuration file
4) Run the connector making sure the file contains the header for the newly created mapping that is for custom column 16
Cause
We cannot update custom columns more than 15 via User Connector/User Connector SF with the default connector configuration mapping in place, i.e there is no such default mapping available for custom columns 16, 17 and so on in the connector configuration in LMS. The COL_NUMxx_VAL type of mapping can be used only for the default 15 custom columns.
If you try to just change the column number in the existing mapping and run the connector, the connector will fail and throw the error defined above in the title.
Resolution
- To update or create Custom column greater than 15 via User Connector - SF, you need to use the following property in the connector config:
- sfuser.field.customcolumn.<num>=CUSTOM<num>
<num> represents the number of the custom column
- sfuser.field.customcolumn.<num>=CUSTOM<num>
- Let's illustrate this with an example:
Suppose you need to configure a CUSTOM16 field that is coming in the input file file to a custom column in LMS, and all the available default 15 custom columns are in use already. In this case, you can create a new custom column - say number 16 - and map them using the property as follows:
sfuser.field.customcolumn.16=CUSTOM16
Replace your original general mapping with this and the connector will no longer fail due to the error.
For more information or details, please review the following KBA as well: 2326051 - How to configure mapping for additional custom fields for connector files in SAP SuccessFactors Learning
See Also
Keywords
Custom Column, Connector, LMS, Field mapping, configuration, more than 15 custom column, user connector,user connector sf, pa_conn_stud_user, pa_conn_student, Connector Error: com.plateausystems.connector.api.ConnectorException: Column doesn't exists :COL_NUM16_VAL in tables [pa_conn_stud_user, pa_conn_student] , KBA , LOD-SF-LMS-CON , Connectors , Problem
SAP Knowledge Base Article - Public