IBM Support

Lifecycle Query Engine log for Jazz Reporting Service reports: CRLQE0827W Detected a rogue query that started...

Troubleshooting


Problem

Using the Lifecycle Query Engine (LQE) service for IBM Jazz Reporting Service (JRS)  becomes unresponsive and may crash resulting in a restart of the LQE server and the lqe.log reports errors "CRLQE0827W Detected a rogue query..." and "CRLQE0793E The query service is temporarily suspending new query execution due to high volume"

Symptom

In the 'lqe.log' you can see messages similar to the following:

[lqe.RogueQueryMonitor-thread-0]  WARN com.ibm.team.jis.lqe.health.load.RogueQueryMonitor  - CRLQE0827W Detected a rogue query that started at 2/5/24 7:01 AM and has been running for 34 minutes 57 seconds. You might want to block this query from execution in the future or enable the automatic cancellation of rogue queries. The query uuid is 01349425-e908-42ce-8a0f-b6baf0915282. The SPARQL text executed is (#@id : b18c6c98-e1e6-4017-9b8c-c27c53d6664f
#Report URL : https://jazz.ibm.com/rs/query/18601/export/excel/static?report=18450&limit=-1

 [ lqe.MetricsEvent]  WARN am.integration.lqe.lib.dataset.query.QueryExchange  - {"nanos":53327303,"dbCount":2,"errorInfo":"{\"timestamp\":1530620255916,\"description\":\"CRLQE0793E The query service is temporarily suspending new query execution due to high volume.\",\"errorId\":-1}","status":"failed","query":"PREFIX  oslc_rm: <http:\/\/open-services.net\/ns\/rm#>\nPREFIX  merge: <http:\/\/jazz.net\/ns\/lqe\/merge.....,"endTime":1530620255916,"concurrentQueries":0,"maxConcurrentQueries":0,"dbTimeAvg":0.0,"startTime":1530620255869,"partition":"default","dbTimeMin":0.0,"isFtsQuery":false,"dbTimeStdDev":0.0,"dbTimeMax":0.0,"resultCacheHit":false,"queryId":"7725f85c","user":"frneukam"}

German language example:

[lqe.RogueQueryMonitor-thread-0]  WARN com.ibm.team.jis.lqe.health.load.RogueQueryMonitor  - CRLQE0827W Es wurde eine Rogue-Abfrage erkannt, die um 12.06.19 05:56 gestartet wurde und seit 6 hours 45 minutes 5 seconds läuft. Möglicherweise möchten Sie verhindern, dass die Abfrage in Zukunft ausgeführt wird, oder den automatischen Abbruch von Rogue-Abfragen aktivieren.

There may also be:

[lqe.lqe.config.vocab-reader-thread-0] ERROR ation.lqe.lib.kvstore.reader.KVStoreBufferedReader  - CRLQE0567E An error occurred attempting to refresh cached configuration information from the database.  The application will continue attempting to refresh the cache on regular intervals,but will not log subsequent errors until this problem has been resolved.
java.lang.OutOfMemoryError: Java-Heapspace

 [ WebContainer : 12] ERROR com.ibm.team.jis.lqe.http.HttpErrorWriter           - A servlet request is responding with a status of 500 and the message is .
java.lang.OutOfMemoryError: Java-Heapspace

NOTE: You will see the same errors in  Link Index Provider (LDX).

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTU9C","label":"Jazz Reporting Service"},"ARM Category":[{"code":"a8m0z000000CbMZAA0","label":"Jazz Reporting Service-\u003ELifecycle Query Engine-\u003EAdministration"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
05 April 2024

UID

ibm10716583