[production] ERROR: TransportError: TransportError(500, u'SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[MKCYb-dqR1WScePL_8N1Iw][hqcases_2016-03-04][0]: RemoteTransportException[[hqes2][inet[/10.177.128.1

Internal Server Error: /a/broadreach-sa/data/edit/json/reassign_cases/

Method: GET

URL:
http://www.commcarehq.org/a/broadreach-sa/data/edit/json/reassign_cases/?sEcho=2&iColumns=5&sColumns=%2Cname.exact%2Ctype.exact%2Cowner_display%2Cmodified_on&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&bSortable_0=false&mDataProp_1=1&bSortable_1=true&mDataProp_2=2&bSortable_2=true&mDataProp_3=3&bSortable_3=false&mDataProp_4=4&bSortable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&individual=&group=&case_type=&ufilter=0&search_query=opened_on%3A[*TO*]&emw=project_data&is_open=&case_type=&filterSet=true&is_open=
Traceback (most recent call first):

TransportError: TransportError(500,
u'SearchPhaseExecutionException[Failed to execute phase [query], all
shards failed; shardFailures
{[MKCYb-dqR1WScePL_8N1Iw][hqcases_2016-03-04][0]:
RemoteTransportException[[hqes2][inet[/10.177.128.130:9300]][indices:data/read/search[phase/query]]];
nested: NotSerializableTransportException[[org.elasticsearch.search.SearchParseException]
[hqcases_2016-03-04][0]: from[-1],size[-1]: Parse Failure [Failed to
parse source [{"sort": [], "query": {"filtered": {"filter": {"and":
[{"term": {"domain.exact": "broadreach-sa"}}, {"not": {"term":
{"type.exact": "user-owner-mapping-case"}}}, {"not": {"terms":
{"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9",
"f9850603eb327568ee8dc87db66478b5",
"5717c273af7c27adda53b669b9da0352",
"950179dbe14e9353ed240f9a8c2098ae",
"47f59402ac1cec617d917a1ee8707c34",
"59305b5b19fdf162bb2799b09cc3d332",
"9b21a3bb1f03cacecdce04b0a8260181",
"e577fbeaa3cb34baf435900fe74ae654",
"b4ec5e72fff356127b1bc44d14a96d5d",
"e727ca61e4b017a9125b22a871d5492f",
"d33c2399b494142ee9b108c8ad8ecba2",
"7f15a963286cbda20b8c40ce413d90e5",
"3e0bdc38ac893a95d9c03b3bd25e898e",
"fb561ea0dac5ffb63621b95e7df672c1",
"5fd1c72303c7c83c32aba9a14ffebea9",
"39a569c2bbfd368a16b22d6cc1867a66",
"f5fd6f3e1dc3ba0ca3dfa313e0ca03d4",
"9fd8ba43080c8845db23fe0ea738808b",
"bdf01c51106b632055c17ca379d63918",
"f0f883973419b85b7057fb666fd2d04d",
"5621f14bc40783beb03c5023f880de72",
"ed0ac00f49ae73951bd5dd7def804a36",
"064065e249d569f7fa1b8b1aac2d826f",
"38dd888655ff122e70e684ba3580b7c3",
"7194f6a46f5e164e169611d2ba77a47e",
"78231910dc68963dc2c0de832e905fb4",
"484f7c4f10499ceddd2413d9047349c8",
"7352ed58fe6b1e3d8eba6940f907aa43",
"7a4312804d1c55871f297aeff0e0fd5e",
"c6510680f568b41373a8f9cb761e0592",
"8996c85f7d1ab286756eb295fc5fcdce",
"4fc3abe998c231c77657bdb8a42455ce",
"9c4db10034f6b193dc54996d6bba10e2",
"9b20c7212c6554659a4b2792341fb7d5",
"a8ca705c49c7a9dc9e3a51137a9b960a",
"fb1e9441ed139dff6bed86ef45ac9cf8", "demo_user_group_id",
"demo_user"]}}}, {"not": {"term": {"type.exact": "commcare-user"}}},
{"match_all": {}}]}, "query": {"query_string": {"query":
"opened_on:[TO]"}}}}, "from": 0, "size": 10}]]; [hqcases_2016-03-04]
Failed to parse query [opened_on:[TO]]; Cannot parse
'opened_on:[TO]': Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; ];
}{[8pT3Piv_TmKymV_1bHRlDQ][hqcases_2016-03-04][1]:
SearchParseException[[hqcases_2016-03-04][1]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{"sort": [], "query": {"filtered":
{"filter": {"and": [{"term": {"domain.exact": "broadreach-sa"}},
{"not": {"term": {"type.exact": "user-owner-mapping-case"}}}, {"not":
{"terms": {"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9",
"f9850603eb327568ee8dc87db66478b5",
"5717c273af7c27adda53b669b9da0352",
"950179dbe14e9353ed240f9a8c2098ae",
"47f59402ac1cec617d917a1ee8707c34",
"59305b5b19fdf162bb2799b09cc3d332",
"9b21a3bb1f03cacecdce04b0a8260181",
"e577fbeaa3cb34baf435900fe74ae654",
"b4ec5e72fff356127b1bc44d14a96d5d",
"e727ca61e4b017a9125b22a871d5492f",
"d33c2399b494142ee9b108c8ad8ecba2",
"7f15a963286cbda20b8c40ce413d90e5",
"3e0bdc38ac893a95d9c03b3bd25e898e",
"fb561ea0dac5ffb63621b95e7df672c1",
"5fd1c72303c7c83c32aba9a14ffebea9",
"39a569c2bbfd368a16b22d6cc1867a66",
"f5fd6f3e1dc3ba0ca3dfa313e0ca03d4",
"9fd8ba43080c8845db23fe0ea738808b",
"bdf01c51106b632055c17ca379d63918",
"f0f883973419b85b7057fb666fd2d04d",
"5621f14bc40783beb03c5023f880de72",
"ed0ac00f49ae73951bd5dd7def804a36",
"064065e249d569f7fa1b8b1aac2d826f",
"38dd888655ff122e70e684ba3580b7c3",
"7194f6a46f5e164e169611d2ba77a47e",
"78231910dc68963dc2c0de832e905fb4",
"484f7c4f10499ceddd2413d9047349c8",
"7352ed58fe6b1e3d8eba6940f907aa43",
"7a4312804d1c55871f297aeff0e0fd5e",
"c6510680f568b41373a8f9cb761e0592",
"8996c85f7d1ab286756eb295fc5fcdce",
"4fc3abe998c231c77657bdb8a42455ce",
"9c4db10034f6b193dc54996d6bba10e2",
"9b20c7212c6554659a4b2792341fb7d5",
"a8ca705c49c7a9dc9e3a51137a9b960a",
"fb1e9441ed139dff6bed86ef45ac9cf8", "demo_user_group_id",
"demo_user"]}}}, {"not": {"term": {"type.exact": "commcare-user"}}},
{"match_all": {}}]}, "query": {"query_string": {"query":
"opened_on:[TO]"}}}}, "from": 0, "size": 10}]]]; nested:
QueryParsingException[[hqcases_2016-03-04] Failed to parse query
[opened_on:[TO]]]; nested: ParseException[Cannot parse
'opened_on:[TO]': Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ]; nested: ParseException[Encountered " "]" "]
"" at line 1, column 15.\nWas expecting one of:\n "TO" ...\n
<RANGE_QUOTED> ...\n <RANGE_GOOP> ...\n ];
}{[MKCYb-dqR1WScePL_8N1Iw][hqcases_2016-03-04][2]:
RemoteTransportException[[hqes2][inet[/10.177.128.130:9300]][indices:data/read/search[phase/query]]];
nested: NotSerializableTransportException[[org.elasticsearch.search.SearchParseException]
[hqcases_2016-03-04][2]: from[-1],size[-1]: Parse Failure [Failed to
parse source [{"sort": [], "query": {"filtered": {"filter": {"and":
[{"term": {"domain.exact": "broadreach-sa"}}, {"not": {"term":
{"type.exact": "user-owner-mapping-case"}}}, {"not": {"terms":
{"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9",
"f9850603eb327568ee8dc87db66478b5",
"5717c273af7c27adda53b669b9da0352",
"950179dbe14e9353ed240f9a8c2098ae",
"47f59402ac1cec617d917a1ee8707c34",
"59305b5b19fdf162bb2799b09cc3d332",
"9b21a3bb1f03cacecdce04b0a8260181",
"e577fbeaa3cb34baf435900fe74ae654",
"b4ec5e72fff356127b1bc44d14a96d5d",
"e727ca61e4b017a9125b22a871d5492f",
"d33c2399b494142ee9b108c8ad8ecba2",
"7f15a963286cbda20b8c40ce413d90e5",
"3e0bdc38ac893a95d9c03b3bd25e898e",
"fb561ea0dac5ffb63621b95e7df672c1",
"5fd1c72303c7c83c32aba9a14ffebea9",
"39a569c2bbfd368a16b22d6cc1867a66",
"f5fd6f3e1dc3ba0ca3dfa313e0ca03d4",
"9fd8ba43080c8845db23fe0ea738808b",
"bdf01c51106b632055c17ca379d63918",
"f0f883973419b85b7057fb666fd2d04d",
"5621f14bc40783beb03c5023f880de72",
"ed0ac00f49ae73951bd5dd7def804a36",
"064065e249d569f7fa1b8b1aac2d826f",
"38dd888655ff122e70e684ba3580b7c3",
"7194f6a46f5e164e169611d2ba77a47e",
"78231910dc68963dc2c0de832e905fb4",
"484f7c4f10499ceddd2413d9047349c8",
"7352ed58fe6b1e3d8eba6940f907aa43",
"7a4312804d1c55871f297aeff0e0fd5e",
"c6510680f568b41373a8f9cb761e0592",
"8996c85f7d1ab286756eb295fc5fcdce",
"4fc3abe998c231c77657bdb8a42455ce",
"9c4db10034f6b193dc54996d6bba10e2",
"9b20c7212c6554659a4b2792341fb7d5",
"a8ca705c49c7a9dc9e3a51137a9b960a",
"fb1e9441ed139dff6bed86ef45ac9cf8", "demo_user_group_id",
"demo_user"]}}}, {"not": {"term": {"type.exact": "commcare-user"}}},
{"match_all": {}}]}, "query": {"query_string": {"query":
"opened_on:[TO]"}}}}, "from": 0, "size": 10}]]; [hqcases_2016-03-04]
Failed to parse query [opened_on:[TO]]; Cannot parse
'opened_on:[TO]': Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; ];
}{[8pT3Piv_TmKymV_1bHRlDQ][hqcases_2016-03-04][3]:
SearchParseException[[hqcases_2016-03-04][3]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{"sort": [], "query": {"filtered":
{"filter": {"and": [{"term": {"domain.exact": "broadreach-sa"}},
{"not": {"term": {"type.exact": "user-owner-mapping-case"}}}, {"not":
{"terms": {"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9",
"f9850603eb327568ee8dc87db66478b5",
"5717c273af7c27adda53b669b9da0352",
"950179dbe14e9353ed240f9a8c2098ae",
"47f59402ac1cec617d917a1ee8707c34",
"59305b5b19fdf162bb2799b09cc3d332",
"9b21a3bb1f03cacecdce04b0a8260181",
"e577fbeaa3cb34baf435900fe74ae654",
"b4ec5e72fff356127b1bc44d14a96d5d",
"e727ca61e4b017a9125b22a871d5492f",
"d33c2399b494142ee9b108c8ad8ecba2",
"7f15a963286cbda20b8c40ce413d90e5",
"3e0bdc38ac893a95d9c03b3bd25e898e",
"fb561ea0dac5ffb63621b95e7df672c1",
"5fd1c72303c7c83c32aba9a14ffebea9",
"39a569c2bbfd368a16b22d6cc1867a66",
"f5fd6f3e1dc3ba0ca3dfa313e0ca03d4",
"9fd8ba43080c8845db23fe0ea738808b",
"bdf01c51106b632055c17ca379d63918",
"f0f883973419b85b7057fb666fd2d04d",
"5621f14bc40783beb03c5023f880de72",
"ed0ac00f49ae73951bd5dd7def804a36",
"064065e249d569f7fa1b8b1aac2d826f",
"38dd888655ff122e70e684ba3580b7c3",
"7194f6a46f5e164e169611d2ba77a47e",
"78231910dc68963dc2c0de832e905fb4",
"484f7c4f10499ceddd2413d9047349c8",
"7352ed58fe6b1e3d8eba6940f907aa43",
"7a4312804d1c55871f297aeff0e0fd5e",
"c6510680f568b41373a8f9cb761e0592",
"8996c85f7d1ab286756eb295fc5fcdce",
"4fc3abe998c231c77657bdb8a42455ce",
"9c4db10034f6b193dc54996d6bba10e2",
"9b20c7212c6554659a4b2792341fb7d5",
"a8ca705c49c7a9dc9e3a51137a9b960a",
"fb1e9441ed139dff6bed86ef45ac9cf8", "demo_user_group_id",
"demo_user"]}}}, {"not": {"term": {"type.exact": "commcare-user"}}},
{"match_all": {}}]}, "query": {"query_string": {"query":
"opened_on:[TO]"}}}}, "from": 0, "size": 10}]]]; nested:
QueryParsingException[[hqcases_2016-03-04] Failed to parse query
[opened_on:[TO]]]; nested: ParseException[Cannot parse
'opened_on:[TO]': Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ]; nested: ParseException[Encountered " "]" "]
"" at line 1, column 15.\nWas expecting one of:\n "TO" ...\n
<RANGE_QUOTED> ...\n <RANGE_GOOP> ...\n ];
}{[MKCYb-dqR1WScePL_8N1Iw][hqcases_2016-03-04][4]:
RemoteTransportException[[hqes2][inet[/10.177.128.130:9300]][indices:data/read/search[phase/query]]];
nested: NotSerializableTransportException[[org.elasticsearch.search.SearchParseException]
[hqcases_2016-03-04][4]: from[-1],size[-1]: Parse Failure [Failed to
parse source [{"sort": [], "query": {"filtered": {"filter": {"and":
[{"term": {"domain.exact": "broadreach-sa"}}, {"not": {"term":
{"type.exact": "user-owner-mapping-case"}}}, {"not": {"terms":
{"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9",
"f9850603eb327568ee8dc87db66478b5",
"5717c273af7c27adda53b669b9da0352",
"950179dbe14e9353ed240f9a8c2098ae",
"47f59402ac1cec617d917a1ee8707c34",
"59305b5b19fdf162bb2799b09cc3d332",
"9b21a3bb1f03cacecdce04b0a8260181",
"e577fbeaa3cb34baf435900fe74ae654",
"b4ec5e72fff356127b1bc44d14a96d5d",
"e727ca61e4b017a9125b22a871d5492f",
"d33c2399b494142ee9b108c8ad8ecba2",
"7f15a963286cbda20b8c40ce413d90e5",
"3e0bdc38ac893a95d9c03b3bd25e898e",
"fb561ea0dac5ffb63621b95e7df672c1",
"5fd1c72303c7c83c32aba9a14ffebea9",
"39a569c2bbfd368a16b22d6cc1867a66",
"f5fd6f3e1dc3ba0ca3dfa313e0ca03d4",
"9fd8ba43080c8845db23fe0ea738808b",
"bdf01c51106b632055c17ca379d63918",
"f0f883973419b85b7057fb666fd2d04d",
"5621f14bc40783beb03c5023f880de72",
"ed0ac00f49ae73951bd5dd7def804a36",
"064065e249d569f7fa1b8b1aac2d826f",
"38dd888655ff122e70e684ba3580b7c3",
"7194f6a46f5e164e169611d2ba77a47e",
"78231910dc68963dc2c0de832e905fb4",
"484f7c4f10499ceddd2413d9047349c8",
"7352ed58fe6b1e3d8eba6940f907aa43",
"7a4312804d1c55871f297aeff0e0fd5e",
"c6510680f568b41373a8f9cb761e0592",
"8996c85f7d1ab286756eb295fc5fcdce",
"4fc3abe998c231c77657bdb8a42455ce",
"9c4db10034f6b193dc54996d6bba10e2",
"9b20c7212c6554659a4b2792341fb7d5",
"a8ca705c49c7a9dc9e3a51137a9b960a",
"fb1e9441ed139dff6bed86ef45ac9cf8", "demo_user_group_id",
"demo_user"]}}}, {"not": {"term": {"type.exact": "commcare-user"}}},
{"match_all": {}}]}, "query": {"query_string": {"query":
"opened_on:[TO]"}}}}, "from": 0, "size": 10}]]; [hqcases_2016-03-04]
Failed to parse query [opened_on:[TO]]; Cannot parse
'opened_on:[TO]': Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; Encountered " "]" "] "" at line 1, column
15.\nWas expecting one of:\n "TO" ...\n <RANGE_QUOTED> ...\n
<RANGE_GOOP> ...\n ; ]; }]')

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/elasticsearch/connection/base.py",
line 105, in _raise_error
raise HTTP_EXCEPTIONS.get(status_code,
TransportError)(status_code, error_message, additional_info)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/elasticsearch/connection/http_urllib3.py",
line 93, in perform_request
self._raise_error(response.status, raw_data)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/elasticsearch/transport.py",
line 307, in perform_request
status, headers, data = connection.perform_request(method, url,
params, body, ignore=ignore, timeout=timeout)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/elasticsearch/client/init.py",
line 531, in search
doc_type, '_search'), params=params, body=body)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/elasticsearch/client/utils.py",
line 69, in _wrapped
return func(*args, params=params, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/newrelic-2.54.0.41/newrelic/hooks/datastore_elasticsearch.py",
line 70, in nr_wrapper_Elasticsearch_method
return wrapped(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/elastic.py",
line 132, in run_query
return get_es_new().search(es_meta.index, es_meta.type, body=q)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/es/es_query.py",
line 186, in run
raw = run_query(self.index, self.raw_query)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/data_interfaces/interfaces.py",
line 51, in es_results
return query.run().raw

File "/home/cchq/www/production/releases/2016-04-11_18.03/submodules/dimagi-utils-src/dimagi/utils/decorators/memoized.py",
line 128, in call
value = self.func( *args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/submodules/dimagi-utils-src/dimagi/utils/decorators/memoized.py",
line 11, in _inner
return m(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/data_interfaces/interfaces.py",
line 75, in rows
for row in self.es_results['hits'].get('hits', []):

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/reports/generic.py",
line 874, in json_dict
rows = list(self.rows)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/reports/generic.py",
line 634, in json_response
return json_response(self.json_dict)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/reports/cache.py",
line 20, in call
return self.fn(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/util/quickcache.py",
line 308, in inner
return helper(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/reports/dispatcher.py",
line 145, in dispatch
return getattr(report, '%s_response' % render_as)

File "/home/cchq/www/production/releases/2016-04-11_18.03/submodules/dimagi-utils-src/dimagi/utils/decorators/datespan.py",
line 46, in wrapped_func
return f(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/data_interfaces/dispatcher.py",
line 56, in dispatch
return super(EditDataInterfaceDispatcher, self).dispatch(request,
*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/submodules/dimagi-utils-src/dimagi/utils/decorators/datespan.py",
line 46, in wrapped_func
return f(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/django/utils/decorators.py",
line 25, in bound_func
return func.get(self, type(self))(*args2, **kwargs2)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/users/decorators.py",
line 21, in _inner
return view_func(request, domain, *args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/corehq/apps/domain/decorators.py",
line 93, in _inner
return view_func(req, domain_name, *args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/django/utils/decorators.py",
line 29, in _wrapper
return bound_func(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/django/views/generic/base.py",
line 69, in view
return self.dispatch(request, *args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/newrelic-2.54.0.41/newrelic/hooks/framework_django.py",
line 499, in wrapper
return wrapped(*args, **kwargs)

File "/home/cchq/www/production/releases/2016-04-11_18.03/python_env/local/lib/python2.7/site-packages/django/core/handlers/base.py",
line 111, in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)

Code Context

123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140

class ESError(Exception):
pass

def run_query(index_name, q):
es_meta = ES_META[index_name]
try:
return get_es_new().search(es_meta.index, es_meta.type, body=q)
except RequestError as e: raise ESError(e)
def scroll_query(index_name, q):
es_meta = ES_META[index_name]
try:
return scan(
get_es_new(),
index=es_meta.index,

Parameters GET

bSortable_4

true

bSortable_0

false

bSortable_1

true

bSortable_2

true

bSortable_3

false

sSortDir_0

asc

individual

is_open

mDataProp_2

2

group

emw

project_data

filterSet

true

iSortCol_0

0

ufilter

0

sEcho

2

iColumns

5

iDisplayLength

10

mDataProp_4

4

search_query

opened_on:[TO]

mDataProp_0

0

mDataProp_1

1

iDisplayStart

0

mDataProp_3

3

case_type

sColumns

,name.exact,type.exact,owner_display,modified_on

iSortingCols

1

POST Nothing found. Request

<WSGIRequest
path:/a/broadreach-sa/data/edit/json/reassign_cases/,
GET:<QueryDict: {u'bSortable_4': [u'true'], u'bSortable_0':
[u'false'], u'bSortable_1': [u'true'], u'bSortable_2': [u'true'],
u'bSortable_3': [u'false'], u'sSortDir_0': [u'asc'], u'individual':
[u''], u'is_open': [u'', u''], u'mDataProp_2': [u'2'], u'group':
[u''], u'emw': [u'project_data'], u'filterSet': [u'true'],
u'iSortCol_0': [u'0'], u'ufilter': [u'0'], u'sEcho': [u'2'],
u'iColumns': [u'5'], u'iDisplayLength': [u'10'], u'mDataProp_4':
[u'4'], u'search_query': [u'opened_on:[*TO*]'], u'mDataProp_0':
[u'0'], u'mDataProp_1': [u'1'], u'iDisplayStart': [u'0'],
u'mDataProp_3': [u'3'], u'case_type': [u'', u''], u'sColumns':
[u',name.exact,type.exact,owner_display,modified_on'],
u'iSortingCols': [u'1']}>,
POST:<QueryDict: {}>,
COOKIES:{'__hssc': '187943799.7.1460451079411',
'__hssrc': '1',
'__hstc': '187943799.ba34a4bf412c3dbd3eb62b8576ab7c90.1445933660849.1460361771613.1460451079411.205',
'_ga': 'GA1.2.1348837239.1445933648',
'_gat': '1',
'ajs_anonymous_id': '%222d65f3ff-f342-4085-95ad-587c8e2fe92a%22',
'ajs_group_id': 'null',
'ajs_user_id': '%22927%22',
'csrftoken': '1K1418YsndTqlbzX72W0C4PxlGaYFP10',
'hsfirstvisit': 'https%3A%2F%2Fwww.commcarehq.org%2Fhome%2F||1445933660837',
'hubspotutk': 'ba34a4bf412c3dbd3eb62b8576ab7c90',
'km_ai': 'tzingoni%40brhc.com',
'km_lv': 'x',
'km_ni': 'tzingoni%40brhc.com',
'km_uq': '',
'km_vs': '1',
'kvcd': '1460451153749',
'lang': 'en',
'sessionid': 'fp394d14a5tbixwwyezrvaobw2cuitwx'},
META:{u'CSRF_COOKIE': u'1K1418YsndTqlbzX72W0C4PxlGaYFP10',
'HTTP_ACCEPT': '/',
'HTTP_ACCEPT_ENCODING': 'gzip, deflate, sdch',
'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',
'HTTP_CONNECTION': 'close',
'HTTP_COOKIE':
'hsfirstvisit=https%3A%2F%2Fwww.commcarehq.org%2Fhome%2F||1445933660837;
km_lv=x; ajs_anonymous_id=%222d65f3ff-f342-4085-95ad-587c8e2fe92a%22;
ajs_user_id=%22927%22; ajs_group_id=null; lang=en; _gat=1;
_ga=GA1.2.1348837239.1445933648;
__hstc=187943799.ba34a4bf412c3dbd3eb62b8576ab7c90.1445933660849.1460361771613.1460451079411.205;
__hssrc=1; __hssc=187943799.7.1460451079411;
hubspotutk=ba34a4bf412c3dbd3eb62b8576ab7c90; kvcd=1460451153749;
km_ai=tzingoni%40brhc.com; km_ni=tzingoni%40brhc.com; km_vs=1; km_uq=;
csrftoken=1K1418YsndTqlbzX72W0C4PxlGaYFP10;
sessionid=fp394d14a5tbixwwyezrvaobw2cuitwx',
'HTTP_HOST': 'www.commcarehq.org',
'HTTP_REFERER':
'Log In :: CommCare HQ - CommCare HQ',
'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110
Safari/537.36',
'HTTP_X_FORWARDED_FOR': '41.164.52.178',
'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
'PATH_INFO': u'/a/broadreach-sa/data/edit/json/reassign_cases/',
'QUERY_STRING':
'sEcho=2&iColumns=5&sColumns=%2Cname.exact%2Ctype.exact%2Cowner_display%2Cmodified_on&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&bSortable_0=false&mDataProp_1=1&bSortable_1=true&mDataProp_2=2&bSortable_2=true&mDataProp_3=3&bSortable_3=false&mDataProp_4=4&bSortable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&individual=&group=&case_type=&ufilter=0&search_query=opened_on%3A%5BTO%5D&emw=project_data&is_open=&case_type=&filterSet=true&is_open=',
'RAW_URI': '/a/broadreach-sa/data/edit/json/reassign_cases/?sEcho=2&iColumns=5&sColumns=%2Cname.exact%2Ctype.exact%2Cowner_display%2Cmodified_on&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&bSortable_0=false&mDataProp_1=1&bSortable_1=true&mDataProp_2=2&bSortable_2=true&mDataProp_3=3&bSortable_3=false&mDataProp_4=4&bSortable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&individual=&group=&case_type=&ufilter=0&search_query=opened_on%3A%5BTO%5D&emw=project_data&is_open=&case_type=&filterSet=true&is_open=',
'REMOTE_ADDR': '10.210.103.152',
'REMOTE_PORT': '47637',
'REQUEST_METHOD': 'GET',
'SCRIPT_NAME': u'',
'SERVER_NAME': '0.0.0.0',
'SERVER_PORT': '9010',
'SERVER_PROTOCOL': 'HTTP/1.0',
'SERVER_SOFTWARE': 'gunicorn/19.4.0',
'gunicorn.socket': <socket at 0x11928fd0 fileno=29
sock=10.210.130.68:9010 peer=10.210.103.152:47637>,
'wsgi.errors': <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0xfb91690>,
'wsgi.file_wrapper': <class 'gunicorn.http.wsgi.FileWrapper'>,
'wsgi.input': <newrelic.api.web_transaction._WSGIInputWrapper object
at 0x12ed8990>,
'wsgi.multiprocess': True,
'wsgi.multithread': True,
'wsgi.run_once': False,
'wsgi.url_scheme': 'http',
'wsgi.version': (1, 0)}>

ยทยทยท ---------- Forwarded message ---------- From: Date: 12 April 2016 at 10:54 Subject: [production] ERROR: TransportError: TransportError(500, u'SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[MKCYb-dqR1WScePL_8N1Iw][hqcases_2016-03-04][0]: RemoteTransportException[[hqes2][inet[/10.177.128.130:9300]][indices:data/read/search[phase/query]]]; nested: NotSerializableTransportException[[org.elasticsearch.search.SearchParseException] [hqcases_2016-03-04][0]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"sort": [], "query": {"filtered": {"filter": {"and": [{"term": {"domain.exact": "broadreach-sa"}}, {"not": {"term": {"type.exact": "user-owner-mapping-case"}}}, {"not": {"terms": {"owner_id": ["787d3d4f15d091afc6cf1170e84b84c9", "f9850603eb327568ee8dc87db66478b5", "5717c273af7c27adda53b669b9da0352", "950179dbe14e9353ed240f9a8c2098ae", "47f59402ac1cec617d917a1ee8707c34", "59305b5b19fdf162bb2799b09cc3d332", "9b21a3bb1f03cacecdce04b0a8260181", "e577fbeaa3cb34baf435900fe74ae654", "b4ec5e72fff356127b1bc44d14a96d5d", " To: commcarehq-ops+admins@dimagi.com

--
Simon Kelly
Senior Engineer | Dimagi South Africa