-
M mseverin
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.
-
M mseverin
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?
-
M mseverin
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?
-
M mseverin
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?
-
M mseverin
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.
-
M mseverin
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.
-
M mseverin
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?
-
M mseverin
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.
-
M mseverin
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
-
M mseverin
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.