Digital Developer Conference: a FREE half-day online conference focused on AI & Cloud – North America: Nov 2 – India: Nov 9 – Europe: Nov 14 – Asia Nov 23 Register now

Close outline
  • United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.195

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

ODM 8.7.1 decision center - error when deploying a project from rule designer - java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback.

270005X3QC gravatar image
Question by BRMS-DEV  (16) | Jul 15, 2015 at 03:32 AM ibmodmoraclejdbcdecisioncenterodm 8.7transactionweblogicrollback

Hi,

I'm facing the following problem, when deploying a project to decision center from rule designer :

 java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction]'. No further JDBC access is allowed within this transaction.


I am using weblogic 12c with an Oracle 12c database, and a datasource configured using the following driver : "oracle.jdbc.OracleDriver" and the following transaction configuration :

alt text

screenshot1.png (25.7 kB)
LiezlChin

People who like this

  1
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

2 answers

  • Sort: 
270006BT54 gravatar image

Answer by Miriam.Kaestner (8892) | Jul 29, 2015 at 05:29 AM

You can increase the heap size of Weblogic domain and re-test. If the AppSetRollbackOnlyException persists, consult Oracle support to understand how to diagnose this exception

Comment
LiezlChin

People who like this

  1   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
27000657CN gravatar image

Answer by NicolasRegnier (16) | Aug 28, 2015 at 11:47 AM

Hi,

I experienced the issue, unchecking "Prend en charge les transactions globales" with the Non XA Driver made it work for me.

Comment
LiezlChin

People who like this

  1   Show 1   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
270006BT54 gravatar image Miriam.Kaestner (8892)   Sep 01, 2015 at 10:28 AM 1
Share

oracle.jdbc.OracleDriver is the non-XA driver. Global Transaction can be used only with an XA driver, for example, oracle.jdbc.xa.client.OracleXADataSource

DC does not use global transactions Also Oracle DDL statements automatically generate commit operations that cause errors when used with a Global Transaction Manager ==> SQL scripts to create or alter database schema cannot get executed from DC using this configuration. So the preferred option is to disable Global Transactions, and to use a non-XA driver.

Follow this question

38 people are following this question.

Answers

Answers & comments

Related questions

How to configure ODM cluster with Oracle RAC database? 2 Answers

Rollback error during synchronization 1 Answer

Users login with same name but different capitalization are treated as different users in Decision Center Business console on Weblogic 1 Answer

How to check server logs in Decision centre 1 Answer

SRVE0278E warning when starting ODM Sample Server 1 Answer

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • Data and AI
  • DataPower
  • Decision Optimization
  • DevOps Build
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • Hyper Protect
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PartnerWorld Developer Support
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges