[teiid-issues] [JBoss JIRA] (TEIID-2777) java.lang.NoSuchFieldError: ISO8601_WEEK

java.lang.NoSuchFieldError: ISO8601_WEEK ----------------------------------------- Key: TEIID-2777 URL: https://issues.jboss.org/browse/TEIID-2777 Project: Teiid Issue Type: Bug Affects Versions: 7.7.8 Reporter: Debbie Steigner Assignee: Steven Hawkins Dayofweek function gives the following error: Test query is: select dayofweek(curdate()) Server.log: 2013-12-11 18:31:48,526 WARN [org.teiid.PROCESSOR] (Worker90_QueryProcessorQueue4724) Processing exception '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' for request Scc9x1bxXmWr.9. Exception type org.teiid.api.exception.query.ExpressionEvaluationException thrown from org.teiid.query.function.FunctionMethods.dayOfWeek(FunctionMethods.java:398). Enable more detailed logging to see the entire stacktrace. 2013-12-11 18:31:48,526 DEBUG [org.teiid.PROCESSOR] (Worker90_QueryProcessorQueue4724) Removing tuplesource for the request Scc9x1bxXmWr.9 2013-12-11 18:31:48,526 DEBUG [org.teiid.PROCESSOR] (Worker90_QueryProcessorQueue4724) Sending error to client Scc9x1bxXmWr.9 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