3003476 - Data issues in LMS ORD/Canvas reports

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

SAP SuccessFactors HXM Suite

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
    

• Troubleshooting Learning Fields for ORD
• Learning Fields in Online Report Designer

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