BUG

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

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