Excel Reports are not showing templates anymore
-
@shoffend the system exception you are seeing is because you have the Crowd authentication module installed, you should not install as that changes Mango's authentication mechanism.
However I doubt that would cause the problem you are seeing with Excel Reports.
-
Hi Terry,
Ok, I have removed that Crowd authentication module. I can't remeber if I had installed it or if it was already there before.
I have check through the logs as well but don't see anything that would indicate a problem with the Excel reports. I have also tried to log in as another user. I thought that this might give me an idea if it is only with my user or if other users have the same problem. It seems that other users also have this problem. If I want to create a new Report and click on the icon, nothing happens as well. It seems to be that there is some or other thing not loading or there is an error which I cannot see.
Is there a way I could remove and reinstall the Excel module again and see if that maybe solves my problem?
-
Have you upgraded anything else recently? It is quite odd that there is no log output and I doubt that re-installing the module would do anything. But I suggest you try to delete the Mango/work directory and reload the page you are having problems with. That will at least rebuild the page.
If you want to re-install the module you can mark it for deletion on the modules page and then restart Mango. This will likely delete any reports you have run already and configured so I would suggest you make sure you have backups.
Then to re-install you can either try using the modules page to install it again or go to this page and download the zip, add it to the web/modules folder and restart Mango.
-
Ah one more thing is to open the Chrome developer tools to see the 'console' which would be spitting out errors if it is really a UI problem.
-
@terrypacker
Hi Terry,I have had a look at the console in the developer tools. It seems to show a lot of errors. Not sure if this is caused by Chrome not being able to open something or if this is something from the Mango systems itself.
I have attached a screenshot. Maybe you have got an idea what is going on there.
-
Before I forget..... I have also cleared the work folder in Mango and refreshed the page, but it seems to be the same. Funny thing I notices as well is that the users icon. If I click to go to this page I get no users shown. So I assume something is not loading, as I have about 3 users on the system, which should show.
Thanks
-
Hello All,
I will add my two cents here.We are also using Mango 2.8.8 on one server still and have seen the problems that are described here. Excel reports page not populating, User page not populating, also the Alarms page does not completely load and some others.
I have not found a problem within Mango, I discovered it is a browser issue. The latest browsers will not load the pages properly. We had to revert to an older version of the browsers to administer the Mango 2.8 service. Once we did that all the pages loaded properly. In the absence of mango errors in the log I suggest you revert to an older browser version.
Cheers
Brian -
@shoffend @BG is right, newer browsers broke the xstyle library which was included in that version of Mango.
https://forum.infiniteautomation.com/topic/3551/data-sources-does-not-appear/14
https://forum.infiniteautomation.com/topic/2279/chrome-not-loading-data-sources-page-properly/5 -
For reference, issue in xstyle -
https://github.com/kriszyp/xstyle/issues/44Chrome bug report about change in behavior -
https://bugs.chromium.org/p/chromium/issues/detail?id=609848 -
I ran into a very similar problem, Excel Reports does not show my templates, although I did not install or update anything new. I checked the console and found a considerable number of errors there. I'm not sure what else I can check. Literally last week, everything worked fine, without any problems, and for some reason, the whole system decided to break down. I tried to do Phillips steps, but it just seemed to make everything much worse. I have a unique integration for Excel spreadsheet installed on my computer, which looks like this https://www.coupler.io/excel-integrations/airtable-to-excel. Not sure if this integration can affect the work of mango? I don't know what to do next, so I'll be waiting for your answers!
-
@dennisbetty201 Phillip's instructions will not fix this issue. Please see https://forum.mango-os.com/topic/3551/data-sources-does-not-appear/14 or download an old web browser (e.g. standalone Firefox)