"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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content