E1: ORCH: Data Request Using Only Query Ends in Open Find Error "message": "ServiceRequest querytest: Message: Open find not allowed.Ensure there is at least one filter..."
(Doc ID 2999579.1)
Last updated on JANUARY 30, 2024
Applies to:
JD Edwards EnterpriseOne Orchestrator - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
New Data Request with a Query attached, "Include Count" enabled under 'Aggregations' tab, and No Filter Criteria been added and "Include Empty Query Values" enabled under 'Filter Criteria' tab attached to the orchestrator, users are getting the below error message while running it the orchestrator studio:
{
"message": "ServiceRequest querytest: Message: Open find not allowed. Ensure there is at least one filter (turn on Include Empty Query Values switch to add filter even when the value is empty) or Maximum Records is not 0.",
"exception": "Exception",
"timeStamp": "2024-01-30T05:24:22.029+0000",
"userDefinedErrorText": "",
"status": "ERROR",
"jde__simpleMessage": "ServiceRequest querytest: Message: Open find not allowed. Ensure there is at least one filter (turn on Include Empty Query Values switch to add filter even when the value is empty) or Maximum Records is not 0.",
"jde__status": "ERROR",
.......
..........
}
Error Message can be seen in Orchestrator Studio:
Steps to replicate:
-------------------
- Login to Orchestrator Studio.
- Select the Data Request.
- Enter the details and setup this data request such that it will run a Query on a view.
- Enable the "Include Count" from Aggretations, "Include Empty Query Values" toggle buttons and do not add any filter criteria.
- Save the Data Request and Attach it to the Orchestrator.
- Run the Orchestrator.
Changes
Upgrade to tools release 9.2.7.3.
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 |