ReportingTroubleshooting < Deployment

Engineering Lifecycle Management Wiki - Deployment
Community information and contribution guidelines
TWiki > Deployment Web > DeploymentTroubleshooting > ReportingTroubleshooting
Revision 6 - 2025-03-05 - 15:22:37 - PaulEllis
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%">
---+!! Troubleshooting the Jazz Reporting Service  
%DKGRAY% Authors: Main.GerardCregan, Main.ThomasMathews, Main.FrancescoChiossi, Main.PaulEllis<br>
Build basis: Build basis: JRS 6.x and later 
%ENDCOLOR%</div></sticky>

<!-- Page contents top of page on right hand side in box -->
<sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;">
%TOC{title="Page contents"}%
</div></sticky>

<sticky><div style="margin:15px;"></sticky>

This page is the starting point to find information and techniques that you can use to diagnose and troubleshoot issues related to reporting, Lifecycle Query Engine (LQE), Data Collection Component (DCC), Report Builder (also know as JRS - Jazz Reporting Service). This page is expected to be used by <i>administrators</i> of IBM Engineering Jazz Reporting Service as supplemental guidance to the [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=jazz-reporting-service][IBM Documentation]].</br>

IBM Engineering Jazz Reporting Service <i>users</i> should use the [[https://www.ibm.com/community/101/engineering/ibm-jazz-reporting-service-101/][IBM Support Jazz Reporting Service 101]] which contains links to News; Must gathers; Technical Notes; JRS video tutorials; and more.

---++ Where is the issue?

Reporting issues usually involve multiple products. For example, when a report shows incorrect or stale data:
   * is it an issue with the query in Report builder?
   * is it an issue with the datasource within LQE or DCC
   * does the application expose the right data to LQE or DCC?
   * is the TRS provider (ELM application) correct and up-to-date?
</br>

If the following guidance does not resolve your issue, then refer to the following mustgathers:
   * [[https://www.ibm.com/support/pages/node/284799][Mustgather: Investigating problems with wrong data available in LQE data source]] 
   * [[https://www.ibm.com/support/pages/node/791587][MustGather: Investigating Invalid updates in Lifecycle Query Engine data source]]
   * [[https://www.ibm.com/support/pages/node/284799][Mustgather: Investigating LQE or LDX performance problems]]
   * [[https://www.ibm.com/support/pages/node/791579][MustGather: Investigating skipped resources in Lifecycle Query Engine data source]]

Once you have collected this data, raise a case with IBM Support, who will assist you.</br>

---+++ Troubleshooting Report Builder

   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=service-troubleshooting-report-builder][Troubleshooting Report Builder]] provides links to the following topics:
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/c_rb_replace_missing_artifacts.html][Repairing reports with missing artifact types or parameters]]. You can replace missing or renamed artifact types or parameters from other IBM Engineering Lifecycle Management applications in Report Builder.
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/c_jrs_logfiles.html][Report Builder log files]]. If errors or exceptions occur while you use Report Builder, log files and application logging help you research and resolve the issues.
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/rb_troubleshoot_export_report.html][Troubleshooting the error in exporting the report to Microsoft Word, PDF, or HTML]]. If the exported report returns an empty .zip folder and you get the SSL Handshake error in the log file, consider the following solution.
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/c_jrs_rep_cfgs_run_the_report_with_data_completeness_check_enabled.html][Run the report with data completeness check enabled]]. You can use Data completeness check to verify whether a specific report has problems.
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/c_rb_fix_corrupt_db.html][Resolving a corrupt database error]]. Every six hours a backup mechanism in Report Builder verifies that the Jena TDB database can be read, and creates a backup copy. If the database cannot be read, an error occurs. 
      * [[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.team.jp.jrs.doc/topics/c_jrs_gen_tips.html][General troubleshooting tips]]. You might not be able to view the latest enhancements or fixes in Report Builder, when you upgrade or apply a patch to Jazz Reporting Service (JRS).


---+++ Lifecycle Query Engine issues

