Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

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

Avatar

Level 4

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?

 

 

Rut7_0-1688017909628.png

Image of workflow dashboard in ACC client console 7.3.2.

 

 

Thank you,

Rutuja Kelkar

https://rutujakelkar.com/

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Rut7 ,

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

ParthaSarathy_0-1688018450932.png

 

View solution in original post

6 Replies

Avatar

Level 2

Hi @Rut7 ,

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

rahul_kad_0-1688018465088.png

 



Thanks,
Rahul Kad

 

Avatar

Correct answer by
Community Advisor

Hi @Rut7 ,

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

ParthaSarathy_0-1688018450932.png

 

Avatar

Level 4

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)

Rut7_0-1688019160618.png

Image 1

 

 

 

Rut7_1-1688019286414.png

Image 2

 

Avatar

Level 4

Hi @Rut7 ,

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

Let me  know if it helps.

Thanks

Avatar

Community Advisor

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)

Avatar

Level 4

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.