SAP Knowledge Base Article - Public

2185277 - User records not updated due to “Invalid Date Format” exception - LMS

Symptom

When processing the Connector User Record, the records are not being updated in the Learning Management System via the User Connector- SF, because of an “Invalid Date Format” exception error being generated:

Error Code: Invalid Date Format.HIRE_DTE <date format>

Environment

SAP SuccessFactors Learning Mangement System

Cause

  • Invalid Date format exception occurs when there is a mismatch of the “HIRE_DTE” date format in the user input file and the HIRE_DTE transformation configuration in the connector file in LMS.
  • An invalid date format exception will be thrown if the user input connector file has user records with the date format as “yyyy-mm-dd’ where as the HIRE_DTE transformation configuration under System Admin > Configurations > System Configuration > Connector is set as:

    sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=MM/dd/yyyy

Resolution

To resolve this issue please check the following:

  1. Go to System Admin > Configurations > System Configuration > Connector
  2. Search for HIRE_DTE transformation configuration

sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=<date format>

  1. Change the <date format> in the above transformation configuration to “MM/dd/yyyy” which is recommended date format

Please note there is only one configuration for HIRE_DTE transformation

Keywords

SF Success Factors, User Connector Error, Invalid Date Format, Record Updates, LMS , KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions