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.

Hi Ian,

Why are you trying to do such a thing?

No, a named range can only be associated with one time period or series in one time range. The reason being is that the ranges expand and you would never want one series to overwrite another (which I believe you could still achieve by having two named ranges grow over one another, one down and one over).

If they are distinct time periods, why not put them on their own sheets? I would think Excel has the capacity to generate a column by appending columns on other sheets together.

I would expect you want 80+ named ranges for the columns in the report. You could have all the points in the same time period in the excel report setup, but you would probably want to separate each sheet into its own time period so that each sheet has timestamps that you could append together to create something like the example excel cells you posted.

Old thread I know, but I've been having this same issue on a RPi installation.
I hard set the memory and I think it might have fixed the issue.

Cheers
Dan

I would say the closest we are to having a fail-over system right now would involve some development work to revive some of the NoSQL database integrations we've done in the past, which would generally lead to increased costs in either licensing the database engine or the increase in disk and processing power some of those database engines require. It also means we're not necessarily in control of solving every encountered issue (which we still aren't, but this was a large reason of why we kept improving out own NoSQL database).

It's completely possible for authenticated users to crash Mango by making too many and/or too large of requests. Give someone data source permission and there's even more potential for trouble.

That said, a single, well managed instance can achieve the metrics specified in your post of requirement 5. Thinking of your own deployments, do they already meet that standard?

Hi Jenny,

I have sent you an email about this. For license and accounts issues, we prefer to conduct those via email.

Hi James, welcome to the forum!

You could use the Mango/bin/h2-web-console script to launch the H2 web console, then after logging in with the credentials from the H2 section of your Mango/overrides/properties/env.properties file (or Mango/classes/env.properties) to login and DELETE FROM dataPoints WHERE id=(SELECT MAX(id) FROM dataPoints); You can find more about the web console here: https://help.infiniteautomation.com/about-the-h2-database

Or you could move your Mango/databases/ directory, then start with a clean database and restore a backup. That should give you a little time to poke around before it shuts down due to too many points.

@sbaik said in filter points being used in graphics:

Is there a way to sort all points being used in the custom page graphics?

There's no easy way unfortunately. The only suggestion I could give you would be to open your dev tools and look at the network requests your dashboards are making. You will see requests to /rest/v2/point-values/time-period/{xid} for example when its fetching point values for a particular point. You can also find the websocket for live point value updates and see what XIDs it is listening to -

0_1542409809862_e6672f1a-3cc9-4f2e-b834-e2cae9bd6803-image.png

@andrew-oxner said in 3D Models of a building or space.:

But I'm looking for more of a 3D environment is this possible in Mango?

Are you actually wanting to display the 3D model in the dashboard so you can click and drag and rotate etc? Craig is talking about displaying a 2D projection of the model in the dashboard. If you did want a 3D model it would be possible using a WebGL library but you would have to implement that all yourself.

If you do want a 2D projection you could follow Craig's advise and export the drawing as a JPEG then manually draw SVG layers over it and bind these to the Mango data points. Or you could export the projection as a PDF, convert to SVG then manipulate that. There may be an easier way to export to SVG, thats just what I found when I googled exporting SVG from Sketchup.

Hi @JoelHaggar

Ahh, Excel my nemesis, we meet again :P

Thanks for the suggestion. I added 2 rows to the report template and the export is now working as I would expect.

0_1542229499290_0ed22c39-16e4-4d96-a327-122f55915683-image.png

Ian

Technically the free / unlicensed core in 3.x is only to be used for personal, educational, and other non-commercial uses, so I hope that limitation is being honored along with the 300 point limit.

There are other ways to do it that would not use a data point, and then not get you closer to the limit. Still operating under the assumption this is Modbus, the Modbus4J code is open source and you could create the right requests from a script and submit them to the Modbus master. A script solution is also completely possible (where you read the registers as a different data type and then do bitmasking in a script as you suggest. You would just have to encode what to do to the Modbus point into the point that updates the script's context, and do something like,

//untested var data = input.value.split("-"); var mask = 1 << parseInt(data[1]); if( data[0] === "0" ) modbusPoint.set( modbusPoint.value & ~mask ); else modbusPoint.set( modbusPoint.value | mask );

Or for that matter scripts can use the JsonEmport tool to modify points during script runtime.

Thanks @phildunlap with your fast support once again.

C:/Users/DCU/test outside C:/Mango

The webserver cannot try to open a database URL outside its Mango directory. You're probably looking for a URL of jdbc:h2:C:/Mango/databases/mah2

Thanks. It worked.

@phildunlap I guess the thought was to have the function built in within Mango to not rely on the browser. In the case that the user needs to switch browser, clear cookies, or something to that aspect. But I did not consider the vulnerability of network information. Will talk it over with our tech director some more.

I'm updating once 1 minute. Did not seem to bad. So far no issue with mysql.

I just thought of another possibility. Mango 3.x uses Log4J2 where previous versions of Mango used Log4j. If you have a log4j jar that is getting loaded it won't pickup the log42.xml configuration and would probably use some default of only printing to stdout.

I would check your <ma-home>/lib folder and see if there are log4j and log4j2 jars.

ls <ma-home>/lib/*log4j*

This should list only these jars:

lib/log4j-api-2.10.0.jar lib/log4j-jcl-2.10.0.jar lib/log4j-core-2.10.0.jar lib/log4j-slf4j-impl-2.10.0.jar

I had missed setting the permission for the JSON store UI pages and UI menus as you suggested.

Thanks Phil.

Was there any more info available with regards to LDAP availability? @Jared-Wiltshire

@MStangl

You can create a PowerShell script which you schedule on your Windows server.

I started with a snippet created by the Chrome DevTools, you go to the network tab and find the API request and copy the network request as shown below.
0_1540419295859_9cd1ff81-04bc-4ac4-aab0-8fc3f95e7525-image.png

You just need to create an authentication token (on your users page) and add it as a header as shown below.

Invoke-WebRequest ` -Uri "http://yourmangohostname:8080/rest/v2/point-values/single-array/time-period" ` -Method "POST" ` -Headers @{"Accept"="text/csv"; "Authorization"="Bearer yourlongtokenthatyougenerated"} ` -ContentType "application/json;charset=UTF-8" ` -Body "{`"dateTimeFormat`":`"yyyy-MM-dd'T'HH:mm:ss.SSSXXX`",`"from`":`"2018-10-23T21:54:58.951Z`",`"to`":`"2018-10-24T21:54:58.952Z`",`"bookend`":true,`"timezone`":`"UTC`",`"fields`":[`"TIMESTAMP`",`"VALUE`"],`"xids`":[`"DP_9004cb57-f1cb-4415-a078-b60999f06c4d`",`"DP_cd2587fa-93ab-492a-9963-e9f5c4e0a40d`",`"DP_915fb444-6133-45eb-a700-4f415662e108`",`"DP_506cab2d-8f10-46ca-90aa-ff9d8f6c0400`"]}" ` -OutFile "myData.csv"

You will just need to modify the script so that it gets data relative to the time it runs at and names the output file accordingly. And also obviously make it get the XIDs you are interested in.

@pspivey said in Point value may not be reliable:

will i be able to fix the issue on a V2 mango without upgrading to V3?

I suggested a fix for backwards compatibility with v2 publishers to one of our developers who was working on it. I'll see what became of it.