How do we enable SQL logs in ACC Client console 7.3.2 workflow UI dashboard ?

[Rut7]

Hi All,

I'm trying to look for SQL logs (see below image) under the audit tab in ACC client console 7.3.2 edit workflow UI dashboard. But cannot seem to find it in my current ACC UI. Is there an option to enable SQL logs? Or it is available only in campaign V8?

Image of workflow dashboard in ACC client console 7.3.2.

Thank you,

Rutuja Kelkar

https://rutujakelkar.com/

[rahul_kad]

Hi @Rut7 ,

Under the Workflow properties->Execution Tab->select checkbox for enabling SQL logs. PFB snapshot

Thanks,
Rahul Kad

[ParthaSarathy · Accepted solution]

Hi @Rut7 ,

Go to workflow property > execution tab > enable 'Log SQL queries in the journal' checkbox

[Rut7]

Perfect, Thank you @ParthaSarathy @rahul_kad.

SQL query logs appears, but displays empty content (see Image 1)? Any reason for this? (Although I can SQL query logs in workflow properties - see image 2)

Image 1

Image 2

[rahulkad29786]

Hi @Rut7 ,

Can you just try clearing instance cache or restarting the Workflow once.

Let me  know if it helps.

Thanks

[ParthaSarathy]

Try clear cache (file > clear the local cache), disconnect and reconnect, and restart you workflow.
(In case, If this occurs again, try the same property in another workflow and check it)

[Rut7]

Thank you @ParthaSarathy , @rahulkad29786.

Fresh SQL queries initially load in workflow properties>SQL queries tab and then in SQL tab in workflow dashboard.

In my UAT instance they do not directly load in SQL tab in workflow dashboard unless I visit workflow properties>SQL queries tab.

It's working fine in production instance.