SAP Knowledge Base Article - Public

2901834 - LMS: Date pattern change cannot be saved

Symptom

Error generated when changing date format within a locale. Error below:

Error "SQLException - updateI18nActiveLocaleDateFormatPatterns() failed" 

Environment

SAP SuccessFactors Learning 

Reproducing the Issue

  1. Navigate to References > Geography > Locales > select locale > open in Edit mode > open Date Patterns tab.
  2. Select the Date Pattern to be the default one and Apply Changes. Error is generated.

Resolution

  • Go to Locales -> select the affected locale -> Date Patterns -> Click on Apply Changes button without modifying anything.
  • Go to Locales -> select the affected locale -> Time Patterns -> Click on Apply Changes button without modifying anything.

In the new admin UI:

  1. Go to References
  2. Geography
  3. Manage Labels
  4. Locales
  5. Select locale with this issue
  6. Go to Time Patterns and you can add a new time pattern.
  7. You should then have another option under admin preferences for time pattern once you take these steps.

See Also

2705688 - Error generated when updating Date Format for locale

Keywords

date pattern, default date pattern, updateI18nActiveLocaleDateFormatPatterns() failed, cannot save, date pattern error, date, LMS, Success Factors , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem

Product

SAP SuccessFactors Learning all versions