3476025 - LMS: Post 1H 2024, LST_UPD_TSTMP field contains special character

After 1H 2024 upgrade, the LMS custom reports using LST_UPD_TSTMP field, contains special character after 2405 release 

SAP SuccessFactors Learning

1. Login to instance > Learning Administration > Report

2. Search Curriculum Item Status > InfoEdUserCurriculumItemStatusCSV(or the custom report in question)

3. Filter with any random curricula > run report

4. Check the report file with notepad > The last field LST_UPD_TSTMP contains a special character

OR

The space character in custom learning reports has changed from unicode 32 to 8239

The CLDR library was upgraded in Java17, which updated the space character to NNBSP/new space character. The LMS is using Java17, so this problem occurs.

Preparing For Migration (oracle.com) If your application starts successfully, look carefully at your tests and ensure that the behavior is the same as on the JDK version you have been using. For example, a few early adopters have noticed that their dates and currencies are formatted differently. See Use CLDR Locale Data by Default.

There are two solutions:
1. Ask downstream systems to make necessary datetime pattern changes, as this new space character is from the CLDR/Java 17 library and we cannot fix it.
2. Update the custom report and use the event handler class to process the last updated timestamp field. You can refer to the following code snippet as an example.

<cell id="5033">
                        <text id="5039">
                            <property name="eventHandlerClass">com.plateau.common.reportservice.impl.PlateauTextItemEventHandler</property>
                            <property name="newHandlerOnEachEvent">true</property>
                            <list-property name="userProperties">
                                <structure>
                                    <property name="name">SHOW_INPUT</property>
                                    <property name="type">boolean</property>
                                    <property name="isVisible">true</property>
                                </structure>
                                <structure>
                                    <property name="name">OPERATOR_COLUMNS</property>
                                    <property name="type">string</property>
                                    <property name="isVisible">true</property>
                                </structure>
                                <structure>
                                    <property name="name">OPERATOR_NAME</property>
                                    <property name="type">string</property>
                                    <property name="isVisible">true</property>
                                </structure>
                            </list-property>
                            <property name="SHOW_INPUT">true</property>
                            <property name="OPERATOR_COLUMNS">EXPIRATIONDATE:PREFERRED_TIMEZONE</property>
                            <property name="OPERATOR_NAME">FormatOnlyDateDisplayInLearnerTimezone</property>
                            <property name="contentType">auto</property>
                            <text-property name="content"><![CDATA[[EXPIRATION_DATE]]]></text-property>
                        </text>
                    </cell>
                   
Currently no eventhandler class is specified for Last updated timestamp field, please see below.
 <cell id="5045">
                        <data id="5055">
                            <property name="resultSetColumn">ITEMLASTUPDATETIMESTMP</property>
                        </data>
                    </cell>

Since this is a problem caused by Java17, SAP cannot make a direct fix. You can refer to the above solutions to modify the report or downstream system. 

Custom Report, Timestamp, 1H2024 release, Special Character, Unicode, LST_UPD_TSTMP, Java 17, , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Bug Filed