How to Identify which workflow has triggered a query

[mpalaves]

Is there a way that we can identify which workflow is triggering a query. I see the below error in the runwf.log file but unable to trace the source which is trying to execute the same:

WDB-200001 SQL statement 'SELECT 1' could not be executed. (iRc=-2006)

PGS-220000 PostgreSQL error: could not receive data from server: Connection timed out\n (iRc=-2006)

We have hybrid set up with on premise adobe campaign classic installed.

Thank you.

[Milan_Vucetic · Accepted solution]

Hi @mpalaves,

not realy, but you have a timestamp when error occured. Set query over xtk:workflow table and find paused workflow (this error will pause it) around that time.

Regards,

Milan