[Bug 2716] UDT Definition system.tag.configure Regression

[deon.korb]

Hi,

I have an issue after the following change:

@sreis

965: Importing UDTs with existing definitions doesn’t overwrite the entire definition when overwrite option is selected.
Importing a UDT or UDT instance with the overwrite collision policy now overwrites the entire definition instead of just the member tags included with the import.

It seems that UDT instance members that are memory tags are reinitialised after this change if overwrite is selected.

In the past, the UDT would overwritten with memory tag value overrrides in instances intact. If members were deleted in the UDT definition, they would remain (not ideal).

Right now, after the UDT definition is updated, all memory tags are overwritten.

How can I go about distributing standards UDT definitions across multiple gateways and tag providers without destroying memory tag values in the member of the instances?

Running 8.1.6.

Regards,
Deon

[mrojas]

Are you referring to a UDT Instance inside a UDT Definition or outside of one?

[deon.korb]

No, the UDT definition only contains folder and atomic members.

What I’m seeing is that after 8.1.6 all memory tags lose their value override when the definition is updated with overwrite option. No members were renamed.

Merge can work for most applications, but it does not remove the occasional deleted member.

[nminchin]

This would suggest that all property overrides are removed which is extremely concerning!! Some UDT instances will not perform correctly without overridden properties and contain key configuration. What about things like dataset tag values?. Can you check if this is also the case for other types of property overrides, not just the value?

I have noticed that even in earlier versions, that deleting a UDT definition that has instances and then adding it back in will remove all property overrides on the instances, which is super dangerous. This is happening in v8.1.5. Actually I might create my own topic for this one

[deon.korb]

You are correct. All properties overrides are gone. Only parameters survive.

What is also new, is that my UDT distribution script between tag providers is locking up the internal DB. This happened without any real changes, just a redistribution:

Error saving node configuration
simpleorm.utils.SException$Jdbc: Opening com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource@5bcf3bfa

at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:113)

at com.inductiveautomation.ignition.gateway.localdb.persistence.PersistenceSession.initialize(PersistenceSession.java:31)

at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.getSession(PersistenceInterfaceImpl.java:64)

at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.save(PersistenceInterfaceImpl.java:105)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager.saveVersion(InternalJsonStorageManager.java:91)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager$RedundantTagSynchronizationProvider.setVersion(InternalJsonStorageManager.java:592)

at com.inductiveautomation.ignition.gateway.redundancy.types.AbstractSynchronizedStateProvider.incrementVersion(AbstractSynchronizedStateProvider.java:93)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager$RedundantTagSynchronizationProvider.processChanges(InternalJsonStorageManager.java:640)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager.save(InternalJsonStorageManager.java:181)

at com.inductiveautomation.ignition.gateway.tags.config.BatchConfigOperation.save(BatchConfigOperation.java:120)

at com.inductiveautomation.ignition.gateway.tags.config.BatchConfigOperation.execute(BatchConfigOperation.java:105)

at com.inductiveautomation.ignition.gateway.tags.evaluation.BatchContextImpl$OpController.run(BatchContextImpl.java:240)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Connection is locked. Datasource only allows one connection at a time. More information was logged to the gateway console.

at com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource.getConnection(SingleConnectionDatasource.java:75)

at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:111)

... 14 common frames omitted

Error saving record: "[InternalJsonStorageInfoRecord 3 Dirty0]"
simpleorm.utils.SException$Jdbc: Opening com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource@5bcf3bfa

at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:113)

at com.inductiveautomation.ignition.gateway.localdb.persistence.PersistenceSession.initialize(PersistenceSession.java:31)

at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.getSession(PersistenceInterfaceImpl.java:64)

at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.save(PersistenceInterfaceImpl.java:105)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager.saveVersion(InternalJsonStorageManager.java:91)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager$RedundantTagSynchronizationProvider.setVersion(InternalJsonStorageManager.java:592)

at com.inductiveautomation.ignition.gateway.redundancy.types.AbstractSynchronizedStateProvider.incrementVersion(AbstractSynchronizedStateProvider.java:93)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager$RedundantTagSynchronizationProvider.processChanges(InternalJsonStorageManager.java:640)

at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager.save(InternalJsonStorageManager.java:181)

at com.inductiveautomation.ignition.gateway.tags.config.BatchConfigOperation.save(BatchConfigOperation.java:120)

at com.inductiveautomation.ignition.gateway.tags.config.BatchConfigOperation.execute(BatchConfigOperation.java:105)

at com.inductiveautomation.ignition.gateway.tags.evaluation.BatchContextImpl$OpController.run(BatchContextImpl.java:240)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Connection is locked. Datasource only allows one connection at a time. More information was logged to the gateway console.

at com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource.getConnection(SingleConnectionDatasource.java:75)

at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:111)

... 14 common frames omitted

[sreis]

Thanks for this info. Looking into this right now

[nminchin]

What happened to version 8.1.6 LTS? It appears to be gone!

I just noticed that 8.1.6 LTS is no longer available on the current version OR previous version download pages. How long until the LTS release of 8.1.7 for those of us that have 8.1.6 deployed in production environments?? Any comments as to why it ‘disappeared’ all of a sudden?

Fyi 8.1.6 has been pulled due to this regression, @deon.korb thanks for posting!