Cannot remove device in IDE error “Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed”

i posted this question in the community forum, but was advised i should also post here. Im not a developer, so please go easy on me!

ive got a few devices that have been replaced for various reasons that i wantt to get rid of. Instead of thinking ahead and properly disconnecting the zwave devices from the hub, they were just replaced and discarded and are either in storage or broken. So from what i read, i can just delete the device from the IDE, and if it ever gets used again it just has to be properly removed/paired by the new hub.

so im in the IDE and i want to delete these zwave devices. I randomly started having issues with my mesh so i thought some devices were still looking for these in the path back to the hub. repairing the mesh didnt help any, so i wanted to remove them and repair the mesh again. I get an error every time i try to delete the device (zwave and zigbee) from the IDE. This happens from my computer at work on Firefox, Chrome and Chrome incognito, as well as my home computer. Ive rebooted and cleared cookies on both adn tried it all again, so i know its not isolated to a browser, cookie cache, PC or location.

when i try to delete a device, it takes about 3 minutes to work, then reloads the page for the device with this error at the top:

Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

im not sure this is related to my zwave issues, but it seems to have started after i repaired the mesh the first time after removing several devices. Im having some significant latency with zwave (iris motion sensor in my kitchen will turn on my lightify lights almost instantly, but the zwave switches next to it, that are part of the same smart lighting automation, sometimes take 5 or 7 seconds to turn on) so i want to clean things up as much as i can and get my stuff working well again.

to add to that, i have also tried to force remove the zwave devices from the classic app and the new app. in the classic app, once i tell it to forcefully remove the device, the app says it was successfully removed but the device is still showing everywhere (both apps and the IDE). when i force delete in the new app, it also tells me the device has been deleted, one devices was deleted but the others i try fail, and i get the error “this device can’t be deleted because its operating normally”. this specific device was trashed a long time ago after it failed and wouldnt communicate after extensive troubleshooting.

so im still stuck with a bunch of devices i want to get rid of, but cannot. i plan on contacting ST support early next week whenever i have time, but wanted to see if someone else had seen similar issues or knew how to fix it first.

Duplicate of Cannot remove device in IDE error "Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed"

1 Like

© 2019 SmartThings, Inc. All Rights Reserved. Terms of Use | Privacy Policy

SmartThings; SmartApps®; Physical Graph; Hello, Home; and Hello, Smart Home are all trademarks of the SmartThings, Inc.