Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Excel Reports are not showing templates anymore


  • Hi All,

    I have this weird problem that my Excel Reports does not show my templates anymore. I know that it always took a few seconds to show, but this time nothing comes up after even a few minutes. I have also tried to refresh the page a few times, but it still does not come up.

    Secondly I have notices that when I click on the "Data point details" icon it does load the page where I can see the Real-time History, but there are no Data point which I can select from the drop down list.

    I have uploaded a screenshot of my Data point details window.
    Is there anyone who has already run into some problem like this?

    0_1583918057283_Mango Data Point.JPG


  • Hi Stephan

    Not the exact same symptoms as this thread https://forum.infiniteautomation.com/topic/2572/problems-with-upgrade-to-mango-automation-8-2-2-on-raspberrypi-2

    But I think following Phillips steps would be a good place to start.


  • Hi Craig,

    I have checked the thread and followed Phillips advice and steps, but the problem seems to still exist.
    The other thing I see now as well is the "users" button. It does not show any users anymore, which is quite weird as I have got 3 users on the mango system which can log in.

    Could it be that there are some files somewhere missing from the webserver, that could cause this to happen?

    Thanks
    Stephan


  • Just a couple of questions:
    Can you confirm that all installed modules have no updates available?
    What browser are you using?
    What version of the core are you running?
    When you open one of these pages that are not functioning are there any errors in your browser's console?


    1. The installed modules have got updates avaliable. I have the excelReports 1.1.4 version. On the website I can see that there is version 3.7.1 avalibale but it has dependencies - mangoApi v3.7 I believe that I am on mangoApi v3.5. How can I double check this? I assume that I first have to get a license to upgrade to mangoApi 3.7?

    2. The browser I am using is the newest Firefox 74.0

    3. The core version I am running is 2.8.8 build 635. Again, I think to upgrade the core I must buy a license?

    4. There are no errors coming up when I open that page, which is also strange, as I had errors in the past when something was not working correctly, but those error where fixed.

    Hope that info might give you an idea of what else I could try to get those reports going.

    Thanks
    Stephan


  • Also can you confirm that you deleted the /opt/mango/work/jsp folder ?
    Can you try to use chrome, just to see if it is not browser-related.

    If there are no errors in you console can look for anything in your ma.log file after you open the pages.


  • Hi Craig,

    I have deleted everything in the /opt/mango/work/jsp folder, so nothing there. I have also tried it on a few different browsers including Chrome, Firefox, IE, Opera, all give me the same problem.

    I have downloaded the log file from the server but it seems that there are no errors when I navigate to the page (ExcelReports). I have double checked the time as well just to be sure that the server and my PC have the same time.

    One weird thing that I have noticed only now is with the logoff I get a system error.

    "System exception!"
    The server has experienced an exception processing your last request. The exception has been logged, and system administrators will be notified of this problem. You may continue to use the site. We apologize for the inconvenience.

    I get a log from the server after this message. Does this maybe have something to do with the problem in gerneral or is this just some or other glitch on this version?

    *org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid uri 'http://<Crowd domain>/crowd/rest/usermanagement/1/config/cookie': Invalid authority
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
    at com.serotonin.web.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:37)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
    at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
    at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:364)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
    at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:87)
    at com.serotonin.m2m2.web.filter.MangoShallowEtagHeaderFilter.doFilterInternal(MangoShallowEtagHeaderFilter.java:47)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
    at org.eclipse.jetty.server.Server.handle(Server.java:499)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
    at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.IllegalArgumentException: Invalid uri 'http://<Crowd domain>/crowd/rest/usermanagement/1/config/cookie': Invalid authority
    at org.apache.commons.httpclient.HttpMethodBase.<init>(HttpMethodBase.java:222)
    at org.apache.commons.httpclient.methods.GetMethod.<init>(GetMethod.java:89)
    at com.atlassian.crowd.integration.rest.service.RestExecutor.get(RestExecutor.java:100)
    at com.atlassian.crowd.integration.rest.service.RestCrowdClient.getCookieConfiguration(RestCrowdClient.java:868)
    at com.atlassian.crowd.integration.http.CrowdHttpAuthenticatorImpl.logout(CrowdHttpAuthenticatorImpl.java:176)
    at com.serotonin.m2m2.crowd.CrowdUtils.logout(CrowdUtils.java:118)
    at com.serotonin.m2m2.crowd.CrowdAuthenticationDefinition.logout(CrowdAuthenticationDefinition.java:73)
    at com.serotonin.m2m2.rt.LoginManager.performLogout(LoginManager.java:249)
    at com.serotonin.m2m2.web.mvc.controller.LogoutController.handleRequestInternal(LogoutController.java:21)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:147)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    ... 33 more

    REQUEST URL
    http://scebms/exception/error.jsp

    REQUEST PARAMETERS

    REQUEST HEADERS
    Cookie=MANGO80=kekrbbq87nvjczio2nqxkajr; XSRF-TOKEN=498c90e7-e9d3-4a9b-ad61-04f33bba729d
    Accept=text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8
    Upgrade-Insecure-Requests=1
    User-Agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0
    Connection=keep-alive
    Referer=http://scebms/point_details.shtm
    Host=scebms
    Accept-Language=en-GB,en;q=0.5
    Accept-Encoding=gzip, deflate

    REQUEST ATTRIBUTES
    javax.servlet.forward.context_path=
    org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER=org.springframework.web.context.request.async.WebAsyncManager@a0c285
    javax.servlet.error.status_code=500
    javax.servlet.forward.servlet_path=/logout.htm
    org.springframework.web.servlet.DispatcherServlet.CONTEXT=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Wed Mar 11 11:54:16 WAST 2020]; parent: Root WebApplicationContext
    javax.servlet.jsp.jstl.fmt.localizationContext.request=org.springframework.web.servlet.support.JstlUtils$SpringLocalizationContext@bb97af
    org.springframework.web.servlet.HandlerMapping.introspectTypeLevelMapping=false
    org.eclipse.jetty.server.error_page=/exception/error.jsp
    org.springframework.web.servlet.DispatcherServlet.LOCALE_RESOLVER=org.springframework.web.servlet.i18n.SessionLocaleResolver@16e62c2
    org.eclipse.jetty.server.newSessionId=1dwzv54aj2qic1kai58zhxrbfj
    org.springframework.web.servlet.HandlerMapping.bestMatchingPattern=/logout.htm
    org.springframework.web.servlet.DispatcherServlet.OUTPUT_FLASH_MAP=FlashMap [attributes={}, targetRequestPath=null, targetRequestParams={}]
    javax.servlet.error.exception_type=class org.springframework.web.util.NestedServletException
    org.springframework.web.servlet.DispatcherServlet.FLASH_MAP_MANAGER=org.springframework.web.servlet.support.SessionFlashMapManager@13c9e3d
    lang=en
    javax.servlet.forward.request_uri=/logout.htm
    availableLanguages=[]
    sessionUser=User [id=67, username=shoffend, password={SHA-1}mHsgueNWBowIGWkjD4hmoWN+QDY=, email=stephan.hoffend@sce.com.na, phone=, disabled=false, homeUrl=/watch_list.shtm, lastLogin=1583927199058, receiveAlarmEmails=-3, receiveOwnAuditEvents=false, timezone=Africa/Windhoek, permissions=user,guest,admin,superadmin]
    javax.servlet.error.servlet_name=springDispatcher
    javax.servlet.error.message=org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid uri 'http://<Crowd domain>/crowd/rest/usermanagement/1/config/cookie': Invalid authority
    org.springframework.web.servlet.DispatcherServlet.THEME_SOURCE=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Wed Mar 11 11:54:16 WAST 2020]; parent: Root WebApplicationContext
    instanceDescription=SCE BMS
    NEW_ID=-1
    org.springframework.web.servlet.HandlerMapping.pathWithinHandlerMapping=/logout.htm
    javax.servlet.error.request_uri=/logout.htm
    org.springframework.web.servlet.DispatcherServlet.THEME_RESOLVER=org.springframework.web.servlet.theme.FixedThemeResolver@e73992
    javax.servlet.jsp.jstl.fmt.locale.request=en_GB
    javax.servlet.error.exception=org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid uri 'http://<Crowd domain>/crowd/rest/usermanagement/1/config/cookie': Invalid authority

    SESSION ATTRIBUTES

    CONTEXT ATTRIBUTES
    org.eclipse.jetty.server.webapp.ContainerIncludeJarPattern=..jar$
    DwrContainer=org.directwebremoting.impl.DefaultContainer@6ec0c2
    constants.EventType.EventTypeNames.AUDIT=AUDIT
    constants.SystemEventType.TYPE_USER_LOGIN=USER_LOGIN
    constants.Permissions.DataPointAccessTypes.READ=1
    org.directwebremoting.ContainerList=[org.directwebremoting.impl.DefaultContainer@6ec0c2]
    EventsDwr=com.serotonin.m2m2.web.dwr.EventsDwr@3adaff
    constants.DataTypes.BINARY=1
    constants.UserComment.TYPE_EVENT=1
    constants.SystemEventType.TYPE_SYSTEM_STARTUP=SYSTEM_STARTUP
    constants.SystemEventType.TYPE_REJECTED_WORK_ITEM=REJECTED_WORK_ITEM
    constants.AuditEventType.TYPE_EVENT_DETECTOR=EVENT_DETECTOR
    javax.servlet.ServletConfig=org.eclipse.jetty.servlet.ServletHolder$Config@1c674b3
    javax.servlet.http.HttpServlet=org.directwebremoting.servlet.DwrServlet@38e5b0
    org.eclipse.jetty.tmpdirConfigured=true
    constants.EventType.EventTypeNames.DATA_POINT=DATA_POINT
    clientSideMessages={common.alarmLevel.lifeSafety=com.serotonin.m2m2.i18n.TranslatableMessage@1c71626, common.disabled=com.serotonin.m2m2.i18n.TranslatableMessage@be9bfeff, header.mute=com.serotonin.m2m2.i18n.TranslatableMessage@43df3cba, header.unmute=com.serotonin.m2m2.i18n.TranslatableMessage@d635aa93, common.alarmLevel.critical=com.serotonin.m2m2.i18n.TranslatableMessage@2b076d7, js.help.related=com.serotonin.m2m2.i18n.TranslatableMessage@3dce6ae3, js.help.lastUpdated=com.serotonin.m2m2.i18n.TranslatableMessage@729293fd, js.email.addAddress=com.serotonin.m2m2.i18n.TranslatableMessage@cbb9a38a, js.help.error=com.serotonin.m2m2.i18n.TranslatableMessage@f876c0, js.email.addUser=com.serotonin.m2m2.i18n.TranslatableMessage@49cc77b5, js.email.addMailingList=com.serotonin.m2m2.i18n.TranslatableMessage@6fa4a69f, js.email.noRecipForEmail=com.serotonin.m2m2.i18n.TranslatableMessage@4b694592, common.access.set=com.serotonin.m2m2.i18n.TranslatableMessage@a3e5309b, common.access.read=com.serotonin.m2m2.i18n.TranslatableMessage@d8bff83d, common.loading=com.serotonin.m2m2.i18n.TranslatableMessage@cf5f0419, common.sendTestEmail=com.serotonin.m2m2.i18n.TranslatableMessage@8fd89c9f, common.disabledToggle=com.serotonin.m2m2.i18n.TranslatableMessage@d7f89333, common.alarmLevel.none=com.serotonin.m2m2.i18n.TranslatableMessage@223c1a70, common.administrator=com.serotonin.m2m2.i18n.TranslatableMessage@a467f3ea, common.enabledToggle=com.serotonin.m2m2.i18n.TranslatableMessage@ea5c2f12, common.alarmLevel.urgent=com.serotonin.m2m2.i18n.TranslatableMessage@8fa9c879, common.minimize=com.serotonin.m2m2.i18n.TranslatableMessage@5d740b21, js.email.noRecipients=com.serotonin.m2m2.i18n.TranslatableMessage@d78563d2, common.user=com.serotonin.m2m2.i18n.TranslatableMessage@8a9479ce, events.silence=com.serotonin.m2m2.i18n.TranslatableMessage@8376c0ac, js.email.testSent=com.serotonin.m2m2.i18n.TranslatableMessage@f59d9881, common.alarmLevel.ignore=com.serotonin.m2m2.i18n.TranslatableMessage@7a97f30a, common.maximize=com.serotonin.m2m2.i18n.TranslatableMessage@c752a74f, common.alarmLevel.doNotLog=com.serotonin.m2m2.i18n.TranslatableMessage@9d8a4f14, events.unsilence=com.serotonin.m2m2.i18n.TranslatableMessage@29ad6533, common.alarmLevel.info=com.serotonin.m2m2.i18n.TranslatableMessage@2239cfe6}
    constants.SystemEventType.TYPE_SET_POINT_HANDLER_FAILURE=SET_POINT_HANDLER_FAILURE
    MangoApiSystemSettingsDwr=com.infiniteautomation.mangoApi.web.MangoApiSystemSettingsDwr@a25425
    constants.DataTypes.ALPHANUMERIC=4
    org.apache.jasper.compiler.ELInterpreter=org.apache.jasper.compiler.ELInterpreterFactory$DefaultELInterpreter@318c2c
    constants.Permissions.DataPointAccessTypes.ADMIN=4
    constants.Permissions.DataPointAccessTypes.SET=2
    constants.AuditEventType.TYPE_DATA_SOURCE=DATA_SOURCE
    constants.SystemEventType.TYPE_EMAIL_SEND_FAILURE=EMAIL_SEND_FAILURE
    constants.SystemEventType.TYPE_UPGRADE_CHECK=UPGRADE_CHECK
    constants.Permissions.DataPointAccessTypes.NONE=0
    org.directwebremoting.impl.ServerContext=org.directwebremoting.impl.DefaultServerContext@f81b75
    constants.EventType.EventTypeNames.PUBLISHER=PUBLISHER
    WatchListDwr=com.serotonin.m2m2.watchlist.WatchListDwr@16666ff
    org.eclipse.jetty.containerInitializers=[ContainerInitializer{org.eclipse.jetty.apache.jsp.JettyJasperInitializer,interested=[],applicable=[],annotated=[]}]
    org.eclipse.jetty.server.Executor=qtp21746720{STARTED,10<=10<=200,i=6,q=0}
    constants.EventType.EventTypeNames.DATA_SOURCE=DATA_SOURCE
    constants.SystemEventType.TYPE_LICENSE_CHECK=LICENSE_CHECK
    org.springframework.web.context.WebApplicationContext.ROOT=Root WebApplicationContext: startup date [Wed Mar 11 11:54:06 WAST 2020]; root of context hierarchy
    org.springframework.web.context.support.ServletContextScope=org.springframework.web.context.support.ServletContextScope@1c9058a
    constants.SystemEventType.TYPE_SYSTEM_SHUTDOWN=SYSTEM_SHUTDOWN
    mangoMessageKeys=[Ljava.lang.String;@1b714b8
    org.directwebremoting.WebContextFactory$WebContextBuilder=org.directwebremoting.impl.DefaultWebContextBuilder@15c200f
    org.apache.jasper.runtime.JspApplicationContextImpl=org.apache.jasper.runtime.JspApplicationContextImpl@1dffa05
    javax.servlet.context.tempdir=/opt/mango/work
    constants.DataTypes.MULTISTATE=2
    org.apache.tomcat.InstanceManager=org.apache.tomcat.SimpleInstanceManager@3f45e1
    org.apache.catalina.jsp_classpath=/opt/mango/web/modules/vmstat/classes:/opt/mango/web/modules/vmstat/lib/m2m2-vmstat-1.6.0.jar:/opt/mango/web/modules/snmp/classes:/opt/mango/web/modules/snmp/lib/SNMP4J.jar:/opt/mango/web/modules/snmp/lib/m2m2-snmp-1.6.0.jar:/opt/mango/web/modules/egauge/classes:/opt/mango/web/modules/egauge/lib/m2m2-egauge-1.2.0.jar:/opt/mango/web/modules/internal/classes:/opt/mango/web/modules/internal/lib/m2m2-internal-1.6.2.jar:/opt/mango/web/modules/zwave/classes:/opt/mango/web/modules/zwave/lib/zwave4j-0.3.jar:/opt/mango/web/modules/zwave/lib/m2m2-zwave-1.2.0.jar:/opt/mango/web/modules/dnp3/classes:/opt/mango/web/modules/dnp3/lib/m2m2-dnp3-1.7.0.jar:/opt/mango/web/modules/dnp3/lib/dnp34j.jar:/opt/mango/web/modules/BACnet/classes:/opt/mango/web/modules/BACnet/lib/m2m2-BACnet-2.3.1.jar:/opt/mango/web/modules/BACnet/lib/bacnet4j-3.2.4.jar:/opt/mango/web/modules/log4JReset/classes:/opt/mango/web/modules/log4JReset/lib/m2m2-log4JReset-1.2.0.jar:/opt/mango/web/modules/graphicalViews/classes:/opt/mango/web/modules/graphicalViews/lib/m2m2-graphicalViews-1.7.0.jar:/opt/mango/web/modules/pid/classes:/opt/mango/web/modules/pid/lib/commons-math3-3.2.jar:/opt/mango/web/modules/pid/lib/m2m2-pid-1.2.0.jar:/opt/mango/web/modules/pid/lib/jwave-0.1.jar:/opt/mango/web/modules/sqlds/classes:/opt/mango/web/modules/sqlds/lib/m2m2-sqlds-1.7.0.jar:/opt/mango/web/modules/sstGraphics/classes:/opt/mango/web/modules/sstGraphics/lib/m2m2-sstGraphics-1.2.0.jar:/opt/mango/web/modules/crowd/classes:/opt/mango/web/modules/crowd/lib/xfire-core-1.2.6.jar:/opt/mango/web/modules/crowd/lib/xfire-aegis-1.2.6.jar:/opt/mango/web/modules/crowd/lib/m2m2-crowd-2.2.0.jar:/opt/mango/web/modules/crowd/lib/jdom-1.0.jar:/opt/mango/web/modules/crowd/lib/commons-lang-2.4.jar:/opt/mango/web/modules/crowd/lib/commons-httpclient-3.0.1.jar:/opt/mango/web/modules/crowd/lib/crowd-integration-client-2.1.1.jar:/opt/mango/web/modules/excelReports/classes:/opt/mango/web/modules/excelReports/lib/m2m2-excelReports-1.1.4.jar:/opt/mango/web/modules/ssh/classes:/opt/mango/web/modules/ssh/lib/m2m2-ssh-1.2.1.jar:/opt/mango/web/modules/ssh/lib/jsch-0.1.51.jar:/opt/mango/web/modules/pakbus/classes:/opt/mango/web/modules/pakbus/lib/m2m2-pakbus-1.1.0.jar:/opt/mango/web/modules/pakbus/lib/jpakbus.jar:/opt/mango/web/modules/dataPointDetailsView/classes:/opt/mango/web/modules/dataPointDetailsView/lib/m2m2-dataPointDetailsView-1.1.0.jar:/opt/mango/web/modules/asciiFile/classes:/opt/mango/web/modules/asciiFile/lib/m2m2-asciiFile-1.3.0.jar:/opt/mango/web/modules/envcands/classes:/opt/mango/web/modules/envcands/lib/m2m2-envcands-1.2.1.jar:/opt/mango/web/modules/twilio/classes:/opt/mango/web/modules/twilio/lib/twilio-java-sdk-3.4.1-jar-with-dependencies.jar:/opt/mango/web/modules/twilio/lib/m2m2-twilio-1.2.0.jar:/opt/mango/web/modules/reports/classes:/opt/mango/web/modules/reports/lib/m2m2-reports-2.3.2.jar:/opt/mango/web/modules/sstTheme/classes:/opt/mango/web/modules/sstTheme/lib/m2m2-sstTheme-1.2.0.jar:/opt/mango/web/modules/pointLinks/classes:/opt/mango/web/modules/pointLinks/lib/m2m2-pointLinks-1.6.0.jar:/opt/mango/web/modules/TCPIP/classes:/opt/mango/web/modules/TCPIP/lib/m2m2-TCPIP-1.2.0.jar:/opt/mango/web/modules/controlcore/classes:/opt/mango/web/modules/controlcore/lib/m2m2-controlcore-1.2.0.jar:/opt/mango/web/modules/virtualDS/classes:/opt/mango/web/modules/virtualDS/lib/m2m2-virtualDS-1.6.1.jar:/opt/mango/web/modules/serial/classes:/opt/mango/web/modules/serial/lib/m2m2-serial-1.3.0.jar:/opt/mango/web/modules/mbus/classes:/opt/mango/web/modules/mbus/lib/commons-logging-1.1.1.jar:/opt/mango/web/modules/mbus/lib/commons-lang-2.5.jar:/opt/mango/web/modules/mbus/lib/commons-beanutils-1.8.3.jar:/opt/mango/web/modules/mbus/lib/mbus4j-master-1.0.0.jar:/opt/mango/web/modules/mbus/lib/m2m2-mbus-1.2.0.jar:/opt/mango/web/modules/mbus/lib/commons-collections-3.2.2.jar:/opt/mango/web/modules/mbus/lib/spsw-java-0.0.7.jar:/opt/mango/web/modules/mbus/lib/mbus4j-core-1.0.0.jar:/opt/mango/web/modules/mbus/lib/json-lib-2.4-jdk15.jar:/opt/mango/web/modules/mbus/lib/ezmorph-1.0.6.jar:/opt/mango/web/modules/pachube/classes:/opt/mango/web/modules/pachube/lib/m2m2-pachube-1.6.0.jar:/opt/mango/web/modules/meta/classes:/opt/mango/web/modules/meta/lib/m2m2-meta-2.3.0.jar:/opt/mango/web/modules/scripting/classes:/opt/mango/web/modules/scripting/lib/m2m2-scripting-1.2.1.jar:/opt/mango/web/modules/dataFile/classes:/opt/mango/web/modules/dataFile/lib/jaxb-api.jar:/opt/mango/web/modules/dataFile/lib/jaxb-core.jar:/opt/mango/web/modules/dataFile/lib/jaxb-jxc.jar:/opt/mango/web/modules/dataFile/lib/m2m2-dataFile-1.2.0.jar:/opt/mango/web/modules/dataFile/lib/jaxb-xjc.jar:/opt/mango/web/modules/dataFile/lib/jaxb-impl.jar:/opt/mango/web/modules/jspViews/classes:/opt/mango/web/modules/jspViews/lib/m2m2-jspViews-2.2.0.jar:/opt/mango/web/modules/scheduledEvents/classes:/opt/mango/web/modules/scheduledEvents/lib/m2m2-scheduledEvents-1.6.0.jar:/opt/mango/web/modules/mangoNoSqlDatabase/classes:/opt/mango/web/modules/mangoNoSqlDatabase/lib/ias-tsdb-1.3.4+1.jar:/opt/mango/web/modules/mangoNoSqlDatabase/lib/m2m2-mangoNoSqlDatabase-1.3.12.jar:/opt/mango/web/modules/mangoNoSqlDatabase/lib/concurrent-locks-1.0.0.jar:/opt/mango/web/modules/dataImport/classes:/opt/mango/web/modules/dataImport/lib/m2m2-dataImport-1.5.0.jar:/opt/mango/web/modules/templateConfig/classes:/opt/mango/web/modules/templateConfig/lib/m2m2-templateConfig-1.1.0.jar:/opt/mango/web/modules/watchlists/classes:/opt/mango/web/modules/watchlists/lib/m2m2-watchlists-1.8.0.jar:/opt/mango/web/modules/dglux/classes:/opt/mango/web/modules/dglux/lib/m2m2-dglux-1.4.0.jar:/opt/mango/web/modules/dglux/lib/JoSQL-2.2.jar:/opt/mango/web/modules/dglux/lib/gentlyWEB-utils-1.1.jar:/opt/mango/web/modules/openv4j/classes:/opt/mango/web/modules/openv4j/lib/m2m2-openv4j-1.2.0.jar:/opt/mango/web/modules/openv4j/lib/openv4j-core-0.1.5-SNAPSHOT.jar:/opt/mango/web/modules/dashboards/classes:/opt/mango/web/modules/dashboards/lib/m2m2-dashboards-3.3.1.jar:/opt/mango/web/modules/modbus/classes:/opt/mango/web/modules/modbus/lib/modbus4j-3.0.3.jar:/opt/mango/web/modules/modbus/lib/m2m2-modbus-1.8.0.jar:/opt/mango/web/modules/log4jDS/classes:/opt/mango/web/modules/log4jDS/lib/m2m2-log4jDS-1.2.0.jar:/opt/mango/web/modules/pop3/classes:/opt/mango/web/modules/pop3/lib/m2m2-pop3-1.6.0.jar:/opt/mango/web/modules/jmxds/classes:/opt/mango/web/modules/jmxds/lib/m2m2-jmxds-1.6.0.jar:/opt/mango/web/modules/persistent/classes:/opt/mango/web/modules/persistent/lib/m2m2-persistent-1.7.2.jar:/opt/mango/web/modules/opcda/classes:/opt/mango/web/modules/opcda/lib/j-interopdeps-2.01.jar:/opt/mango/web/modules/opcda/lib/org.openscada.opc.dcom_0.7.0.201203290910.jar:/opt/mango/web/modules/opcda/lib/j-interop-2.0.10.jar:/opt/mango/web/modules/opcda/lib/m2m2-opcda-1.7.0.jar:/opt/mango/web/modules/opcda/lib/jcifs-1.2.19.jar:/opt/mango/web/modules/opcda/lib/org.openscada.utils_0.17.0.201203290908.jar:/opt/mango/web/modules/opcda/lib/org.openscada.opc.lib_0.9.0.201203290910.jar:/opt/mango/web/modules/abeip/classes:/opt/mango/web/modules/abeip/lib/abeip-1.4.0-SNAPSHOT.jar:/opt/mango/web/modules/sstGlobalScripts/classes:/opt/mango/web/modules/sstGlobalScripts/lib/m2m2-sstGlobalScripts-1.6.0.jar:/opt/mango/web/modules/mangoESConfiguration/classes:/opt/mango/web/modules/mangoESConfiguration/lib/m2m2-mangoESConfiguration-1.2.2.jar:/opt/mango/web/modules/mangoESConfiguration/lib/jmdns-3.4.2-SNAPSHOT.jar:/opt/mango/web/modules/mangoApi/classes:/opt/mango/web/modules/mangoApi/lib/apache-log4j-extras-1.2.17.jar:/opt/mango/web/modules/mangoApi/lib/m2m2-mangoApi-1.2.1.jar:/opt/mango/web/modules/jsonFileImport/classes:/opt/mango/web/modules/jsonFileImport/lib/m2m2-jsonFileImport-1.2.2.jar:/opt/mango/web/modules/galil/classes:/opt/mango/web/modules/galil/lib/m2m2-galil-1.6.0.jar:/opt/mango/web/modules/sqlConsole/classes:/opt/mango/web/modules/sqlConsole/lib/m2m2-sqlConsole-1.6.0.jar:/opt/mango/web/modules/maintenanceEvents/classes:/opt/mango/web/modules/maintenanceEvents/lib/m2m2-maintenanceEvents-1.6.0.jar:/opt/mango/web/modules/abpccc/classes:/opt/mango/web/modules/abpccc/lib/abpccc-1.4.0-SNAPSHOT.jar:/opt/mango/web/modules/http/classes:/opt/mango/web/modules/http/lib/m2m2-http-1.6.2.jar:/opt/mango/web/modules/onewire/classes:/opt/mango/web/modules/onewire/lib/m2m2-onewire-1.6.0.jar:/opt/mango/web/modules/onewire/lib/RXTXcomm.jar:/opt/mango/web/modules/onewire/lib/OneWireAPI.jar:/opt/mango/web/modules/loggingConsole/classes:/opt/mango/web/modules/loggingConsole/lib/m2m2-loggingConsole-1.2.0.jar
    constants.UserComment.TYPE_POINT=2
    org.directwebremoting.Container=org.directwebremoting.impl.DefaultContainer@6ec0c2
    messageKeys=[Ljava.lang.String;@c130bd
    constants.DataTypes.IMAGE=5
    org.apache.jasper.compiler.TldCache=org.apache.jasper.compiler.TldCache@d72ef2
    org.springframework.web.servlet.FrameworkServlet.CONTEXT.springDispatcher=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Wed Mar 11 11:54:16 WAST 2020]; parent: Root WebApplicationContext
    constants.Permissions.DataPointAccessTypes.DATA_SOURCE=3
    constants.EventType.EventTypeNames.SYSTEM=SYSTEM
    constants.SystemEventType.TYPE_PROCESS_FAILURE=PROCESS_FAILURE
    DataPointDetailsDwr=com.serotonin.m2m2.web.dwr.DataPointDetailsDwr@5ee07f
    constants.AuditEventType.TYPE_DATA_POINT=DATA_POINT
    constants.SystemEventType.TYPE_MAX_ALARM_LEVEL_CHANGED=MAX_ALARM_LEVEL_CHANGED
    constants.DataTypes.NUMERIC=3
    constants.Common.NEW_ID=-1
    MiscDwr=com.serotonin.m2m2.web.dwr.MiscDwr@c8be58
    constants.AuditEventType.TYPE_EVENT_HANDLER=EVENT_HANDLER


  • @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?


  • @shoffend

    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.

    https://store.infiniteautomation.com/module/excelReports


  • 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.

    0_1584426411853_Mango.JPG


  • 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



  • For reference, issue in xstyle -
    https://github.com/kriszyp/xstyle/issues/44

    Chrome bug report about change in behavior -
    https://bugs.chromium.org/p/chromium/issues/detail?id=609848