Report taking longer time to refresh

Hi,

Any updates on above.?

Regards,

Syed

Hi Syed,

Can you please run the info_thread collector for the duration of this report load process?

https://community.yellowfinbi.com/knowledge-base/article/infothreadrunner

This should tell us exactly what Yellowfin is working on at the time.

Regards,

Nathan

Hi Nathan,

Thanks for looking into this.

I am attaching info thread collector logs.

Regards,

Syed

Hi Syed,

Unfortunately for a quick fix, there is nothing that really jumps out at me here. There are several different processes occurring but all of them are pretty standard and none are taking too long.

• Is this a stored procedure view?
• Do you have any related reports?
• Does this report have a refresh schedule on it?
• Is this a cross-tab?
• What is your JVM usage like during this loading?

Regards,

Nathan

Hi Nathan,

Here are the answers for your questions-

• Is this a stored procedure view? - No, we haven't used stored procedure in our views as we need filters with drop-down list. As an alternative we have saved complex query result in a table and added simple select query in all views.
• Do you have any related reports? - Yes
• Does this report have a refresh schedule on it? - No
• Is this a cross-tab? - Yes
• What is your JVM usage like during this loading? - No

Regards,

Syed

Hi Syed,

Sorry for the delay here. It sounds like it might be easier to just hop on a quick screen-share. Do you have time at any point early next week?

Let me know what works for you, I am on US MST.

Nathan

Hi Syed,

I am going to set this to closed, but if you are interested in screen-sharing please let me know and it will be reopened.

Nathan