SAP Knowledge Base Article - Public

2279653 - Error when viewing user record "Unparsable date: Invalid Year Format"

Symptom

Admin wants to open user's record in LMS and after clicking on user's name, the following error message shows up:

Error (2).PNG

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

Environment

SAP SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

  1. Navigate to Users and search for specific user,
  2. Click user's name,
  3. Error message shows up.

Cause

After downloading one of affected user's record from database in xls. format, we observed that record hire date has been overwritten to different value:

HireDate.PNG

That is how we figured out that issue has been caused by hire date information. The error message is related to Invalid Year Format as text specifies.

Resolution

  1. Navigate to SystemAdmin/Tools/Import Data,
  2. Download the template for importing data for users and submit:

    Template.PNG

  3. Open the downloaded template and type the hire date again, make sure that format cells are set to Text (it could be set to number and value can be overwritten):

    Format.PNG

  4. Save file and navigate to SystemAdmin/Tools/Import Data and follow the steps for importing the file to LMS:

    Import.PNG
  5. Replicate the steps for opening user's record and issue should be fixed.

Keywords

java error, invalid year format, unparsable date, snapshot exception, server processing, import data , KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SuccessFactors Learning 1508