fetchNormalizedData failed : Invalid Input is not aligned to interval

#1

I’ve RegisterMeasurementSeries with an interval set to QUARTER_HOUR. When I try to

BasePhysicalMeasurementSeries.evalMetric({"interval":"DAY","start":"2016-08-31T22:00:00.000Z","end":"2018-02-21T23:00:00.000Z","include":"start, end, interval, count, dates, data, timeZone, unit, missing","id":"some-id","expression":"some-compound-metric"})

I get the following error message:

DataLoaderImpl Error : Call to fetchNormalizedData failed : Invalid Input : start: '2018-01-26T11:00:08.000' is not aligned to interval : 'QUARTER_HOUR'

Here is the error full stack:

c3.love.exceptions.C3RuntimeException: c3.love.exceptions.C3RuntimeException: MetricEngine error : c3.love.exceptions.C3RuntimeException: Error c3.love.exceptions.C3RuntimeException: DataLoaderImpl Error : Call to fetchNormalizedData failed : Invalid Input : start: '2018-01-26T11:00:08.000' is not aligned to interval : 'QUARTER_HOUR'\n\tat c3.love.expr.DataLoaderImpl.throwError(DataLoaderImpl.java:103)\n\tat c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:135)\n\tat c3.love.expr.DataLoaderImpl.getNormalizedData(DataLoaderImpl.java:368)\n\tat c3.love.expr.eval.EvalVisitor.processTimeseriesNodes(EvalVisitor.java:813)\n\tat c3.love.expr.eval.EvalVisitor.processTimeseriesContext(EvalVisitor.java:901)\n\tat c3.love.expr.eval.EvalVisitor.visitNameOrKeywordNode(EvalVisitor.java:1016)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNameNode(AstNodeVisitor.java:171)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:72)\n\tat c3.love.expr.eval.EvalVisitor.visitGetPropNode(EvalVisitor.java:1098)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:80)\n\tat c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:602)\n\tat c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:411)\n\tat c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:351)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)\n\tat c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:602)\n\tat c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:411)\n\tat c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:351)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)\n\tat c3.love.expr.eval.EvalVisitor.visitConditionalExprNode(EvalVisitor.java:303)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:63)\n\tat c3.love.expr.eval.EvalVisitor.evaluateExpression(EvalVisitor.java:122)\n\tat c3.love.expr.eval.EvalFacade.evalExprWithBindings(EvalFacade.java:188)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:577)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:528)\n\tat c3.service.metric.MetricEvaluatable.compute(MetricEvaluatable.java:296)\n\tat c3.service.metric.MetricEvaluatable.computeResultsFromHierarchies(MetricEvaluatable.java:159)\n\tat c3.service.metric.MetricEvaluatable.eval(MetricEvaluatable.java:108)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$123(TsFuncLib.java:1406)\n\tat c3.love.expr.bytecode.TsFuncLib$$Lambda$104/999654168.eval(Unknown Source)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.CompiledExpr$$Lambda$105/1934820946.accept(Unknown Source)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.Expr_5421310909665396526_7000755580296137922.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:902)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:660)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:870)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:381)\n\tat sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:422)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:355)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\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:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\nCaused by: c3.love.exceptions.C3RuntimeException: Invalid Input : start: '2018-01-26T11:00:08.000' is not aligned to interval : 'QUARTER_HOUR'\n\tat c3.love.timeseries.impl.TimeInfoImpl.throwError(TimeInfoImpl.java:187)\n\tat c3.love.timeseries.impl.TimeInfoImpl.dflt(TimeInfoImpl.java:180)\n\tat c3.love.timeseries.impl.TimeInfoImpl.make(TimeInfoImpl.java:39)\n\tat c3.love.timeseries.impl.TimeInfoImpl.fromTimeseriesObj(TimeInfoImpl.java:150)\n\tat c3.love.timeseries.TimeInfo.fromTimeseriesObj(TimeInfo.java:200)\n\tat c3.love.timeseries.impl.TimeseriesInfoImpl.fromTimeseriesObj(TimeseriesInfoImpl.java:74)\n\tat c3.love.timeseries.impl.TimeseriesFactory.fromObj(TimeseriesFactory.java:49)\n\tat c3.love.timeseries.Timeseries.fromObj(Timeseries.java:687)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getTimeseriesFromCustomNormalizer(NormalizedDataPersister.java:193)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getCustomNormalizedTimeseries(NormalizedDataPersister.java:212)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getNormalizedTimeseries(NormalizedDataPersister.java:122)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.persistNormalizedTimeseries(NormalizedDataPersister.java:175)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.process(NormalizedDataPersister.java:116)\n\tat c3.engine.database.timeseries.normn.NTTask.processNormalizedValues(NTTask.java:449)\n\tat c3.engine.database.timeseries.normn.NTTask.normalize(NTTask.java:234)\n\tat c3.engine.database.timeseries.normn.NTTask.normalizeTimeseries(NTTask.java:155)\n\tat c3.engine.database.timeseries.normn.NTTask.call(NTTask.java:130)\n\tat c3.engine.database.timeseries.normn.NTTask.call(NTTask.java:78)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1348)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:335)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:370)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:283)\n\tat c3.love.dbfacade.DbFacade.dispatch(DbFacade.java:666)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.normalize(FetchNormalizedDataTask.java:1361)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.evaluate(FetchNormalizedDataTask.java:219)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:169)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:93)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1348)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:335)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:370)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:283)\n\tat c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:133)\n\t... 53 more\n,msg Failed to eval expression with bindings for srcId: 03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A,srcId=03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A\n\tat c3.service.metric.SimpleMetricEvaluator.throwError(SimpleMetricEvaluator.java:670)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:583)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:528)\n\tat c3.service.metric.MetricEvaluatable.compute(MetricEvaluatable.java:296)\n\tat c3.service.metric.MetricEvaluatable.computeResultsFromHierarchies(MetricEvaluatable.java:159)\n\tat c3.service.metric.MetricEvaluatable.eval(MetricEvaluatable.java:108)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$123(TsFuncLib.java:1406)\n\tat c3.love.expr.bytecode.TsFuncLib$$Lambda$104/999654168.eval(Unknown Source)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.CompiledExpr$$Lambda$105/1934820946.accept(Unknown Source)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.Expr_5421310909665396526_7000755580296137922.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:902)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:660)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:870)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:381)\n\tat sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:422)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:355)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\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:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\n \nSimple Metric Evaluation failed. metric=GenericSensor,srcId=03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A,srcType=BasePhysicalMeasurementSeries,start=2016-08-31T00:00:00.000,end=2018-02-22T00:00:00.000,interval=DAY,because=Error c3.love.exceptions.C3RuntimeException: DataLoaderImpl Error : Call to fetchNormalizedData failed : Invalid Input : start: '2018-01-26T11:00:08.000' is not aligned to interval : 'QUARTER_HOUR'\n\tat c3.love.expr.DataLoaderImpl.throwError(DataLoaderImpl.java:103)\n\tat c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:135)\n\tat c3.love.expr.DataLoaderImpl.getNormalizedData(DataLoaderImpl.java:368)\n\tat c3.love.expr.eval.EvalVisitor.processTimeseriesNodes(EvalVisitor.java:813)\n\tat c3.love.expr.eval.EvalVisitor.processTimeseriesContext(EvalVisitor.java:901)\n\tat c3.love.expr.eval.EvalVisitor.visitNameOrKeywordNode(EvalVisitor.java:1016)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNameNode(AstNodeVisitor.java:171)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:72)\n\tat c3.love.expr.eval.EvalVisitor.visitGetPropNode(EvalVisitor.java:1098)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:80)\n\tat c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:602)\n\tat c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:411)\n\tat c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:351)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)\n\tat c3.love.expr.eval.EvalVisitor.evalArgs(EvalVisitor.java:602)\n\tat c3.love.expr.eval.EvalVisitor.evaluateFunctionCall(EvalVisitor.java:411)\n\tat c3.love.expr.eval.EvalVisitor.visitCallNode(EvalVisitor.java:351)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:96)\n\tat c3.love.expr.eval.EvalVisitor.visitConditionalExprNode(EvalVisitor.java:303)\n\tat c3.love.expr.graph.AstNodeVisitor.visitNode(AstNodeVisitor.java:63)\n\tat c3.love.expr.eval.EvalVisitor.evaluateExpression(EvalVisitor.java:122)\n\tat c3.love.expr.eval.EvalFacade.evalExprWithBindings(EvalFacade.java:188)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateExpressionBasedMetric(SimpleMetricEvaluator.java:577)\n\tat c3.service.metric.SimpleMetricEvaluator.evaluateMetric(SimpleMetricEvaluator.java:528)\n\tat c3.service.metric.MetricEvaluatable.compute(MetricEvaluatable.java:296)\n\tat c3.service.metric.MetricEvaluatable.computeResultsFromHierarchies(MetricEvaluatable.java:159)\n\tat c3.service.metric.MetricEvaluatable.eval(MetricEvaluatable.java:108)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$123(TsFuncLib.java:1406)\n\tat c3.love.expr.bytecode.TsFuncLib$$Lambda$104/999654168.eval(Unknown Source)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.CompiledExpr$$Lambda$105/1934820946.accept(Unknown Source)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.Expr_5421310909665396526_7000755580296137922.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:902)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:660)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:870)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:381)\n\tat sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:422)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:355)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\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:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\nCaused by: c3.love.exceptions.C3RuntimeException: Invalid Input : start: '2018-01-26T11:00:08.000' is not aligned to interval : 'QUARTER_HOUR'\n\tat c3.love.timeseries.impl.TimeInfoImpl.throwError(TimeInfoImpl.java:187)\n\tat c3.love.timeseries.impl.TimeInfoImpl.dflt(TimeInfoImpl.java:180)\n\tat c3.love.timeseries.impl.TimeInfoImpl.make(TimeInfoImpl.java:39)\n\tat c3.love.timeseries.impl.TimeInfoImpl.fromTimeseriesObj(TimeInfoImpl.java:150)\n\tat c3.love.timeseries.TimeInfo.fromTimeseriesObj(TimeInfo.java:200)\n\tat c3.love.timeseries.impl.TimeseriesInfoImpl.fromTimeseriesObj(TimeseriesInfoImpl.java:74)\n\tat c3.love.timeseries.impl.TimeseriesFactory.fromObj(TimeseriesFactory.java:49)\n\tat c3.love.timeseries.Timeseries.fromObj(Timeseries.java:687)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getTimeseriesFromCustomNormalizer(NormalizedDataPersister.java:193)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getCustomNormalizedTimeseries(NormalizedDataPersister.java:212)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.getNormalizedTimeseries(NormalizedDataPersister.java:122)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.persistNormalizedTimeseries(NormalizedDataPersister.java:175)\n\tat c3.engine.database.timeseries.normn.NormalizedDataPersister.process(NormalizedDataPersister.java:116)\n\tat c3.engine.database.timeseries.normn.NTTask.processNormalizedValues(NTTask.java:449)\n\tat c3.engine.database.timeseries.normn.NTTask.normalize(NTTask.java:234)\n\tat c3.engine.database.timeseries.normn.NTTask.normalizeTimeseries(NTTask.java:155)\n\tat c3.engine.database.timeseries.normn.NTTask.call(NTTask.java:130)\n\tat c3.engine.database.timeseries.normn.NTTask.call(NTTask.java:78)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1348)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:335)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:370)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:283)\n\tat c3.love.dbfacade.DbFacade.dispatch(DbFacade.java:666)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.normalize(FetchNormalizedDataTask.java:1361)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.evaluate(FetchNormalizedDataTask.java:219)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:169)\n\tat c3.engine.database.timeseries.normn.FetchNormalizedDataTask.call(FetchNormalizedDataTask.java:93)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:1348)\n\tat c3.engine.database.DatabaseEngine.execute(DatabaseEngine.java:335)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:370)\n\tat c3.server.impl.InteractiveDispatcher.dispatch(InteractiveDispatcher.java:283)\n\tat c3.love.expr.DataLoaderImpl.fetchNormalizedData(DataLoaderImpl.java:133)\n\t... 53 more\n,msg Failed to eval expression with bindings for srcId: 03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A,srcId=03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A\n\tat c3.service.metric.MetricUtils.throwError(MetricUtils.java:988)\n\tat c3.service.metric.MetricEvaluatable.computeResultsFromHierarchies(MetricEvaluatable.java:162)\n\tat c3.service.metric.MetricEvaluatable.eval(MetricEvaluatable.java:108)\n\tat c3.love.expr.bytecode.TsFuncLib.lambda$cache$123(TsFuncLib.java:1406)\n\tat c3.love.expr.bytecode.TsFuncLib$$Lambda$104/999654168.eval(Unknown Source)\n\tat c3.love.expr.bytecode.CompiledExpr.lambda$doEvalTimeseries$0(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.CompiledExpr$$Lambda$105/1934820946.accept(Unknown Source)\n\tat java.lang.Iterable.forEach(Iterable.java:75)\n\tat c3.love.expr.bytecode.CompiledExpr.doEvalTimeseries(CompiledExpr.java:213)\n\tat c3.love.expr.bytecode.Expr_5421310909665396526_7000755580296137922.eval(Unknown Source)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:902)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:660)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:870)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:381)\n\tat sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:422)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:355)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\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:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\n\nsrcId=03-Rete01.03-Group00000000.QR11_____EDTF203______001_ENE_A\n\tat c3.service.metric.CompoundMetricEvaluator.throwError(CompoundMetricEvaluator.java:1048)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateCompiledExpr(CompoundMetricEvaluator.java:904)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetricsForSource(CompoundMetricEvaluator.java:660)\n\tat c3.service.metric.CompoundMetricEvaluator.evaluateMetrics(CompoundMetricEvaluator.java:870)\n\tat c3.service.metric.MetricEngine.evalMetric(MetricEngine.java:381)\n\tat sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat c3.server.engine.AnnotatedEngine.invokeMethod(AnnotatedEngine.java:422)\n\tat c3.server.engine.AnnotatedEngine.execute(AnnotatedEngine.java:355)\n\tat c3.server.impl.Task.doFilter(Task.java:247)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:185)\n\tat c3.server.impl.dataCache.DataCacheEngine.doFilter(DataCacheEngine.java:126)\n\tat c3.server.impl.ServerDispatcherBase$ActionFilterChainImpl.doFilter(ServerDispatcherBase.java:183)\n\tat c3.server.impl.ServerDispatcherBase.doFilter(ServerDispatcherBase.java:153)\n\tat c3.server.impl.InteractiveDispatcher.doFilter(InteractiveDispatcher.java:77)\n\tat c3.server.impl.Task.run(Task.java:183)\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:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\n\nmsg=c3.love.exceptions.C3RuntimeException: ...

