Mashboard views not receiving data

matthew.t.short
User offline. Last seen 3 years 1 week ago. Offline
Joined: 11/01/2010
Points: 31

We have noticed a problem when running some of our views from the Mashboard. Occasionally views that usually work will hang on our loading screen. After debugging in firebug it appears the emml files are never returning the data to our JavaScript files. If you click the little refresh button on the view the emml will run again and return the correct information.  I have not successfully been able to find any group of steps that will consistently reproduce these actions. This happens when using Firefox.

 
This typically happens when multiple views are loading at the same time. How does Presto run emml files if I try to load multiple views at the same time. Do they run synchronously or will one finish before the next loads?

Do you have any theories why these views might be hanging?  They are pulling information from a database and excel files hosted on the server.

Thanks

0
Your rating: None
jeremy.pitten
jeremy.pitten's picture
User offline. Last seen 25 weeks 1 day ago. Offline
Joined: 09/22/2008
Points: 275

 Just to confirm you're using Presto 2.7?

When you say the emml files (mashups) never return the data, does firebug show any response coming back or are the requests hanging?

The mashups should run in parallel but if they all hit the same db maybe they are fighting over limited number of db connections? I'm wondering if they are timing out trying to connect to the db.

matthew.t.short
User offline. Last seen 3 years 1 week ago. Offline
Joined: 11/01/2010
Points: 31

Yes, we are on 2.7

Firebug shows no response in the callback function like it should and usually does.  I first thought this might be a database issue but I was looking at the activity monitor in sql server and it doesn't seem to be the case. 

To further examine the issue I also installed chrome and after playing around in there I could not repeat this issue.  At one point I was loading the same 4 views between Firefox and Chrome and 2 of 4 did not load in FF but all 4 loaded in chrome.  I was able to repeat this. 

If you need any more information let me know.

jeremy.pitten
jeremy.pitten's picture
User offline. Last seen 25 weeks 1 day ago. Offline
Joined: 09/22/2008
Points: 275

 Does <presto install directory>/logs/presto.log record anything? Any exceptions logged?

If not we may need to enable some debug to trace what's happening.

 

matthew.t.short
User offline. Last seen 3 years 1 week ago. Offline
Joined: 11/01/2010
Points: 31

There are some exceptions logged but I know where they are coming from and are seperate from the views that are freezing.  Nothing is showing up at the same time as the views freeze.

I've done more testing in Chrome and I'm still unable to reproduce the freezing.

jeremy.pitten
jeremy.pitten's picture
User offline. Last seen 25 weeks 1 day ago. Offline
Joined: 09/22/2008
Points: 275

Ok, assuming you're still able to see the freezing using Firefox, can you enable some server logging to trace the requests?

 

If you edit <presto install directory>/server/apache-tomcat-5.5.20/webapps/presto/WEB-INF/classes/log4j.properties and uncomment the following line by removing the hash character (should be around line 34):

log4j.logger.com.jackbe.jbp.sas.saf.spa=DEBUG, finelog

Then you'll need to stop and restart presto. The log will be written to <presto install directory>/logs/prestofine.log

If the the data isnt sensitive you can send it to me at jeremy.pitten@jackbe.com and I'll take a quick look and get back to you, or you can take a look yourself and let me know what you find.