My Oracle Support Banner

E1: DB: Long Running SQL Not Logged ("Failed to generate the query string, retCode=0") (Doc ID 3030532.1)

Last updated on AUGUST 19, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The following error in kernel logs when long-running SQL query tracking is enabled and a query runs for more than the QueryExecutionTimeThreshold (jde.ini setting, see Doc ID 1527286.1), and no query is written to the log:

Steps:

  1. Set QueryExecutionTimeThreshold to 2
  2. Perform action that submits a query that takes > 2 seconds
  3. Observe error noted above in kernel log

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.