AnsweredAssumed Answered

Relative to Current Time Query Issues

Question asked by arepsher on May 24, 2016
Latest reply on May 25, 2016 by arepsher

I am trying to utilize the "Relative to current time" value selection for a query within ArcGIS Dashboards and am running into "SEVERE" errors within the ArcGIS Enterprise logs.  Looking to just show the last 5 minutes of data.  Here is how I am setting up the query:


When the query filter is applied, the real-time Feature Service stops updating in OD without any error being shown.  Looking at the AGS logs shows quite the problem.  This is just part of the severe error message.  It is repeated within the same message many times.  I have not taken the time to break it all down to see how many...:

Failed to execute phase [query], all shards failed; shardFailures {[Qy8SrxfWQOavsZW-Hu6ulQ][d8684b2f-ea72-478d-bb7f-b35a41c5ad2b][0]: SearchParseException[[d8684b2f-ea72-478d-bb7f-b35a41c5ad2b][0]: from[0],size[1001]: Parse Failure [Failed to parse source [{"from":0,"size":1001,"query":{"filtered":{"query":{"bool":{"must":[{"range":{"DateTimeStamp":{"from":"2016-05-24 16:05:15","to":null,"include_lower":true,"include_upper":true}}},{"range":{"DateTimeStamp":{"from":null,"to":"2016-05-24 16:10:15","include_lower":true,"include_upper":true}}}]}},"filter":{"geo_bbox":{"Geometry":{"top_left":[-77.19168316650345,40.46689211286708],"bottom_right":[-76.64305340576199,40.18893213802859]}}}}},"fields":["objectid","globalid","ip","Label","Bearing","Speed","GPS_Status","Symbol","S_SIGN","UNIT_ID","STATION","S_CODE","GROUP","FEED","Longitude","Latitude","EV","NV","GPSTimeSec","DateTimeStamp","MesESN","LastPollTime","LastReceivedTime","ResponseTime","PollInterval","_id","Geometry"]}]]]; nested: ElasticsearchParseException[failed to parse date field [2016-05-24 16:05:15], tried both date format [dateOptionalTime], and timestamp number]; nested: IllegalArgumentException[Invalid format: "2016-05-24 16:05:15" is malformed at " 16:05:15"]; }



I am looking to see if there is a known bug, or at least someone else is having this problem attempting to filter on relative to current time.

Thank you!