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).
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
05 April 2024
UID
ibm10716583