• Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. thutchis

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website
    • Profile
    • Following 0
    • Followers 0
    • Topics 6
    • Posts 28
    • Best 1
    • Controversial 0
    • Groups 0

    Tom Hutchison

    @thutchis

    Small craft malt producer in NE Oregon. Supplying craft malt for small breweries and distilleries

    1
    Reputation
    706
    Profile views
    28
    Posts
    0
    Followers
    0
    Following
    Joined Last Online
    Website www.goldrushmalt.com Location Baker City, OR Age 68

    thutchis Unfollow Follow

    Best posts made by thutchis

    • Where to enter user supplied data?

      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?

      posted in User help
      thutchisT
      thutchis

    Latest posts made by thutchis

    • RE: Data Source gone after upgrade to 3.6

      @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.

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      @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

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      @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

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      @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.

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      @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?

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

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

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

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

      Tom

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      @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.

      posted in User help
      thutchisT
      thutchis
    • RE: Data Source gone after upgrade to 3.6

      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.

      posted in User help
      thutchisT
      thutchis
    • Data Source gone after upgrade to 3.6

      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.

      posted in User help
      thutchisT
      thutchis