cancel
Showing results for 
Search instead for 
Did you mean: 

Problem reading data from two tables

Alfredo_Lagunar
Participant
0 Kudos

Hi experts,

I'm developing a JDBC - IDOC scenario that needs to read data from two oracle tables. I have created a BPM that has a initial fork for the two channels and it works fine.

The problem is that I need to read data from the first, two or both tables depending if there is data to read. If there is data in the two tables it works, but if only there is data in one of the two tables, I have read problems. I have tryed to set the 'neccesary branches' to 1 but this is a problem when I have data in both tables.

Any idea?

Best Regards,

Alfredo Lagunar.

Accepted Solutions (1)

Accepted Solutions (1)

udo_martens
Active Contributor
0 Kudos

Hi Alfredo,

create a third branch with a wait step and set neccessary branches to 2.

Regards,

Udo

Alfredo_Lagunar
Participant
0 Kudos

Hi Udo,

I tried this solution and works for me.

Thanks,

Alfredo Lagunar.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

have your fork step inside a block and then right-click your block to insert a deadline branch to your BPM process and specify the time after which your BPM process should be cancelled.....so if in that time, you get data from both tables, your BPM will work okay otherwise if that time is over, then your BPM process will be cancelled.

Regards,

Rajeev Gupta