SAP Knowledge Base Article - Public

2316246 - Admin Receiving "The Learning Event does not exist in the database" even though the record exists

Symptom

Admin is receiving "The Learning Event does not exist in the database" when they try to update the Learning History via the Import Data tool even though the record exists in the LMS System

"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

Reproducing the Issue

  1. Logon to Learning Admin
  2. Navigate to System Admin -> Tools -> Import Data -> Learning History
  3. Select completed Learning History file to import
  4. Import fails with the error:
    The Learning Event does not exist in the database 

Cause

  • The following fields cannot be updated using the import data tool: User ID, Item Type, Item ID, Item Revision Date & Time, Completion Date & Time, Completion Status
  • This failure error is likely due to the Completion time format in the template:
    • The "Completion Time" entered in the import file must match the time to seconds and not just Hour:Minutes
    • If the seconds are missing or the timestamp is inaccurate, the system is unable to match the learning event that is being updated and errors

Resolution

  • If the Admin preferences for Date/Time have been modified to only display Hours & Minutes in the LMS, the completion date may be observed as only HH:mm (example: 08:38 AM)
  • This may lead the Admin to enter the completion time into the import file as 08:38 AM
  • However, this is not the actual completion time
  • Demo System screenshot showing modified date/time format of Completion Date: Admin going to user page > completed item > view details

                

  • To change the date/time format so that the seconds can be viewed, please go to References -> Geography -> Locales
    1. Perform an Empty search
    2. Choose the Language that you use as an admin (Edit)



    3. Go to the “Time Patterns” tab and see if hh:mm:ss aaa is available and made “Default”.

      LearningHistory-Update-ImportData-LocaleTimeWithoutSecond.jpg

    4. If it is not, please select “add one or more from the list” option and add “hh:mm:ss aaa” or “HH:mm:ss” (24 hour format) and make it default

      LearningHistory-Update-ImportData-AddTimeWithSecond.jpg
      • Note: All the new user or admin accounts created after this change with English Locale will have hh:mm:ss as their default time pattern but the not the ones who were created before this, existing Admins will need to update their preferences

  1. Now you can go to Prefrence and select the :

         

  1. After changing the time pattern, the date and time with seconds is now displayed:

         

  1. This full time stamp is what will be entered into the import file
    • In this example, it would be 08:38:31 AM
  2. Using the full timestamps in the import file, the import is successful 

    Keywords

    The Learning Event does not exist in the database, Learning History Update, Import Data, Failed , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-IMP , Import Data Tool , Problem

    Product

    SAP SuccessFactors Learning all versions