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

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic