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, 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