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.
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:
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"
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