Importing A Module
-
Hi,
I am trying to enable the excelReports module.
I went ahead and downloaded the module from the downloads page. I placed the zip file in Mango/web/modules and restarted the instance.
The file was unzipped and I see on the modules page that it is downloaded.
!
However when I go to the module itself it says that it is not enabled.
0_1537471769633_Screen Shot 2018-09-13 at 9.48.04 AM.png -
Hi gquiroz,
In Mango 2.8 you need to have the "dashboards" module installed for the Excel Reports module to work. You can install that on your modules page, or download it from the store: https://store.infiniteautomation.com/module/dashboards
-
Thank you Philip,
The module was added and I see now that the excel report are available. However, after restarting the instance I am no longer able to see my data sources and datapoints. Am getting the following error messages:
As well as the following System Exception:
java.lang.OutOfMemoryError: Java heap space at java.lang.Class.getDeclaredMethods0(Native Method) at java.lang.Class.privateGetDeclaredMethods(Unknown Source) at java.lang.Class.privateGetMethodRecursive(Unknown Source) at java.lang.Class.getMethod0(Unknown Source) at java.lang.Class.getMethod(Unknown Source) at org.apache.commons.logging.LogFactory.directGetContextClassLoader(LogFactory.java:896) at org.apache.commons.logging.LogFactory$1.run(LogFactory.java:862) at java.security.AccessController.doPrivileged(Native Method) at org.apache.commons.logging.LogFactory.getContextClassLoaderInternal(LogFactory.java:859) at org.apache.commons.logging.LogFactory.getFactory(LogFactory.java:423) at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:685) at org.springframework.util.ConcurrencyThrottleSupport.<init>(ConcurrencyThrottleSupport.java:61) at org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottleAdapter.<init>(SimpleAsyncTaskExecutor.java:222) at org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottleAdapter.<init>(SimpleAsyncTaskExecutor.java:222) at org.springframework.core.task.SimpleAsyncTaskExecutor.<init>(SimpleAsyncTaskExecutor.java:64) at org.springframework.web.context.request.async.WebAsyncManager.<init>(WebAsyncManager.java:74) at org.springframework.web.context.request.async.WebAsyncUtils.getAsyncManager(WebAsyncUtils.java:49) at org.springframework.web.filter.OncePerRequestFilter.isAsyncDispatch(OncePerRequestFilter.java:137) at org.springframework.web.filter.OncePerRequestFilter.skipDispatch(OncePerRequestFilter.java:118) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:98) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) 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) REQUEST URL http://localhost:8080/exception/error.jsp REQUEST PARAMETERS REQUEST HEADERS Cookie=MANGO8080=qw0nw897f1yt1u2tb4xqp0uk2; XSRF-TOKEN=d9819a8d-cb00-4947-86bd-64cfeefd0180 If-None-Match="0e052cff6abf853db533e56f16b6a98dc" Accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Upgrade-Insecure-Requests=1 User-Agent=Mozilla/5.0 (Windows NT 6.1; rv:56.0) Gecko/20100101 Firefox/56.0 Referer=http://localhost:8080/data_point_details.shtm Connection=keep-alive Host=localhost:8080 Accept-Language=en-US,en;q=0.5 Accept-Encoding=gzip, deflate REQUEST ATTRIBUTES javax.servlet.forward.context_path= javax.servlet.error.status_code=500 javax.servlet.forward.servlet_path=/data_sources.shtm javax.servlet.jsp.jstl.fmt.localizationContext.request=org.springframework.web.servlet.support.JstlUtils$SpringLocalizationContext@163daa1 javax.servlet.forward.request_uri=/data_sources.shtm org.eclipse.jetty.server.error_page=/exception/error.jsp javax.servlet.error.exception_type=class java.lang.OutOfMemoryError javax.servlet.error.message=java.lang.OutOfMemoryError: Java heap space javax.servlet.error.request_uri=/data_sources.shtm javax.servlet.error.servlet_name=springDispatcher javax.servlet.jsp.jstl.fmt.locale.request=en_US javax.servlet.error.exception=java.lang.OutOfMemoryError: Java heap space SESSION ATTRIBUTES org.springframework.security.web.csrf.HttpSessionCsrfTokenRepository.CSRF_TOKEN=org.springframework.security.web.csrf.DefaultCsrfToken@44c2cd sessionUser=User [id=1, username=admin, password={BCRYPT}$2a$10$orU2uPOKLWs2e1yYeQmVGu3cQjlO/WQ.VQ90Y9ntuCumkoCyA6kWm, email=admin@yourMangoDomain.com, phone=, disabled=false, homeUrl=null, lastLogin=1537543599985, receiveAlarmEmails=-3, receiveOwnAuditEvents=false, timezone=null, permissions=superadmin] LONG_POLL_DATA_TIMEOUT=1537544025638 SPRING_SECURITY_CONTEXT=org.springframework.security.core.context.SecurityContextImpl@d1182eca: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@d1182eca: Principal: User [id=1, username=admin, password={BCRYPT}$2a$10$orU2uPOKLWs2e1yYeQmVGu3cQjlO/WQ.VQ90Y9ntuCumkoCyA6kWm, email=admin@yourMangoDomain.com, phone=, disabled=false, homeUrl=null, lastLogin=1537543599985, receiveAlarmEmails=-3, receiveOwnAuditEvents=false, timezone=null, permissions=superadmin]; Credentials: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_superadmin, ROLE_ADMIN LONG_POLL_DATA=[com.serotonin.m2m2.web.dwr.longPoll.LongPollData@1318e1] CONTEXT ATTRIBUTES org.eclipse.jetty.server.webapp.ContainerIncludeJarPattern=.*\.jar$ DwrContainer=org.directwebremoting.impl.DefaultContainer@18fb25f constants.EventType.EventTypeNames.AUDIT=AUDIT constants.SystemEventType.TYPE_USER_LOGIN=USER_LOGIN constants.Permissions.DataPointAccessTypes.READ=1 org.directwebremoting.ContainerList=[org.directwebremoting.impl.DefaultContainer@18fb25f] 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@dcc89d javax.servlet.http.HttpServlet=org.directwebremoting.servlet.DwrServlet@6432e1 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 constants.DataTypes.ALPHANUMERIC=4 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@3ce95c constants.EventType.EventTypeNames.PUBLISHER=PUBLISHER org.eclipse.jetty.containerInitializers=[ContainerInitializer{org.eclipse.jetty.apache.jsp.JettyJasperInitializer,interested=[],applicable=[],annotated=[]}] org.eclipse.jetty.server.Executor=qtp17492387{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 [Fri Sep 21 11:33:14 EDT 2018]; root of context hierarchy org.springframework.web.context.support.ServletContextScope=org.springframework.web.context.support.ServletContextScope@a9b08e constants.SystemEventType.TYPE_SYSTEM_SHUTDOWN=SYSTEM_SHUTDOWN mangoMessageKeys=[Ljava.lang.String;@c717e6 org.directwebremoting.WebContextFactory$WebContextBuilder=org.directwebremoting.impl.DefaultWebContextBuilder@1efdf25 org.apache.jasper.runtime.JspApplicationContextImpl=org.apache.jasper.runtime.JspApplicationContextImpl@8ba0d javax.servlet.context.tempdir=C:\Mango\work constants.DataTypes.MULTISTATE=2 org.apache.tomcat.InstanceManager=org.apache.tomcat.SimpleInstanceManager@1965f02 org.apache.catalina.jsp_classpath=C:\Mango\web\modules\internal\classes;C:\Mango\web\modules\internal\lib\m2m2-internal-1.6.2.jar;C:\Mango\web\modules\snmp\classes;C:\Mango\web\modules\snmp\lib\m2m2-snmp-1.6.0.jar;C:\Mango\web\modules\snmp\lib\SNMP4J.jar;C:\Mango\web\modules\reports\classes;C:\Mango\web\modules\reports\lib\m2m2-reports-2.3.2.jar;C:\Mango\web\modules\virtualDS\classes;C:\Mango\web\modules\virtualDS\lib\m2m2-virtualDS-1.6.1.jar;C:\Mango\web\modules\loggingConsole\classes;C:\Mango\web\modules\loggingConsole\lib\m2m2-loggingConsole-1.2.0.jar;C:\Mango\web\modules\dataImport\classes;C:\Mango\web\modules\dataImport\lib\m2m2-dataImport-1.5.0.jar;C:\Mango\web\modules\dashboards\classes;C:\Mango\web\modules\dashboards\lib\m2m2-dashboards-3.3.1.jar;C:\Mango\web\modules\scripting\classes;C:\Mango\web\modules\scripting\lib\m2m2-scripting-1.2.1.jar;C:\Mango\web\modules\ssh\classes;C:\Mango\web\modules\ssh\lib\jsch-0.1.51.jar;C:\Mango\web\modules\ssh\lib\m2m2-ssh-1.2.1.jar;C:\Mango\web\modules\http\classes;C:\Mango\web\modules\http\lib\m2m2-http-1.6.2.jar;C:\Mango\web\modules\opcda\classes;C:\Mango\web\modules\opcda\lib\j-interop-2.0.10.jar;C:\Mango\web\modules\opcda\lib\j-interopdeps-2.01.jar;C:\Mango\web\modules\opcda\lib\jcifs-1.2.19.jar;C:\Mango\web\modules\opcda\lib\m2m2-opcda-1.7.0.jar;C:\Mango\web\modules\opcda\lib\org.openscada.opc.dcom_0.7.0.201203290910.jar;C:\Mango\web\modules\opcda\lib\org.openscada.opc.lib_0.9.0.201203290910.jar;C:\Mango\web\modules\opcda\lib\org.openscada.utils_0.17.0.201203290908.jar;C:\Mango\web\modules\serial\classes;C:\Mango\web\modules\serial\lib\m2m2-serial-1.3.0.jar;C:\Mango\web\modules\graphicalViews\classes;C:\Mango\web\modules\graphicalViews\lib\m2m2-graphicalViews-1.7.0.jar;C:\Mango\web\modules\sqlds\classes;C:\Mango\web\modules\sqlds\lib\m2m2-sqlds-1.7.0.jar;C:\Mango\web\modules\log4jDS\classes;C:\Mango\web\modules\log4jDS\lib\m2m2-log4jDS-1.2.0.jar;C:\Mango\web\modules\excelReports\classes;C:\Mango\web\modules\excelReports\lib\m2m2-excelReports-1.1.4.jar;C:\Mango\web\modules\scheduledEvents\classes;C:\Mango\web\modules\scheduledEvents\lib\m2m2-scheduledEvents-1.6.0.jar;C:\Mango\web\modules\templateConfig\classes;C:\Mango\web\modules\templateConfig\lib\m2m2-templateConfig-1.1.0.jar;C:\Mango\web\modules\pakbus\classes;C:\Mango\web\modules\pakbus\lib\jpakbus.jar;C:\Mango\web\modules\pakbus\lib\m2m2-pakbus-1.1.0.jar;C:\Mango\web\modules\pop3\classes;C:\Mango\web\modules\pop3\lib\m2m2-pop3-1.6.0.jar;C:\Mango\web\modules\sstGlobalScripts\classes;C:\Mango\web\modules\sstGlobalScripts\lib\m2m2-sstGlobalScripts-1.6.0.jar;C:\Mango\web\modules\sstGraphics\classes;C:\Mango\web\modules\sstGraphics\lib\m2m2-sstGraphics-1.2.0.jar;C:\Mango\web\modules\envcands\classes;C:\Mango\web\modules\envcands\lib\m2m2-envcands-1.2.1.jar;C:\Mango\web\modules\dnp3\classes;C:\Mango\web\modules\dnp3\lib\dnp34j.jar;C:\Mango\web\modules\dnp3\lib\m2m2-dnp3-1.7.0.jar;C:\Mango\web\modules\log4JReset\classes;C:\Mango\web\modules\log4JReset\lib\m2m2-log4JReset-1.2.0.jar;C:\Mango\web\modules\maintenanceEvents\classes;C:\Mango\web\modules\maintenanceEvents\lib\m2m2-maintenanceEvents-1.6.0.jar;C:\Mango\web\modules\controlcore\classes;C:\Mango\web\modules\controlcore\lib\m2m2-controlcore-1.2.0.jar;C:\Mango\web\modules\BACnet\classes;C:\Mango\web\modules\BACnet\lib\bacnet4j-3.2.4.jar;C:\Mango\web\modules\BACnet\lib\m2m2-BACnet-2.3.0.jar;C:\Mango\web\modules\onewire\classes;C:\Mango\web\modules\onewire\lib\m2m2-onewire-1.6.0.jar;C:\Mango\web\modules\onewire\lib\OneWireAPI.jar;C:\Mango\web\modules\onewire\lib\RXTXcomm.jar;C:\Mango\web\modules\watchlists\classes;C:\Mango\web\modules\watchlists\lib\m2m2-watchlists-1.8.0.jar;C:\Mango\web\modules\TCPIP\classes;C:\Mango\web\modules\TCPIP\lib\m2m2-TCPIP-1.2.0.jar;C:\Mango\web\modules\twilio\classes;C:\Mango\web\modules\twilio\lib\m2m2-twilio-1.2.0.jar;C:\Mango\web\modules\twilio\lib\twilio-java-sdk-3.4.1-jar-with-dependencies.jar;C:\Mango\web\modules\dataFile\classes;C:\Mango\web\modules\dataFile\lib\jaxb-api.jar;C:\Mango\web\modules\dataFile\lib\jaxb-core.jar;C:\Mango\web\modules\dataFile\lib\jaxb-impl.jar;C:\Mango\web\modules\dataFile\lib\jaxb-jxc.jar;C:\Mango\web\modules\dataFile\lib\jaxb-xjc.jar;C:\Mango\web\modules\dataFile\lib\m2m2-dataFile-1.2.0.jar;C:\Mango\web\modules\modbus\classes;C:\Mango\web\modules\modbus\lib\m2m2-modbus-1.8.0.jar;C:\Mango\web\modules\modbus\lib\modbus4j-3.0.3.jar;C:\Mango\web\modules\pointLinks\classes;C:\Mango\web\modules\pointLinks\lib\m2m2-pointLinks-1.6.0.jar;C:\Mango\web\modules\vmstat\classes;C:\Mango\web\modules\vmstat\lib\m2m2-vmstat-1.6.0.jar;C:\Mango\web\modules\jsonFileImport\classes;C:\Mango\web\modules\jsonFileImport\lib\m2m2-jsonFileImport-1.2.2.jar;C:\Mango\web\modules\asciiFile\classes;C:\Mango\web\modules\asciiFile\lib\m2m2-asciiFile-1.3.0.jar;C:\Mango\web\modules\sqlConsole\classes;C:\Mango\web\modules\sqlConsole\lib\m2m2-sqlConsole-1.6.0.jar;C:\Mango\web\modules\meta\classes;C:\Mango\web\modules\meta\lib\m2m2-meta-2.3.0.jar;C:\Mango\web\modules\egauge\classes;C:\Mango\web\modules\egauge\lib\m2m2-egauge-1.2.0.jar;C:\Mango\web\modules\mbus\classes;C:\Mango\web\modules\mbus\lib\commons-beanutils-1.8.3.jar;C:\Mango\web\modules\mbus\lib\commons-collections-3.2.2.jar;C:\Mango\web\modules\mbus\lib\commons-lang-2.5.jar;C:\Mango\web\modules\mbus\lib\commons-logging-1.1.1.jar;C:\Mango\web\modules\mbus\lib\ezmorph-1.0.6.jar;C:\Mango\web\modules\mbus\lib\json-lib-2.4-jdk15.jar;C:\Mango\web\modules\mbus\lib\m2m2-mbus-1.2.0.jar;C:\Mango\web\modules\mbus\lib\mbus4j-core-1.0.0.jar;C:\Mango\web\modules\mbus\lib\mbus4j-master-1.0.0.jar;C:\Mango\web\modules\mbus\lib\spsw-java-0.0.7.jar;C:\Mango\web\modules\mangoApi\classes;C:\Mango\web\modules\mangoApi\lib\apache-log4j-extras-1.2.17.jar;C:\Mango\web\modules\mangoApi\lib\m2m2-mangoApi-1.2.1.jar constants.UserComment.TYPE_POINT=2 org.directwebremoting.Container=org.directwebremoting.impl.DefaultContainer@18fb25f constants.DataTypes.IMAGE=5 org.apache.jasper.compiler.TldCache=org.apache.jasper.compiler.TldCache@1de1ef1 org.springframework.web.servlet.FrameworkServlet.CONTEXT.springDispatcher=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Fri Sep 21 11:33:17 EDT 2018]; 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@65e718 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@1bae04b constants.AuditEventType.TYPE_EVENT_HANDLER=EVENT_HANDLER
-
Did it fix the users page, or it's not loading?
How large is the Mango/databases/mah2.h2.db file? I am surprised you would be running out of memory immediately upon restarting... that would suggest to me the mah2.h2.db file is very large and your system would benefit from a backup / clean restore shrinking of the database. I wonder also if you are using the NoSQL module. Some directions on doing a backup and restore are here: https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backup
-
-
The mah2.h2.db file is 552,044 KB
We are nor using the NoSQL module, just the BACNet IP module
Everything is loading from what I see, except the data sources and datapoints. -
This is 2.8? And you are using Chrome? Have you overridden the xstyle library as described in this thread (see Jared's post at the end): https://forum.infiniteautomation.com/topic/3551/data-sources-does-not-appear
-
Yes, this is 2.8. I am using Mozilla Firefox.
-
Have you restarted since getting the memory error? Have you allocated explicit memory with a .bat script like those in Mango/bin/ext-available (by placing an appropriate memory script in Mango/bin/ext-enabled and then stopping, then starting (not restarting))?