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.

@sbaik said in Custom Page disappeared:

I believe it was on an earlier version than 3.2. Perhaps it was deleted before I updated to 3.4 last week and just noticed it after.

Ah OK, that's probably it then. I feel confident we fixed the issue, let me know if you see anything odd again.

Hi Phildunlap,
Thank you for the response. I have a whole lot of meta data points used to scale a value, which are alphanumeric. I want to change to numeric. Not to worried about losing data. Just wanted to make sure It is safe to do a bulk update with out anything else going wrong.

Thank so much @Jared-Wiltshire and @phildunlap ;)

@jared-wiltshire

Thank you, that is exactly what I was missing. I tried ma-get-point-value, but did not know to put "point.setValue(true)" in the ma-button markup.

Oh, and the timezone on the system settings page is gotten from the operating system. So, in Linux you would want to modify /etc/timezone

If there were, it would be a nightmare to investigate it through console screenshots.

You can email your logs and your latest Mango/backup/core-database-H2-...zip file to support@infiniteautomation.com and I'll give it a look.

Awesome! i'll give it a shot...
Thank you.

Hmm. Rereading the description, it sounds like maybe the websockets were still getting updates appropriately but for whatever reason the CSRF token was missing from the chart data request? Are you accessing it through a proxy?

Without some clearer direction and it being, "fixed" we're unlikely to keep thinking about it. If you notice it again, be sure to recount what you were doing in the system for some time prior. I would not expect the existence of users to be the affecting factor. If it were, restarting would be sufficient to blow out any caching, and user session information is not stored in the database.

Hi Felipe,

I'm not sure what you mean. The Modbus4J library will already handle the conversion from a numeric point value (a double) in Mango to whatever data type it needs to be. You can see the exact code for this here: https://github.com/infiniteautomation/modbus4j/blob/50d7dfe6c0330bf720ae97492c9213c21fdb8d5f/Modbus4J/src_cdc/com/serotonin/cdc/modbus4j/locator/NumericLocator.java#L201

I can assure you many people have set values to integer registers through the Mango interface. I am not sure what this means,

Considering all tests and results, I think the problem is that the float values (regulator outputs) are not compatible with the 2 byte integer data, which is the type that Arduino can read and process.

Hi Phillip,

I suspect you need to delete your Mango/work/jsp directory.

Thanks Phil,

Your logic was sound.

I was trying to set this remotely over a very slow connection I wonder if that was the problem??

Went to site and deleted the point and started again, everything worked fine.

Cheers!

Hi pierjsap,

I too am somewhat confused. It sounds like you're asking if the SQL data source can read data? The answer is yes, it can store data from the data source's select statement or it can be configured only to update the table (which it must be if you wish to set the point to some dynamic value in the update statement, a point that isn't "Modify Table Only" will only have a constant update statement), You either have to match the 'Column name' property of the point to the column names returned, or do a "row based query" and have the column name match the value in the first column of the results, then its value in the second column.

There are a few examples scattered around the forum. If you can say more, perhaps I can recall a relevant thread for you.

@pierjsap He's talking about the old /watch_list.shtm page. But, it's good advice when making your own charts from watchlists in the new UI!

Hi tangyiping,

I would expect that's caused by an NaN or Infinite value in one of the point's series. Do most of them chart individually if you uncheck the other boxes adding those points to the chart? Or, perhaps easier, if you download the data using the green download arrow after the chart has not rendered, do you find NaN and Infinity in the data set?

Otherwise I would wonder if there was a message in your logs about what could have failed. But, it looks like the chart generated without showing any values, as in these images where I have a script doing,

p.set(Number.POSITIVE_INFINITY); RuntimeManager.sleep(5000); p.set(Number.NEGATIVE_INFINITY); RuntimeManager.sleep(5000); p.set(Number.NaN);

I produced these charts:

0_1527784446556_no-extremes.png
0_1527784456922_extremes.png

@pierjsap said in How to managed data on DB and query by ma-point-query:

What's wrong?

I specified "from a dashboard", you are trying to use the function in a server side script. These are two different environments.

@pierjsap said in How to managed data on DB and query by ma-point-query:

Would you give me an example of how to recall classes and methods for working with datasoruce and datapoint and extracting the fields?

I was not suggesting to tag data points from within a script, in fact I would advise against this. I was suggesting to setup all your data sources for the sensors and possibly meta data sources as required then tagging these through the bulk data point editor in the UI. You can these use these tags from your dashboards to locate the applicable data points for the machine you are viewing.

Hi Phildunlap,

I have an update. The mission time is being received through serial communication and is saved as a data point. How can I use that to configure the axis?

@phildunlap

SHOW !!!! Thank you, Thank you, Thank you.

Hi Gordoe,

Good question! Alas, I'm not too sure. i can tell you that the OPC module is using the org.openscada OPC version 0.9 library to actually do the OPC protocol. I have very limited experience with OPC devices. It looks like you could modify a Mango/bin/ext-available script to set the log level for the logger in the library to a lower level by change its JAVA_OPTS to -Dorg.slf4j.simpleLogger.defaultLogLevel=debug or put a config file someplace: https://stackoverflow.com/questions/14544991/how-to-configure-slf4j-simple

I'm not sure I found the ideal place to explore v0.9 of the source code for the library on the web.

JAVA_HOME would be defined as an environment variable in the OS, so that's Control Panel --> System --> Advanced System Settings --> Environment Variables as C:\path\to\jdk1.8.0_x

You could also modify your Path environment variable to ensure jdk/bin/ is sooner on the path than jre/bin/ (or remove the jre path entry entirely)

Are you sure you downloaded a JDK when you installed Java?

Great thanks! I will try that out.

The Import / Export tool tries to not delete things. You could delete them surgically from the database if you trust your SQL or you can.

delete from eventDetectors where sourceTypeName='DATA_POINT';

Then import your configuration backup of the data points again.