Retrieve the query time for database calls used by a report

Yamini,

Could you advise which component of the Audit content would be relevant for the specific situation that I'm trying to assess?

Hello,

There is a report in the audit content called longest running reports that will provide statistics you can use. Apart from that, there is no much logs or diagnostics that match your particular request available.

To obtain a set of logs, you can activate the debug mode of the logging system. I have a reference article that could help you further.https://community.yellowfinbi.com/knowledge-base/article/how-do-i-turn-on-debug-logging-within-yellowfin-log-file

Note: Also, for my reference I would like to know from you, which database you have integrated with Yellowfin and what is the version of it.

Regards,

Yamini Naidu

Yamini,

Thanks for the clarification re: Audit content.

Verbose logging may be an option - could you advise the name of the logger that is used for database operations from Yellowfin, would be better to just set that to a finer grained than the whole application if possible.

Database engine is Amazon Aurora, MySQL 5.7 compatibility for both the source and config database. Yellowfin is 9.7.1.1.

Hello,

Hope you are doing well

I did review this issue one more time to see if there are any other possible opportunities to achieve the expected output however there are a couple of pointers that I would like to highlight here.

1. Necessary configuration (Script/Coding) must be carried out on your end unfortunately it's an out-of-scope issue for Yellowfin support.

2. The other option is, you may need to configure it via the Tomcat server as well to give it a try I'll share a couple of helpful links with you, hope this would help you in some way.

https://wiki.yellowfinbi.com/display/yfcurrent/Logs+and+Logging

https://community.yellowfinbi.com/knowledge-base/article/how-to-turn-on-debug-logging-for-one-class-only

Thanks!

Regards,

Yamini Naidu

Yamini,

Yes, we understand that we need to apply the configuration changes to our instance to enable the logging needed.

In terms of the name of the logger, what I was hoping to get was a finer grained logger - similar to the 2nd link you shared regarding enabling logging for the ReportBroadcastProcess. I'm not familiar with the Yellowfin application so wanted to get a pointer on which configuration to set so that the database related logs could be enabled at the DEBUG level. As the link mentions, we don't want to be trawling through copious amounts of log outputs.

Hope that clarifies what I was requesting regarding the name of the logger.

Hello,

Hope you are doing well.

I apologies for the delayed response.

After having a discussion with the wider teams we would like to conclude that, the issue which you have been facing looks to be an out of scope for Yellowfin support. We will go ahead and create a Jira ticket for further improvements and will keep you posted with the updates as and when we have it from Dev team.

Regards,

Yamini Naidu

Hello,

Hope you are doing well

I'm writing to let you know that we've opened a Jira ticket for improvement on the problem you're having. We will keep you posted once we have some updates around this.

Thanks!

Regards,

Yamini Naidu

Yamini,

Thanks for the note, definitely will need assistance from the Development team on this. Will keep a lookout for updates on this. Appreciate the help.