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.

@phildunlap said in Data Source gone after upgrade to 3.6:

select id, name from dataSources;

Sorry, I mixed up "id" and "xid". That worked and I can now see the "disappeared" original serial data source on the data sources page.

This seems to have fixed all the issues I had after upgrading to 3.6.x. No more errors in ma.log, The datapoint is now logging the serial data properly and the event handler is sending me the results again via email.

Thanks so much for your patience, I am not a java or javascript programmer so I really struggle with this.

@phildunlap I wondered if that was your intention so I tried leaving out he square brackets, still get errors for some reason.

BadSqlGrammarException: StatementCallback; bad SQL grammar [update dataSources set data=(select data from dataSources where id=DS_bf3ed68c-3ced-491a-af92-d228a4ce345c) where id=DS_80cdd749-28ad-4612-93d4-cac1ea998a1c;]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "UPDATE DATASOURCES SET DATA=(SELECT DATA FROM DATASOURCES WHERE ID=DS_BF3ED68C-3CED[*]-491A-AF92-D228A4CE345C) WHERE ID=DS_80CDD749-28AD-4612-93D4-CAC1EA998A1C; "; expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT, LIKE, ILIKE, REGEXP, IS, IN, BETWEEN, AND, OR, GROUP, HAVING, WINDOW, QUALIFY, UNION, EXCEPT, MINUS, INTERSECT, ORDER, OFFSET, FETCH, LIMIT, SAMPLE_SIZE, FOR, [, ::, *, /, %, +, -, ||, ~, !~, NOT, LIKE, ILIKE, REGEXP, IS, IN, BETWEEN, AND, OR, ,, )"; SQL statement: update dataSources set data=(select data from dataSources where id=DS_bf3ed68c-3ced-491a-af92-d228a4ce345c) where id=DS_80cdd749-28ad-4612-93d4-cac1ea998a1c; [42001-199]
Press Escape to dismiss. Press Control-"o" to

@phildunlap If I put your SQL statement into the "SQL" update window I get the following error:
BadSqlGrammarException: StatementCallback; bad SQL grammar [update dataSources set data=(select data from dataSources where id=[DS_bf3ed68c-3ced-491a-af92-d228a4ce345c]) where id=[DS_80cdd749-28ad-4612-93d4-cac1ea998a1c];]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "UPDATE DATASOURCES SET DATA=(SELECT DATA FROM DATASOURCES WHERE ID=[[*]DS_BF3ED68C-3CED-491A-AF92-D228A4CE345C]) WHERE ID=[DS_80CDD749-28AD-4612-93D4-CAC1EA998A1C]; "; expected "ALL, ANY, SOME"; SQL statement: update dataSources set data=(select data from dataSources where id=[DS_bf3ed68c-3ced-491a-af92-d228a4ce345c]) where id=[DS_80cdd749-28ad-4612-93d4-cac1ea998a1c]; [42001-199]
Press Escape to dismiss. Press Control-"o" to

@phildunlap said in Data Source gone after upgrade to 3.6:

update dataSources set data=(select data from dataSources where id=[new id here]) where id=[old id here];

This is the error message get when I submit the SQL Query:

update dataSources set data=(select data from dataSources where id=[DS_bf3ed68c-3ced-491a-af92-d228a4ce345c]) where id=[DS_80cdd749-28ad-4612-93d4-cac1ea998a1c];

ShouldNeverHappenException: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "UPDATE DATASOURCES SET DATA=(SELECT DATA FROM DATASOURCES WHERE ID=[[*]DS_BF3ED68C-3CED-491A-AF92-D228A4CE345C]) WHERE ID=[DS_80CDD749-28AD-4612-93D4-CAC1EA998A1C]; "; expected "ALL, ANY, SOME"; SQL statement: update dataSources set data=(select data from dataSources where id=[DS_bf3ed68c-3ced-491a-af92-d228a4ce345c]) where id=[DS_80cdd749-28ad-4612-93d4-cac1ea998a1c]; [42001-199]

Apparently the SQL syntax is wrong. I am not enough of an SQL expert to find it.

@phildunlap OK, I get it now. Databits is the serial parameter of the data source. The data source is the problem because it disappeared when I upgraded to Mango 3.6, leaving the data point "orphaned". Do I need to recreate the original data source with the same XID from an old backup?

@phildunlap I am not familar with the databits parameter. How would I determine that?

@phildunlap I am also sending the ma.log to support@infiiteautomation.com.

Tom

@phildunlap

