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:
- 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 - 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 - 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 - Error message (e.g. about Java or SQL) appears in the cells instead of the data
- SAP DBTech JDBC: invalid column name - Error while exporting report: The result was truncated because the number of transferred bytes reached the set limit
- User can see data only of himself
- People Scope option is greyed out/unavailable
- Target Population behavior in the report - Some users are missing in the report
- Some columns are missing creating the report
- How Date filters work for each LMS schema
- Mandatory Date filters at runtime - Custom columns are not available in ORD/Canvas
Environment
SAP SuccessFactors HXM Suite
Resolution
- 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 - 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] - 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 - 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. - 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 - 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 - Some users are missing in the report
2585697 - Learning Report in ORD not displaying the full list of users from LMS - Some columns are missing creating the report
2549794 - LMS - Users can't see some columns in ORD report - 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 - 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