How to increase the database timeout in Activiti?

[zlatan316]

Hi,

I'm connecting to a MS Project Server Report via an Activiti Service Task, and because of the time taken to run it, I get a connection reset error in Activiti. I was wondering if there was a way to increase the timeout to the Activiti DB so I can allocate more time to open connections?

Regards

[martin_grofcik]

Hi,

DB transaction timeout is DB property.
I would suggest to use asynchronous processing for your case.

Regards
Martin

[zlatan316]

Currently enabling the Service Task to Async does not resolve this issue. I was hoping to simply increase the timeout parameter so we can allow more time for the connection to remain open?

[martin_grofcik]

Hi,

Making Service task asynchronous does not solve the issue. I would propose to use something like messaging for your problem.
Service task will initiate report generation and when report is ready reporting system sends a message on which process instance will wait.

Regards
Martin