Untitled
unknown
plain_text
2 years ago
76 kB
6
Indexable
{
"_index": "monitoring_search_20240204_1200",
"_type": "monitoringLog",
"_id": "lDRRdI0BmGbsD3Q2F3wm",
"_version": 1,
"_score": 1,
"_source": {
"date": "2024-02-04 19:01:27.779 +0530",
"ctxUId": 759695,
"moduleType": "ss_es_sla",
"level": "ERROR",
"aggregationFields": "[fU.pK, snSt.nF, snSt.reC, snSt.erEng]",
"cacheKeys": "[0568ae, 6dba3c, 9afe17, 4ec6b5]",
"uuid": "73586ff6-bee6-47d8-9c2f-73e8abd93f47",
"ctxPId": 1108,
"calleeClass": "com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder",
"threadName": "APP_Thread_1108_5597_759695__1707053487779_P_Th_SPR-monitoring-logger-pool-7-thread-3909",
"sprAppInfo": {
"sprAppType": "API",
"appVersion": "unknown",
"buildTimestamp": "unknown",
"buildNumber": "unknown",
"buildJobName": "unknown",
"subModuleType": "unknown",
"buildSvnRevision": "unknown",
"extraAppInfo": {},
"metaInfo": {},
"processID": "1",
"appStartTime": 1706957767554,
"webRequest": true,
"ui": false
},
"querySkeletonHash": "A1ABEA",
"calleeMethod": "doSafeLog",
"requestContext": {
"path": "/api/v3.1/reports/query",
"requestSourceDetail": {
"requestSource": "MICRO_SERVICES"
},
"distributedTraceId": "65bf91322672be79132198bf",
"module": "API",
"additional": {
"SPR_HTTP_REQUEST_ID": "65bf91372672be79132199e9",
"REPORTING_REQUEST_SOURCE": "REPORTING_UI",
"threadPoolType": "THROTTLE",
"RPT_ENGINE_NAME": "LISTENING",
"display-app": "true",
"httpMethod": "POST",
"RPT_REPORT_NAME": "SPRINKSIGHTS"
},
"apiAuthDetails": {
"authType": "JWT_TOKEN",
"apiKeyOrOAuthClientId": "Bearer eyJhbGciOiJSUzI1NiJ9.eyJzdWIiOiJBY2Nlc3MgVG9rZW4gR2VuZXJhdGVkIEJ5IFNwcmlua2xyIiwiY2xpZW50SWQiOjU1OTcsIm90YUlkIjoiNjViOTk2YWZjYjJkOGUzMjU2ZTNhYjE0IiwiaXNzIjoiU1BSSU5LTFIiLCJ0eXAiOiJKV1QiLCJ1c2VySWQiOjc1OTY5NSwiYXVkIjoiU1BSSU5LTFIiLCJuYmYiOjE3MDcwNDkxMjYsInNjb3BlIjpbIlJFQUQiLCJXUklURSJdLCJwYXJ0bmVySWQiOjExMDgsImV4cCI6MTcwNzA2NDcyNiwiYXV0aFR5cGUiOiJTUFJfS0VZX1BBU1NfTE9HSU4iLCJ0b2tlblR5cGUiOiJBQ0NFU1MiLCJpYXQiOjE3MDcwNTAzMjYsImp0aSI6InNwcmlua2xyIiwibWljcm9TZXJ2aWNlIjoiZGlzcGxheSJ9.gqVRBe1T6SrtssGkRvgkHR-XX4USGQW8yKzWb_gDSAEnfZ1JatmAHajH0Fg3Ti15DeryrHVRxUv-HO16ksIZHcUDjk9fntzYBEfKXdb4Q5A2kKYXlkCXib3SkVZE7sn4Sr0Tw7VAYtemWY5xweDk9AaBw4r1W6HBJ6Vy4S1OS-1UXgGZnxvvUcgb2RWk_3HRN4aWEze3Se9BhVgSulENFbSGHaVscceL2Moa0KxwrQMzwy2vrp5LK4XC7SlBNzvzGpbYWP1EPIvcxzYGnxcgviIIvDZ3yaEfawzrq5tnk_EqQ1LG6349dBi1I-a_6yFR-8l0FSrF-CQ98GNk8lE6iQ"
},
"source": "/api/v3.1/reports/query",
"traceEnabled": false,
"debugLogEnabled": false,
"skipAutoTranslate": false
},
"userIpAddress": "54.173.96.48",
"hostNameIp": "api-tier1-deployment-84fc7dc679-xxt2c/10.0.196.86",
"deploymentName": "api-tier1-deployment",
"attributes": {
"panelId": [
"cGFuZWw6NjUyOTMwYmVkZjQyYzcyN2I2Zjc3Mjhi"
],
"__exception_class": "com.spr.exceptions.unchecked.SprinklrRuntimeException",
"indicesCount": 196,
"relativeDaysQueried": [
34,
35,
36,
37,
38,
39,
40,
41,
42,
43,
44,
45,
46,
47,
48,
49,
50,
51,
52,
53,
54,
55,
56,
57,
58,
59,
60,
61,
62,
63,
64,
65,
66,
67,
68,
69,
70,
71,
72,
73,
74,
75,
76,
77,
78,
79,
80,
81,
82,
83,
84,
85,
86,
87,
88,
89,
90,
91,
92,
93,
94,
95,
96,
97,
98,
99,
100,
101,
102,
103,
104,
105,
106,
107,
108,
109,
110,
111,
112,
113,
114,
115,
116,
117,
118,
119,
120,
121,
122,
123,
124,
125,
126,
127,
128,
129,
130,
131,
132,
133,
134,
135,
136,
137,
138,
139,
140,
141,
142,
143,
144,
145,
146,
147,
148,
149,
150,
151,
152,
153,
154,
155,
156,
157,
158,
159,
160,
161,
162,
163,
164,
165,
166,
167,
168,
169,
170,
171,
172,
173,
174,
175,
176,
177,
178,
179,
180,
181,
182,
183,
184,
185,
186,
187,
188,
189,
190,
191,
192,
193,
194,
195,
196,
197,
198,
199,
200,
201,
202,
203,
204,
205,
206,
207,
208,
209,
210,
211,
212,
213,
214,
215,
216,
217,
218,
219,
220,
221,
222,
223,
224,
225,
226,
227,
228,
229,
230,
231,
232,
233,
234,
235,
236,
237,
238,
239,
240,
241,
242,
243,
244,
245,
246,
247,
248,
249,
250,
251,
252,
253,
254,
255,
256,
257,
258,
259,
260,
261,
262,
263,
264,
265,
266,
267,
268,
269,
270,
271,
272,
273,
274,
275,
276,
277,
278,
279,
280,
281,
282,
283,
284,
285,
286,
287,
288,
289,
290,
291,
292,
293,
294,
295,
296,
297,
298,
299,
300,
301,
302,
303,
304,
305,
306,
307,
308,
309,
310,
311,
312,
313,
314,
315,
316,
317,
318,
319,
320,
321,
322,
323,
324,
325,
326,
327,
328,
329,
330,
331,
332,
333,
334,
335,
336,
337,
338,
339,
340,
341,
342,
343,
344,
345,
346,
347,
348,
349,
350,
351,
352,
353,
354,
355,
356,
357,
358,
359,
360,
361,
362,
363,
364,
365,
366,
367,
368,
369,
370,
371,
372,
373,
374,
375,
376,
377,
378,
379,
380,
381,
382,
383,
384,
385,
386,
387,
388,
389,
390,
391,
392,
393,
394,
395,
396,
397
],
"__exception_atPackage": "com.spr.utils.elasticsearch",
"storyboardId": [
"c3Rvcnlib2FyZDo2NTI5MzBhYTRlY2Y1MDZjNjdkNzFiNTM="
],
"__exception_rootCause_class": "java.io.IOException",
"numberOfDays": 364,
"__exception_atClassMethodRC": "org.elasticsearch.client.rest.support.InternalRestClient$1.retryIfPossible(InternalRestClient.java:338)",
"_doc_type": "search",
"callee_m": "call",
"clusterName": "listening33-es7-demo",
"context": {
"queryCost": [
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:5d277b3de4b0246d4c093af6:581",
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:6100094381f6d0002cc4c521:6",
"TOPIC:6100094381f6d0002cc4c521:6",
"TOPIC:61796aeb59c2e0442ea6ee5f:4"
],
"timeRange": "Range{from=1672511400000, upto=1704047399999, includeLower=true, includeUpper=true}"
},
"__exception_exceptionChain": "com.spr.exceptions.unchecked.SprinklrRuntimeException: Failed execution timeValue: 3m, org.elasticsearch.common.util.concurrent.UncategorizedExecutionException: Failed execution, java.util.concurrent.ExecutionException: java.io.IOException: request retries exceeded max retry timeout [120000], java.io.IOException: request retries exceeded max retry timeout [120000]",
"__exception_msg": "Failed execution timeValue: 3m",
"callee_c": "com.spr.ops.ContextTransferableCallable",
"timeRange": "1672511400000-1704047399999/0",
"esServerType": "SPRINKSIGHTS",
"querySize": 4452,
"__exception_stackTrace": "com.spr.exceptions.unchecked.SprinklrRuntimeException: Failed execution timeValue: 3m\n\tat com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:535)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.doExecuteActionGet(AbstractESRequestBuilder.java:174)\n\tat com.spr.search.repository.elasticsearch.es.ESSearchRequestBuilder.doExecuteActionGet(ESSearchRequestBuilder.java:248)\n\tat com.spr.search.repository.elasticsearch.es.ESSearchRequestBuilder.doExecuteActionGet(ESSearchRequestBuilder.java:62)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.lambda$executeActionGet$0(AbstractESRequestBuilder.java:102)\n\tat com.spr.utils.core.RequestContextProvider.safeTrackCall(RequestContextProvider.java:323)\n\tat com.spr.utils.core.interceptor.TrackingInterceptor.run(TrackingInterceptor.java:15)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.StuckThreadInterceptor.run(StuckThreadInterceptor.java:77)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.BulkheadInterceptor.run(BulkheadInterceptor.java:31)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.RateLimiterInterceptor.run(RateLimiterInterceptor.java:31)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.CircuitBreakerInterceptor.run(CircuitBreakerInterceptor.java:29)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:53)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:45)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.executeActionGet(AbstractESRequestBuilder.java:100)\n\tat com.spr.search.repository.elasticsearch.timeshard.ESTimeShardedSearchRepoImpl.searchWithFacets(ESTimeShardedSearchRepoImpl.java:772)\n\tat com.spr.shifu.repository.TimeShardedESSearchAdapter.search(TimeShardedESSearchAdapter.java:181)\n\tat com.spr.shifu.AbstractReportingEngine.handleESAggregationRequest(AbstractReportingEngine.java:1506)\n\tat com.spr.shifu.AbstractReportingEngine.handleESAggregationRequest(AbstractReportingEngine.java:2088)\n\tat com.spr.shifu.listening.ListeningReportingEngine.handleESAggregationRequest(ListeningReportingEngine.java:775)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateNonExecutableReport(AbstractReportingEngine.java:556)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateInternal(AbstractReportingEngine.java:501)\n\tat com.spr.shifu.listening.ListeningReportingEngine._aggregateInternal(ListeningReportingEngine.java:736)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregateInternal(ListeningReportingEngine.java:426)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregateInternal(ListeningReportingEngine.java:451)\n\tat com.spr.shifu.listening.ListeningReportingEngine.lambda$getReportingEngineQueryCacheLoader$2(ListeningReportingEngine.java:746)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.loadFromCallable(PersistentCacheMongo.java:522)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.getFromCacheOrLoadAtomic(PersistentCacheMongo.java:483)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.getFromCacheOrLoadAtomic(PersistentCacheMongo.java:457)\n\tat com.spr.shifu.ReportingEngineQueryCacheImpl.getFromCacheOrLoadAtomic(ReportingEngineQueryCacheImpl.java:141)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateOrReturnFromCache(AbstractReportingEngine.java:2004)\n\tat com.spr.shifu.AbstractReportingEngine.aggregate(AbstractReportingEngine.java:471)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregate(ListeningReportingEngine.java:377)\n\tat com.spr.shifu.ReportingServiceImpl.processRequest(ReportingServiceImpl.java:130)\n\tat com.spr.shifu.ReportingServiceImpl.executeRequest(ReportingServiceImpl.java:358)\n\tat com.spr.shifu.ReportingServiceImpl.batchQueryInternal(ReportingServiceImpl.java:253)\n\tat com.spr.shifu.ReportingServiceImpl.batchQuery(ReportingServiceImpl.java:103)\n\tat com.spr.shifu.ReportingServiceProxy.batchQuery(ReportingServiceProxy.java:87)\n\tat com.spr.reporting.rest.ReportingRestAPI.executeBatchQuery(ReportingRestAPI.java:940)\n\tat com.spr.reporting.rest.ReportingRestAPI.lambda$batchQuery$3(ReportingRestAPI.java:743)\n\tat com.spr.utils.AsyncRestExecutionTemplate$1.doCall(AsyncRestExecutionTemplate.java:61)\n\tat com.spr.utils.AsyncRestExecutionTemplate$1.doCall(AsyncRestExecutionTemplate.java:50)\n\tat com.spr.ops.executor.util.UserContextAwareCallable.call(UserContextAwareCallable.java:116)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)\n\tat java.base/java.lang.Thread.run(Thread.java:842)\nCaused by: org.elasticsearch.common.util.concurrent.UncategorizedExecutionException: Failed execution\n\tat org.elasticsearch.action.support.AdapterActionFuture.rethrowExecutionException(AdapterActionFuture.java:92)\n\tat org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:79)\n\tat com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:532)\n\t... 55 more\nCaused by: java.util.concurrent.ExecutionException: java.io.IOException: request retries exceeded max retry timeout [120000]\n\tat org.elasticsearch.common.util.concurrent.BaseFuture$Sync.getValue(BaseFuture.java:288)\n\tat org.elasticsearch.common.util.concurrent.BaseFuture$Sync.get(BaseFuture.java:261)\n\tat org.elasticsearch.common.util.concurrent.BaseFuture.get(BaseFuture.java:92)\n\tat org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:72)\n\t... 56 more\nCaused by: java.io.IOException: request retries exceeded max retry timeout [120000]\n\tat org.elasticsearch.client.rest.support.InternalRestClient$1.retryIfPossible(InternalRestClient.java:338)\n\tat org.elasticsearch.client.rest.support.InternalRestClient$1.failed(InternalRestClient.java:325)\n\tat org.elasticsearch.client.rest.support.InternalRestClientBuilder$2.execute(InternalRestClientBuilder.java:388)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequestAsync(InternalRestClient.java:358)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequestAsync(InternalRestClient.java:251)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequest(InternalRestClient.java:222)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequest(InternalRestClient.java:189)\n\tat org.elasticsearch.client.rest.support.RestExecuteUtil.execute(RestExecuteUtil.java:75)\n\tat org.elasticsearch.client.rest.RestClient.execute(RestClient.java:113)\n\tat org.elasticsearch.client.support.AbstractClient.search(AbstractClient.java:348)\n\tat org.elasticsearch.action.search.SearchRequestBuilder.doExecute(SearchRequestBuilder.java:1208)\n\tat org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:94)\n\tat org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:68)\n\t... 56 more\n",
"entityType": "universalMessage",
"query": "{\"size\":0,\"timeout\":\"120000ms\",\"query\":{\"constant_score\":{\"filter\":{\"bool\":{\"must\":{\"bool\":{\"must\":[{\"range\":{\"snCTm\":{\"from\":1672511400000,\"to\":1704047399999,\"include_lower\":true,\"include_upper\":true}}},{\"bool\":{\"must_not\":{\"bool\":{\"should\":[{\"term\":{\"fU.sN\":\"BYJU's\"}},{\"term\":{\"fU.sN\":\"Budweiser\"}},{\"term\":{\"fU.sN\":\"Budweiserusa\"}},{\"term\":{\"fU.sN\":\"Hisense\"}},{\"term\":{\"fU.sN\":\"McDonald's\"}},{\"term\":{\"fU.sN\":\"Vivo\"}},{\"term\":{\"fU.sN\":\"Adidas\"}},{\"term\":{\"fU.sN\":\"Coca-Cola\"}},{\"term\":{\"fU.sN\":\"Wanda Group\"}},{\"term\":{\"fU.sN\":\"Hyundai\"}},{\"term\":{\"fU.sN\":\"Qatar Airways\"}},{\"term\":{\"fU.sN\":\"Visa\"}},{\"term\":{\"fU.sN\":\"Hummel\"}},{\"term\":{\"fU.sN\":\"Kappa\"}},{\"term\":{\"fU.sN\":\"Majid\"}},{\"term\":{\"fU.sN\":\"Marathon\"}},{\"term\":{\"fU.sN\":\"New Balance\"}},{\"term\":{\"fU.sN\":\"Nike\"}},{\"term\":{\"fU.sN\":\"One All Sports\"}},{\"term\":{\"fU.sN\":\"Puma\"}},{\"term\":{\"fU.sN\":\"Twitter\"}}],\"_cache_key\":\"bb6f84403a545ba7f6b79bbe680568ae\"}}}},{\"bool\":{\"should\":[{\"bool\":{\"should\":[{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"spr_user_handle\"}}}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"en\"}}}}]}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.q_tw\",\"add.t_en\",\"add.m_en\",\"addI.quotedMsg.m\",\"addI.revItemInfo.item\",\"mVadd.m_x_url\"],\"use_dis_max\":false,\"extra_analyzer_per_field\":{\"mVadd.q_tw\":\"en\",\"add.t_en\":\"en\",\"add.m_en\":\"en\",\"addI.quotedMsg.m\":\"en\",\"addI.revItemInfo.item\":\"en\",\"mVadd.m_x_url\":\"en\"}}}}},{\"bool\":{\"should\":[{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"spr_user_handle\"}}}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"en\"}}}}]}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.q_tw\",\"add.t_en\",\"add.m_en\",\"addI.quotedMsg.m\",\"addI.revItemInfo.item\",\"mVadd.m_x_url\"],\"use_dis_max\":false,\"extra_analyzer_per_field\":{\"mVadd.q_tw\":\"en\",\"add.t_en\":\"en\",\"add.m_en\":\"en\",\"addI.quotedMsg.m\":\"en\",\"addI.revItemInfo.item\":\"en\",\"mVadd.m_x_url\":\"en\"}}}}}],\"_cache_key\":\"62ef9db17072a29f4da7951a566dba3c\"}},{\"bool\":{\"must\":{\"terms\":{\"iD\":[false]}}}},{\"bool\":{\"must\":{\"bool\":{\"must_not\":{\"terms\":{\"add.prS\":[\"tve\",\"eClips\",\"movFt\",\"fac\"]}}}}}},{\"bool\":{\"must\":{\"bool\":{\"must_not\":{\"exists\":{\"field\":\"add.auMiss\"}}}}}}]}},\"must_not\":[{\"bool\":{\"should\":[{\"bool\":{\"must\":[{\"bool\":{\"should\":[{\"terms\":{\"add.domain\":[\"heraldsun.com.au\",\"themercury.com.au\",\"adelaidenow.com.au\",\"goldcoastbulletin.com.au\",\"dailytelegraph.com.au\",\"ntnews.com.au\",\"news.com.au\",\"geelongadvertiser.com.au\",\"theaustralian.com.au\",\"skynews.com.au\",\"thechronicle.com.au\",\"cairnspost.com.au\",\"weeklytimesnow.com.au\",\"townsvillebulletin.com.au\",\"couriermail.com.au\"]}},{\"terms\":{\"add.td\":[\"heraldsun.com.au\",\"themercury.com.au\",\"adelaidenow.com.au\",\"goldcoastbulletin.com.au\",\"dailytelegraph.com.au\",\"ntnews.com.au\",\"news.com.au\",\"geelongadvertiser.com.au\",\"theaustralian.com.au\",\"skynews.com.au\",\"thechronicle.com.au\",\"cairnspost.com.au\",\"weeklytimesnow.com.au\",\"townsvillebulletin.com.au\",\"couriermail.com.au\"]}}]}},{\"bool\":{\"must_not\":{\"terms\":{\"add.iUDA\":[\"true\"]}},\"_cache_key\":\"e029ebc70021d9b4c58c7085cf9afe17\"}}]}},{\"bool\":{\"must\":[{\"terms\":{\"add.d_s\":[\"bmk\"]}},{\"terms\":{\"add.m_t\":[\"INSTAGRAM\"]}}]}},{\"terms\":{\"mVadd.licenses\":[\"NCA\"]}}],\"_cache_key\":\"7124d6022c9ed38d982c0b87744ec6b5\"}},{\"term\":{\"add.d_s\":\"tw_sl\"}}]}}}},\"aggregations\":{\"SPRINKSIGHTS\":{\"filter\":{\"match_all\":{}},\"aggregations\":{\"TABULAR\":{\"group-by\":{\"size\":9,\"shard_size\":100000,\"order\":{\"INFLUENCER_SCORE_AVG\":\"desc\"},\"fields\":[{\"name\":\"FROM_SN_USER\",\"field\":\"fU.pK\"},{\"name\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"snSt.nF\"}]},\"aggregations\":{\"MENTIONS_COUNT\":{\"sum\":{\"script\":{\"inline\":\"1\"}}},\"POS_SEN_FILTERED_PROJECTION\":{\"filter\":{\"bool\":{\"must\":{\"terms\":{\"addI.sem.data.sentiment_polarity\":[\"1\",\"2\",\"1.0\",\"2.0\",\"positive\"]}}}},\"aggregations\":{\"POS_SEN\":{\"sum\":{\"script\":{\"inline\":\"1\"}}}}},\"REACH_COUNT\":{\"sum\":{\"field\":\"snSt.reC\"}},\"EARNED_ENGAGEMENT\":{\"sum\":{\"field\":\"snSt.erEng\"}},\"INFLUENCER_SCORE_AVG\":{\"avg\":{\"script\":{\"inline\":\"if(doc['snSt.iFsC'].value == null) {if(doc['enr.kl.sc'].value == null) {if(doc['enr.fc.scr_val'].value == null || doc['enr.fc.scr_pro'].value != 'klout') {0} else {doc['enr.fc.scr_val'].value}} else { doc['enr.kl.sc'].value}} else {doc['snSt.iFsC'].value}\",\"lang\":\"painless\"}}}}}}}}}",
"__exception_atClassRC": "org.elasticsearch.client.rest.support.InternalRestClient$1",
"__exception_atClass": "com.spr.utils.elasticsearch.ElasticSearchUtil",
"pId": "1108",
"ttm": 120086,
"__exception_atPackageRC": "org.elasticsearch.client.rest.support",
"indices": [
"lst_p1108_v_15_20221229_1849",
"lst_p1108_v_15_20230102_1933",
"lst_p1108_v_15_20230108_0347",
"lst_p1108_v_15_20230112_2211",
"lst_p1108_v_15_20230117_2102",
"lst_p1108_v_15_20230122_1932",
"lst_p1108_v_15_20230126_1903",
"lst_p1108_v_15_20230129_0103",
"lst_p1108_v_15_20230130_1924",
"lst_p1108_v_15_20230201_1835",
"lst_p1108_v_15_20230204_1233",
"lst_p1108_v_15_20230207_0532",
"lst_p1108_v_15_20230209_0317",
"lst_p1108_v_15_20230210_1411",
"lst_p1108_v_15_20230212_1217",
"lst_p1108_v_15_20230214_1217",
"lst_p1108_v_15_20230216_1202",
"lst_p1108_v_15_20230218_1233",
"lst_p1108_v_15_20230220_1334",
"lst_p1108_v_15_20230222_0647",
"lst_p1108_v_15_20230225_0859",
"lst_p1108_v_15_20230227_0202",
"lst_p1108_v_15_20230228_1403",
"lst_p1108_v_15_20230302_1132",
"lst_p1108_v_15_20230303_1606",
"lst_p1108_v_15_20230305_1503",
"lst_p1108_v_15_20230306_1719",
"lst_p1108_v_15_20230308_1404",
"lst_p1108_v_15_20230309_1704",
"lst_p1108_v_15_20230311_1348",
"lst_p1108_v_15_20230313_1047",
"lst_p1108_v_15_20230314_1603",
"lst_p1108_v_15_20230316_0233",
"lst_p1108_v_15_20230317_1504",
"lst_p1108_v_15_20230319_1525",
"lst_p1108_v_15_20230321_0048",
"lst_p1108_v_15_20230323_0353",
"lst_p1108_v_15_20230324_1503",
"lst_p1108_v_15_20230325_2103",
"lst_p1108_v_15_20230327_1707",
"lst_p1108_v_15_20230328_2106",
"lst_p1108_v_15_20230330_1003",
"lst_p1108_v_15_20230331_1933",
"lst_p1108_v_15_20230403_2006",
"lst_p1108_v_15_20230410_0722",
"lst_p1108_v_15_20230415_0119",
"lst_p1108_v_15_20230420_1558",
"lst_p1108_v_15_20230425_1910",
"lst_p1108_v_15_20230501_0904",
"lst_p1108_v_15_20230506_0704",
"lst_p1108_v_15_20230510_2249",
"lst_p1108_v_15_20230515_1634",
"lst_p1108_v_15_20230518_2218",
"lst_p1108_v_15_20230521_0220",
"lst_p1108_v_15_20230522_2148",
"lst_p1108_v_15_20230524_1123",
"lst_p1108_v_15_20230525_1625",
"lst_p1108_v_15_20230526_2256",
"lst_p1108_v_15_20230528_1603",
"lst_p1108_v_15_20230530_0557",
"lst_p1108_v_15_20230531_1604",
"lst_p1108_v_15_20230602_0118",
"lst_p1108_v_15_20230603_1650",
"lst_p1108_v_15_20230605_1417",
"lst_p1108_v_15_20230607_0933",
"lst_p1108_v_15_20230608_1905",
"lst_p1108_v_15_20230610_1503",
"lst_p1108_v_15_20230612_1935",
"lst_p1108_v_15_20230614_0033",
"lst_p1108_v_15_20230615_1621",
"lst_p1108_v_15_20230617_0106",
"lst_p1108_v_15_20230618_1703",
"lst_p1108_v_15_20230619_1810",
"lst_p1108_v_15_20230620_2204",
"lst_p1108_v_15_20230621_2204",
"lst_p1108_v_15_20230623_0918",
"lst_p1108_v_15_20230624_2004",
"lst_p1108_v_15_20230626_1304",
"lst_p1108_v_15_20230627_1718",
"lst_p1108_v_15_20230628_1905",
"lst_p1108_v_15_20230630_0018",
"lst_p1108_v_15_20230630_1949",
"lst_p1108_v_15_20230701_1919",
"lst_p1108_v_15_20230703_0618",
"lst_p1108_v_15_20230704_1108",
"lst_p1108_v_15_20230705_1605",
"lst_p1108_v_15_20230706_1904",
"lst_p1108_v_15_20230707_2009",
"lst_p1108_v_15_20230709_0833",
"lst_p1108_v_15_20230710_1705",
"lst_p1108_v_15_20230712_0104",
"lst_p1108_v_15_20230713_1134",
"lst_p1108_v_15_20230714_1605",
"lst_p1108_v_15_20230716_0233",
"lst_p1108_v_15_20230717_1436",
"lst_p1108_v_15_20230718_2204",
"lst_p1108_v_15_20230720_0704",
"lst_p1108_v_15_20230721_1704",
"lst_p1108_v_15_20230723_1148",
"lst_p1108_v_15_20230724_1934",
"lst_p1108_v_15_20230725_2204",
"lst_p1108_v_15_20230727_0204",
"lst_p1108_v_15_20230728_1219",
"lst_p1108_v_15_20230730_0633",
"lst_p1108_v_15_20230731_2334",
"lst_p1108_v_15_20230802_1049",
"lst_p1108_v_15_20230803_1905",
"lst_p1108_v_15_20230805_0034",
"lst_p1108_v_15_20230805_2018",
"lst_p1108_v_15_20230807_0049",
"lst_p1108_v_15_20230807_2105",
"lst_p1108_v_15_20230808_1009",
"lst_p1108_v_15_20230809_0048",
"lst_p1108_v_15_20230809_1920",
"lst_p1108_v_15_20230810_1707",
"lst_p1108_v_15_20230811_1805",
"lst_p1108_v_15_20230812_1820",
"lst_p1108_v_15_20230813_0835",
"lst_p1108_v_15_20230814_0739",
"lst_p1108_v_15_20230815_0623",
"lst_p1108_v_15_20230816_0251",
"lst_p1108_v_15_20230817_0050",
"lst_p1108_v_15_20230817_1857",
"lst_p1108_v_15_20230818_1534",
"lst_p1108_v_15_20230819_1506",
"lst_p1108_v_15_20230820_1805",
"lst_p1108_v_15_20230821_1605",
"lst_p1108_v_15_20230822_1537",
"lst_p1108_v_15_20230823_1351",
"lst_p1108_v_15_20230824_1618",
"lst_p1108_v_15_20230825_1906",
"lst_p1108_v_15_20230827_0133",
"lst_p1108_v_15_20230828_1205",
"lst_p1108_v_15_20230829_1835",
"lst_p1108_v_15_20230830_1904",
"lst_p1108_v_15_20230901_0649",
"lst_p1108_v_15_20230902_1903",
"lst_p1108_v_15_20230904_1143",
"lst_p1108_v_15_20230905_1849",
"lst_p1108_v_15_20230907_0649",
"lst_p1108_v_15_20230908_1533",
"lst_p1108_v_15_20230910_1133",
"lst_p1108_v_15_20230911_1906",
"lst_p1108_v_15_20230913_0733",
"lst_p1108_v_15_20230914_1834",
"lst_p1108_v_15_20230916_1548",
"lst_p1108_v_15_20230918_1219",
"lst_p1108_v_15_20230919_2219",
"lst_p1108_v_15_20230921_0634",
"lst_p1108_v_15_20230922_1536",
"lst_p1108_v_15_20230924_0108",
"lst_p1108_v_15_20230925_1235",
"lst_p1108_v_15_20230926_1822",
"lst_p1108_v_15_20230927_1921",
"lst_p1108_v_15_20230928_1858",
"lst_p1108_v_15_20230929_1948",
"lst_p1108_v_15_20231001_0448",
"lst_p1108_v_15_20231002_1920",
"lst_p1108_v_15_20231004_0133",
"lst_p1108_v_15_20231005_0705",
"lst_p1108_v_15_20231006_0118",
"lst_p1108_v_15_20231007_0703",
"lst_p1108_v_15_20231008_1905",
"lst_p1108_v_15_20231010_0649",
"lst_p1108_v_15_20231011_1805",
"lst_p1108_v_15_20231013_0005",
"lst_p1108_v_15_20231014_0133",
"lst_p1108_v_15_20231015_1305",
"lst_p1108_v_15_20231016_2133",
"lst_p1108_v_15_20231018_0348",
"lst_p1108_v_15_20231019_0635",
"lst_p1108_v_15_20231022_0448",
"lst_p1108_v_15_20231025_0049",
"lst_p1108_v_15_20231027_1448",
"lst_p1108_v_15_20231030_1534",
"lst_p1108_v_15_20231101_1904",
"lst_p1108_v_15_20231103_1905",
"lst_p1108_v_15_20231106_1834",
"lst_p1108_v_15_20231109_1336",
"lst_p1108_v_15_20231113_0704",
"lst_p1108_v_15_20231116_0049",
"lst_p1108_v_15_20231119_1219",
"lst_p1108_v_15_20231122_1305",
"lst_p1108_v_15_20231126_1204",
"lst_p1108_v_15_20231129_1419",
"lst_p1108_v_15_20231202_1819",
"lst_p1108_v_15_20231206_0923",
"lst_p1108_v_15_20231209_1319",
"lst_p1108_v_15_20231212_2224",
"lst_p1108_v_15_20231214_1835",
"lst_p1108_v_15_20231217_1849",
"lst_p1108_v_15_20231219_2136",
"lst_p1108_v_15_20231221_0819",
"lst_p1108_v_15_20231224_1049",
"lst_p1108_v_15_20231227_1848",
"lst_p1108_v_15_20231230_2103"
],
"es-requestId": "65bf91372672be79132199ec",
"size": "20",
"esReqType": "ESSearchRequestBuilderWithTimeRange",
"success": false,
"reportingReqJson": [
"{\"key\":\"SPRINKSIGHTS\",\"timeFilter\":{\"field\":\"snCTm\",\"sinceTime\":1672511400000,\"untilTime\":1704047399999,\"includeLower\":true,\"includeUpper\":true},\"previousTimeFilter\":{\"sinceTime\":1640975400000,\"untilTime\":1672511399999,\"includeLower\":true,\"includeUpper\":true},\"reportingEngine\":\"LISTENING\",\"filters\":[{\"filterType\":\"NIN\",\"field\":\"QUERY\",\"values\":[\" author:(\\\"BYJU’s\\\"OR \\\"Budweiser\\\"OR \\\"Budweiserusa\\\" OR \\\"Hisense\\\"OR \\\"McDonald\\u0027s\\\"OR \\\"Vivo\\\"OR \\\"Adidas\\\"OR \\\"Coca-Cola\\\"OR \\\"Wanda Group\\\"OR \\\"Hyundai\\\"OR \\\"Qatar Airways\\\"OR \\\"Visa\\\"OR \\\"Adidas\\\"OR \\\"Hummel\\\"OR \\\"Kappa\\\"OR \\\"Majid\\\"OR \\\"Marathon\\\"OR \\\"New Balance\\\"OR \\\"Nike\\\"OR \\\"One All Sports\\\"OR \\\"Puma\\\"OR \\\"Qatar Airways\\\" OR Twitter)\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"type\":\"DIMENSION\",\"OLD_DIM_NAME\":\"TOPIC_QUERY\",\"INPUT_TYPE\":\"FREE_TEXT\",\"EXCLUDE_IN_THEME_PREVIEW\":\"true\",\"EXIST_FILTER\":false,\"singleSelect\":\"true\"}},{\"filterType\":\"IN\",\"field\":\"QUERY\",\"values\":[\"a OR an\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"contentType\":\"DB_FILTER\",\"OLD_DIM_NAME\":\"TOPIC_QUERY\",\"INPUT_TYPE\":\"FREE_TEXT\",\"EXCLUDE_IN_THEME_PREVIEW\":\"true\",\"EXIST_FILTER\":false,\"singleSelect\":\"true\"}},{\"filterType\":\"IN\",\"field\":\"IS_DELETED\",\"values\":[false],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{}},{\"filterType\":\"NIN\",\"field\":\"PREMIUM_SUBSCRIPTION\",\"values\":[\"tve\",\"eClips\",\"movFt\",\"fac\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"showAsDashbaordFilter\":\"true\",\"include\":[\"tve\",\"fac\"]}}],\"projectionFilters\":[],\"groupBys\":[{\"groups\":[{\"key\":\"FROM_SN_USER\",\"field\":\"FROM_SN_USER\",\"groupType\":\"FIELD\",\"details\":{},\"projections\":[],\"childrenGroupBys\":[{\"key\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"TOTAL_USER_FOLLOWERS\",\"groupType\":\"FIELD\",\"details\":{},\"sort\":{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"},\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}]},{\"key\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"TOTAL_USER_FOLLOWERS\",\"groupType\":\"FIELD\",\"details\":{},\"sort\":{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"},\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}],\"key\":\"TABULAR\",\"groupType\":\"MULTI_FIELD\",\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}],\"projections\":[],\"report\":\"SPRINKSIGHTS\",\"tzOffset\":0,\"timezone\":\"Asia/Kolkata\",\"sorts\":[{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"}],\"page\":{\"page\":0,\"size\":8,\"skip\":0},\"additional\":{\"originatingApp\":\"spr-display-publisher\",\"panelId\":\"cGFuZWw6NjUyOTMwYmVkZjQyYzcyN2I2Zjc3Mjhi\",\"clientId\":\"5597\",\"IGNORE_DRILL_DOWN\":\"true\",\"ACTUAL_DATE_FIELD\":\"snCTm\",\"storyboardId\":\"c3Rvcnlib2FyZDo2NTI5MzBhYTRlY2Y1MDZjNjdkNzFiNTM\\u003d\",\"partnerId\":\"1108\",\"uiRequestAdaptTime\":\"2\",\"TABULAR\":\"true\",\"PARTNER_ID\":\"1108\"},\"cacheDisabled\":false,\"projectionDecorations\":[],\"includeFields\":[],\"excludeFields\":[],\"reportDateField\":\"snCTm\"}"
],
"numberOfDaysOffset": 34,
"sortOrder": "DESC",
"__exception_atClassMethod": "com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:535)"
},
"fetch_size": 0,
"aggregationsUsed": "[avg, group-by, sum]",
"ctxCId": 5597,
"timestamp": 1707053487779
},
"fields": {
"sprAppInfo.appStartTime": [
1706957767554
],
"date": [
"2024-02-04 19:01:27.779 +0530"
],
"attributes._doc_type": [
"search"
],
"attributes.panelId": [
"cGFuZWw6NjUyOTMwYmVkZjQyYzcyN2I2Zjc3Mjhi"
],
"attributes.pId": [
"1108"
],
"attributes.context.queryCost": [
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:5d277b3de4b0246d4c093af6:581",
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:65bb6f63cb6c2821f051e73f:51",
"TOPIC:6100094381f6d0002cc4c521:6",
"TOPIC:6100094381f6d0002cc4c521:6",
"TOPIC:61796aeb59c2e0442ea6ee5f:4"
],
"aggregationFields": [
"[fU.pK, snSt.nF, snSt.reC, snSt.erEng]"
],
"attributes.callee_c": [
"com.spr.ops.ContextTransferableCallable"
],
"uuid": [
"73586ff6-bee6-47d8-9c2f-73e8abd93f47"
],
"attributes.success": [
false
],
"ctxPId": [
1108
],
"requestContext.source": [
"/api/v3.1/reports/query"
],
"sprAppInfo.webRequest": [
true
],
"attributes.__exception_class": [
"com.spr.exceptions.unchecked.SprinklrRuntimeException"
],
"attributes.indices": [
"lst_p1108_v_15_20221229_1849",
"lst_p1108_v_15_20230102_1933",
"lst_p1108_v_15_20230108_0347",
"lst_p1108_v_15_20230112_2211",
"lst_p1108_v_15_20230117_2102",
"lst_p1108_v_15_20230122_1932",
"lst_p1108_v_15_20230126_1903",
"lst_p1108_v_15_20230129_0103",
"lst_p1108_v_15_20230130_1924",
"lst_p1108_v_15_20230201_1835",
"lst_p1108_v_15_20230204_1233",
"lst_p1108_v_15_20230207_0532",
"lst_p1108_v_15_20230209_0317",
"lst_p1108_v_15_20230210_1411",
"lst_p1108_v_15_20230212_1217",
"lst_p1108_v_15_20230214_1217",
"lst_p1108_v_15_20230216_1202",
"lst_p1108_v_15_20230218_1233",
"lst_p1108_v_15_20230220_1334",
"lst_p1108_v_15_20230222_0647",
"lst_p1108_v_15_20230225_0859",
"lst_p1108_v_15_20230227_0202",
"lst_p1108_v_15_20230228_1403",
"lst_p1108_v_15_20230302_1132",
"lst_p1108_v_15_20230303_1606",
"lst_p1108_v_15_20230305_1503",
"lst_p1108_v_15_20230306_1719",
"lst_p1108_v_15_20230308_1404",
"lst_p1108_v_15_20230309_1704",
"lst_p1108_v_15_20230311_1348",
"lst_p1108_v_15_20230313_1047",
"lst_p1108_v_15_20230314_1603",
"lst_p1108_v_15_20230316_0233",
"lst_p1108_v_15_20230317_1504",
"lst_p1108_v_15_20230319_1525",
"lst_p1108_v_15_20230321_0048",
"lst_p1108_v_15_20230323_0353",
"lst_p1108_v_15_20230324_1503",
"lst_p1108_v_15_20230325_2103",
"lst_p1108_v_15_20230327_1707",
"lst_p1108_v_15_20230328_2106",
"lst_p1108_v_15_20230330_1003",
"lst_p1108_v_15_20230331_1933",
"lst_p1108_v_15_20230403_2006",
"lst_p1108_v_15_20230410_0722",
"lst_p1108_v_15_20230415_0119",
"lst_p1108_v_15_20230420_1558",
"lst_p1108_v_15_20230425_1910",
"lst_p1108_v_15_20230501_0904",
"lst_p1108_v_15_20230506_0704",
"lst_p1108_v_15_20230510_2249",
"lst_p1108_v_15_20230515_1634",
"lst_p1108_v_15_20230518_2218",
"lst_p1108_v_15_20230521_0220",
"lst_p1108_v_15_20230522_2148",
"lst_p1108_v_15_20230524_1123",
"lst_p1108_v_15_20230525_1625",
"lst_p1108_v_15_20230526_2256",
"lst_p1108_v_15_20230528_1603",
"lst_p1108_v_15_20230530_0557",
"lst_p1108_v_15_20230531_1604",
"lst_p1108_v_15_20230602_0118",
"lst_p1108_v_15_20230603_1650",
"lst_p1108_v_15_20230605_1417",
"lst_p1108_v_15_20230607_0933",
"lst_p1108_v_15_20230608_1905",
"lst_p1108_v_15_20230610_1503",
"lst_p1108_v_15_20230612_1935",
"lst_p1108_v_15_20230614_0033",
"lst_p1108_v_15_20230615_1621",
"lst_p1108_v_15_20230617_0106",
"lst_p1108_v_15_20230618_1703",
"lst_p1108_v_15_20230619_1810",
"lst_p1108_v_15_20230620_2204",
"lst_p1108_v_15_20230621_2204",
"lst_p1108_v_15_20230623_0918",
"lst_p1108_v_15_20230624_2004",
"lst_p1108_v_15_20230626_1304",
"lst_p1108_v_15_20230627_1718",
"lst_p1108_v_15_20230628_1905",
"lst_p1108_v_15_20230630_0018",
"lst_p1108_v_15_20230630_1949",
"lst_p1108_v_15_20230701_1919",
"lst_p1108_v_15_20230703_0618",
"lst_p1108_v_15_20230704_1108",
"lst_p1108_v_15_20230705_1605",
"lst_p1108_v_15_20230706_1904",
"lst_p1108_v_15_20230707_2009",
"lst_p1108_v_15_20230709_0833",
"lst_p1108_v_15_20230710_1705",
"lst_p1108_v_15_20230712_0104",
"lst_p1108_v_15_20230713_1134",
"lst_p1108_v_15_20230714_1605",
"lst_p1108_v_15_20230716_0233",
"lst_p1108_v_15_20230717_1436",
"lst_p1108_v_15_20230718_2204",
"lst_p1108_v_15_20230720_0704",
"lst_p1108_v_15_20230721_1704",
"lst_p1108_v_15_20230723_1148",
"lst_p1108_v_15_20230724_1934",
"lst_p1108_v_15_20230725_2204",
"lst_p1108_v_15_20230727_0204",
"lst_p1108_v_15_20230728_1219",
"lst_p1108_v_15_20230730_0633",
"lst_p1108_v_15_20230731_2334",
"lst_p1108_v_15_20230802_1049",
"lst_p1108_v_15_20230803_1905",
"lst_p1108_v_15_20230805_0034",
"lst_p1108_v_15_20230805_2018",
"lst_p1108_v_15_20230807_0049",
"lst_p1108_v_15_20230807_2105",
"lst_p1108_v_15_20230808_1009",
"lst_p1108_v_15_20230809_0048",
"lst_p1108_v_15_20230809_1920",
"lst_p1108_v_15_20230810_1707",
"lst_p1108_v_15_20230811_1805",
"lst_p1108_v_15_20230812_1820",
"lst_p1108_v_15_20230813_0835",
"lst_p1108_v_15_20230814_0739",
"lst_p1108_v_15_20230815_0623",
"lst_p1108_v_15_20230816_0251",
"lst_p1108_v_15_20230817_0050",
"lst_p1108_v_15_20230817_1857",
"lst_p1108_v_15_20230818_1534",
"lst_p1108_v_15_20230819_1506",
"lst_p1108_v_15_20230820_1805",
"lst_p1108_v_15_20230821_1605",
"lst_p1108_v_15_20230822_1537",
"lst_p1108_v_15_20230823_1351",
"lst_p1108_v_15_20230824_1618",
"lst_p1108_v_15_20230825_1906",
"lst_p1108_v_15_20230827_0133",
"lst_p1108_v_15_20230828_1205",
"lst_p1108_v_15_20230829_1835",
"lst_p1108_v_15_20230830_1904",
"lst_p1108_v_15_20230901_0649",
"lst_p1108_v_15_20230902_1903",
"lst_p1108_v_15_20230904_1143",
"lst_p1108_v_15_20230905_1849",
"lst_p1108_v_15_20230907_0649",
"lst_p1108_v_15_20230908_1533",
"lst_p1108_v_15_20230910_1133",
"lst_p1108_v_15_20230911_1906",
"lst_p1108_v_15_20230913_0733",
"lst_p1108_v_15_20230914_1834",
"lst_p1108_v_15_20230916_1548",
"lst_p1108_v_15_20230918_1219",
"lst_p1108_v_15_20230919_2219",
"lst_p1108_v_15_20230921_0634",
"lst_p1108_v_15_20230922_1536",
"lst_p1108_v_15_20230924_0108",
"lst_p1108_v_15_20230925_1235",
"lst_p1108_v_15_20230926_1822",
"lst_p1108_v_15_20230927_1921",
"lst_p1108_v_15_20230928_1858",
"lst_p1108_v_15_20230929_1948",
"lst_p1108_v_15_20231001_0448",
"lst_p1108_v_15_20231002_1920",
"lst_p1108_v_15_20231004_0133",
"lst_p1108_v_15_20231005_0705",
"lst_p1108_v_15_20231006_0118",
"lst_p1108_v_15_20231007_0703",
"lst_p1108_v_15_20231008_1905",
"lst_p1108_v_15_20231010_0649",
"lst_p1108_v_15_20231011_1805",
"lst_p1108_v_15_20231013_0005",
"lst_p1108_v_15_20231014_0133",
"lst_p1108_v_15_20231015_1305",
"lst_p1108_v_15_20231016_2133",
"lst_p1108_v_15_20231018_0348",
"lst_p1108_v_15_20231019_0635",
"lst_p1108_v_15_20231022_0448",
"lst_p1108_v_15_20231025_0049",
"lst_p1108_v_15_20231027_1448",
"lst_p1108_v_15_20231030_1534",
"lst_p1108_v_15_20231101_1904",
"lst_p1108_v_15_20231103_1905",
"lst_p1108_v_15_20231106_1834",
"lst_p1108_v_15_20231109_1336",
"lst_p1108_v_15_20231113_0704",
"lst_p1108_v_15_20231116_0049",
"lst_p1108_v_15_20231119_1219",
"lst_p1108_v_15_20231122_1305",
"lst_p1108_v_15_20231126_1204",
"lst_p1108_v_15_20231129_1419",
"lst_p1108_v_15_20231202_1819",
"lst_p1108_v_15_20231206_0923",
"lst_p1108_v_15_20231209_1319",
"lst_p1108_v_15_20231212_2224",
"lst_p1108_v_15_20231214_1835",
"lst_p1108_v_15_20231217_1849",
"lst_p1108_v_15_20231219_2136",
"lst_p1108_v_15_20231221_0819",
"lst_p1108_v_15_20231224_1049",
"lst_p1108_v_15_20231227_1848",
"lst_p1108_v_15_20231230_2103"
],
"attributes.numberOfDaysOffset": [
34
],
"sprAppInfo.buildJobName": [
"unknown"
],
"attributes.__exception_stackTrace": [
"com.spr.exceptions.unchecked.SprinklrRuntimeException: Failed execution timeValue: 3m\n\tat com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:535)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.doExecuteActionGet(AbstractESRequestBuilder.java:174)\n\tat com.spr.search.repository.elasticsearch.es.ESSearchRequestBuilder.doExecuteActionGet(ESSearchRequestBuilder.java:248)\n\tat com.spr.search.repository.elasticsearch.es.ESSearchRequestBuilder.doExecuteActionGet(ESSearchRequestBuilder.java:62)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.lambda$executeActionGet$0(AbstractESRequestBuilder.java:102)\n\tat com.spr.utils.core.RequestContextProvider.safeTrackCall(RequestContextProvider.java:323)\n\tat com.spr.utils.core.interceptor.TrackingInterceptor.run(TrackingInterceptor.java:15)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.StuckThreadInterceptor.run(StuckThreadInterceptor.java:77)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.BulkheadInterceptor.run(BulkheadInterceptor.java:31)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.RateLimiterInterceptor.run(RateLimiterInterceptor.java:31)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.CircuitBreakerInterceptor.run(CircuitBreakerInterceptor.java:29)\n\tat com.spr.utils.core.interceptor.Interceptors.lambda$run$1(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:53)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:56)\n\tat com.spr.utils.core.interceptor.Interceptors.run(Interceptors.java:45)\n\tat com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder.executeActionGet(AbstractESRequestBuilder.java:100)\n\tat com.spr.search.repository.elasticsearch.timeshard.ESTimeShardedSearchRepoImpl.searchWithFacets(ESTimeShardedSearchRepoImpl.java:772)\n\tat com.spr.shifu.repository.TimeShardedESSearchAdapter.search(TimeShardedESSearchAdapter.java:181)\n\tat com.spr.shifu.AbstractReportingEngine.handleESAggregationRequest(AbstractReportingEngine.java:1506)\n\tat com.spr.shifu.AbstractReportingEngine.handleESAggregationRequest(AbstractReportingEngine.java:2088)\n\tat com.spr.shifu.listening.ListeningReportingEngine.handleESAggregationRequest(ListeningReportingEngine.java:775)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateNonExecutableReport(AbstractReportingEngine.java:556)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateInternal(AbstractReportingEngine.java:501)\n\tat com.spr.shifu.listening.ListeningReportingEngine._aggregateInternal(ListeningReportingEngine.java:736)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregateInternal(ListeningReportingEngine.java:426)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregateInternal(ListeningReportingEngine.java:451)\n\tat com.spr.shifu.listening.ListeningReportingEngine.lambda$getReportingEngineQueryCacheLoader$2(ListeningReportingEngine.java:746)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.loadFromCallable(PersistentCacheMongo.java:522)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.getFromCacheOrLoadAtomic(PersistentCacheMongo.java:483)\n\tat com.spr.core.cache.persistent.impl.PersistentCacheMongo.getFromCacheOrLoadAtomic(PersistentCacheMongo.java:457)\n\tat com.spr.shifu.ReportingEngineQueryCacheImpl.getFromCacheOrLoadAtomic(ReportingEngineQueryCacheImpl.java:141)\n\tat com.spr.shifu.AbstractReportingEngine.aggregateOrReturnFromCache(AbstractReportingEngine.java:2004)\n\tat com.spr.shifu.AbstractReportingEngine.aggregate(AbstractReportingEngine.java:471)\n\tat com.spr.shifu.listening.ListeningReportingEngine.aggregate(ListeningReportingEngine.java:377)\n\tat com.spr.shifu.ReportingServiceImpl.processRequest(ReportingServiceImpl.java:130)\n\tat com.spr.shifu.ReportingServiceImpl.executeRequest(ReportingServiceImpl.java:358)\n\tat com.spr.shifu.ReportingServiceImpl.batchQueryInternal(ReportingServiceImpl.java:253)\n\tat com.spr.shifu.ReportingServiceImpl.batchQuery(ReportingServiceImpl.java:103)\n\tat com.spr.shifu.ReportingServiceProxy.batchQuery(ReportingServiceProxy.java:87)\n\tat com.spr.reporting.rest.ReportingRestAPI.executeBatchQuery(ReportingRestAPI.java:940)\n\tat com.spr.reporting.rest.ReportingRestAPI.lambda$batchQuery$3(ReportingRestAPI.java:743)\n\tat com.spr.utils.AsyncRestExecutionTemplate$1.doCall(AsyncRestExecutionTemplate.java:61)\n\tat com.spr.utils.AsyncRestExecutionTemplate$1.doCall(AsyncRestExecutionTemplate.java:50)\n\tat com.spr.ops.executor.util.UserContextAwareCallable.call(UserContextAwareCallable.java:116)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)\n\tat java.base/java.lang.Thread.run(Thread.java:842)\nCaused by: org.elasticsearch.common.util.concurrent.UncategorizedExecutionException: Failed execution\n\tat org.elasticsearch.action.support.AdapterActionFuture.rethrowExecutionException(AdapterActionFuture.java:92)\n\tat org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:79)\n\tat com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:532)\n\t... 55 more\nCaused by: java.util.concurrent.ExecutionException: java.io.IOException: request retries exceeded max retry timeout [120000]\n\tat org.elasticsearch.common.util.concurrent.BaseFuture$Sync.getValue(BaseFuture.java:288)\n\tat org.elasticsearch.common.util.concurrent.BaseFuture$Sync.get(BaseFuture.java:261)\n\tat org.elasticsearch.common.util.concurrent.BaseFuture.get(BaseFuture.java:92)\n\tat org.elasticsearch.action.support.AdapterActionFuture.actionGet(AdapterActionFuture.java:72)\n\t... 56 more\nCaused by: java.io.IOException: request retries exceeded max retry timeout [120000]\n\tat org.elasticsearch.client.rest.support.InternalRestClient$1.retryIfPossible(InternalRestClient.java:338)\n\tat org.elasticsearch.client.rest.support.InternalRestClient$1.failed(InternalRestClient.java:325)\n\tat org.elasticsearch.client.rest.support.InternalRestClientBuilder$2.execute(InternalRestClientBuilder.java:388)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequestAsync(InternalRestClient.java:358)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequestAsync(InternalRestClient.java:251)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequest(InternalRestClient.java:222)\n\tat org.elasticsearch.client.rest.support.InternalRestClient.performRequest(InternalRestClient.java:189)\n\tat org.elasticsearch.client.rest.support.RestExecuteUtil.execute(RestExecuteUtil.java:75)\n\tat org.elasticsearch.client.rest.RestClient.execute(RestClient.java:113)\n\tat org.elasticsearch.client.support.AbstractClient.search(AbstractClient.java:348)\n\tat org.elasticsearch.action.search.SearchRequestBuilder.doExecute(SearchRequestBuilder.java:1208)\n\tat org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:94)\n\tat org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:68)\n\t... 56 more\n"
],
"requestContext.module": [
"API"
],
"attributes.numberOfDays": [
364
],
"requestContext.apiAuthDetails.apiKeyOrOAuthClientId": [
"Bearer eyJhbGciOiJSUzI1NiJ9.eyJzdWIiOiJBY2Nlc3MgVG9rZW4gR2VuZXJhdGVkIEJ5IFNwcmlua2xyIiwiY2xpZW50SWQiOjU1OTcsIm90YUlkIjoiNjViOTk2YWZjYjJkOGUzMjU2ZTNhYjE0IiwiaXNzIjoiU1BSSU5LTFIiLCJ0eXAiOiJKV1QiLCJ1c2VySWQiOjc1OTY5NSwiYXVkIjoiU1BSSU5LTFIiLCJuYmYiOjE3MDcwNDkxMjYsInNjb3BlIjpbIlJFQUQiLCJXUklURSJdLCJwYXJ0bmVySWQiOjExMDgsImV4cCI6MTcwNzA2NDcyNiwiYXV0aFR5cGUiOiJTUFJfS0VZX1BBU1NfTE9HSU4iLCJ0b2tlblR5cGUiOiJBQ0NFU1MiLCJpYXQiOjE3MDcwNTAzMjYsImp0aSI6InNwcmlua2xyIiwibWljcm9TZXJ2aWNlIjoiZGlzcGxheSJ9.gqVRBe1T6SrtssGkRvgkHR-XX4USGQW8yKzWb_gDSAEnfZ1JatmAHajH0Fg3Ti15DeryrHVRxUv-HO16ksIZHcUDjk9fntzYBEfKXdb4Q5A2kKYXlkCXib3SkVZE7sn4Sr0Tw7VAYtemWY5xweDk9AaBw4r1W6HBJ6Vy4S1OS-1UXgGZnxvvUcgb2RWk_3HRN4aWEze3Se9BhVgSulENFbSGHaVscceL2Moa0KxwrQMzwy2vrp5LK4XC7SlBNzvzGpbYWP1EPIvcxzYGnxcgviIIvDZ3yaEfawzrq5tnk_EqQ1LG6349dBi1I-a_6yFR-8l0FSrF-CQ98GNk8lE6iQ"
],
"attributes.context.timeRange": [
"Range{from=1672511400000, upto=1704047399999, includeLower=true, includeUpper=true}"
],
"attributes.size": [
"20"
],
"attributes.relativeDaysQueried": [
34,
35,
36,
37,
38,
39,
40,
41,
42,
43,
44,
45,
46,
47,
48,
49,
50,
51,
52,
53,
54,
55,
56,
57,
58,
59,
60,
61,
62,
63,
64,
65,
66,
67,
68,
69,
70,
71,
72,
73,
74,
75,
76,
77,
78,
79,
80,
81,
82,
83,
84,
85,
86,
87,
88,
89,
90,
91,
92,
93,
94,
95,
96,
97,
98,
99,
100,
101,
102,
103,
104,
105,
106,
107,
108,
109,
110,
111,
112,
113,
114,
115,
116,
117,
118,
119,
120,
121,
122,
123,
124,
125,
126,
127,
128,
129,
130,
131,
132,
133,
134,
135,
136,
137,
138,
139,
140,
141,
142,
143,
144,
145,
146,
147,
148,
149,
150,
151,
152,
153,
154,
155,
156,
157,
158,
159,
160,
161,
162,
163,
164,
165,
166,
167,
168,
169,
170,
171,
172,
173,
174,
175,
176,
177,
178,
179,
180,
181,
182,
183,
184,
185,
186,
187,
188,
189,
190,
191,
192,
193,
194,
195,
196,
197,
198,
199,
200,
201,
202,
203,
204,
205,
206,
207,
208,
209,
210,
211,
212,
213,
214,
215,
216,
217,
218,
219,
220,
221,
222,
223,
224,
225,
226,
227,
228,
229,
230,
231,
232,
233,
234,
235,
236,
237,
238,
239,
240,
241,
242,
243,
244,
245,
246,
247,
248,
249,
250,
251,
252,
253,
254,
255,
256,
257,
258,
259,
260,
261,
262,
263,
264,
265,
266,
267,
268,
269,
270,
271,
272,
273,
274,
275,
276,
277,
278,
279,
280,
281,
282,
283,
284,
285,
286,
287,
288,
289,
290,
291,
292,
293,
294,
295,
296,
297,
298,
299,
300,
301,
302,
303,
304,
305,
306,
307,
308,
309,
310,
311,
312,
313,
314,
315,
316,
317,
318,
319,
320,
321,
322,
323,
324,
325,
326,
327,
328,
329,
330,
331,
332,
333,
334,
335,
336,
337,
338,
339,
340,
341,
342,
343,
344,
345,
346,
347,
348,
349,
350,
351,
352,
353,
354,
355,
356,
357,
358,
359,
360,
361,
362,
363,
364,
365,
366,
367,
368,
369,
370,
371,
372,
373,
374,
375,
376,
377,
378,
379,
380,
381,
382,
383,
384,
385,
386,
387,
388,
389,
390,
391,
392,
393,
394,
395,
396,
397
],
"level": [
"ERROR"
],
"sprAppInfo.sprAppType": [
"API"
],
"sprAppInfo.buildNumber": [
"unknown"
],
"requestContext.traceEnabled": [
false
],
"calleeClass": [
"com.spr.search.repository.elasticsearch.es.AbstractESRequestBuilder"
],
"attributes.__exception_atClassRC": [
"org.elasticsearch.client.rest.support.InternalRestClient$1"
],
"attributes.querySize": [
4452
],
"userIpAddress": [
"54.173.96.48"
],
"attributes.sortOrder": [
"DESC"
],
"attributes.indicesCount": [
196
],
"attributes.__exception_atClassMethod": [
"com.spr.utils.elasticsearch.ElasticSearchUtil.executeActionGet(ElasticSearchUtil.java:535)"
],
"sprAppInfo.ui": [
false
],
"requestContext.additional.SPR_HTTP_REQUEST_ID": [
"65bf91372672be79132199e9"
],
"attributes.callee_m": [
"call"
],
"requestContext.requestSourceDetail.requestSource": [
"MICRO_SERVICES"
],
"ctxCId": [
5597
],
"ctxUId": [
759695
],
"attributes.entityType": [
"universalMessage"
],
"sprAppInfo.processID": [
"1"
],
"attributes.query": [
"{\"size\":0,\"timeout\":\"120000ms\",\"query\":{\"constant_score\":{\"filter\":{\"bool\":{\"must\":{\"bool\":{\"must\":[{\"range\":{\"snCTm\":{\"from\":1672511400000,\"to\":1704047399999,\"include_lower\":true,\"include_upper\":true}}},{\"bool\":{\"must_not\":{\"bool\":{\"should\":[{\"term\":{\"fU.sN\":\"BYJU's\"}},{\"term\":{\"fU.sN\":\"Budweiser\"}},{\"term\":{\"fU.sN\":\"Budweiserusa\"}},{\"term\":{\"fU.sN\":\"Hisense\"}},{\"term\":{\"fU.sN\":\"McDonald's\"}},{\"term\":{\"fU.sN\":\"Vivo\"}},{\"term\":{\"fU.sN\":\"Adidas\"}},{\"term\":{\"fU.sN\":\"Coca-Cola\"}},{\"term\":{\"fU.sN\":\"Wanda Group\"}},{\"term\":{\"fU.sN\":\"Hyundai\"}},{\"term\":{\"fU.sN\":\"Qatar Airways\"}},{\"term\":{\"fU.sN\":\"Visa\"}},{\"term\":{\"fU.sN\":\"Hummel\"}},{\"term\":{\"fU.sN\":\"Kappa\"}},{\"term\":{\"fU.sN\":\"Majid\"}},{\"term\":{\"fU.sN\":\"Marathon\"}},{\"term\":{\"fU.sN\":\"New Balance\"}},{\"term\":{\"fU.sN\":\"Nike\"}},{\"term\":{\"fU.sN\":\"One All Sports\"}},{\"term\":{\"fU.sN\":\"Puma\"}},{\"term\":{\"fU.sN\":\"Twitter\"}}],\"_cache_key\":\"bb6f84403a545ba7f6b79bbe680568ae\"}}}},{\"bool\":{\"should\":[{\"bool\":{\"should\":[{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"spr_user_handle\"}}}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"en\"}}}}]}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"a\\\"\",\"fields\":[\"mVadd.q_tw\",\"add.t_en\",\"add.m_en\",\"addI.quotedMsg.m\",\"addI.revItemInfo.item\",\"mVadd.m_x_url\"],\"use_dis_max\":false,\"extra_analyzer_per_field\":{\"mVadd.q_tw\":\"en\",\"add.t_en\":\"en\",\"add.m_en\":\"en\",\"addI.quotedMsg.m\":\"en\",\"addI.revItemInfo.item\":\"en\",\"mVadd.m_x_url\":\"en\"}}}}},{\"bool\":{\"should\":[{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"spr_user_handle\"}}}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.m_x\"],\"use_dis_max\":false,\"analyzer\":\"en\"}}}}]}},{\"bool\":{\"must\":{\"spr_query_string\":{\"query\":\"\\\"an\\\"\",\"fields\":[\"mVadd.q_tw\",\"add.t_en\",\"add.m_en\",\"addI.quotedMsg.m\",\"addI.revItemInfo.item\",\"mVadd.m_x_url\"],\"use_dis_max\":false,\"extra_analyzer_per_field\":{\"mVadd.q_tw\":\"en\",\"add.t_en\":\"en\",\"add.m_en\":\"en\",\"addI.quotedMsg.m\":\"en\",\"addI.revItemInfo.item\":\"en\",\"mVadd.m_x_url\":\"en\"}}}}}],\"_cache_key\":\"62ef9db17072a29f4da7951a566dba3c\"}},{\"bool\":{\"must\":{\"terms\":{\"iD\":[false]}}}},{\"bool\":{\"must\":{\"bool\":{\"must_not\":{\"terms\":{\"add.prS\":[\"tve\",\"eClips\",\"movFt\",\"fac\"]}}}}}},{\"bool\":{\"must\":{\"bool\":{\"must_not\":{\"exists\":{\"field\":\"add.auMiss\"}}}}}}]}},\"must_not\":[{\"bool\":{\"should\":[{\"bool\":{\"must\":[{\"bool\":{\"should\":[{\"terms\":{\"add.domain\":[\"heraldsun.com.au\",\"themercury.com.au\",\"adelaidenow.com.au\",\"goldcoastbulletin.com.au\",\"dailytelegraph.com.au\",\"ntnews.com.au\",\"news.com.au\",\"geelongadvertiser.com.au\",\"theaustralian.com.au\",\"skynews.com.au\",\"thechronicle.com.au\",\"cairnspost.com.au\",\"weeklytimesnow.com.au\",\"townsvillebulletin.com.au\",\"couriermail.com.au\"]}},{\"terms\":{\"add.td\":[\"heraldsun.com.au\",\"themercury.com.au\",\"adelaidenow.com.au\",\"goldcoastbulletin.com.au\",\"dailytelegraph.com.au\",\"ntnews.com.au\",\"news.com.au\",\"geelongadvertiser.com.au\",\"theaustralian.com.au\",\"skynews.com.au\",\"thechronicle.com.au\",\"cairnspost.com.au\",\"weeklytimesnow.com.au\",\"townsvillebulletin.com.au\",\"couriermail.com.au\"]}}]}},{\"bool\":{\"must_not\":{\"terms\":{\"add.iUDA\":[\"true\"]}},\"_cache_key\":\"e029ebc70021d9b4c58c7085cf9afe17\"}}]}},{\"bool\":{\"must\":[{\"terms\":{\"add.d_s\":[\"bmk\"]}},{\"terms\":{\"add.m_t\":[\"INSTAGRAM\"]}}]}},{\"terms\":{\"mVadd.licenses\":[\"NCA\"]}}],\"_cache_key\":\"7124d6022c9ed38d982c0b87744ec6b5\"}},{\"term\":{\"add.d_s\":\"tw_sl\"}}]}}}},\"aggregations\":{\"SPRINKSIGHTS\":{\"filter\":{\"match_all\":{}},\"aggregations\":{\"TABULAR\":{\"group-by\":{\"size\":9,\"shard_size\":100000,\"order\":{\"INFLUENCER_SCORE_AVG\":\"desc\"},\"fields\":[{\"name\":\"FROM_SN_USER\",\"field\":\"fU.pK\"},{\"name\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"snSt.nF\"}]},\"aggregations\":{\"MENTIONS_COUNT\":{\"sum\":{\"script\":{\"inline\":\"1\"}}},\"POS_SEN_FILTERED_PROJECTION\":{\"filter\":{\"bool\":{\"must\":{\"terms\":{\"addI.sem.data.sentiment_polarity\":[\"1\",\"2\",\"1.0\",\"2.0\",\"positive\"]}}}},\"aggregations\":{\"POS_SEN\":{\"sum\":{\"script\":{\"inline\":\"1\"}}}}},\"REACH_COUNT\":{\"sum\":{\"field\":\"snSt.reC\"}},\"EARNED_ENGAGEMENT\":{\"sum\":{\"field\":\"snSt.erEng\"}},\"INFLUENCER_SCORE_AVG\":{\"avg\":{\"script\":{\"inline\":\"if(doc['snSt.iFsC'].value == null) {if(doc['enr.kl.sc'].value == null) {if(doc['enr.fc.scr_val'].value == null || doc['enr.fc.scr_pro'].value != 'klout') {0} else {doc['enr.fc.scr_val'].value}} else { doc['enr.kl.sc'].value}} else {doc['snSt.iFsC'].value}\",\"lang\":\"painless\"}}}}}}}}}"
],
"attributes.ttm": [
120086
],
"attributes.reportingReqJson": [
"{\"key\":\"SPRINKSIGHTS\",\"timeFilter\":{\"field\":\"snCTm\",\"sinceTime\":1672511400000,\"untilTime\":1704047399999,\"includeLower\":true,\"includeUpper\":true},\"previousTimeFilter\":{\"sinceTime\":1640975400000,\"untilTime\":1672511399999,\"includeLower\":true,\"includeUpper\":true},\"reportingEngine\":\"LISTENING\",\"filters\":[{\"filterType\":\"NIN\",\"field\":\"QUERY\",\"values\":[\" author:(\\\"BYJU’s\\\"OR \\\"Budweiser\\\"OR \\\"Budweiserusa\\\" OR \\\"Hisense\\\"OR \\\"McDonald\\u0027s\\\"OR \\\"Vivo\\\"OR \\\"Adidas\\\"OR \\\"Coca-Cola\\\"OR \\\"Wanda Group\\\"OR \\\"Hyundai\\\"OR \\\"Qatar Airways\\\"OR \\\"Visa\\\"OR \\\"Adidas\\\"OR \\\"Hummel\\\"OR \\\"Kappa\\\"OR \\\"Majid\\\"OR \\\"Marathon\\\"OR \\\"New Balance\\\"OR \\\"Nike\\\"OR \\\"One All Sports\\\"OR \\\"Puma\\\"OR \\\"Qatar Airways\\\" OR Twitter)\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"type\":\"DIMENSION\",\"OLD_DIM_NAME\":\"TOPIC_QUERY\",\"INPUT_TYPE\":\"FREE_TEXT\",\"EXCLUDE_IN_THEME_PREVIEW\":\"true\",\"EXIST_FILTER\":false,\"singleSelect\":\"true\"}},{\"filterType\":\"IN\",\"field\":\"QUERY\",\"values\":[\"a OR an\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"contentType\":\"DB_FILTER\",\"OLD_DIM_NAME\":\"TOPIC_QUERY\",\"INPUT_TYPE\":\"FREE_TEXT\",\"EXCLUDE_IN_THEME_PREVIEW\":\"true\",\"EXIST_FILTER\":false,\"singleSelect\":\"true\"}},{\"filterType\":\"IN\",\"field\":\"IS_DELETED\",\"values\":[false],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{}},{\"filterType\":\"NIN\",\"field\":\"PREMIUM_SUBSCRIPTION\",\"values\":[\"tve\",\"eClips\",\"movFt\",\"fac\"],\"userFilter\":false,\"allValuesAllowed\":true,\"lockedWithValues\":false,\"hidden\":false,\"favourite\":false,\"mandatory\":false,\"locked\":false,\"ignoreAddingToDimensionFilter\":false,\"details\":{\"showAsDashbaordFilter\":\"true\",\"include\":[\"tve\",\"fac\"]}}],\"projectionFilters\":[],\"groupBys\":[{\"groups\":[{\"key\":\"FROM_SN_USER\",\"field\":\"FROM_SN_USER\",\"groupType\":\"FIELD\",\"details\":{},\"projections\":[],\"childrenGroupBys\":[{\"key\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"TOTAL_USER_FOLLOWERS\",\"groupType\":\"FIELD\",\"details\":{},\"sort\":{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"},\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}]},{\"key\":\"TOTAL_USER_FOLLOWERS\",\"field\":\"TOTAL_USER_FOLLOWERS\",\"groupType\":\"FIELD\",\"details\":{},\"sort\":{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"},\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}],\"key\":\"TABULAR\",\"groupType\":\"MULTI_FIELD\",\"projections\":[{\"key\":\"MENTIONS_COUNT\",\"measurement\":\"MENTIONS_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":0},\"filters\":[]},{\"key\":\"POS_SEN\",\"measurement\":\"POS_SEN\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":1},\"filters\":[]},{\"key\":\"REACH_COUNT\",\"measurement\":\"REACH_COUNT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":2},\"filters\":[]},{\"key\":\"EARNED_ENGAGEMENT\",\"measurement\":\"EARNED_ENGAGEMENT\",\"aggregateFunction\":\"SUM\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":3},\"filters\":[]},{\"key\":\"INFLUENCER_SCORE_AVG\",\"measurement\":\"INFLUENCER_SCORE\",\"aggregateFunction\":\"AVG\",\"details\":{\"origReport\":\"SPRINKSIGHTS\",\"alternateHeading\":\"\",\"origOrder\":4},\"filters\":[]}]}],\"projections\":[],\"report\":\"SPRINKSIGHTS\",\"tzOffset\":0,\"timezone\":\"Asia/Kolkata\",\"sorts\":[{\"key\":\"INFLUENCER_SCORE_AVG\",\"order\":\"DESC\"}],\"page\":{\"page\":0,\"size\":8,\"skip\":0},\"additional\":{\"originatingApp\":\"spr-display-publisher\",\"panelId\":\"cGFuZWw6NjUyOTMwYmVkZjQyYzcyN2I2Zjc3Mjhi\",\"clientId\":\"5597\",\"IGNORE_DRILL_DOWN\":\"true\",\"ACTUAL_DATE_FIELD\":\"snCTm\",\"storyboardId\":\"c3Rvcnlib2FyZDo2NTI5MzBhYTRlY2Y1MDZjNjdkNzFiNTM\\u003d\",\"partnerId\":\"1108\",\"uiRequestAdaptTime\":\"2\",\"TABULAR\":\"true\",\"PARTNER_ID\":\"1108\"},\"cacheDisabled\":false,\"projectionDecorations\":[],\"includeFields\":[],\"excludeFields\":[],\"reportDateField\":\"snCTm\"}"
],
"attributes.__exception_msg": [
"Failed execution timeValue: 3m"
],
"querySkeletonHash": [
"A1ABEA"
],
"attributes.timeRange": [
"1672511400000-1704047399999/0"
],
"sprAppInfo.subModuleType": [
"unknown"
],
"requestContext.apiAuthDetails.authType": [
"JWT_TOKEN"
],
"attributes.clusterName": [
"listening33-es7-demo"
],
"requestContext.additional.RPT_ENGINE_NAME": [
"LISTENING"
],
"deploymentName": [
"api-tier1-deployment"
],
"fetch_size": [
0
],
"sprAppInfo.appVersion": [
"unknown"
],
"aggregationsUsed": [
"[avg, group-by, sum]"
],
"requestContext.debugLogEnabled": [
false
],
"timestamp": [
"2024-02-04T13:31:27.779Z"
],
"requestContext.skipAutoTranslate": [
false
],
"attributes.esServerType": [
"SPRINKSIGHTS"
],
"moduleType": [
"ss_es_sla"
],
"requestContext.additional.httpMethod": [
"POST"
],
"attributes.__exception_atPackageRC": [
"org.elasticsearch.client.rest.support"
],
"requestContext.additional.REPORTING_REQUEST_SOURCE": [
"REPORTING_UI"
],
"requestContext.additional.RPT_REPORT_NAME": [
"SPRINKSIGHTS"
],
"sprAppInfo.buildSvnRevision": [
"unknown"
],
"cacheKeys": [
"[0568ae, 6dba3c, 9afe17, 4ec6b5]"
],
"attributes.esReqType": [
"ESSearchRequestBuilderWithTimeRange"
],
"attributes.__exception_atPackage": [
"com.spr.utils.elasticsearch"
],
"sprAppInfo.buildTimestamp": [
"unknown"
],
"requestContext.additional.display-app": [
"true"
],
"attributes.es-requestId": [
"65bf91372672be79132199ec"
],
"requestContext.distributedTraceId": [
"65bf91322672be79132198bf"
],
"threadName": [
"APP_Thread_1108_5597_759695__1707053487779_P_Th_SPR-monitoring-logger-pool-7-thread-3909"
],
"attributes.__exception_rootCause_class": [
"java.io.IOException"
],
"calleeMethod": [
"doSafeLog"
],
"attributes.__exception_atClass": [
"com.spr.utils.elasticsearch.ElasticSearchUtil"
],
"attributes.__exception_atClassMethodRC": [
"org.elasticsearch.client.rest.support.InternalRestClient$1.retryIfPossible(InternalRestClient.java:338)"
],
"requestContext.additional.threadPoolType": [
"THROTTLE"
],
"hostNameIp": [
"api-tier1-deployment-84fc7dc679-xxt2c/10.0.196.86"
],
"attributes.__exception_exceptionChain": [
"com.spr.exceptions.unchecked.SprinklrRuntimeException: Failed execution timeValue: 3m, org.elasticsearch.common.util.concurrent.UncategorizedExecutionException: Failed execution, java.util.concurrent.ExecutionException: java.io.IOException: request retries exceeded max retry timeout [120000], java.io.IOException: request retries exceeded max retry timeout [120000]"
],
"requestContext.path": [
"/api/v3.1/reports/query"
],
"attributes.storyboardId": [
"c3Rvcnlib2FyZDo2NTI5MzBhYTRlY2Y1MDZjNjdkNzFiNTM="
]
}
}Editor is loading...
Leave a Comment