My Oracle Support Banner

E1: GRID: Databrowser Cannot Have More Than 100 Advanced Queries AND Personal Queries Disappearing While Number of Shared Queries Are Increasing (Doc ID 2237560.1)

Last updated on MAY 29, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Symptoms


Symptom 1: Customer has been creating more and more shared queries for Databrowser recently, but as the number of shared queries increases, the number of personal queries available on the query selection screen has dropped. Looking through a trace of the HTML server, there seems to be a limit on the number of queries that will be presented on the query selection screen, and the limit is 100.

Found these lines in the HTML logs in DEBUG mode:

SELECT AQWOBNM,AQWOUSER,AQWOOBNMS,AQOBNM,AQFMNM,AQVERS,AQSEQ,AQOMRBLOB FROM QA910.F952430 WHERE ((AQOBNM = ? AND ((((AQWOUSER = ? OR AQWOUSER = ? ) OR AQWOUSER = ? ) OR AQWOUSER = ? ) OR AQWOUSER = ? ))) ORDER BY AQWOUSER ASC

JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 3, nextpageid = 1487170703012, data = JASResultSet is returning 100 rows


Requesting to allow more than 100 queries for Databrowser.

Symptom 2: User's personal queries are not visible in data browser. But the same query visible if user search "By Table"

 

Changes

 

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
Changes
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.