Unable to enlist resource error when attempting to INSERT INTO with JBEDS

Solution Verified - Updated -

Issue

  • While trying to populate my External Materialized View with the INSERT INTO, I receive the below error:
INSERT INTO mv_views.supplierinfo 
SELECT SUPPLIER_ID, PART_ID, QUANTITY, SHIPPER_ID, SUPPLIER_NAME,SUPPLIER_STATUS,SUPPLIER_CITY,SUPPLIER_STATE 
FROM External_CacheViews.supplierinfo OPTION NOCACHE 

Remote org.teiid.core.TeiidProcessingException: PartsSourceA: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -7f7612eb:e11b:4fb15466:1683 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -7f7612eb:e11b:4fb15466:1683 status: ActionStatus.ABORT_ONLY >))

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.2.0

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