Bug: The Executed Query is Not Executing Correctly against the Database. Verify the Query

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

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

Description

Cause

Workaround

Discover more on this topic