SAP Knowledge Base Article - Public

3003476 - Data issues in LMS ORD/Canvas reports

Symptom

This KBA is about the most common data issues in ORD/Canvas reports related to LMS schemas. The issues below are identified by number:

  1. Data missing in the result because of the Date filters
    - Data discrepancy
    - Data missing running the report online, but it's available exported offline
    - Report is blank after applying a filter, but it displays data if exported offline

  2. Error message presented the output report: "Error rendering List Report component"
    - Error message running the report via bundle in Report Distributor: Unable to read data from the transport connection: The connection was closed"...Error in retrieving AdHoc Report results for OrgId

  3. No LMS Schema available trying to create or run a report
    - Permissions for LMS Schema
    - "Role based security prevent the viewing of this component" error message running the report

  4. Error message (e.g. about Java or SQL) appears in the cells instead of the data
    - SAP DBTech JDBC: invalid column name

  5. Error while exporting report: The result was truncated because the number of transferred bytes reached the set limit

  6. User can see data only of himself
    - People Scope option is greyed out/unavailable
    - Target Population behavior in the report

  7. Some users are missing in the report

  8. Some columns are missing creating the report

  9. How Date filters work for each LMS schema
    - Mandatory Date filters at runtime

  10. Custom columns are not available in ORD/Canvas

Environment

SAP SuccessFactors HXM Suite

Resolution

  1. Some records are missing in the result because of the Date filters
    - 2316286 - Data discrepancy in the ORD reports generated with "Schedule Offering Registration" and "Item Cost and Order information" - [LMS]
    - 2341864 - Data discrepancy between ORD and LMS on learning data returned


  2. Error message presented the output report: "Error rendering List Report component"
    - 2773555 - ORD Report does not bring data from LMS
    - 2647080 - Downloading ORD Report with learning fields displays [Error rendering List Report component]


  3. No LMS Schema available trying to create or run a report
    - 2258949 - No LMS schema coming up in Online Report Designer
    - 2199772 - Accessing LMS Learning Schemas in Online Report Designer
    - 2490125 - Learning permissions for ORD
    - 2375144 - "Role based security prevent the viewing of this component" error when running LMS reports in ORD

    If none of the above solutions work, raise a support ticket to review the origin- parameter in ORD, same as KBA 2647080
      - If the issue persists after including the origin- parameter, we need to raise an internal ticket to Operations team


  4. Error message (e.g. about Java or SQL) appears in the cells instead of the data
    Make sure that the Assignment Profile Synchronization is scheduled to run. If not, follow the steps below:

    1. Go to LMS admin
    2. System admin
    3. Automatic processes
    4. Assignment Profile Synchronization

    If the issue persists after running the Assignment Profile Synchronization, please raise a support ticket to engage LMS Engineering.


  5. Error while exporting report: The result was truncated because the number of transferred bytes reached the set limit
    2443149 - Error while exporting an ORD report from LMS - Online Report Designer / Learning


  6. User can see data only of himself / People Scope option is greyed out
    2276460 - People Scope / Target population behaviour for LMS / Learning schema in Online Report Designer / Report Canvas


  7. Some users are missing in the report
    2585697 - Learning Report in ORD not displaying the full list of users from LMS


  8. Some columns are missing creating the report
    2549794 - LMS - Users can't see some columns in ORD report


  9. How Date filters work for each LMS schema
    2682086 - Mandatory Date filter / Required Parameters / Default Date Range filters at Run time in Report Canvas / ORD reports for the Learning Sub Domain Schema


  10. Custom columns are not available in ORD/Canvas
    - 2497762 - No Data Returned for LMS Custom Columns in ORD/Report Canvas
    - Run the Assignment Profile Synchronization
    1. Go to LMS admin
    2. System admin
    3. Automatic processes
    4. Assignment Profile Synchronization

 

See Also

Keywords

KBA , LOD-SF-LMS , Learning Management System , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions