Receiving "'Stored procedure '<procedure>' may be run only in unchained transaction mode." in DV
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.