Permissions for evalMetrics & Normalization


#1

Does having permissions for evalMetrics() also include permissions to normalize time series?

Currently have these evalMetrics-related permissions included in a Role,
“allow:::evalMetric",
"allow:
::evalMetrics”,
“allow:*::evalMetricsWithMetadata”,

But I receive errors when running an evalMetric that requires normalization. The error references a normalization issue. Screenshot here:

Thus, adding "allow:Normalization::", and/or "NormalizedTimeseries:: should resolve the issue.

Why I would need to add this? My understanding is that adding evalMetric permissions would already allow one to also normalize time series.


#2

Adding: this is happening in 7.8.1.3547-1.


#3

What is the full stack of the error? What you posted above does not indicate it being a ‘permissions’ issue.


#4

True, I’m able to execute the evalMetrics call while in with other AdminGroups, such as Developer and Debugger. For this specific case (a DataScienceGroup only able to access Jupyter), I am unable to.

Here’s the first half of the error stack (community has a char limit). Let me know if you’d like the other half.
“”"
Error: c3.love.exceptions.C3RuntimeException: c3.love.exceptions.C3RuntimeException: MetricEngine error : c3.love.exceptions.C3RuntimeException: Error c3.engine.database.DbException: Internal error: Error in TimeRangeUpdatedHandler: ↵ at c3.engine.database.DbException.timeRangeUpdatedHandlerException(DbException.java:172)↵ at c3.engine.database.async.invalidation.NormalizationInvalidator.throwException(NormalizationInvalidator.java:111)↵ at c3.engine.database.async.invalidation.AbstractInvalidator.call(AbstractInvalidator.java:111)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invokeInvalidator(InvalidatorUtil.java:361)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.callInvalidators(InvalidatorUtil.java:184)↵ at c3.engine.database.timeseries.normn.TriggerTimeseriesNormalizationTask.call(TriggerTimeseriesNormalizationTask.java:64)↵ at c3.engine.database.timeseries.normn.TriggerTimeseriesNormalizationTask.call(TriggerTimeseriesNormalizationTask.java:32)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1493)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:364)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.timeseries.TimeseriesUtils.normalizeTimeseries(TimeseriesUtils.java:1125)↵ at c3.love.timeseries.TimeseriesUtils.triggerNormalizeTimeseries(TimeseriesUtils.java:1109)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.evaluate(FetchNormalizedDataTask.java:222)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:171)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:90)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1493)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:364)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.expr.DataLoaderImpl.fetchNormalizedTs(DataLoaderImpl.java:148)↵ at c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:124)↵ at c3.love.expr.DataLoaderImpl.getNormalizedData(DataLoaderImpl.java:382)↵ at c3.love.expr.eval.EvalVisitor.processTimeseriesNodes(EvalVisitor.java:830)↵ at c3.love.expr.eval.EvalVisitor.processTimeseriesContext(EvalVisitor.java:918)↵ at c3.love.expr.eval.EvalVisitor.visitNameOrKeywordNode(EvalVisitor.java:1037)↵ at c3.love.expr.graph.AstNodeVisitor.visitNameNode(AstNodeVisitor.java:171)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:72)↵ at c3.love.expr.eval.EvalVisitor.visitGetPropNode(EvalVisitor.java:1119)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:80)↵ at c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:618)↵ at c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:420)↵ at c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:360)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)↵ at c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:618)↵ at c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:420)↵ at c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:360)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)↵ at c3.love.expr.eval.EvalVisitor.evaluateExpression(EvalVisitor.java:128)↵ at c3.love.expr.eval.EvalFacade.evalExprWithBindings(EvalFacade.java:201)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:597)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:548)↵ 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$$Lambda$627/1725674477.get(Unknown Source)↵ 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.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$ternaryForEvaluatableCondition$66(TsFuncLib.java:846)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$624/1687607464.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.CompiledExpr$$Lambda$625/1487579051.accept(Unknown Source)↵ at java.lang.Iterable.forEach(Iterable.java:75)↵ at c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.Expr_7460201085417636252_8340249756999787846.eval(Unknown Source)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:870)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:631)↵ at c3.service.metric.EvalMetricsResultOvi$ResultMappIterator.next(EvalMetricsResultOvi.java:113)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readValue(ValueReader.java:89)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:294)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:284)↵ at c3.love.typesys.obj.ObjImpl.fromFields(ObjImpl.java:65)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readObj(ValueReader.java:134)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:84)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:26)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:35)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:29)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:290)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:280)↵ at c3.love.impl.ActionImpl.collect(ActionImpl.java:740)↵ at c3.love.impl.ActionImpl.setResultStream(ActionImpl.java:1144)↵ at c3.service.metric.MetricEngine.evalMetrics(MetricEngine.java:227)↵ at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)↵ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)↵ at java.lang.reflect.Method.invoke(Method.java:497)↵ at c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)↵ at c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)↵ at java.util.concurrent.FutureTask.run(FutureTask.java:266)↵ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)↵ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)↵ at java.lang.Thread.run(Thread.java:745)↵Caused by: c3.server.authz.NotAuthorizedException: User ‘arthur.liou@c3iot.com’ (Identity arthur.liou@c3iot.com) is not authorized to access Target [coned/prod/NormalizationQueue?action=isDisabled], roles: [DefaultAccessRole, C3.Role.ReadAll, C3.Role.Console, ConedDataScienceRole], pagegroups: []↵ at c3.server.authz.NotAuthorizedException.create(NotAuthorizedException.java:35)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:224)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:192)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:367)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.C3.dispatchWithArgs(C3.java:740)↵ at c3.love.C3.dispatch(C3.java:705)↵ at c3.love.C3.dispatch(C3.java:701)↵ at c3.type.async.InvalidationQueue$Subclass.isDisabled(InvalidationQueue.java:568)↵ at c3.engine.database.async.InvalidationQueueMethods.invalidate(InvalidationQueueMethods.java:145)↵ at c3.type.async.methods.InvalidationQueueMethodsBase$1.accept(InvalidationQueueMethodsBase.java:58)↵ at c3.type.async.methods.InvalidationQueueMethodsBase$1.accept(InvalidationQueueMethodsBase.java:56)↵ at c3.server.engine.TypeSysEngine.execute(TypeSysEngine.java:65)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.C3.dispatchWithArgs(C3.java:740)↵ at c3.love.C3.dispatch(C3.java:705)↵ at c3.love.C3.dispatch(C3.java:701)↵ at c3.type.async.NormalizationQueue.invalidate(NormalizationQueue.java:80)↵ at c3.engine.database.async.invalidation.InvalidatorUtil$NormalizationInvalidatorHelper.invalidateBatch(InvalidatorUtil.java:1211)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.lambda$invalidate$7(InvalidatorUtil.java:856)↵ at c3.engine.database.async.invalidation.InvalidatorUtil$$Lambda$641/834193112.accept(Unknown Source)↵ at c3.love.typesys.Stream.each(Stream.java:881)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invalidate(InvalidatorUtil.java:846)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invalidateNormalization(InvalidatorUtil.java:681)↵ at c3.engine.database.async.invalidation.NormalizationInvalidator.handle(NormalizationInvalidator.java:71)↵ at c3.engine.database.async.invalidation.AbstractInvalidator.call(AbstractInvalidator.java:109)↵ … 110 more↵,msg Failed to eval expression with bindings for srcId: 100003561528,srcId=100003561528,srcType=BillingAccount,metric=MDMElectricityConsumptionInterval,start=2018-06-07T22:00:00.000,end=2018-07-07T22:00:00.000↵ at c3.service.metric.SimpleMetricEvaluator.throwError(SimpleMetricEvaluator.java:677)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:603)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:548)↵ 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$$Lambda$627/1725674477.get(Unknown Source)↵ 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.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$ternaryForEvaluatableCondition$66(TsFuncLib.java:846)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$624/1687607464.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.CompiledExpr$$Lambda$625/1487579051.accept(Unknown Source)↵ at java.lang.Iterable.forEach(Iterable.java:75)↵ at c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.Expr_7460201085417636252_8340249756999787846.eval(Unknown Source)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:870)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:631)↵ at c3.service.metric.EvalMetricsResultOvi$ResultMappIterator.next(EvalMetricsResultOvi.java:113)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readValue(ValueReader.java:89)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:294)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:284)↵ at c3.love.typesys.obj.ObjImpl.fromFields(ObjImpl.java:65)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readObj(ValueReader.java:134)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:84)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:26)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:35)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:29)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:290)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:280)↵ at c3.love.impl.ActionImpl.collect(ActionImpl.java:740)↵ at c3.love.impl.ActionImpl.setResultStream(ActionImpl.java:1144)↵ at c3.service.metric.MetricEngine.evalMetrics(MetricEngine.java:227)↵ at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)↵ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)↵ at java.lang.reflect.Method.invoke(Method.java:497)↵ at c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)↵ at c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)↵ at java.util.concurrent.FutureTask.run(FutureTask.java:266)↵ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)↵ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)↵ at java.lang.Thread.run(Thread.java:745)↵ ↵Simple Metric Evaluation failed. metric=MDMElectricityConsumptionInterval,srcId=100003561528,srcType=BillingAccount,start=2018-06-07T22:00:00.000,end=2018-07-07T22:00:00.000,interval=HOUR,because=Error c3.engine.database.DbException: Internal error: Error in TimeRangeUpdatedHandler: ↵ at c3.engine.database.DbException.timeRangeUpdatedHandlerException(DbException.java:172)↵ at c3.engine.database.async.invalidation.NormalizationInvalidator.throwException(NormalizationInvalidator.java:111)↵ at c3.engine.database.async.invalidation.AbstractInvalidator.call(AbstractInvalidator.java:111)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invokeInvalidator(InvalidatorUtil.java:361)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.callInvalidators(InvalidatorUtil.java:184)↵ at c3.engine.database.timeseries.normn.TriggerTimeseriesNormalizationTask.call(TriggerTimeseriesNormalizationTask.java:64)↵ at c3.engine.database.timeseries.normn.TriggerTimeseriesNormalizationTask.call(TriggerTimeseriesNormalizationTask.java:32)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1493)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:364)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.timeseries.TimeseriesUtils.normalizeTimeseries(TimeseriesUtils.java:1125)↵ at c3.love.timeseries.TimeseriesUtils.triggerNormalizeTimeseries(TimeseriesUtils.java:1109)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.evaluate(FetchNormalizedDataTask.java:222)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:171)↵ at c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:90)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1493)↵ at c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:364)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.expr.DataLoaderImpl.fetchNormalizedTs(DataLoaderImpl.java:148)↵ at c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:124)↵ at c3.love.expr.DataLoaderImpl.getNormalizedData(DataLoaderImpl.java:382)↵ at c3.love.expr.eval.EvalVisitor.processTimeseriesNodes(EvalVisitor.java:830)↵ at c3.love.expr.eval.EvalVisitor.processTimeseriesContext(EvalVisitor.java:918)↵ at c3.love.expr.eval.EvalVisitor.visitNameOrKeywordNode(EvalVisitor.java:1037)↵ at c3.love.expr.graph.AstNodeVisitor.visitNameNode(AstNodeVisitor.java:171)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:72)↵ at c3.love.expr.eval.EvalVisitor.visitGetPropNode(EvalVisitor.java:1119)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:80)↵ at c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:618)↵ at c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:420)↵ at c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:360)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)↵ at c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:618)↵ at c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:420)↵ at c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:360)↵ at c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)↵ at c3.love.expr.eval.EvalVisitor.evaluateExpression(EvalVisitor.java:128)↵ at c3.love.expr.eval.EvalFacade.evalExprWithBindings(EvalFacade.java:201)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:597)↵ at c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:548)↵ 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$$Lambda$627/1725674477.get(Unknown Source)↵ 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.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$ternaryForEvaluatableCondition$66(TsFuncLib.java:846)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$624/1687607464.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.CompiledExpr$$Lambda$625/1487579051.accept(Unknown Source)↵ at java.lang.Iterable.forEach(Iterable.java:75)↵ at c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.Expr_7460201085417636252_8340249756999787846.eval(Unknown Source)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:870)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:631)↵ at c3.service.metric.EvalMetricsResultOvi$ResultMappIterator.next(EvalMetricsResultOvi.java:113)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readValue(ValueReader.java:89)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:294)↵ at c3.love.typesys.obj.pipe.ser.ValueReader$2.next(ValueReader.java:284)↵ at c3.love.typesys.obj.ObjImpl.fromFields(ObjImpl.java:65)↵ at c3.love.typesys.obj.pipe.ser.ValueReader.readObj(ValueReader.java:134)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:84)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.next(ObjReader.java:26)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:35)↵ at c3.love.typesys.obj.pipe.ser.ObjReader.readObj(ObjReader.java:29)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:290)↵ at c3.love.typesys.obj.pipe.Pipeline.collectAsObj(Pipeline.java:280)↵ at c3.love.impl.ActionImpl.collect(ActionImpl.java:740)↵ at c3.love.impl.ActionImpl.setResultStream(ActionImpl.java:1144)↵ at c3.service.metric.MetricEngine.evalMetrics(MetricEngine.java:227)↵ at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)↵ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)↵ at java.lang.reflect.Method.invoke(Method.java:497)↵ at c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:427)↵ at c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:360)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)↵ at java.util.concurrent.FutureTask.run(FutureTask.java:266)↵ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)↵ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)↵ at java.lang.Thread.run(Thread.java:745)↵Caused by: c3.server.authz.NotAuthorizedException: User ‘arthur.liou@c3iot.com’ (Identity arthur.liou@c3iot.com) is not authorized to access Target [coned/prod/NormalizationQueue?action=isDisabled], roles: [DefaultAccessRole, C3.Role.ReadAll, C3.Role.Console, ConedDataScienceRole], pagegroups: []↵ at c3.server.authz.NotAuthorizedException.create(NotAuthorizedException.java:35)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:224)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:192)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:367)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.C3.dispatchWithArgs(C3.java:740)↵ at c3.love.C3.dispatch(C3.java:705)↵ at c3.love.C3.dispatch(C3.java:701)↵ at c3.type.async.InvalidationQueue$Subclass.isDisabled(InvalidationQueue.java:568)↵ at c3.engine.database.async.InvalidationQueueMethods.invalidate(InvalidationQueueMethods.java:145)↵ at c3.type.async.methods.InvalidationQueueMethodsBase$1.accept(InvalidationQueueMethodsBase.java:58)↵ at c3.type.async.methods.InvalidationQueueMethodsBase$1.accept(InvalidationQueueMethodsBase.java:56)↵ at c3.server.engine.TypeSysEngine.execute(TypeSysEngine.java:65)↵ at c3.server.impl.Task.doFilter(Task.java:243)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:193)↵ at c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:125)↵ at c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:191)↵ at c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:161)↵ at c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:81)↵ at c3.server.impl.Task.run(Task.java:179)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:400)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.C3.dispatchWithArgs(C3.java:740)↵ at c3.love.C3.dispatch(C3.java:705)↵ at c3.love.C3.dispatch(C3.java:701)↵ at c3.type.async.NormalizationQueue.invalidate(NormalizationQueue.java:80)↵ at c3.engine.database.async.invalidation.InvalidatorUtil$NormalizationInvalidatorHelper.invalidateBatch(InvalidatorUtil.java:1211)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.lambda$invalidate$7(InvalidatorUtil.java:856)↵ at c3.engine.database.async.invalidation.InvalidatorUtil$$Lambda$641/834193112.accept(Unknown Source)↵ at c3.love.typesys.Stream.each(Stream.java:881)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invalidate(InvalidatorUtil.java:846)↵ at c3.engine.database.async.invalidation.InvalidatorUtil.invalidateNormalization(InvalidatorUtil.java:681)↵ at c3.engine.database.async.invalidation.NormalizationInvalidator.handle(NormalizationInvalidator.java:71)↵ at c3.engine.database.async.invalidation.AbstractInvalidator.call(AbstractInvalidator.java:109)↵ … 110 more↵,msg Failed to eval expression with bindings for srcId: 100003561528,srcId=100003561528,srcType=BillingAccount,metric=MDMElectricityConsumptionInterval,start=2018-06-07T22:00:00.000,end=2018-07-07T22:00:00.000↵ at c3.service.metric.MetricUtilsOld.throwError(MetricUtilsOld.java:635)↵ at c3.service.metric.MetricEvaluatableOld.compute(MetricEvaluatableOld.java:170)↵ 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.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$ternaryForEvaluatableCondition$66(TsFuncLib.java:846)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$624/1687607464.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.TsFuncLib.lambda$cache$129(TsFuncLib.java:1597)↵ at c3.love.expr.bytecode.TsFuncLib$$Lambda$623/2044434686.eval(Unknown Source)↵ at c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.CompiledExpr$$Lambda$625/1487579051.accept(Unknown Source)↵ at java.lang.Iterable.forEach(Iterable.java:75)↵ at c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:214)↵ at c3.love.expr.bytecode.Expr_7460201085417636252_8340249756999787846.eval(Unknown Source)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:870)↵ at c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:631)↵ at c3.service.metric.EvalMetricsResultOvi$ResultMappIterator.next(EvalMetricsResultOvi.java:113)↵ at
“”"


#5

here it is:
Caused by: c3.server.authz.NotAuthorizedException: User ‘arthur.liou@c3iot.com’ (Identity arthur.liou@c3iot.com) is not authorized to access Target [coned/prod/NormalizationQueue?action=isDisabled], roles: [DefaultAccessRole, C3.Role.ReadAll, C3.Role.Console, ConedDataScienceRole], pagegroups: []↵ at c3.server.authz.NotAuthorizedException.create(NotAuthorizedException.java:35)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:224)↵ at c3.server.authz.AccessAuthorizerImpl.authorizeAction(AccessAuthorizerImpl.java:192)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:367)↵ at c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:306)↵ at c3.love.C3.dispatch(C3.java:660)↵ at c3.love.C3.dispatchWithArgs(C3.java:740)↵ at c3.love.C3.dispatch(C3.java:705)↵ at c3.love.C3.dispatch(C3.java:701)↵ at c3.type.async.InvalidationQueue$Subclass.isDisabled(InvalidationQueue.java:568)↵ at

It is due to a bug which has since been fixed. I will give you the build number.


#6

Should have been fixed in build 7.8.1.2606, What environment is this?