The reason I ask this is because I am getting an error while waiting for the tab to load:



I have tried Google but all I am finding is references to timeouts. Is it possible that YF is timing out in it's requests to build the reports on the tab?

If I load the reprots individually, I can run them all without issues. When I have them in the tab I get this message.

Thanks

Brendon

Hi Brendan,

Dashboard report loading can be configured under Admin > Configuration > Page Format:




If you are receiving timeout messages I would recommend checking the Yellowfin.log/JDBC.log/Source...log files for confirmation of the error.

Information on how to modify the timeout settings for the Yellowfin DB and Data source DB can be found here.

Please let me know how you go.

Regards,
David

Hi David,

I've followed through the above and have changed and added settings where required - I'm now getting a much better result on all my reports with the exception of one.

Here is what I'm getting for that particular report in the yellowfin.log:

[code]
YF:2011-09-21 12:05:38: INFO (MIDashboardAction:execute) - MIDashboardAction entered
YF:2011-09-21 12:05:38: INFO (MIDashboardAction:execute) - MIDashboardAction exiting with action: output
YF:2011-09-21 12:05:38: INFO (MIPreReportPreviewAction:execute) - MIPreReportPreviewAction entered
YF:2011-09-21 12:05:39: INFO (MIPreReportPreviewAction:execute) - MIPreReportPreviewAction exiting with action: preload
YF:2011-09-21 12:05:39: INFO (MIPreReportPreviewAction:execute) - MIPreReportPreviewAction entered
YF:2011-09-21 12:05:51: INFO (JDBCEventCreation:createEvent) - EventId=67019,Time=1316563551817,SessionId=19F7163068D3CFDD8477637A2B1CCDF6,EventTypeCode=REPORT,EventCode=RPTRUN,IpSource=10338,UnitId=1,ReferenceId=99,RemoteHost=192.168.51.188,Data=[numrows=3,timetorun=12,requestortype=PERSON,report=49515,requestor=10338]
YF:2011-09-21 12:05:51: INFO (MIPreReportPreviewAction:execute) - MIPreReportPreviewAction exiting with action: success
YF:2011-09-21 12:05:51: WARN (UtilString:getJavaScriptArray) - Object is null
YF:2011-09-21 12:05:51: WARN (UtilString:getJavaScriptArray) - Object is null
YF:2011-09-21 12:05:51: INFO (HtmlExporter:D) - Exporting report to HTML (49515: Monthly Quote Values (All Departments))
[/code]

Thanks

Brendon

Hi Brendon,

This is just a warning message, which doesn't give too much info as it's only used for internal debugging and don't believe it's an issue.

What issues are you experiencing with this 1 report?

Thanks,
David

Hi David,

The report doesn't load.

Before modifying all the concurrent settings above, the 12002 message would prevent the dashboard from loading. Now the other reports all load and it's just this one which doesn't - it produces the error.

When I try to load it as a stand alone report I also get the error. The error appears quite quickly, so I'm surprised that it might be time-out related, but the report does have multiple sub-queries so I suppose it might be one of those.

Can you point me in a direction I might be able to head in to finding out exactly what might be causing it to time-out?

Thanks

Brendon

Hi Brendon,

If a time-out message is displaying straight away it won't be related to the database connection.
This is sounding more like an issue with your actual browser, are you using IE?

Can you try with another browser ?

Thanks,
David

Hi David,

Sorry for the delay in getting back to you on this.

Yes we use IE as it's out clients most common browser. I had the same issue today with another report, so I tried it in Chrome. It worked fine in chrome but produced the Submit error in IE.

Do you have recommended settings for IE to help with this or is there anything that we can do at all?

Thanks

Brendon

Hi Brendon,

No problems.
We have noticed IE seems to have added security, or other configuration settings that can affect the way java apps are handled.

You could consider turning off cookies in IE, which may help.
Which version of IE are you using?

Otherwise I believe the post below can help shed some light on the situation:
http://askville.amazon.com/Error-status-code-%2312002-correct/AnswerViewer.do?requestId=51620322

Please let me know how you go.

Regards,
David