"java.lang.NoSuchFieldError: ISO8601_WEEK" in EDS

Solution Verified - Updated -

Issue

  • After applying an EDS patch, the dayofweek function gives the below error:
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

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In