Receiving "'Stored procedure '<procedure>' may be run only in unchained transaction mode." in DV

Solution Verified - Updated -

Issue

  • What is the meaning of this error? This model was migrated DV 6.0 and no longer works.
14:52:34,180 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue63) TEIID30020 Processing exception for request mzfClunxeJO8.11 'TEIID30504 GTN_PL: TEIID11004 Error executing statement(s): {call COP2_PAX_Query;1(?,?,?,?,?)}'. Originally TeiidProcessingException 'Stored procedure 'COP2_PAX_Query' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.0
  • Sybase RDBMS

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.