Idea Details

Enhance BPMChorus to use on load-balanced Oracle RAC when deployed on TCServer

Last activity 8 days ago
Jon Goetz's profile image
By: Jon Goetz
01-23-2023 17:41

Version:  BPMChorus

Deployed on TCServer v4.1.15

Oracle RAC (two & three-instance cluster, configured via Oracle for load-balancing).  Oracle19.

I have found that this version of BPMChorus, when deployed on TCServer, has application start-up errors when the database is a load-balanced Oracle RAC.

BPMChorus has a file that references 3 JDBC XA datasources.  In a load-balanced oracle configuration, the application exhibits ORA-24798 errors when starting up.

My team has determined that these errors only occur when there is a load-balanced oracle rac configuration.   If we configure our oracle rac to be a single-instance  OR  a cluster set up in fail-over configuration, then the application starts up cleanly & does not present the errors.   

We have found that we can configure Oracle to have an XA dtp-enabled service on each instance, then configure the file to 'hard-code' all XA transactions to a single-instance on our oracle cluster.   However, this workaround simply negates the advantage of a load-balanced oracle cluster.

We have learned that SS&C has tested this software in 2 manners:  against a single-instance of oracle (for test environments) and against a fail-over oracle cluster.  But, it hasn't been tested against a load-balanced oracle cluster.   My request is to enhance the software to better manage its XA connections against a load-balanced oracle rac cluster.    In the event that this enhancement cannot be made, my recommendation would be for SS&C to update documentation to indicate the Oracle scenarios on which their software has been proven to work & on which scenarios it has not been tested/confirmed.

Ideas Portal

• Like this idea? Tap the up arrow!  Ideas with over 15 votes will be discussed with our product teams in our idea review meeting.
• Discussion is healthy! If you have a question or comment, don’t be afraid to jump in and start a discussion in the comments section below.
• Collaboration is the key to making magic happen!
This idea is new to the community and hasn’t been reviewed yet. While in the New stage, it is particularly important to vote and comment to further the discussion around this idea.
This idea already exists! A change to the Duplicate status will include a comment linking to the existing idea, so all voting and feedback can be collected in one place.
Need More Info
We’ve reviewed this idea, and determined we need a bit more info before deciding on how to move forward. An update to the Need More Info status will be accompanied by a comment explaining which additional details are needed. Ideas are still open for voting and comments while in the Need More Info stage.
We have all the info we need and are planning to review the idea for implementation feasibility and value added to the product. Ideas with this status are still open to community voting and discussion.
Under Consideration
We have all the info we need and are currently considering the feasibility of implementing this idea. Ideas in the Under Consideration status are still open to community voting and discussion.
Not Planned
We’ve reviewed this idea, and determined that it’s not feasible to implement right now. Ideas in the Not Planned status are no longer open for voting.
We’ve reviewed this idea and have determined that it will be delivered in the near future. Ideas in the Planned status are not attached to a binding timeline, but there is a concrete plan to implement this idea.
We’ve reviewed this idea and confirmed that this is planned for delivery in the next 6 months.
Congrats! Your idea has been accepted by the team and is now delivered! Give yourself a pat on the back – you contributed to the improvement of one of Blue Prism’s products or services!