Receiving "txnAutoWrap" error in MetaMatrix Designer

Solution Verified - Updated -


  • We created a relational model which mainly inserts or updates a data source table. When we tested it inside designer, We get the below error message:
    • ERROR <com.metamatrix.core|0> Detected request "12213.24842" with multiple updates when using txnAutoWrap=OPTIMISTIC.  If you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAutoWrap=PESSIMISTIC to automatically create a transaction when needed. If you are not using MetaMatrix Enterprise, no transaction manager is provided and transactions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction methods to be called and ignored without actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction methods is risky because transactions will not be executed atomically and rollback will not occur!


  • MetaMatrix Enterprise Server
  • MetaMatrix Enterprise Designer

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