org.teiid.api.exception.query.ExpressionEvaluationException

Error Code:ERR.015.001.0003 Message:Unable to evaluate dayofweek({d'2013-12-11'}): Error Code:ERR.015.001.0003 Message:Error while evaluating function dayofweek

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1

  • Error Code:ERR.015.001.0003 Message:Unable to evaluate dayofweek({d'2013-12-11'}): Error Code:ERR.015.001.0003 Message:Error while evaluating function dayofweek
  • Stack trace

    • org.teiid.api.exception.query.ExpressionEvaluationException: Error Code:ERR.015.001.0003 Message:Unable to evaluate dayofweek({d'2013-12-11'}): Error Code:ERR.015.001.0003 Message:Error while evaluating function dayofweek at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:658) at org.teiid.query.rewriter.QueryRewriter.evaluate(QueryRewriter.java:2168) at org.teiid.query.rewriter.QueryRewriter.rewriteExpressionDirect(QueryRewriter.java:2162) at org.teiid.query.rewriter.QueryRewriter.access$000(QueryRewriter.java:97) at org.teiid.query.rewriter.QueryRewriter$3.replaceExpression(QueryRewriter.java:723) at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:194) at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:82) at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:52) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:140) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:261) at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:82) at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61) at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:425) at org.teiid.query.sql.lang.Select.acceptVisitor(Select.java:168) at org.teiid.query.sql.navigator.PostOrderNavigator.doVisit(PostOrderNavigator.java:40) at org.teiid.query.rewriter.QueryRewriter.rewriteExpressions(QueryRewriter.java:730) at org.teiid.query.rewriter.QueryRewriter.rewriteQuery(QueryRewriter.java:577) at org.teiid.query.rewriter.QueryRewriter.rewriteCommand(QueryRewriter.java:196) at org.teiid.query.rewriter.QueryRewriter.evaluateAndRewrite(QueryRewriter.java:147) at org.teiid.query.processor.relational.AccessNode.rewriteAndEvaluate(AccessNode.java:231) at org.teiid.query.processor.relational.AccessNode.prepareNextCommand(AccessNode.java:252) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:144) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:140) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:151) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:133) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:377) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:290) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:218) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: org.teiid.api.exception.query.FunctionExecutionException: Error Code:ERR.015.001.0003 Message:Error while evaluating function dayofweek at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:201) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1070) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:686) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:656) ... 38 more Caused by: java.lang.NoSuchFieldError: ISO8601_WEEK at org.teiid.query.function.FunctionMethods.dayOfWeek(FunctionMethods.java:398) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:196) ... 41 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.