Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tuxedo load balancing issue on MP mode

Our c++ application(32 bit) was deployed in Oracle Enterprise Linux 6.6 and Tuxedo was 11.1.1 (Model was SHM)

We migrated our application to Oracle enterprise Linux 7.7 and Tuxedo to 12CR2(12.1.3 Patch 120)
Now we have enabled Model = MP. SITE1 master and SITE2 slave

We have created two linux virtual machines. Existing application executables are duplicated to both the virtual machines when we enabled MP mode(VM1 – SITE1 & VM2 – SITE2). These two virtual machines may get loaded due to the processes which are outside tuxedo domain(For example, we have C++ jobs, which are outside tuxedo services).

When one of the VM is completely loaded (RAM / CPU utilization is 100%) due to the load from processes which are from outside Tuxedo scope, Tuxedo doesn’t identify this load on the specific VM. It still routes tuxedo service calls to the loaded VM when second VM is completely free. This is causing Tuxedo transactions to be stuck till the RAM is released by the non – Tuxedo process.

In short, in MP mode, when one VM(SITE1) is loaded with non-Tuxedo load, Tuxedo doesn’t do a proper load-balancing. It still routes Tuxedo workqueue requests to the loaded VM(VM1 - SITE1) even if slave machine(SITE2) has negligible load.
This is causing Tuxedo transactions to get stuck and eventually timeout

Could you please review and let me know if this is an issue / Some config changes to be made on tuxconfig?

Sample Tuxedo file and machine configurations are attached.
Thanks
TuxedoIssue.docx (16.89 KB)

Comments

Gianni Ceresa

If you inspect the HTML behind the "columns format" of your prompts you will see each columns of prompts his a <td> of a main table. So you can add some custom CSS to change alignment and size of that main table and the 4 <td>.

You can probably also try a less "clean" solution like adding lot of spaces in front of the longer label of the 2nd, 3rd and 4th columns to "push" the others columns a bit more.

There aren't lot of available settings for how prompts must look like, but it's HTML, so with JS or CSS you can change the way it looks like...

I would only advice to not make anything too complicated also because you have the risk the HTML code change with a future release of OBIEE.

Also try to just align the prompts centrally, they will maybe look a bit better with less empty space on the left.

Capture.PNG

Daniel Willis

I managed to make checkboxes go horizontal instead of vertical using JS/CSS a while back but unfortunately every time I changed the value in a prompt it would refresh them and not redo my JS. I stopped there because I was doing it more for interest rather than anything else.

Gianni Ceresa

@"Daniel Willis" : time to move to 11.1.1.9, horizontal checkboxes / radio buttons are there out of the box (Rittman Mead Consulting » OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users > "Horizontal Layout for Radio Button and Check Box Dashboard Prompts")

2804071

To spread out between columns in PROMPTS, is possible to add a character that is not visible but takes up space (normal space is ignored), use alt + 255.

While holding down the alt key, write 255 in the numeric keypad (on the right). Release the alt between each character.

1 - 4

Post Details

Added on Dec 29 2020
1 comment
285 views