SAP Knowledge Base Article - Public

2865989 - Location is not allowing to add new default date format - LMS

Symptom

Customer is not able to add new default date patterns.

They are getting an error: Error message = SQLException in unsetDefaultActiveLocaleDateFormatPatternForCurrentPatternType()

Environment

SuccessFactors Learning Management System - LMS

Reproducing the Issue

1.) Go to learning admin

2.)Go to refferences

3.) Go to Geography

4.) Go to Locations

5.) Select Spanish Mexican

6.) Go to date patterns

7.) Try to change default value from M/d/yyyy to d/M/yyyy

You will get the next error:

 

Error message = SQLException in unsetDefaultActiveLocaleDateFormatPatternForCurrentPatternType()<br>Ticket No = 964<br>ErrorFingerprint

Cause

the issue is happening as date pattern and time pattern related to locale id have last updated user as null in database.

Resolution

1.Go to References -> Geography -> Locales
2.Search for Spanish Mexican locale
3.Click Edit button
4.Go to Time Patterns
5.Click on Apply Changes button without modifying anything
6.Go to Date Patterns
7.Click on Apply Changes button without modifying anything

After following above steps, try to add new date pattern id for Spanish Mexican locale. There should not be any issue while adding the same.

See Also

LRN-50838

Keywords

error in adding default locale, unsunsetDefaultActiveLocaleDateFormatPatternForCurrentPatternType error , KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning 1802 ; SAP SuccessFactors Learning 1805 ; SAP SuccessFactors Learning 1808 ; SAP SuccessFactors Learning 1811 ; SAP SuccessFactors Learning 1902 ; SAP SuccessFactors Learning 1905 ; SAP SuccessFactors Learning 1908 ; SAP SuccessFactors Learning 1911