Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Workflow execution/DB session management

ankitkochar
Level 3
Level 3

Hi - Can anyone please explain how does Adobe Campaign manages the workflow executions, as in how does it manages the session with database.
For example - let's say if I have a workflow called WF-1, scheduled to run at a particular time T1, which module in campaign in responsible for identifying when the T1 has arrived and trigger it , is it wfserver ?

If so, does wfserver always keeps a connection open with database ?

The reason I am asking is that, we have a DB timeout parameter set a 30 min (in case session is Idle), and what we have seen is that let's say a workflow  WF1 got triggered and was running fine and it may have 10 Activities. If one of the activity in between has taken up let's say more than 2 hours to perform DB operation, then we have seen errors as ORA-01012: not logged while trying to insert logs into xtkworkflowlog table, so I presume that there was a master session which sort of works as a coordinator and manages when to execute the workflow etc., and that session with DB also writes logs etc. into the xtkworkflow table. If the activity has taken long time that means that the coordinator session / process was waiting for that activity to complete before doing any new log entry and ultimately due to DB timeout parameter set as 30 min, its gets logged out.

Regards,

Ankit

4 Replies
Vapsy
Employee
Employee

Hi Ankit,

yes it will be WFSERVER which will then pass the execution context to runwf,

Your questions are more related to product architecture and it will be best answered by Campaign Engineering.

Regards,
Vipul

David__Garcia
Level 9
Level 9

Is there any reason why you've set the idle time out to 30m

ankitkochar
Level 3
Level 3

This is as per standard policy with in our enterprise, and thus looking for more details about this product to so that can argue about correct values.

Regards

Ankit