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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
