Direct Process / Data Store / Transaction Handling

[#1]

Hello folks,

currently I am fighting with an strange / non predictive behavior of the CPI. We have already implemented following flow / logic:

1. iFlow which is triggered by HTTPs with some header parameters. With these infos from header iFlow decide which next iFlow will be called via "DirectProcess" adapter. Insight this 1. iFlow the current information / message will be written to an data storage. Transaction handling is set to "Required for JDBC"

2. A second iFlow will be called via "DirectProcess" Adapter. First step in this second iFlow is to read the data from the previous created data storage. I tried already "GET" and "SELECT". When data is accessed the data storage should be deleted. ("Delete on completion") Transaction handling is set to "Required for JDBC". At the end if this iFLow message will be send to an queue via JMS adapter.

When we are testing the iFlow we see now different strange behaviors:

1. The data storage will not get deleted from the second iFlow independent if "GET" or "SELECT" is used ("Delete on completion" is switched on)

2. As soon we want to test the whole flow a second time the second iFlow get stuck "in process" for around 6 min and then failed. This depends if the data storage is empty or not. If data storage is empty flow is working if data storage was already filled with some data from previous testing the flow stucks.

Hopefully someone have ideas what could cause this behavior and how to fix it.

Thanks

Best regards

DL

[Sriprasadsbhat]

Hello Dominic,

Quick suggestion here.Can you try adding the data store related steps inside Local Integration Process( Not in main integration process ) and capture the behavior.

Regards,

Sriprasad Shivaram Bhat