SAP Knowledge Base Article - Public

2185280 - Learning Management System -Connector Error: com.plateausystems.connector.api.ConnectorException: Column doesn't exists :COL_NUM16_VAL in tables [pa_conn_stud_user, pa_conn_student]

Symptom

User connector fails with below error, 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 till 15)

   e.g COL_NUM15_VAL=CUSTOM15

2)Change the number 15 to 16

   e.g COL_NUM16_VAL=CUSTOM15

3)Paste in the same section in the CONNECTOR configuration file

4)Run the connector making sure the file contains the header for newly created mapping that is for custom colomn 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.

Also, 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. It is always advisable to use custom column till 15 if you are updating it via connector. There is no workaround for this.

But there is a work around for user connector sf which is mentioned in Resolution.

Resolution

  • To update custom columns more than 15, it's important to note that this can only be achieved via user connector sf. We have some extended DB tables that can handle this task. They come into play when we use a specific property.
  • 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>;  Here,num represents the number of the custom column.

  • Let's illustrate this with an example:

Suppose you need to configure a CUSTOM30 field that is coming in the bizx file to a custom column, and all the available 15 custom columns are filled. In this case, you can create a new custom column, say 16, and map them using the property as follows:

sfuser.field.customcolumn.16=CUSTOM30

By doing this, you replace the general mapping which would be sfuser.field.mapping.data.COL_NUM16_VAL=CUSTOM30. This way, the connector will no longer fail due to the error.

See Also

2148513 - Update user custom columns outside of default custom columns via User Connector

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 , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions