error code 400 message "Unable to complete operation, Unable to perform query operation

Question

Part of the error message received.

Error Posting to URL: http://localhost:6080/arcgis/rest/services/Caroline/Schema1/FeatureServer/0/query with parameters: where=animal_sighted IN ('Wildebeest','Zebra','Thompson_Gazelle','Giraffe','Lion')&outfields=animal_sighted,objectid&f=json. java.io.IOException: {"error":{"code":400,"message":"Unable to complete operation.","details":["Unable to perform query operation."]}} at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.validateResponse(FeatureServiceOutboundTransport.java:745)

What could be the source of this error?

Mark Mindlin​ Hafizi Saidin​ Wes Goldstein​ Could you please help me with this?

Caroline_Akoth · Answer

Hello RJ,

Yes I have gone through both the blog and the product Introduction tutorial is actually what i have been using.

I have added an output TCP text output that shows output as shown:

I am now pulling my feature service from My Hosted services on AGOL, from which i imported my Geo-event definitions.Upon making that shift i reset my configuration settings.

Here a screen shot of the Karaf.log indicating that services are being pulled from ArcGIS server which are now empty. Having reset my data store i did not expect this.

RJSunderman · Answer

Hello Caroline -

Looking closely at the error you posted, you are still being told "Unable to perform query".

Your underlying issue has not been resolved. GeoEvent is still looking for an OBJECTID for the specified TRACKID values:

where=animal_sighted IN ('Cheetah','Leopard','Elephant','Buffalo','Wildebeest')

* Notice the REST endpoint on which the request is being made:  .../FeatureServer/0/query
* Also, notice the fields being requested:  outfields=animal_sighted,objectid

Verifying event attributes in your input CSV and using a Field Mapper processor to make sure GeoEvents sent to an 'Update a Feature' output have the correct schema are good workflow debugging steps. Using the GeoEvent Monitor page to observe event counts for your input, GeoEvent Service, and output is also good. However, jumping from this to Operations Dashboard to see if features are being updated in an operational view is premature.

As part of your debugging, have you stepped through the narrative on pages 34 - 42 ("Reconfigure the Flights GeoEvent Service") and ("Examine an updated feature service’s REST endpoint") in Module 2 of the product introduction tutorial? I would recommend using a TCP/Text output (and possibly a File/JSON output as well) to see what your GeoEvent Service is producing. You also need to be using the ArcGIS REST Services Directory to examine your feature service's content before expecting Operations Dashboard to show you features being updated.

Have you had a chance to try some of the debugging steps outlined in the Debugging the Add a Feature / Update a Feature Output Connectors​ blog? Understanding the queries and Server responses illustrated in the FeatureServiceUpdate.png attached to that blog -- and observing the same in your GeoEvent's karaf.log -- are important when trying to figure out why features are not being added or updated in a feature service's feature class. Unfortunately, seeing an output's count increment on the GeoEvent Monitor page is not sufficient to conclude that requests made to the feature service, or transactions made with the database, were successful.

Until we figure out why GeoEvent is unable to query the feature service to obtain an OBJECTID you will never see requests made to update features (.../FeatureServer/0/updateFeatures). Until you see updateFeatures messages in the GeoEvent log, you can't conclude that GeoEvent has actually requested a feature service update features in its feature class. The web map you have prepared, which the operational view is using, won't be able to tell you anything if features are not being updated in the underlying feature class.

Hope this helps -

RJ

Caroline_Akoth · Answer

Hello RJ Sunderman​

I tried your suggestion and i can now view counts  but output cannot display on the operations dashboard.

I'm also getting the following error. I have counter-checked my Schema and CSV.

Error Posting to URL: http://services6.arcgis.com/UN0h3uOZyPiORHVm/arcgis/rest/services/Schema/FeatureServer/0/query
with parameters: where=animal_sighted IN ('Cheetah','Leopard','Elephant','Buffalo','Wildebeest')&outfields=animal_sighted,objectid&f=json
&token=EdRUeCApvDpYYJiXnMsxgmPTu6Dh53qVlDT7BbgbW1C5bfk3JPQGiKcpl_idsh2CwpaHGGQuvJo-QxC0vtSvlaGI-Cr_hUh79nY3gaDM-w4OBjRH00GDAKjh0ucL20kxXaxsri167B1inOuvBtwjHBQX7Ksc8cQBh0op-gOXCTkNFKJvmIzqCVPatNscq1SYKxzfXwyELZYGKLCbZJmTBm5UDMhMnm8hro0Wk0g5tYWTsQimDDPiYzQq8W7sGP5-OVhtmoLBUEeq2_f5kmt2GA...
java.io.IOException: {"error":{"code":400,"message":"","details":["Unable to perform query. Please check your parameters."]}}
at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.validateResponse(FeatureServiceOutboundTransport.java:745)[266:com.esri.ges.framework.transport.featureservice-transport:10.3.0]
at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.performMissingOIDQuery(FeatureServiceOutboundTransport.java:452)[266:com.esri.ges.framework.transport.featureservice-transport:10.3.0]
at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.queryForMissingOIDs(FeatureServiceOutboundTransport.java:433)[266:com.esri.ges.framework.transport.featureservice-transport:10.3.0]
at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.writeToFeatureService(FeatureServiceOutboundTransport.java:153)[266:com.esri.ges.framework.transport.featureservice-transport:10.3.0]
at com.esri.ges.transport.featureService.FeatureServiceOutboundTransport.receive(FeatureServiceOutboundTransport.java:84)[266:com.esri.ges.framework.transport.featureservice-transport:10.3.0]
at com.esri.ges.manager.stream.internal.OutboundTransportProxy.receive(OutboundTransportProxy.java:42)[325:com.esri.ges.manager.internal-streammanager:10.3.0]
at com.esri.ges.manager.stream.internal.OutboundStreamImpl.receive(OutboundStreamImpl.java:184)[325:com.esri.ges.manager.internal-streammanager:10.3.0]
at com.esri.ges.adapter.OutboundAdapterBase.receive(OutboundAdapterBase.java:44)[253:com.esri.ges.framework.adapter.adapter-api:10.3.0]
at com.esri.ges.adapter.json.FeatureJsonOutboundAdapter.flushQueue(FeatureJsonOutboundAdapter.java:116)[258:com.esri.ges.framework.adapter.feature-json-adapter:10.3.0]
at com.esri.ges.adapter.json.FeatureJsonOutboundAdapter.run(FeatureJsonOutboundAdapter.java:91)[258:com.esri.ges.framework.adapter.feature-json-adapter:10.3.0]
at java.lang.Thread.run(Thread.java:745)[:1.7.0_65]