• BG

    Hello,
    I have a customer that is trying to get the evaluation version of Mango3.4.4 to run on their Windows 2012 Server. They followed the instructions for the windows install and they are sure the Java path is correct but when they run the application they just get a browser with a grey screen and a floating orange circle.

    Here are the most recent log entries:

    INFO  2018-06-12T08:45:55,157 (com.serotonin.m2m2.Main.main:97) - Starting Mango 3.4.4 with Schema Version: 25 
    INFO  2018-06-12T08:45:56,250 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'asciiFile', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,282 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'BACnet', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,297 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'controlcore', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,344 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dashboardDesigner', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,344 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\Program Files (x86)\M2M\web\modules\dashboardDesigner\web\dox\manifest.xml 
    INFO  2018-06-12T08:45:56,344 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dataFile', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,391 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dataImport', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,422 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'deviceConfig', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,438 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\Program Files (x86)\M2M\web\modules\deviceConfig\web\dox\manifest.xml 
    INFO  2018-06-12T08:45:56,438 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dnp3', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,469 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'egauge', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,485 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'envcands', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,516 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'excelReports', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,563 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'graphicalViews', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,610 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'Haystack', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,625 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'http', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,657 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'jsonFileImport', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,688 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'log4jDS', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,703 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'log4JReset', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,703 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'loggingConsole', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,750 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'maintenanceEvents', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,750 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mangoApi', v3.4.3 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,766 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mangoUI', v3.4.3 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,782 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\Program Files (x86)\M2M\web\modules\mangoUI\web\dox\manifest.xml 
    INFO  2018-06-12T08:45:56,860 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,875 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'meta', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,907 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'modbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,922 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'onewire', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,938 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'opcda', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,938 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pakbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,969 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pointLinks', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:56,985 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pop3', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,016 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'reports', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,032 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'scheduledEvents', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,047 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'scripting', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,063 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'serial', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,063 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'snmp', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,078 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sqlConsole', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,110 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sqlds', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,125 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'ssh', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,157 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sstGlobalScripts', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,172 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sstGraphics', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,203 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'TCPIP', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,203 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'templateConfig', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,219 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'twilio', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,250 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'virtualDS', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,250 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'vmstat', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,266 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'watchlists', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:45:57,297 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'internal', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-06-12T08:46:03,657 (com.serotonin.m2m2.Lifecycle.initialize:223) - Initializing Spring Object Mapper 
    INFO  2018-06-12T08:46:05,829 (com.serotonin.m2m2.Lifecycle.loadLic:529) - Checking license... 
    INFO  2018-06-12T08:46:05,829 (com.serotonin.m2m2.Lifecycle.loadLic:615) - License file not found 
    INFO  2018-06-12T08:46:06,047 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42) - Initializing H2 connection manager 
    INFO  2018-06-12T08:46:10,405 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:38) - Starting instance with core version 3.4.4, db 25 
    INFO  2018-06-12T08:46:10,937 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:77) - Initializing 1 NORMAL priority data sources in 8 threads. 
    INFO  2018-06-12T08:46:11,390 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source 'Mango Internal' initialized 
    INFO  2018-06-12T08:46:11,390 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:413) - Data source 'Mango Internal' took 440.577152ms to start 
    INFO  2018-06-12T08:46:11,468 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:109) - Initialization of 1 NORMAL priority data sources took 531ms 
    INFO  2018-06-12T08:46:11,593 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:160) - Starting 0 Publishers... 
    INFO  2018-06-12T08:46:11,609 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:172) - 0 Publisher's started in 32ms 
    INFO  2018-06-12T08:46:17,492 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:32) - Mango Automation context starting 
    INFO  2018-06-12T08:46:17,492 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:40) - Mango Automation context started 
    INFO  2018-06-12T08:46:40,024 (com.serotonin.m2m2.web.mvc.rest.v1.BacnetDiscoveryRestController.<init>:54) - Creating Discovery Rest Controller 
    INFO  2018-06-12T08:46:42,836 (com.serotonin.m2m2.web.mvc.rest.v1.DataPointRestController.<init>:75) - Creating Data Point Rest Controller. 
    ERROR 2018-06-12T08:46:43,602 (com.serotonin.m2m2.rt.maint.UpgradeCheck.run:70) - Connect to store.infiniteautomation.com:443 [store.infiniteautomation.com/35.161.166.188] failed: Connection timed out: connect 
    org.apache.http.conn.HttpHostConnectException: Connect to store.infiniteautomation.com:443 [store.infiniteautomation.com/35.161.166.188] failed: Connection timed out: connect
    	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:159) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:373) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:381) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:237) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:185) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:111) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56) ~[httpclient-4.5.5.jar:4.5.5]
    	at com.serotonin.web.http.HttpUtils4.executeWithRetries(HttpUtils4.java:174) ~[mango-3.4.4.jar:?]
    	at com.serotonin.web.http.HttpUtils4.getTextContent(HttpUtils4.java:132) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.dwr.ModulesDwr.getAvailableUpgrades(ModulesDwr.java:380) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.dwr.ModulesDwr.upgradesAvailable(ModulesDwr.java:289) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.rt.maint.UpgradeCheck.run(UpgradeCheck.java:53) [mango-3.4.4.jar:?]
    	at com.serotonin.timer.Task.runTask(Task.java:179) [mango-3.4.4.jar:?]
    	at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) [mango-3.4.4.jar:?]
    	at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:336) [mango-3.4.4.jar:?]
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) [?:?]
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
    	at java.lang.Thread.run(Thread.java:844) [?:?]
    Caused by: java.net.ConnectException: Connection timed out: connect
    	at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) ~[?:?]
    	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) ~[?:?]
    	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:400) ~[?:?]
    	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:243) ~[?:?]
    	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:225) ~[?:?]
    	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:148) ~[?:?]
    	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:402) ~[?:?]
    	at java.net.Socket.connect(Socket.java:591) ~[?:?]
    	at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:339) ~[httpclient-4.5.5.jar:4.5.5]
    	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142) ~[httpclient-4.5.5.jar:4.5.5]
    	... 21 more
    INFO  2018-06-12T08:46:44,133 (com.serotonin.m2m2.web.mvc.rest.v1.DataSourceRestController.<init>:61) - Creating DS Rest Controller 
    INFO  2018-06-12T08:46:45,149 (com.infiniteautomation.mango.rest.v2.BACnetRestController.<init>:156) - Creating BACnet v2 Rest Controller. 
    INFO  2018-06-12T08:46:45,587 (com.infiniteautomation.mango.rest.v2.DataPointRestController.<init>:98) - Creating Data Point v2 Rest Controller. 
    INFO  2018-06-12T08:46:46,571 (com.infiniteautomation.mango.rest.v2.MetaRestController.<init>:51) - Creating meta rest controller. 
    WARN  2018-06-12T08:46:51,602 (org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandlers:114) - Neither 'urlMap' nor 'mappings' set on SimpleUrlHandlerMapping 
    INFO  2018-06-12T08:46:55,290 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: EnvCanEditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: HttpDataSourceDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: TcpIpDataSourceEditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: Pop3EditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: HaystackDataSourceDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: DataFileDataSourceEditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: OPCDAEditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: BACnetMSTPEditDwr 
    INFO  2018-06-12T08:46:55,306 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: PakBusEditDwr 
    INFO  2018-06-12T08:46:55,321 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: MBusEditDwr 
    INFO  2018-06-12T08:46:55,321 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.infiniteautomation.mango.pakbus.dwr.PakBusEditDwr 
    INFO  2018-06-12T08:46:55,321 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: SNMPEditDwr 
    INFO  2018-06-12T08:46:55,352 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: InternalEditDwr 
    INFO  2018-06-12T08:46:55,352 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: SerialEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: MetaEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: DnpEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: ModbusEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: Log4jEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: ScriptingEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: SshDataSourceEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: AsciiFileEditDwr 
    INFO  2018-06-12T08:46:55,368 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr 
    INFO  2018-06-12T08:46:55,415 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: OneWireEditDwr 
    INFO  2018-06-12T08:46:55,415 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: SqlEditDwr 
    INFO  2018-06-12T08:46:55,415 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: VMStatEditDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: EgaugeDataSourceDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: BACnetIPEditDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: br.org.scadabr.dnp3.dwr.DnpEditDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: ControlCoreEditDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.modbus.dwr.ModbusEditDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1188) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr 
    INFO  2018-06-12T08:46:55,431 (com.serotonin.m2m2.Lifecycle.configureDwr:1195) - Added DWR definition for: VirtualEditDwr 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_point_details.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/pending_alarms.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/event_handlers.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_sources.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/point_hierarchy.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/mailing_lists.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/publishers.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/system_settings.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/modules.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/emport.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/error.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/not-found.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/unauthorized.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/upload.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/mobile_data_point_details.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/dataImport.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/csvDataImport.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/excel-reports.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/public_view.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/views.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,618 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/logging_console.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/point_links.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/reportChart.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/m2m_report_import.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/reports.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/templateConfig.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/mobile/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/internal/workItems.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/internal/threads.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/internal/status.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/internal/tasks.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/internal/queueStats.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_point_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.DataPointEditController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_source_properties.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.DataSourcePropertiesController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_source_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.DataSourceEditController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/data_source_properties_error.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.DataSourceEditController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/help.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.HelpController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/startup.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.StartupController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/shutdown.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.ShutdownController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/publisher_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.PublisherEditController] 
    INFO  2018-06-12T08:46:55,634 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/users.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.controller.UsersController] 
    INFO  2018-06-12T08:46:55,649 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/view_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,649 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/maintenance_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,649 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/scheduled_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,649 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/sqlConsole.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    INFO  2018-06-12T08:46:55,649 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:362) - Mapped URL path [/globalScripts.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
    
    

    Any suggestion on how to proceed would be greatly appreciated.

    posted in User help read more
  • BG

    Hello Phil,
    Thanks for checking. I have been redesigning spreadsheet to do the AVERAGEIFS and the COUNTIFS in long hand format. Through trial and error I found the same as yourself that the SUMIFS and FLOOR works fine.

    As mentioned initially, this is for Mango 2.8 so hopefully will not be a problem when I finally get Mango 3 off the ground.

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello all,
    I am using Mango 2.8 with Excel Reports module 1.1.4.
    Does the excel reports module support the following functions:

    FLOOR
    SUMIFS
    AVERAGEIFS

    Also if those functions are included inside IF statements?

    The functions above work fine in my desktop Office Excel 2010 and are supported in our Office 365 version.

    But when I run the report in the excel reports module I get an error message in the Finished Reports page saying "Failure error evaluating cell "Calculations!G5" and sometimes the cell reference changes.

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello Phil,
    Fantastic! That works perfectly now.

    Cheers
    Brian

    posted in User help read more
  • BG

    Thank you Phil,
    I will give this a try.

    Cheers
    Brian

    posted in User help read more
  • BG

    Hello,
    I am revisiting this thread because I have moved one step further in my requirements.
    The reports and excel reports menu items are working and opening a new tab in legacy view for Mango 3. I have amended the web address to include the commands to remove the header, footer and toolbar as shown in the screen shot below:

    0_1521038014398_report_page 1.jpg

    However, if the user deletes part of the text in the address bar, the toolbar comes back as shown below:

    0_1521038078467_report_page 2.jpg

    My fear is that the user will then continue to use the legacy buttons for the Data Points Details, Events, Watchlist and Graphics View.

    Where can I edit the toolbar to remove the buttons for the items that are now incorporated into the Mango 3 UI?

    Thank you for your help.

    Cheers
    Brian

    posted in User help read more
  • BG

    Hello Phil,
    Thank you for your reply.
    I have deleted the menu item and created a new one. It now works.

    I think the URL wasn't being picked up correctly with the previous menu item. When you go into edit the menu item it showed the correct URL, but when the menu item was displayed in the item list the URL was not the same.

    Cheers
    Brian

    posted in User help read more
  • BG

    Hello,
    I am using Mango 3.3.3 and Centos 7.4.

    I would like all of our users to have left hand menu items for the following:

    1. Data Points (already available)
    2. Events (already available)
    3. Watchlists (already available)
    4. Help (already available)
    5. Reports (from reports.shtm)
    6. Excel Reports (from excel-reports.shtm)
    7. Custom Graphics dashboard (not created yet but will be used as the home page)

    I am stuck on the first menu item that I am trying to set up: Reports.
    I have created the menu item as shown in the screen shot:

    0_1520875033349_report_menu.jpg

    The Report item appears in the menu list as you can see in the screen shot, it also appears in the menu list for my users. However, clicking the Report menu item does not open the reports page. If I right click and choose open in a new tab or new window I can access the reports page.

    Have I configured the menu item wrong?

    Cheers,
    Brian

    posted in User help read more
  • BG

    Hello,
    I have a way of doing this in Mango 2.8 and DGlux. It does not apply to Mango 3 but I am sure someone could script this into a data point and use it like I have.

    I have a numeric data point in the meta data source called time_diff. The data point has the following script using the timestamp of incoming data:

    var time = raw.time;
    var d = new Date();
    var now = d.getTime();
    var diff = (now-time) / 1000;
    if (diff < 3600) return 1; return 0; //1 is good

    I then use the result to change a colour setting in DGlux and to trigger an event for a "No Data" alarm

    I am still getting to grips with Mango 3 but I am sure this could be used to grey out an indicator or gauge in the dashboard.

    Cheers
    Brian

    posted in Dashboard Designer & Custom AngularJS Pages read more