search

google-code-export / marinemap

Automatically exported from code.google.com/p/marinemap
Other
1 stars 2 forks source link

Commercial Impact Reports Not Working on Some Arrays #388

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
When I try to run a commercial impact report on my array ("Jazz Array", ID 
100000), I get the following error:

"An error occurred when trying to load this tab. If the problem persists..."

However, if I try to run any of the other reports (e.g., Commercial Private 
Fishing Vessel, Recreational Dive, etc.) I do not get this error.

Original issue reported on code.google.com by will.mcc...@gmail.com on 3 May 2010 at 3:42

GoogleCodeExporter commented 9 years ago 
This was a result of duplicate entries in the original cache table.  The new 
caching
strategy was built to check the old table first and port any old cached values 
over
to the new caching table rather than regenerate those values (which would take 
much
longer to generate).  When these duplicates were being entered into the new 
caching
table a flag was raised and the duplicates were blocked from the new cache.  
To fix this, I removed all duplicate entries from the original cache table
(econ_analysis_fishingimpactresults) on production.  As no new values are 
stored in
the original cache table, this problem should be fixed now.

Original comment by sfletche@gmail.com on 6 May 2010 at 10:09