Solved
Data Store integrity violation error
After updating a Thing Shape that gets used in multiple other thing templates, we get this error attached.
after 2 mins of this error, the SQL DB goes into a DEADLOCK.
Hard to say what the underlying issue is, but this looks pretty bad ...
As such I would recommend logging a ticket with support.ptc.com
You could 'experiment' by creating your own additional ThingShape adding it to some not all of your templates and making changes to see what happens. But either your change is affecting too much at one time or is doing something that might interfere with a dependency of some sort