SAP Knowledge Base Article - Public

2853626 - Import Background Information Error: SAP DBTech JDBC: [***]: duplicate column name: SM_BG_ENDDATE or SM_BG_STARTDATE - Employee Profile

Symptom

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

When importing background information from Import Extended User Information, the request was submitted, but you received e-mail stating:

System error during importcom.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: failed to save section (section name). Failed to execute a batched prepared statement. SAP DBTech JDBC: [***]: duplicate column name: SM_BG_ENDDATE or SM_BG_STARTDATE

Environment

  • SAP SuccessFactors HCM Core
  • SAP SuccessFactors HCM Suite
  • Employee Profile

Reproducing the Issue

  1. Import background information
  2. E-mail received stating System error during importcom.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: failed to save section (section name). Failed to execute a batched prepared statement. SAP DBTech JDBC: [***]: duplicate column name: SM_BG_ENDDATE or SM_BG_STARTDATE

Cause

More than one data fields are defined as field-name="endDate" in that background element.

<data-fieldid="endDate"field-name="endDate"max-length="999"max-file-size-KB="1000">
<label>End Date</label>
<labelxml:lang="en-US">End Date</label>
</data-field>
<data-fieldid="expireDate"field-name="endDate"max-length="999"max-file-size-KB="1000">
<label>Expiration Date</label>
<labelxml:lang="en-US">Expiration Date</label>
</data-field>

Resolution

Please keep only one field as field-name="endDate" within one background element in SDM or BCUI, and if you want to define other date fields, please use the specific field-name attribute for general date fields.

DATE fields (dfld1 - dfld5): These fields will show date values in the date format based on the configuration of your instance/language. These fields will have a "calendar button" next to them for date selection as well.

You can check KBA 2803695 for more reference.

See Also

2803695 - Creating and Configuring Background Elements Using BCUI

Keywords

field-name="endDate"; duplicate column name; SM_BG_ENDDATE; SAP DBTech JDBC , KBA , LOD-SF-EP-BGD , Background Elements , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors HCM Suite all versions