IBM Support

Cleaning up the database and indexes of Lifecycle Query Engine in JRS

How To


Summary

How to clean database and indexes of Lifecycle Query Engine (LQE) in IBM Jazz Reporting Server (JRS)

Objective

These steps can be used when:
  • The LQE data is corrupted and needs to be cleaned up and you don't have a valid backup
  • You want to reset the data for any other reason

Steps

To reset the LQE data, do the following:
  1. Log in to the JTS Admin of the CLM server and go to Server > Registered Applications
  2. Unregister Lifecycle Query Engine by clicking Remove Application next to Lifecycle Query Engine
  3. Stop the Lifecycle Query Engine Application
  4. Edit the lqe/app.properties file and set lqe.configMode = true
    Check the settings for lqe.restore & lqe.restore.node values. These lines might need to be commented out.
  5. Delete the following directories located in JAZZ_HOME/conf/lqe:  indexTdb, textindex, shapeTdb, shapeText, historyTdb, historyText, versionTdb (only in 6.0.6 iFix003 and later releases)
  6. Drop the LQE database
  7. Re-create the LQE database as described in: Setting up the database
  8. Start the Lifecycle Query Engine Application
  9. Log in to the JTS Admin of the CLM server and go to Server > Registered Applications
  10. Click Add in the Registered Applications page and provide the following values:
    1. Discovery URL: https://server:port/lqe/scr
    2. Application Name: /lqe
    3. Consumer Secret: Enter the new consumer secret and write it down
    4. Retype Secret: Enter the new consumer secret again
  11. Click Finish
  12. In the list of registered applications, you might now have an entry for /lqe
  13. Rerun the setup of LQE through the jts/setup
For Link Index Provider (LDX), it is the same as LQE, except conf/ldx folder and the ldx context instead of lqe.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTU9C","label":"Jazz Reporting Service"},"Component":"LQE","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
04 August 2023

UID

ibm10961310

Page Feedback