I finally got some time to work on this issue. When I try to delete the "orphaned" datapoint I get the following error in the UI.

Error deleting data point: Internal Server Error — com.serotonin.ShouldNeverHappenException: java.lang.IllegalArgumentException: Invalid enum value

What the data source and datapoint function is to receive a serial message from a moisture balance in the lab and email me the result. It worked great for over a year until I upgraded to 3.6.0 and that is when the Data Source disappeared.

I have tried to recreate both the Data Source and Data Point under different names, using the same regex expression to parse the serial message. So far I don't get anything logged in the data point results.

I do get the serial message logged in the /opt/mango/log/serialIO-x.log so I know the Mango server is getting the messages.

Any suggestions on how to trouble-shoot this would be appreciated.

Modules page shows:
serial
Serial Data Source
Version: 3.6.0
License: done unrestricted
Signature: verified_user
Signed: by store
Vendor: Infinite Automation Systems Inc.

I can send the ma.log if you tell me where to send it. There are some error entries. But I can't understand what all it says.

I had a serial data source that disappeared after upgrading to 3.6. This data source had one data point that still shows up and I can't delete it. The data point still has data in the database up until the upgrade. I thought about backing up and manually deleting the data source in the .json file, but importing the .json file won't overwrite what's in memory I figure. Help.

Here is another type of solution that would work for you. https://www.automationdirect.com/stride/index Its a VPN remote access "router" you can access from anywhere or mobile device.

@phildunlap I am curious, now that I have the NoSQL DB showing as licensed on the Modules Page. If I look at "Administration>System Status>Server Info" it shows:

Database Type: H2"
SQL Database size: 9.9 MiB
NoSQL point value database size: 785.0 KiB

Since the Database Type is H2, does this mean Mango isn't using the NoSQL DB?

Just want to make sure I have everything configured right.

Tom

@chrapchp said in Temporal observational data on collected data:

I'm also going to chime in and suggest that a alpha-numeric data point might be good way to go. We have added data point tags in v3.3 so you will be able to tag the data points with the growingChamber=X, nutrientTank=Y and plantType=Z. You can then locate all the data points with a given set of tags.

We are hoping to have v3.3 released within the next few weeks, the data point tags will be usable via the REST API upon release but it might be another couple of weeks before the tagging functionality will be added to the UI.

Jarad,
Where can I find more information on the data point tags? Any examples of using them with the REST API? I would like to tag my meta data and data points created in a batch process time span with a batch number tag for easy retrieval when creating a batch report.

Thanks. Downloaded license and both modules now show as licensed. Thanks.

If

@phildunlap said in Mango Commercial Licence, but NoSQL DB Unlicensed?:

You are correct! You should be able to click 'update my license' on the modules page, then you'll be presented with a list of options for licensing your core and modules. Don't change your core license, and you should see any applicable modules you don't already have licensed have a cost of $0.00. If you whole order costs $0, the license will be granted to you immediately and you can license those modules. So after selecting them and >making the 'purchase' you can hit 'download license' from Mango.

If I try "making the purchase" I get an error popup that says "Error confirming core license type: no-change"

Thanks Phil, I followed your instructions and will assume then the modules are active and have no restrictions despite saying they are "unlicensed" on the modules page.

I purchased a lite commercial license and installed the "Mango Automation 3.2.2 Enterprise" linux package over the top of a "Mango Automation 3.2.2 Free" installation. When I go to the modules page from the home page it shows "mangoNoSqlDatabase" and "advancedComponents" modules as "Unlicensed". My understanding the Commercial license included the NoSqlDatabase.

I want to store user supplied data for generating reports. For instance, batch number, batch start time, batch end time, comments during the batch process with time stamps, lab result values for the batch etc.

Would creating data points for these in a "virtual data source" be the best way to accomplish this?

I connected the moisture balance as a serial data source and it works. I get the percent moisture value as an alpha-numeric which is fine for logging. I don't need any charting. I changed the Regex to include "%M" so a unit is displayed when looking at point details.

The data source (moisture balance RS232) sends a 0x04 (EOT End Of Transmission) at the end of each message. If I try to use a terminator string of 0x04 it won't work. If I ignore the terminator it does work, so no big deal. Just curious why I cant use the hex value 0x04 as a terminator. Is there another encoding that would work?

Now I need to figure out how to have the result emailed to me when the data point is logged.
Tom

I was able to get the REGEX tester to duplicate your results and got the value as group 1.

Thanks for your help today, I learned a lot. I plan to connect the serial data source to the Mango server tomorrow. I'll see what happens then.

Tom