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.
Data Source Copy error
-
Hello,
I'm trying to make a copy of all Data Source (SNMP) with Data points inside but get an error:
PreparedStatementCallback; SQL [INSERT INTO eventDetectors (xid,sourceTypeName,typeName,data,dataPointId) VALUES (?,?,?,?,?)]; Unique index or primary key violation: "EVENTDETECTORSUN1_INDEX_D ON PUBLIC.EVENTDETECTORS(XID) VALUES ( /* 83 */ CAST('ED_36ee074e-96d4-4fa2-a7ab-581e45afd47d_43' AS VARCHAR_IGNORECASE) )"; SQL statement: INSERT INTO eventDetectors (xid,sourceTypeName,typeName,data,dataPointId) VALUES (?,?,?,?,?) [23505-181]; nested exception is org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "EVENTDETECTORSUN1_INDEX_D ON PUBLIC.EVENTDETECTORS(XID) VALUES ( /* 83 */ CAST('ED_36ee074e-96d4-4fa2-a7ab-581e45afd47d_43' AS VARCHAR_IGNORECASE) )"; SQL statement: INSERT INTO eventDetectors (xid,sourceTypeName,typeName,data,dataPointId) VALUES (?,?,?,?,?) [23505-181]If I remove Event Detectors from Data Points then I can make a copy.
If I'm copying just Data point with Event Detector then Mango makes a copy but without Event Detector configured.. -
Hi dovydas,
Thanks for bringing this to our attention. This is fixed in the upcoming 3.3 release (this upcoming Monday, partially released if you're on the beta release channel or lower). This was its git issue: https://github.com/infiniteautomation/ma-core-public/issues/1163