SAP Knowledge Base Article - Public

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


Customer is not able to add new default date patterns.

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


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


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


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



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


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