Changing the normalization interval from QUARTER_HOUR to DAY fixes the problem but we want QUARTER_HOUR! Any idea on how to fixe this without having to change the interval?

0 Likes

#2

I am facing a similar issue:

c3.love.exceptions.C3RuntimeException: c3.love.exceptions.C3RuntimeException: MetricEngine error : c3.love.exceptions.C3RuntimeException: Error c3.love.exceptions.C3RuntimeException: wrapped IllegalArgumentException: The end instant must be greater the start

later in the error message you can see that the evalMetric request did not an invalid timeRange:

Failed to eval expression with bindings for srcId: Well1,srcId=Well1,srcType=BridgeWell,metric=Temperature,start=2018-06-01T00:00:00.000,end=2018-07-01T00:00:00.000

My GUESS is that the normalized data was somehow created incorrectly, but I cant confirm this because I dont know how to fetch the raw normalized data except for in the context of a metric result.

  1. Any idea as to what is going on here?
  2. How can I fetch normalized data directly from the db?
0 Likes

#3

@caljep @bachr This sounds like a bug in the time range creation for fetching normalized data. Can you guys provide steps to reproduce in a ticket and we’ll take a look.

In order to fetch normalized data from the db, use the api:

NormalizedTimeseriesPersister.getId(PhysicalMeasurementSeries.noramalizedTimeseriesKey('headerId', 'tsField'))

0 Likes