Unable to enlist resource error when attempting to INSERT INTO with JBEDS
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.