• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    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

    User help
    6
    18
    1592
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      shoffend last edited by

      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

      1 Reply Last reply Reply Quote 0
      • CraigWeb
        CraigWeb last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • S
          shoffend last edited by

          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

          dennisbetty201 1 Reply Last reply Reply Quote 0
          • CraigWeb
            CraigWeb last edited by

            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 Reply Last reply Reply Quote 0
            • S
              shoffend last edited by

              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

              1 Reply Last reply Reply Quote 0
              • CraigWeb
                CraigWeb last edited by

                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.

                1 Reply Last reply Reply Quote 0
                • S
                  shoffend last edited by

                  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

                  1 Reply Last reply Reply Quote 0
                  • terrypacker
                    terrypacker last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • S
                      shoffend last edited by

                      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?

                      1 Reply Last reply Reply Quote 0
                      • terrypacker
                        terrypacker last edited by

                        @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

                        1 Reply Last reply Reply Quote 0
                        • terrypacker
                          terrypacker last edited by

                          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.

                          1 Reply Last reply Reply Quote 0
                          • S
                            shoffend last edited by

                            @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

                            1 Reply Last reply Reply Quote 0
                            • S
                              shoffend last edited by

                              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

                              1 Reply Last reply Reply Quote 0
                              • BG
                                BG last edited by

                                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

                                1 Reply Last reply Reply Quote 0
                                • Jared Wiltshire
                                  Jared Wiltshire last edited by

                                  @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

                                  Developer at Radix IoT

                                  1 Reply Last reply Reply Quote 0
                                  • Jared Wiltshire
                                    Jared Wiltshire last edited by

                                    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

                                    Developer at Radix IoT

                                    1 Reply Last reply Reply Quote 0
                                    • dennisbetty201
                                      dennisbetty201 @shoffend last edited by

                                      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!

                                      Jared Wiltshire 1 Reply Last reply Reply Quote 0
                                      • Jared Wiltshire
                                        Jared Wiltshire @dennisbetty201 last edited by Jared Wiltshire

                                        @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)

                                        Developer at Radix IoT

                                        1 Reply Last reply Reply Quote 0
                                        • First post
                                          Last post