SAP Knowledge Base Article - Public

3492914 - Special characters are being added to the date time format in Learning reports

Symptom

Special characters are being added to the date time format in Learning reports.

Environment

SAP SuccessFactors Learning

Cause

Our Learning Engineering Team has reviewed this issue and confirmed that a new space character (NNBSP) is appearing in the date time format. This is because the CLDR library has been upgraded in Java17, which has updated the space character to NNBSP/new space character. Since Learning is using Java17, this is causing the issue.

Resolution

This problem is not connected to standard or custom reports. It happens when a date time field in the report does not have a defined eventHandler class.

Solution:

  1. Please request the downstream system to make the required changes to the date time pattern. The introduction of this new space character is a result of the CLDR/Java 17 library, and we cannot fix it, as it does not rely on Learning.

  2. As an alternative, you can update the custom report to use event handler class for the last updated timestamp field like below code snippet:
      <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>

Keywords

special, characters, learning, reports, custom, NNBSP, java, standard, timestamp, LST_UPD_TSTMP, date, column , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions