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.
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?
-
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? -
-
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?
-
The browser I am using is the newest Firefox 74.0
-
The core version I am running is 2.8.8 build 635. Again, I think to upgrade the core I must buy a license?
-
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 moreREQUEST URL
http://scebms/exception/error.jspREQUEST 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, deflateREQUEST 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 authoritySESSION 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?
-
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)
