"The specified change set revtype against an inherently updatable view does not map to a key preserving group" error in EDS

Solution Verified - Updated -

Issue

  • An error is thrown while attempting to insert or update a record using a EDS federated data layer
org.teiid.api.exception.query.QueryValidatorException: The specified change set revtype against an inherently updatable view does not map to a key preserving group.
    at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
    at org.teiid.dqp.internal.process.Request.validateQuery(Request.java:308)
    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:414)
    at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154)
    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
    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.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)

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