Question
AGL Australia
AU
Last activity: 25 Nov 2021 0:00 EST
Is there a way to set timeout in DataSets of type database?
We are facing issues where the query run by data set is timing out and hence campaign run is failing. Is there a way to set timeout in DataSets of type database?
Exception:
Unable to query the database: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation DatabaseException caused by prior exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation | SQL Code: 1013 | SQL State: 72000 From:
Aaseya IT Solutions
IN
@Saurabh Mittal Hello Saurabh, I don't think Pega provides any option for DB query timeout. Either we have to optimize our query or change settings at DB level.
I know you can set timeouts for Kafka dataset.
On another note, did you check the partition keys and concurrency settings to see if it can help with performance?
Interested to hear from others.