Scheduler problems related to execution of a single BLT by many schedules

Posted on 16th Feb 2014 07:03 pm by admin

Hello all,

We are running several MII instances in a distibuted architecture using a single generic BL transaction to transfer different types of messages from the site instances to a single central instance. The central instance has several schedules that run the same generic transaction with different parameters in order to transfer different types of messages.

As far as possible we have tried to avoid overruns where two of these schedules are running at the same time, but eventually the scheduler becomes "stuck" where many of the "Next Run Time" values indicated on the Scheduler table are in the past. When in this state the Scheduler page indicates that the transactions are running, but no messages are transferred.

Do we need to ensure that a transaction is never reused across different schedules, or is there another likely cause for the problems we are experiencing (e.g. scheduled next run times not updating when the MII instance is restarted)?

Thanks

Your Answer:

Login to answer

Other forums

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.

Example:
I

Combining refCursors and Summing
Given the following DDL:

CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "ST