Problem with Aggregator Pattern

[#1]

Hello Dear Expert

I just watching a aggregator pattern like this blog: Enterprise Integration Patterns at SAP Cloud Integration: Aggregator | SAP Blogs

However whan I tried to save a iflow this messages appear: The process requires a transaction because aggregator is used. Set transaction handling to Required for JDBC.

Can you help me?

[PriyankaChak · Accepted solution]

Hi Luis,

Click on the Integration Process block and there is an option to set transaction handling.

Select 'Required for JDBC' from the list.

You can refer to the below blogpost for more dettails.

https://blogs.sap.com/2017/05/31/cloud-integration-how-to-configure-transaction-handling-in-integrat...

Regards,

Priyanka

[alex_bundschuh]

To add to Priyanka's answer, some background why you get this issue now and before this was not the case: note that if you create a new integration flow the default setting for transaction handling has been recently changed from Required for JDBC to Not Required because in many cases you actually won't need a transaction, this new default setting should avoid potential data pool exhaustion in case of too many transactions opened, in your case as Priyanka stated however you need a transaction, see https://help.sap.com/docs/SAP_INTEGRATION_SUITE/51ab953548be4459bfe8539ecaeee98d/2a5d4bc3b5da46df84b...

Alex