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.
SQL Data Points
-
Hi all-
I'm trying to get a sample of data from an SQL data source with a query that works in the execute test on the data source screen, but the same query in the data point settings doesn't get a value.
Take a look at the attached screenshots, the update time is 5 min but after waiting 30 minutes with the data point enabled no values write to the point history. Has the current version of M2M2 been tested with the SQL data source module? Might this be a configuration or script issue? Thanks,
Jordan
Attachment: download link
-
Check out the documentation on "row-based queries".
-
Hi Matt, thanks for the reply. I tried the row-based query and am still not seeing data. Does the "Update statement" section need to have a select statement even if it isn't updating (inserting to) the database? I tried it both with and without a select statement in the update statement box and didn't get data either way.
If the answer is in documentation, can you point me to the right section? See the attached screenshot for the execute test returning results but the same query in the "Update statement" section of the data point not getting anything. Let me know if you have any ideas. Thanks,
Jordan
Attachment: download link
-
Hi Jordan,
I think i may have steered you in the wrong direction. Try unchecking the "row-based query" box, and return to column based mode.
If you want to get, say, the MessageText value from the result set, set the data type to alphanumeric, and the column name to "MessageText". (The update statement field can be left blank; this is for when you want to write a value back to the database.) In my tests, these setting work fine.
-
Hi Matt-
I tried the row-based query and the data point still doesn't read the value in the database. I'm wondering if there's a timeout for requesting the value because the database I'm testing against is pretty slow. It might take a couple of minutes to return a query response. See my setup in the attachments, they show that we can get a test execution and are connected to the database. The data point hasn't generated any values in the weeks that I've had it set up. Can you spot any problems in the way the data point is configured? Thanks,
Jordan
Attachment: download link
-
You still have "row-based query" checked. Make sure you save the data source after making changes.
-
Thanks for the reply! My apologies, I had already changed it to column based and back again in testing. Changing it to column based didn't get me any data point values either.
I decided to test connecting to a local MySQL database to simplify things. I believe I found a bug with having multiple SQL data sources, I can extrapolate on that if you wish but that's outside of this conversation. Connecting to my local MySQL database yields the same effects- the test "Excecute" function in the data source setup screen gives me results, but the test data point that I set up doesn't ever get a value.
Please see the updated screenshots and advise if you have any ideas. The local database is the one that we're interested in connecting to ultimately. Thanks,
Jordan
Attachment: download link
-
Looks right, but a similar setup in my environment works fine. If you want me to take a closer look at your system, let me know.
-
I just installed TeamViewer on the server for Joel to look at a DGLux configuration, maybe we can figure out a plan for you to connect the same way. Thanks!
Jordan