MetricError Fetch exceeded max allowed data points for dpType

#1

I’ve a TSDecl metric ob Facility that for a certain object its evaluation fails with:

c3.love.exceptions.C3RuntimeException: c3.love.exceptions.C3RuntimeException: 
MetricEngine error : c3.love.exceptions.C3RuntimeException: 
AsTimeseriesGroup: Fetch exceeded max allowed data points for dpType=WifiConnectedDeviceMeasurement,current_max_allowed=300000,header_type=WifiAccessPoint,header_ids=wifiaccesspoint-1-13,wifiaccesspoint-1-12,wifiaccesspoint-1-15,wifiaccesspoint-1-14,wifiaccesspoint-1-11,wifiaccesspoint-1-10,wifiaccesspoint-9-10,wifiaccesspoint-9-11,wifiaccesspoint-9-12,wifiaccesspoint-9-13,wifiaccesspoint-9-14,wifiaccesspoint-9-15,wifiaccesspoint-9-16,wifiaccesspoint-9-17,wifiaccesspoint-9-18,wifiaccesspoint-9-19,wifiaccesspoint-1-17,wifiaccesspoint-1-16,wifiaccesspoint-1-19,wifiaccesspoint-1-18,wifiaccesspoint-1-24,wifiaccesspoint-1-23,wifiaccesspoint-1-26,wifiaccesspoint-3-9,wifiaccesspoint-1-25,wifiaccesspoint-4m-10,wifiaccesspoint-4-13,wifiaccesspoint-1-20,wifiaccesspoint-4-14,wifiaccesspoint-4m-11,wifiaccesspoint-4-11,wifiaccesspoint-1-22,wifiaccesspoint-4m-12,wifiaccesspoint-1-21,wifiaccesspoint-4m-13,wifiaccesspoint-9-21,wifiaccesspoint-9-22,wifiaccesspoint-9-23,wifiaccesspoint-9-25,wifiaccesspoint-9-26,wifiaccesspoint-3-4,wifiaccesspoint-9-27,wifiaccesspoint-3-3,wifiaccesspoint-3-2,wifiaccesspoint-3-1,wifiaccesspoint-3-8,wifiaccesspoint-1-28,wifiaccesspoint-1-27,wifiaccesspoint-3-7,wifiaccesspoint-3-6,wifiaccesspoint-4-19,wifiaccesspoint-3-5,wifiaccesspoint-7-1,wifiaccesspoint-3-12,wifiaccesspoint-3-13,wifiaccesspoint-3-10,wifiaccesspoint-3-11,wifiaccesspoint-g-3,wifiaccesspoint-g-2,wifiaccesspoint-g-1,wifiaccesspoint-4m-4,wifiaccesspoint-4m-3,wifiaccesspoint-4m-2,wifiaccesspoint-4m-1,wifiaccesspoint-2-5,wifiaccesspoint-2-4,wifiaccesspoint-2-3,wifiaccesspoint-4m-9,wifiaccesspoint-2-2,wifiaccesspoint-4m-8,wifiaccesspoint-2-9,wifiaccesspoint-2-8,wifiaccesspoint-4m-7,wifiaccesspoint-4m-6,wifiaccesspoint-2-7,wifiaccesspoint-4m-5,wifiaccesspoint-2-6,wifiaccesspoint-2-25,wifiaccesspoint-2-24,wifiaccesspoint-2-27,wifiaccesspoint-2-26,wifiaccesspoint-2-21,wifiaccesspoint-2-20,wifiaccesspoint-2-23,wifiaccesspoint-2-22,wifiaccesspoint-2-29,wifiaccesspoint-2-28,wifiaccesspoint-9-6,wifiaccesspoint-9-5,wifiaccesspoint-9-3,wifiaccesspoint-9-9,wifiaccesspoint-9-8,wifiaccesspoint-9-7,wifiaccesspoint-8-10,wifiaccesspoint-1-2,wifiaccesspoint-8-11,wifiaccesspoint-1-1,wifiaccesspoint-8-12,wifiaccesspoint-8-13,wifiaccesspoint-8-14,wifiaccesspoint-1-6,wifiaccesspoint-1-5,wifiaccesspoint-1-4,wifiaccesspoint-1-3,wifiaccesspoint-9-2,wifiaccesspoint-9-1,wifiaccesspoint-1-9,wifiaccesspoint-1-8,wifiaccesspoint-1-7,wifiaccesspoint-4-28,wifiaccesspoint-4-29,wifiaccesspoint-4-26,wifiaccesspoint-4-27,wifiaccesspoint-4-24,wifiaccesspoint-4-22,wifiaccesspoint-4-21,wifiaccesspoint-8-7,wifiaccesspoint-2-14,wifiaccesspoint-8-6,wifiaccesspoint-2-13,wifiaccesspoint-4-9,wifiaccesspoint-8-5,wifiaccesspoint-2-16,wifiaccesspoint-4-8,wifiaccesspoint-2-15,wifiaccesspoint-8-4,wifiaccesspoint-2-10,wifiaccesspoint-4-35,wifiaccesspoint-4-36,wifiaccesspoint-4-33,wifiaccesspoint-8-9,wifiaccesspoint-2-12,wifiaccesspoint-4-34,wifiaccesspoint-8-8,wifiaccesspoint-2-11,wifiaccesspoint-4-31,wifiaccesspoint-4-32,wifiaccesspoint-4-3,wifiaccesspoint-4-2,wifiaccesspoint-4-1,wifiaccesspoint-8-3,wifiaccesspoint-2-18,wifiaccesspoint-4-6,wifiaccesspoint-8-2,wifiaccesspoint-2-17,wifiaccesspoint-4-5,wifiaccesspoint-8-1,wifiaccesspoint-2-19,metric_id=BuildingOccupancy_Facility. Set TenantConfig.upsert({id:'TSDeclObjsLimit',value:YOUR_MAX_INTEGER_VALUE}) and retry.\n\tat c3.service.metric.AsTimeseriesGroup.optimize(AsTimeseriesGroup.java:429)
    at c3.service.metric.AsTimeseriesGroup.fetchObjs(AsTimeseriesGroup.java:482)
    at c3.service.metric.AsTimeseriesGroup.evaluate(AsTimeseriesGroup.java:190)
    at c3.service.metric.AsTimeseriesOptimizer.evaluate(AsTimeseriesOptimizer.java:81)
    at c3.service.metric.AsTimeseries.getEvalResult(AsTimeseries.java:114)
    at c3.service.metric.AsTimeseries.asTimeseries(AsTimeseries.java:46)
    at c3.service.metric.SimpleMetricEvaluator.evaluateAsTimeseriesBasedMetric(SimpleMetricEvaluator.java:558)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:550)
    at c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:306)
    at c3.service.metric.MetricEvaluatableOld.lambda$computeResultsFromHierarchies$1(MetricEvaluatableOld.java:160)
    at c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:168)
    at c3.service.metric.MetricEvaluatableOld.computeResultsFromHierarchies(MetricEvaluatableOld.java:160)
    at c3.service.metric.MetricEvaluatableOld.eval(MetricEvaluatableOld.java:112)
    at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)
    at c3.love.timeseries.impl.TimeseriesMath.eval(TimeseriesMath.java:563)
    at c3.love.timeseries.Timeseries.eval(Timeseries.java:657)
    at c3.love.expr.bytecode.TsFuncLib.lambda$eval$81(TsFuncLib.java:1017)
    at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)
    at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)
    at c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)\n\tat c3.love.expr.bytecode.Expr_7214899690045853356_6908768206845336299.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:878)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:632)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:846)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:216)\n\tat sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)\n\tat c3.server.impl.Task.doFilter(Task.java:242)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:82)\n\tat c3.server.impl.Task.run(Task.java:178)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n \nSimple Metric Evaluation failed. metric=BuildingOccupancy,srcId=0082,srcType=Facility,start=2018-01-01T00:00:00.000,end=2020-01-01T00:00:00.000,interval=HOUR,because=AsTimeseriesGroup: Fetch exceeded max allowed data points for dpType=WifiConnectedDeviceMeasurement,current_max_allowed=300000,header_type=WifiAccessPoint,header_ids=wifiaccesspoint-1-13,wifiaccesspoint-1-12,wifiaccesspoint-1-15,wifiaccesspoint-1-14,wifiaccesspoint-1-11,wifiaccesspoint-1-10,wifiaccesspoint-9-10,wifiaccesspoint-9-11,wifiaccesspoint-9-12,wifiaccesspoint-9-13,wifiaccesspoint-9-14,wifiaccesspoint-9-15,wifiaccesspoint-9-16,wifiaccesspoint-9-17,wifiaccesspoint-9-18,wifiaccesspoint-9-19,wifiaccesspoint-1-17,wifiaccesspoint-1-16,wifiaccesspoint-1-19,wifiaccesspoint-1-18,wifiaccesspoint-1-24,wifiaccesspoint-1-23,wifiaccesspoint-1-26,wifiaccesspoint-3-9,wifiaccesspoint-1-25,wifiaccesspoint-4m-10,wifiaccesspoint-4-13,wifiaccesspoint-1-20,wifiaccesspoint-4-14,wifiaccesspoint-4m-11,wifiaccesspoint-4-11,wifiaccesspoint-1-22,wifiaccesspoint-4m-12,wifiaccesspoint-1-21,wifiaccesspoint-4m-13,wifiaccesspoint-9-21,wifiaccesspoint-9-22,wifiaccesspoint-9-23,wifiaccesspoint-9-25,wifiaccesspoint-9-26,wifiaccesspoint-3-4,wifiaccesspoint-9-27,wifiaccesspoint-3-3,wifiaccesspoint-3-2,wifiaccesspoint-3-1,wifiaccesspoint-3-8,wifiaccesspoint-1-28,wifiaccesspoint-1-27,wifiaccesspoint-3-7,wifiaccesspoint-3-6,wifiaccesspoint-4-19,wifiaccesspoint-3-5,wifiaccesspoint-7-1,wifiaccesspoint-3-12,wifiaccesspoint-3-13,wifiaccesspoint-3-10,wifiaccesspoint-3-11,wifiaccesspoint-g-3,wifiaccesspoint-g-2,wifiaccesspoint-g-1,wifiaccesspoint-4m-4,wifiaccesspoint-4m-3,wifiaccesspoint-4m-2,wifiaccesspoint-4m-1,wifiaccesspoint-2-5,wifiaccesspoint-2-4,wifiaccesspoint-2-3,wifiaccesspoint-4m-9,wifiaccesspoint-2-2,wifiaccesspoint-4m-8,wifiaccesspoint-2-9,wifiaccesspoint-2-8,wifiaccesspoint-4m-7,wifiaccesspoint-4m-6,wifiaccesspoint-2-7,wifiaccesspoint-4m-5,wifiaccesspoint-2-6,wifiaccesspoint-2-25,wifiaccesspoint-2-24,wifiaccesspoint-2-27,wifiaccesspoint-2-26,wifiaccesspoint-2-21,wifiaccesspoint-2-20,wifiaccesspoint-2-23,wifiaccesspoint-2-22,wifiaccesspoint-2-29,wifiaccesspoint-2-28,wifiaccesspoint-9-6,wifiaccesspoint-9-5,wifiaccesspoint-9-3,wifiaccesspoint-9-9,wifiaccesspoint-9-8,wifiaccesspoint-9-7,wifiaccesspoint-8-10,wifiaccesspoint-1-2,wifiaccesspoint-8-11,wifiaccesspoint-1-1,wifiaccesspoint-8-12,wifiaccesspoint-8-13,wifiaccesspoint-8-14,wifiaccesspoint-1-6,wifiaccesspoint-1-5,wifiaccesspoint-1-4,wifiaccesspoint-1-3,wifiaccesspoint-9-2,wifiaccesspoint-9-1,wifiaccesspoint-1-9,wifiaccesspoint-1-8,wifiaccesspoint-1-7,wifiaccesspoint-4-28,wifiaccesspoint-4-29,wifiaccesspoint-4-26,wifiaccesspoint-4-27,wifiaccesspoint-4-24,wifiaccesspoint-4-22,wifiaccesspoint-4-21,wifiaccesspoint-8-7,wifiaccesspoint-2-14,wifiaccesspoint-8-6,wifiaccesspoint-2-13,wifiaccesspoint-4-9,wifiaccesspoint-8-5,wifiaccesspoint-2-16,wifiaccesspoint-4-8,wifiaccesspoint-2-15,wifiaccesspoint-8-4,wifiaccesspoint-2-10,wifiaccesspoint-4-35,wifiaccesspoint-4-36,wifiaccesspoint-4-33,wifiaccesspoint-8-9,wifiaccesspoint-2-12,wifiaccesspoint-4-34,wifiaccesspoint-8-8,wifiaccesspoint-2-11,wifiaccesspoint-4-31,wifiaccesspoint-4-32,wifiaccesspoint-4-3,wifiaccesspoint-4-2,wifiaccesspoint-4-1,wifiaccesspoint-8-3,wifiaccesspoint-2-18,wifiaccesspoint-4-6,wifiaccesspoint-8-2,wifiaccesspoint-2-17,wifiaccesspoint-4-5,wifiaccesspoint-8-1,wifiaccesspoint-2-19,metric_id=BuildingOccupancy_Facility. Set TenantConfig.upsert({id:'TSDeclObjsLimit',value:YOUR_MAX_INTEGER_VALUE}) and retry.\n\tat c3.service.metric.MetricUtilsOld.throwError(MetricUtilsOld.java:635)\n\tat c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:170)\n\tat c3.service.metric.MetricEvaluatableOld.computeResultsFromHierarchies(MetricEvaluatableOld.java:160)\n\tat c3.service.metric.MetricEvaluatableOld.eval(MetricEvaluatableOld.java:112)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.timeseries.impl.TimeseriesMath.eval(TimeseriesMath.java:563)\n\tat c3.love.timeseries.Timeseries.eval(Timeseries.java:657)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$eval$81(TsFuncLib.java:1017)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)\n\tat c3.love.expr.bytecode.Expr_7214899690045853356_6908768206845336299.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:878)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:632)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:846)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:216)\n\tat sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)\n\tat c3.server.impl.Task.doFilter(Task.java:242)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:82)\n\tat c3.server.impl.Task.run(Task.java:178)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n\nsrcId=0082\n\tat c3.service.metric.CompoundMetricEvaluator.throwError(CompoundMetricEvaluator.java:1024)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:880)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:632)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:846)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:216)\n\tat sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)\n\tat c3.server.impl.Task.doFilter(Task.java:242)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:82)\n\tat c3.server.impl.Task.run(Task.java:178)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n\nmsg=c3.love.exceptions.C3RuntimeException: MetricEngine error : c3.love.exceptions.C3RuntimeException: AsTimeseriesGroup: Fetch exceeded max allowed data points for dpType=WifiConnectedDeviceMeasurement,current_max_allowed=300000,header_type=WifiAccessPoint,header_ids=wifiaccesspoint-1-13,wifiaccesspoint-1-12,wifiaccesspoint-1-15,wifiaccesspoint-1-14,wifiaccesspoint-1-11,wifiaccesspoint-1-10,wifiaccesspoint-9-10,wifiaccesspoint-9-11,wifiaccesspoint-9-12,wifiaccesspoint-9-13,wifiaccesspoint-9-14,wifiaccesspoint-9-15,wifiaccesspoint-9-16,wifiaccesspoint-9-17,wifiaccesspoint-9-18,wifiaccesspoint-9-19,wifiaccesspoint-1-17,wifiaccesspoint-1-16,wifiaccesspoint-1-19,wifiaccesspoint-1-18,wifiaccesspoint-1-24,wifiaccesspoint-1-23,wifiaccesspoint-1-26,wifiaccesspoint-3-9,wifiaccesspoint-1-25,wifiaccesspoint-4m-10,wifiaccesspoint-4-13,wifiaccesspoint-1-20,wifiaccesspoint-4-14,wifiaccesspoint-4m-11,wifiaccesspoint-4-11,wifiaccesspoint-1-22,wifiaccesspoint-4m-12,wifiaccesspoint-1-21,wifiaccesspoint-4m-13,wifiaccesspoint-9-21,wifiaccesspoint-9-22,wifiaccesspoint-9-23,wifiaccesspoint-9-25,wifiaccesspoint-9-26,wifiaccesspoint-3-4,wifiaccesspoint-9-27,wifiaccesspoint-3-3,wifiaccesspoint-3-2,wifiaccesspoint-3-1,wifiaccesspoint-3-8,wifiaccesspoint-1-28,wifiaccesspoint-1-27,wifiaccesspoint-3-7,wifiaccesspoint-3-6,wifiaccesspoint-4-19,wifiaccesspoint-3-5,wifiaccesspoint-7-1,wifiaccesspoint-3-12,wifiaccesspoint-3-13,wifiaccesspoint-3-10,wifiaccesspoint-3-11,wifiaccesspoint-g-3,wifiaccesspoint-g-2,wifiaccesspoint-g-1,wifiaccesspoint-4m-4,wifiaccesspoint-4m-3,wifiaccesspoint-4m-2,wifiaccesspoint-4m-1,wifiaccesspoint-2-5,wifiaccesspoint-2-4,wifiaccesspoint-2-3,wifiaccesspoint-4m-9,wifiaccesspoint-2-2,wifiaccesspoint-4m-8,wifiaccesspoint-2-9,wifiaccesspoint-2-8,wifiaccesspoint-4m-7,wifiaccesspoint-4m-6,wifiaccesspoint-2-7,wifiaccesspoint-4m-5,wifiaccesspoint-2-6,wifiaccesspoint-2-25,wifiaccesspoint-2-24,wifiaccesspoint-2-27,wifiaccesspoint-2-26,wifiaccesspoint-2-21,wifiaccesspoint-2-20,wifiaccesspoint-2-23,wifiaccesspoint-2-22,wifiaccesspoint-2-29,wifiaccesspoint-2-28,wifiaccesspoint-9-6,wifiaccesspoint-9-5,wifiaccesspoint-9-3,wifiaccesspoint-9-9,wifiaccesspoint-9-8,wifiaccesspoint-9-7,wifiaccesspoint-8-10,wifiaccesspoint-1-2,wifiaccesspoint-8-11,wifiaccesspoint-1-1,wifiaccesspoint-8-12,wifiaccesspoint-8-13,wifiaccesspoint-8-14,wifiaccesspoint-1-6,wifiaccesspoint-1-5,wifiaccesspoint-1-4,wifiaccesspoint-1-3,wifiaccesspoint-9-2,wifiaccesspoint-9-1,wifiaccesspoint-1-9,wifiaccesspoint-1-8,wifiaccesspoint-1-7,wifiaccesspoint-4-28,wifiaccesspoint-4-29,wifiaccesspoint-4-26,wifiaccesspoint-4-27,wifiaccesspoint-4-24,wifiaccesspoint-4-22,wifiaccesspoint-4-21,wifiaccesspoint-8-7,wifiaccesspoint-2-14,wifiaccesspoint-8-6,wifiaccesspoint-2-13,wifiaccesspoint-4-9,wifiaccesspoint-8-5,wifiaccesspoint-2-16,wifiaccesspoint-4-8,wifiaccesspoint-2-15,wifiaccesspoint-8-4,wifiaccesspoint-2-10,wifiaccesspoint-4-35,wifiaccesspoint-4-36,wifiaccesspoint-4-33,wifiaccesspoint-8-9,wifiaccesspoint-2-12,wifiaccesspoint-4-34,wifiaccesspoint-8-8,wifiaccesspoint-2-11,wifiaccesspoint-4-31,wifiaccesspoint-4-32,wifiaccesspoint-4-3,wifiaccesspoint-4-2,wifiaccesspoint-4-1,wifiaccesspoint-8-3,wifiaccesspoint-2-18,wifiaccesspoint-4-6,wifiaccesspoint-8-2,wifiaccesspoint-2-17,wifiaccesspoint-4-5,wifiaccesspoint-8-1,wifiaccesspoint-2-19,metric_id=BuildingOccupancy_Facility. Set TenantConfig.upsert({id:'TSDeclObjsLimit',value:YOUR_MAX_INTEGER_VALUE}) and retry.\n\tat c3.service.metric.AsTimeseriesGroup.optimize(AsTimeseriesGroup.java:429)\n\tat c3.service.metric.AsTimeseriesGroup.fetchObjs(AsTimeseriesGroup.java:482)\n\tat c3.service.metric.AsTimeseriesGroup.evaluate(AsTimeseriesGroup.java:190)\n\tat c3.service.metric.AsTimeseriesOptimizer.evaluate(AsTimeseriesOptimizer.java:81)\n\tat c3.service.metric.AsTimeseries.getEvalResult(AsTimeseries.java:114)\n\tat c3.service.metric.AsTimeseries.asTimeseries(AsTimeseries.java:46)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateAsTimeseriesBasedMetric(SimpleMetricEvaluator.java:558)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:550)\n\tat c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:306)\n\tat c3.service.metric.MetricEvaluatableOld.lambda$computeResultsFromHierarchies$1(MetricEvaluatableOld.java:160)\n\tat c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:168)\n\tat c3.service.metric.MetricEvaluatableOld.computeResultsFromHierarchies(MetricEvaluatableOld.java:160)\n\tat c3.service.metric.MetricEvaluatableOld.eval(MetricEvaluatableOld.java:112)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.timeseries.impl.TimeseriesMath.eval(TimeseriesMath.java:563)\n\tat c3.love.timeseries.Timeseries.eval(Timeseries.java:657)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$eval$81(TsFuncLib.java:1017)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)\n\tat c3.love.expr.bytecode.Expr_7214899690045853356_6908768206845336299.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:878)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:632)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:846)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:216)\n\tat sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)\n\tat c3.server.impl.Task.doFilter(Task.java:242)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:82)\n\tat c3.server.impl.Task.run(Task.java:178)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n \nSimple Metric Evaluation failed. metric=BuildingOccupancy,srcId=0082,srcType=Facility,start=2018-01-01T00:00:00.000,end=2020-01-01T00:00:00.000,interval=HOUR,because=AsTimeseriesGroup: Fetch exceeded max allowed data points for dpType=WifiConnectedDeviceMeasurement,current_max_allowed=300000,header_type=WifiAccessPoint,header_ids=wifiaccesspoint-1-13,wifiaccesspoint-1-12,wifiaccesspoint-1-15,wifiaccesspoint-1-14,wifiaccesspoint-1-11,wifiaccesspoint-1-10,wifiaccesspoint-9-10,wifiaccesspoint-9-11,wifiaccesspoint-9-12,wifiaccesspoint-9-13,wifiaccesspoint-9-14,wifiaccesspoint-9-15,wifiaccesspoint-9-16,wifiaccesspoint-9-17,wifiaccesspoint-9-18,wifiaccesspoint-9-19,wifiaccesspoint-1-17,wifiaccesspoint-1-16,wifiaccesspoint-1-19,wifiaccesspoint-1-18,wifiaccesspoint-1-24,wifiaccesspoint-1-23,wifiaccesspoint-1-26,wifiaccesspoint-3-9,wifiaccesspoint-1-25,wifiaccesspoint-4m-10,wifiaccesspoint-4-13,wifiaccesspoint-1-20,wifiaccesspoint-4-14,wifiaccesspoint-4m-11,wifiaccesspoint-4-11,wifiaccesspoint-1-22,wifiaccesspoint-4m-12,wifiaccesspoint-1-21,wifiaccesspoint-4m-13,wifiaccesspoint-9-21,wifiaccesspoint-9-22,wifiaccesspoint-9-23,wifiaccesspoint-9-25,wifiaccesspoint-9-26,wifiaccesspoint-3-4,wifiaccesspoint-9-27,wifiaccesspoint-3-3,wifiaccesspoint-3-2,wifiaccesspoint-3-1,wifiaccesspoint-3-8,wifiaccesspoint-1-28,wifiaccesspoint-1-27,wifiaccesspoint-3-7,wifiaccesspoint-3-6,wifiaccesspoint-4-19,wifiaccesspoint-3-5,wifiaccesspoint-7-1,wifiaccesspoint-3-12,wifiaccesspoint-3-13,wifiaccesspoint-3-10,wifiaccesspoint-3-11,wifiaccesspoint-g-3,wifiaccesspoint-g-2,wifiaccesspoint-g-1,wifiaccesspoint-4m-4,wifiaccesspoint-4m-3,wifiaccesspoint-4m-2,wifiaccesspoint-4m-1,wifiaccesspoint-2-5,wifiaccesspoint-2-4,wifiaccesspoint-2-3,wifiaccesspoint-4m-9,wifiaccesspoint-2-2,wifiaccesspoint-4m-8,wifiaccesspoint-2-9,wifiaccesspoint-2-8,wifiaccesspoint-4m-7,wifiaccesspoint-4m-6,wifiaccesspoint-2-7,wifiaccesspoint-4m-5,wifiaccesspoint-2-6,wifiaccesspoint-2-25,wifiaccesspoint-2-24,wifiaccesspoint-2-27,wifiaccesspoint-2-26,wifiaccesspoint-2-21,wifiaccesspoint-2-20,wifiaccesspoint-2-23,wifiaccesspoint-2-22,wifiaccesspoint-2-29,wifiaccesspoint-2-28,wifiaccesspoint-9-6,wifiaccesspoint-9-5,wifiaccesspoint-9-3,wifiaccesspoint-9-9,wifiaccesspoint-9-8,wifiaccesspoint-9-7,wifiaccesspoint-8-10,wifiaccesspoint-1-2,wifiaccesspoint-8-11,wifiaccesspoint-1-1,wifiaccesspoint-8-12,wifiaccesspoint-8-13,wifiaccesspoint-8-14,wifiaccesspoint-1-6,wifiaccesspoint-1-5,wifiaccesspoint-1-4,wifiaccesspoint-1-3,wifiaccesspoint-9-2,wifiaccesspoint-9-1,wifiaccesspoint-1-9,wifiaccesspoint-1-8,wifiaccesspoint-1-7,wifiaccesspoint-4-28,wifiaccesspoint-4-29,wifiaccesspoint-4-26,wifiaccesspoint-4-27,wifiaccesspoint-4-24,wifiaccesspoint-4-22,wifiaccesspoint-4-21,wifiaccesspoint-8-7,wifiaccesspoint-2-14,wifiaccesspoint-8-6,wifiaccesspoint-2-13,wifiaccesspoint-4-9,wifiaccesspoint-8-5,wifiaccesspoint-2-16,wifiaccesspoint-4-8,wifiaccesspoint-2-15,wifiaccesspoint-8-4,wifiaccesspoint-2-10,wifiaccesspoint-4-35,wifiaccesspoint-4-36,wifiaccesspoint-4-33,wifiaccesspoint-8-9,wifiaccesspoint-2-12,wifiaccesspoint-4-34,wifiaccesspoint-8-8,wifiaccesspoint-2-11,wifiaccesspoint-4-31,wifiaccesspoint-4-32,wifiaccesspoint-4-3,wifiaccesspoint-4-2,wifiaccesspoint-4-1,wifiaccesspoint-8-3,wifiaccesspoint-2-18,wifiaccesspoint-4-6,wifiaccesspoint-8-2,wifiaccesspoint-2-17,wifiaccesspoint-4-5,wifiaccesspoint-8-1,wifiaccesspoint-2-19,metric_id=BuildingOccupancy_Facility. Set TenantConfig.upsert({id:'TSDeclObjsLimit',value:YOUR_MAX_INTEGER_VALUE}) and retry.\n\tat c3.service.metric.MetricUtilsOld.throwError(MetricUtilsOld.java:635)\n\tat c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:170)\n\tat c3.service.metric.MetricEvaluatableOld.computeResultsFromHierarchies(MetricEvaluatableOld.java:160)\n\tat c3.service.metric.MetricEvaluatableOld.eval(MetricEvaluatableOld.java:112)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.timeseries.impl.TimeseriesMath.eval(TimeseriesMath.java:563)\n\tat c3.love.timeseries.Timeseries.eval(Timeseries.java:657)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$eval$81(TsFuncLib.java:1017)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)\n\tat c3.love.expr.bytecode.Expr_7214899690045853356_6908768206845336299.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:878)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:632)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:846)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:216)\n\tat sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)\n\tat c3.server.impl.Task.doFilter(Task.java:242)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:82)\n\tat c3.server.impl.Task.run(Task.java:178)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n\nsrcId=0082\nsrcId=0082

What’s wrong here?

0 Likes

Useful TenantConfig keys
#2

@bachr if you look at the error message, it should be self explanatory. It says maximum number of points allowed for this TSDecl fetch has exceeded the max number of points allowed. Default is 300k

The reason for the limit is for the system to avoid OOM errors. If you want to raise this limit, as the error message suggests you can do:
Set

TenantConfig.upsert({id:'TSDeclObjsLimit',value:YOUR_MAX_INTEGER_VALUE})
1 Like

#3

It was a terrible idea using TSDecl in the first place, I managed to rewrite the metric and leveraging normalization, now the metric evaluation is blazing fast :rocket:

0 Likes

#4

@rohit.sureka is that limit on the amount of data points within the specified timeframe for the metric evaluation or the amount of data points in the timeseries associated with that parent.id? we have tried setting the timeframe for the metric eval to 1 second and we are still experiencing this error

0 Likes

#5

Its the total number of points fetched as a result of the logical time series headers it ends up touching, irrespective of the time range queried as of now.

0 Likes