SAP Knowledge Base Article - Public

2294211 - Background Extended User Information Import - Internal System Error - ORA-00957: duplicate column name

Symptom

Background User Information import fails with error: "Failed to execute a batched prepared statement. ORA-00957: duplicate column name.". See full error message below:

Internal system error.  Please contact your representative. Not able to call the EJB to import the data. com.successfactors.sm.service.SuccessionEJBException: failed to save section (insideWorkExperience). Failed to execute a batched prepared statement. ORA-00957: duplicate column name.

Environment

SAP SuccessFactors HCM Core

Reproducing the Issue

  1. Create a Background Information import for a background element that has the "lastModified" column configured.
  2. Go to Admin Center > Import Extended User Information > select Background Information and import the file.
  3. The import file fails with the error message indicated in the Symptom section of this KBA. 

Cause

The Background Element that you are trying to import has been configured with a "lastModified" column. See below what the field definition in the Succession Data Model looks like:

<data-field id="lastmodified" field-name="lastModified" max-length="999" max-file-size-KB="1000">
<label>Last Modified</label>
</data-field>

The "lastModified" field value is automatically generated by the system when saving the records, which means that data for the given background element (portlet) cannot be imported via Live Profile Import.

Resolution

Importing data for a background element that has been configured with the "lastModified" field is not supported. However, if you really need to, see below workaround for that:

  1. Remove "lastModified" field from the background element in the Succession Data Model XML.
  2. Import the background element with the CSV which doesn't contain the "lastModified" field.
  3. Add the "lastModified" field back in the Succession Data Model XML.

Note: If you remove the "lastModified" field from a background element and then perform an "Import by re-loading all data with your new changes" (import by overwrite), the lastModified date will be updated with the Import Date for all records, even if the records were already present before. This happens because, when you make an import by re-loading all data, the previous records are deleted and the records in the CSV file you are importing are inserted into the instance.

Keywords

Live Profile Import Extended User Info Import Background Import Element portlet last modified date lastModified , KBA , LOD-SF-EP , Employee Profile , LOD-SF-EP-ADM , Roles & Permission / Directory search , Problem

Product

SAP SuccessFactors HXM Core all versions