Hello,

Re: OO 2023.05 - Purge Execution Summary a Hit and Miss

Anyone who runs Purge Execution Summary flow without any issues on 2023.05?

Mine is a hit and miss, playing around with the maxAmount paremeter... let me know your feedback and suggestions.

Last time it worked for me was I put maxAmount=1500000 delayBetweenRequests=30, it ran but the flow keeps running even when records are not being deleted anymore.

When I was still with OO 10.70, it worked all the time but after upgrading to 2023.05 iit worked for 8 monhs then suddenly misbehaving since July.

I am using Oracle 19c by the way:

This is my database.properties maybe you can suggest something:

db.pool.maxPoolSize=200
db.pool.minPoolSize=16
#db.connection.pool.strategy=hikari
db.validateQuery=SELECT 1 FROM DUAL
db.pool.maxIdleTime=3000
jdbc.driver_class=oracle.jdbc.OracleDriver
db.show_sql=false

Regards,

ART