5004: SpatialQuery.whereClause is not a valid SQL WHERE clause

Error Message

Note:
The ArcWeb Services product line has been retired. ESRI recommends that customers who wish to create Web applications or use services similar to those that were available in ArcWeb Services transition to the capabilities of ArcGIS Server and ArcGIS Online.

Cause

The WHERE clause contains too many items. For example the IN statement can only hold 1000 values.

Code:
variable IN ( value1, value2, ... valueN)

Solution or Workaround

Code:
variable IN (value1, value2, ... , value1000) OR variable IN (value1001, value1002, ... , value2000) OR variable IN (value2001, value2002, ... , value2345)

Note:
The ArcWeb Services product line has been retired. ESRI recommends that customers who wish to create Web applications or use services similar to those that were available in ArcWeb Services transition to the capabilities of ArcGIS Server and ArcGIS Online.