Incomplete data Advance Reporting-Jaspersoft - Dutch Language

Document ID : KB000031688
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

When we create an adhoc report in advance reporting. The User can access the report but gets only one page with data, not all data and cannot export the data. 

Steps To Reproduce:

  1. Install PMO Accelerator and its sample data to make sure you have a good number of resources, if you have more sample data even better 
  2. Create a user with all access rights (with the PMO Accelerator installed just add the resource to the PMO System Administrator group) 
  3. Configure the Data Warehouse to include English, Dutch and French 
  4. Run the Load Data Warehouse (Full) and the Load Data Warehouse Access Rights job 
  5. Log in as the user you just created keeping English as the user language in Accounting Settings 
  6. Navigate to Advanced Reporting and create an ad hoc view from the Resource Management Domain 
    • Create the ad hoc view as a table and make sure you move all columns under Resources (Resource Name, Resource ID, Resource Type, Primary Role, Resource Manager, etc) and all columns under General, and OBS Level 1, OBS Level 2, OBS Level 3, and OBS Level 4 
  7. Save the ad hoc view as an ad hoc view and an ad hoc report 
  8. Run the ad hoc report with the user in English - note the number of pages that is generated (it should be more than one page) 
  9. Change the language in Accounting Settings to French 
  10. Log out and log back in and navigate to Advanced Reporting 
  11. Run the ad hoc report again - note the number of pages that is generated (it should be more than one page again) 
  12. Change the language in Accounting Settings to Dutch 
  13. Log out and log back in and navigate to Advanced Reporting 
  14. Run the ad hoc report again - note the number of pages that is generated 
Expected Result:  The report displays the same number of records as before, when the user had English or French. The same number of pages is generated.
Actual Result: The report only displays one page. It does not include all records of all resources. 

Cause: 

Caused by CLRT-78743

Resolution: 

Resolved in CA PPM 14.2 

Workaround: 

Navigate to Home, Account Settings: Change Language to a Non-Dutch language.