I sent the requested data a couple weeks and haven't heard anything. Is there any update on this or can someone give my a different way to extract historical data.

I'm being asked to provide daily gas and water usage for the entire 2019 year.

My report still shows queued under the State heading and the download and view buttons are disabled. I've tried a new simple report with just Timestamp and value and it does the same thing.

I see no errors in the log file.

Any ideas?

Thanks, that helped, The report I created was uploaded and I assigned data points. When I run it, it shows up in the Finished / in-progress with the state "queued".

what does this mean?

I'm trying to create a new hourly rollup excel report. When I copy the hourly report sample and try to save it as a new report I get "Report template file not found".

Under the "select template file" link, when I click on Sample1_2.xlsx it opens up File stores > Excel_report_templates and it's empty.

If I try to create a new excel report I can't save it because i get the same "Report template file not found" error.

How do I get the report templates back or how do I create a new excel report?

I'm going to convert my H2 database to a MySql database. I have read all the posts I can find and am confident I can manage the conversion but I didn't find anything about what version of MySQL to use and I want to make sure I use a version of MySql that has been tested.

What is the recommended version of MySQL should I be installing?

I'm running Mango version 3.7.4.

Sorry.

I have lost my dashboard data as well. When I go to the edit menu items page, I don't see any of my custom menus.

If I create a new menu and try to point it to my custom pages, there are no pages there to point it to.

If I look in the JSON, there are no custom menu items.

Because I'm running Mango in a vm, I restored a snapshot to just prior to purging the events and have determined that things disappeared after I did the purge of events using the H2 Console.

Do to the large number of events, I couldn't get logged in long enough to purge them thru system settings, so I connected to the H2 console and ran "delete from events".

Is there a better way that I should have used?

I had a problem where my events table had got really big so I couldn't log in (it kept timing out). Using the H2 Console I was able to delete everything from the events table but now I have no custom pages or menu structure.

If I edit the latest json backup, it looks like the menu structure is there but I get nothing except for Data Point Details, Events, Watch lists and the Administration section, even after re-importing the json file.

I also don't see any errors in the ma.log except for a server key validation issue regarding CloudConnect.

Any help would be greatly appreciated.

@terrypacker

Thanks for the reply.

I have finally been able to connect.

The solution was to change my h2-web-console.sh back to -webAllowOthers

and my JDBC URL to jdbc:h2:/opt/mango/databases/mah2.199

@joelhaggar

I can't connect the same as the example because the database is on a different server from where I'm running the web browser so I get the message "Database /opt/mango/mah2 not found". However if I modify the file to -tcp -tcpAllowOthers as the help link suggests, then I just get "This page isn't working.

When I modified my h2-web-console.sh like yours, I can now get to the Login screen but then I get

@craigweb

Hello,

Yes, I was running it like ./h2-web-console.sh - webAllowOthers.

I modified the h2-web-console.sh and added -webAllowOthers to the end of the file but I still get the same result...

(Web Console server running at http://127.0.1.1:8081 (only local connections).

I'm really stuck. The events table has over 100,000 lines in it and even running in safe mode I am unable to purge the events.

I really need a way to access the H2 database outside of Mango so I can manually purge the table.

Mango is running on a Linux box with command line only.

Any help would be appreciated as Mango has been down for over a week now.

Thanks for all the suggestions.

I have started Mango in SAFE mode (verified by looking in the ma.log file but I still can't get logged in.

I changed the env.properties file to set set db.web.start=true and tried to run the H2 web Console using web-console.sh -webAllowOthers but I get the message "Web Console server running at http://127.0.1.1:8081 (only local connections).

I thought the flag -webAllowOthers would let me connect to the Console from my laptop.

Is there something I'm missing in order to run the H2 database manager?

Hello,

We are in the middle of switching BAS providers and as a result Mango has been flooded with events as devices go offline and then come back online.

My events table has too many records and now I can't connect to Mango.

I've tried to use the "purge all events" button from System Settings, but cannot stay logged in long enough to get to this page.

I also tried using Mango/bin/h2-web-console.sh but the page doesn't load.

Is there any other way I can delete all events?

Is there a video that explains how it works, similar to the video for SVG graphics?

Thanks, this is a big help. I'm very new to trying to make interactive pages.

Is there some other setup that I need to do to get the ng-click to work?

Hello,

I watched the Data rollup video and it is exactly what I'd like to do.

Is there somewhere that I can see the code behind this example? I've checked the examples in my Mango installation but don't see anything close to the Data rollup example.

Thanks.

When I tried to restart Mango through the upgrades module I get the following error and the system won't restart.

ERROR 2019-12-04T12:58:57,204 (com.serotonin.m2m2.util.timeout.TimeoutTask.run:61) - Uncaught Task Exception
java.lang.ClassCastException: com.infiniteautomation.asciifile.rt.AsciiFilePointLocatorRT cannot be cast to com.serotonin.m2m2.internal.InternalPointLocatorRT
at com.serotonin.m2m2.internal.InternalDataSourceRT.doPoll(InternalDataSourceRT.java:110) ~[?:?]
at com.serotonin.m2m2.rt.dataSource.PollingDataSource.doPollNoSync(PollingDataSource.java:228) ~[mango-3.7.1.jar:?]
at com.serotonin.m2m2.rt.dataSource.PollingDataSource.scheduleTimeoutImpl(PollingDataSource.java:183) ~[mango-3.7.1.jar:?]
at com.serotonin.m2m2.rt.dataSource.PollingDataSource$1.scheduleTimeout(PollingDataSource.java:85) ~[mango-3.7.1.jar:?]
at com.serotonin.m2m2.util.timeout.TimeoutTask.run(TimeoutTask.java:59) ~[mango-3.7.1.jar:?]
at com.serotonin.timer.Task.runTask(Task.java:179) ~[mango-3.7.1.jar:?]
at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) ~[mango-3.7.1.jar:?]
at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:314) ~[mango-3.7.1.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_172]

Yes, the NoSQL module is installed. As for users, right now Admin is the only user.