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.

posted in User help

both.

posted in User help

I have two modbus licenses, one for the new instance and one for the old. So I'd be happy to go for the core less the old modbus license.

the modbus license is included below.

<license><core><guid>2-c52e4148-159b-4b71-a237-2ae79f1c930d</guid><distributor>IA</distributor></core><modules/><signature>
RMb1MeFKhqtMYYXMAGg2bzKwHdYc9MvjVhM8EwpXuLti5akZ/X/0kgbonmgGIOI4
InXrdBt1UdlYe4SgXiDOdYG9xNIRRb1Y19nlGG7COls5l1r7YfWG5zEj225oCG1c
lkWv9O5lH51xvc1euzWXIF82FV47UnTyyQXWK04+7K+8fFWnZGleBer+euevkOML
OOA/nvE92g25DuRpIEFTXopRXuiwkwjM7UKjscZTeMFOwNcZv1z0Zzq1spNLT0bw
uwf76VVARsyibopFs5PS9xt3IhxCcvtIWki+BVCja6lXq9Adokkcxh1LBOEOQpBa
1qD46FHZmhe2PgBuTcvsLLXwweDKsGiIw8eKMLB1fgfDxQ+6J7dBHCHiW9hB0uFy
nlTwwOq4QQmImtTrjforCfCUXT4IqniKSDjr1ZksGsgMEs4nW0XQ8OSOUVdSxrpU
90f1Ht2n0bWa7SJzTqLLQoucV70gothxhCIeSDWdOJ8V0V5pGHOyyao1j2yju1fO
4ryr0ctC9oBfHCtUy77cociQePF0w+x0WPykTMxzKxoLi7Mf4mlF2/AzPmnuaedh
FYYOTKcW74ShCdkL8X93SI0g0XBGZhdTXg6xb/bcm/p6yY3uxWr+/4o9oH23eXP5
ulDcG5SL4I3zodyavNfC4NwXv3VBce+mJR2c5uuBQ6A=</signature></license>

posted in User help

Hi I have created a modbus instance and configured the data points. Now if I go to the instance and look at the data points and try to filter on a column, I get a big SQL error:

I am using ubuntu 12.04 and openjdk-7. everthing else seems to work...

Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name]; nested exception is org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT DP.ID,DP.DATA,DP.XID,DP.DATASOURCEID,DP.NAME,DP.DEVICENAME,DP.ENABLED,DP.POINTFOLDERID,DP.LOGGINGTYPE,DP.INTERVALLOGGINGPERIODTYPE,DP.INTERVALLOGGINGPERIOD,DP.INTERVALLOGGINGTYPE,DP.TOLERANCE,DP.PURGEOVERRIDE,DP.PURGETYPE,DP.PURGEPERIOD,DP.DEFAULTCACHESIZE,DP.DISCARDEXTREMEVALUES,DP.ENGINEERINGUNITS,DS.NAME,DS.XID,DS.DATASOURCETYPE FROM DATAPOINTS AS DP JOIN DATASOURCES DS ON DS.ID = DP.DATASOURCEID WHERE ORDER[*] BY DP.DEVICENAME, DP.NAME "; expected "NOT, EXISTS, SELECT, FROM"; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name [42001-171]

I'd send you a screenshot of my instance but I don't seem to be able to attach anything ...

posted in User help

Hi I have created a modbus instance and configured the data points. Now if I go to the instance and look at the data points and try to filter on a column, I get a big SQL error:

I am using ubuntu 12.04 and openjdk-7. everthing else seems to work...

Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name]; nested exception is org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT DP.ID,DP.DATA,DP.XID,DP.DATASOURCEID,DP.NAME,DP.DEVICENAME,DP.ENABLED,DP.POINTFOLDERID,DP.LOGGINGTYPE,DP.INTERVALLOGGINGPERIODTYPE,DP.INTERVALLOGGINGPERIOD,DP.INTERVALLOGGINGTYPE,DP.TOLERANCE,DP.PURGEOVERRIDE,DP.PURGETYPE,DP.PURGEPERIOD,DP.DEFAULTCACHESIZE,DP.DISCARDEXTREMEVALUES,DP.ENGINEERINGUNITS,DS.NAME,DS.XID,DS.DATASOURCETYPE FROM DATAPOINTS AS DP JOIN DATASOURCES DS ON DS.ID = DP.DATASOURCEID WHERE ORDER[*] BY DP.DEVICENAME, DP.NAME "; expected "NOT, EXISTS, SELECT, FROM"; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name [42001-171]

I'd send you a screenshot of my instance but I don't seem to be able to attach anything ...

posted in User help

Joel I didn't know how quick you'd answer (and it was quick) so I went ahead and purchased a new one.

Could I exchange the modbus license against the purchase of a core license?

thanks Dominic

posted in User help

Hi I registered and created a license for my system (GUID 2-c52e4148-159b-4b71-a237-2ae79f1c930d) but I had to trash the VM and rebuild. it's now got a new GUID (2-ec099c5e-2634-4492-9656-09ddea64b2d2) and my purchase of the modbus module does not work.

How can I use my old paid for license file or can Infinite Automation refund me? I'm building out a demo system for tonight and will need to activate a new license very shortly.

BTW I tried to contact IA on their "contact me" link but it's broken.

thanks Dominic Storey

posted in User help

Hi I registered and created a license for my system (GUID 2-c52e4148-159b-4b71-a237-2ae79f1c930d) but I had to trash the VM and rebuild. it's now got a new GUID (2-ec099c5e-2634-4492-9656-09ddea64b2d2) and my purchase of the modbus module does not work.

How can I use my old paid for license file or can Infinite Automation refund me? I'm building out a demo system for tonight and will need to activate a new license very shortly.

BTW I tried to contact IA on their "contact me" link but it's broken.

thanks Dominic Storey

Dom Storey

@Dom Storey

Latest posts made by Dom Storey