[[ConfigurationAwareReportingTroubleshooting][Configuration aware reporting Troubleshooting]]covers many of the known issues for those who use Lifecycle Query Engine for reporting on configurations.
   * [[ConfigurationAwareReportingTroubleshooting#Reindex_operations][Reindex operations]]
      * [[ConfigurationAwareReportingTroubleshooting#What_to_check_before_requesting][What to check before requesting a reindex on a LQE or LDX datasource]]
      * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#Reasons_and_considerations_for_r][Reasons and considerations for reindexing all datasources again]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#How_can_I_make_sure_the_set_of_d][How can I make sure the set of data from a data provider is complete in LQE/LDX?]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#What_can_happen_from_the_Data_Pr][What can happen from the Data Provider (TRS)?]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#What_can_happen_fetching_resourc][What can happen fetching resources identified by TRS?]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#In_a_configuration_aware_report][In a configuration-aware report, what controls which artifacts are within scope?]]
      * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#Report_Builder_Data_Completeness][Report Builder - Data Completeness Checker]]
      * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=configurations-run-report-data-completeness-check-enabled][Run the report with data completeness check enabled]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#What_can_be_done_to_check_that_s][What can be done to check that selection resources are correct?]]
   * [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#LQE_status_information][LQE status information]]
</br>

---+++Validating the applications (TRS providers)

One of the mechanisms available to administrators, if their users' reports are inconsistent is to validate the TRS provider.  Each application that provides a data source to LQE, will have a way to validate that what is being presented to LQE is consistent.  For more information on validating data providers, see the [[https://jazz.net/wiki/bin/view/Deployment/ConfigurationAwareReportingTroubleshooting#What_can_happen_from_the_Data_Pr][What can happen from the Data Provider (TRS)?]] link and also the IBM documentation:
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=arelm-validating-trs-feeds-lifecycle-query-engine-ldx-index][Validating TRS feeds and the Lifecycle Query Engine or Link Index Provider index]]
   * [[Jhttps://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=arelm-validating-trs-feeds-lifecycle-query-engine-ldx-index#task_val_jts_rtc][Validating the TRS providers]], Jazz Team Server, Engineering Workflow Management, Rhapsody Model Manager, Engineering Requirements Management DOORS Next, Engineering Test Management, and Global Configuration Management

There are additional pages for advanced troubleshooting the validation output from the applications.  [[https://jazz.net/wiki/bin/view/Deployment/TRSValidation][TRS Validation]] explains how to deeper investigate issues that have been reported previously, including how to set verbose logging. </br>
[[https://jazz.net/wiki/bin/view/Deployment/DOORSNextTRSTroubleshooting][DOORS Next]] has an application-specific troubleshooting page that address issues reported with both modes of TRS validation with DOORS Next. </br>
[[https://jazz.net/wiki/bin/view/Deployment/TRSLogBasedSwitch][Log-based TRS]] provides further information on the process of switching to the new mode of TRS processing with DOORS Next.

---+++ LQE rs

There are specific steps to <i>graduating</i> from LQE (Jena store) to LQE (relational store).  The IBM documentation [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.0.3?topic=builder-working-lifecycle-query-engine-relational-store-reports][Working with Lifecycle Query Engine relational store reports]] is your starting point for this.  The topics covered within that document are:
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=builder-working-lifecycle-query-engine-relational-store-reports#task_hsw_zty_gxb__title__1][Making reports available in Report Builder]]
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=builder-working-lifecycle-query-engine-relational-store-reports#task_ddx_k5y_gxb__title__1][Editing queries to create advanced reports]]
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=builder-working-lifecycle-query-engine-relational-store-reports#task_wxk_t5y_gxb__title__1][Converting a SPARQL query to an SQL query in Report Builder]]
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=builder-working-lifecycle-query-engine-relational-store-reports#task_ng4_qxy_gxb__title__1][Manually converting SPARQL to SQL Resources]]
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=builder-working-lifecycle-query-engine-relational-store-reports#task_pnm_j44_3xb__title__1][Comparing query results between SPARQL and SQL]]

</br>
[[https://jazz.net/wiki/bin/view/Deployment/LQERSDatabaseSizing][Database sizing for LQE relational store]] provides guidance for sizing database servers that host the Lifecycle Query Engine - Relational store (LQE rs) application.


---+++ Data Warehouse Data source

[[https://www.ibm.com/docs/en/SSYMRC_7.1/com.ibm.rational.dcc.doc/topics/c_troubleshoot_dcc.html][Troubleshooting Data Collection Component]] is the starting document for Data Warehouse issues.

   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=component-troubleshooting-data-collection-data-collection#c_dcc_dw_links__missing_project][Data warehouse records are missing for a project area]]
   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.1?topic=component-troubleshooting-data-collection-data-collection#c_dcc_dw_links__link-to-deleted-artifacts][Data warehouse reports are showing links to deleted artifacts]]

For further troubleshooting guidance, technical notes on issues or details of Known Issues, visit the [[https://www.ibm.com/community/101/engineering/ibm-jazz-reporting-service-101/][Jazz Reporting Service 101 page]].

---++ Additional Log4j traces

Prior to versions 7.0.1 SR1 / 7.0.2 SR2:
here are some traces that can be added in log4j.properties per product

For versions 7.0.1 SR1 / 7.0.2 SR2 and beyond:
traces are to be added in log4j2.xml per product 

   * Report Builder
[[Report Builder Traces]]
   * Lifecycle Query Engine
   * Data Collection Component


---+++ Other scenarios
</br>
[[https://supportcontent.ibm.com/support/pages/after-server-rename-ibm-jazz-reporting-server-no-reports-are-displayed-gui][After server rename on IBM Jazz reporting server, no reports are displayed in GUI]]

---+++++!! Related topics: [[DeploymentWebHome][Deployment web home]], [[DeploymentWebHome][Deployment web home]]

---+++++!! External links:          

   * [[https://www.ibm.com][IBM]], [[https://www.ibm.com/community/101/engineering/ibm-jazz-reporting-service-101/][IBM Support Jazz Reporting Service 101]] 

---+++++!! Additional contributors: Main.TWikiUser, Main.TWikiUser

<sticky></div></sticky>
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.