Skip to main content

Oracle SOA Transaction time/JTA configuration

Hi Everyone,

During my recent project development where i designed a BPEL service which was orchestrating a very complex logic with more then 100 DB/WS call and everything was in SYNC design, During some request set of data BPEL service return JTA transaction error as with default JTA transaction time, BPEL was not able to complete the request execution and failed with audit/instance information in SOA DB and generate error response.

After a lot debugging/papers.blog reading i found some information which actually resolved my issue. Hope this will help you.
1.For the BPEL timeout set property SyncMaxWaitTime (value in seconds) in the SOA Suite console (Oracle Fusion Middleware Control): In the navigation menu on the left expand the “SOA” folder and select item “soa-infra (soa_server1)” just below it. Then in the top of the details screen on the right expand the drop down menu “SOA Infrastructure” and select “SOA Administration” -> “BPEL Properties” . The “BPEL Service Engine Properties” screen opens. Click on link “More BPEL Configuration Properties…” at the bottom of this screen. Now the “Application Defined MBeans: BPELConfig:bpel” screen opens and finally you can edit the setting SyncMaxWaitTime (scroll down, setting #32 in list).
2.Set timeouts in the soa EJB’s: Open the Weblogic console and click in the navigation menu on the left on “Deployments”. Expand “soa-infra” by clicking on [+] and expand node “EJBs” in the same way. Increase the “Transaction Timeout” (value in seconds) in the “Configuration” tab for the following EJB’s by clicking on them:
    • BPELEngineBean
    • BPELDeliveryBean
    • BPELActivityManagerBean
    • BPELServerManagerBean
    • BPELProcessManagerBean
    • BPELInstanceManagerBean
    • BPELFinderBean
3.Increase the JTA timeout in the Weblogic console by selecting “soa_domain” in the navigation menu (top item) on the left. Then select tab “Configuration” and subtab “JTA”. The first setting is the “Timeout Seconds” (value in seconds).
4.To solve “HeuristicMixedException” timeouts, set the “XA Transaction Timeout” of the soa jdbc connection to 0 seconds (means inherit) by expanding “Services” -> “JDBC” and select “Data Sources”. In the screen on the right select “SOADataSource” from the list and select tab “Configuration” and subtab “Transaction”. Enable setting “Use XA Datasource Interface” and setting “Set XA Transaction Timeout” and set setting “XA Transaction Timeout:” to 0 (inherit globale Weblogic transaction timeout).

Comments

  1. slickMarch 9, 2021 at 6:04 PM

    Thank you Sandeep. This helped me to solve a JTA timeout problem.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle SOA 12C rest adapter with Custom HTTP headers

Most existing web applications are connected through web services, which are commonly known as SOAP services. More and more users are relying on mobile devices for communication, and they’re looking for lighter ways to access enterprise information on the go. REST services are the answer for the mobile device platform, because they get rapid responses and fast access to data. Oracle SOA Suite 12 c  provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite 12 c  enables services to be created, managed, and orchestrated into composite applications and business processes. Some time we have need to send HTTP headers in REST service, In OSB we use header component and add what ever is needed but in oracle SOA 12C it's little bit different. Let see how we can do it. Create one SOA Application. Create one SOA Sample project inside SOA Application. Go to composite and drag drop REST ...
32 comments
Read more

How to Change Weblogic Domain MODE to Production and Development.

Hi all,   today i experienced a little task to change the "Production mode" settings to FALSE in weblogic domain because due to production mode web service test client was not working. Setting up the mode to true was easy and straight forward but a little trick comes where for some reasons we had to rollback that change to test some issues.  If you want to know what are the differences between the two modes check this post  To configure all servers in a domain to run in production mode:  Login to Weblogic Console In the left pane of the WebLogic Console, under Domain Structure, select the domain name.  Select Configuration > General and select the Production Mode check box.  Click Save, and then, to activate these changes, in the Change Center, click Activate Changes. Start and stop any servers that are currently running. Here are the steps to configure all servers in a domain back to development mode. Weblogic server stor...
17 comments
Read more

Swagger API document from Any WADL & Schema in Oracle SOA

Hi everyone, Hope everyone is doing well these days, Recently i started a project work over how to generate swagger API document for your any REST API, In case if you don't know what is swagger please go and check " https://swagger.io/tools/swagger-editor/ ". It's a great and easy to use tool which will help to create user friendly, human readable form API documentation with extension for generating API client in different languages with capability of testing your API from same. What is swagger editor, Design, describe, and document your API on the first open source editor fully dedicated to OpenAPI-based APIs. The Swagger Editor is great for quickly getting started with the OpenAPI (formerly known as the Swagger Specification) specification, with support for Swagger 2.0 and OpenAPI 3.0.  What benefits you will get by using swagger, Runs Anywhere, The Editor works in any development environment, be it locally or in the web. Smart Feedback, Validate you...
10 comments
Read more