BUG

The executed query is not executing correctly against the database. Verify the query syntax for your underlying database system.

Last Published: April 25, 2020

Description

Trying to find jobs by date or filter by date in a query against an Oracle JTX repository causes the following error message:

"The executed query is not executing correctly against the database. Verify the query syntax for your underlying database system."

Cause

The query generated by JTX is not a valid Oracle query.

Workaround

To format the date being searched, use the JTX SQL query functionality and the Oracle to_date or to_char function.

    Article ID:000010665

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options