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

Developer Programs Writing Device Types
1

hi, im trying up do a minor tweek to a TRV device handler, but when i try to save in the ide i get this error

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

i cant seam to do anything with the DH it wont even role back from git hub

2

Same here but only for z-wave DHā€¦

3

Same my cloud based DH work fine. Any one know whatā€™s going on. Iā€™m in UK using classic app

4

Weā€™re also seeing reports from users. Would recommend sending a note to support@smartthings.com as https://status.smartthings.com/ this showing all clear today

1 Like
5

Im trying to add a device handler for my new dome water main and im getting the errors

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

And

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

So its nothing im doing worng?

6

Nothing its smartthings email them and log a ticket

1 Like
7

Does this happen alot? Im starting to think I should have went with Wink hub

8

Iā€™m generally satifyed. But yes sometimes they push updates without testing properly. So now and again you might need a bit of intervention

1 Like
9

I have been on hold for 30 mins what should I do just wait it out? I really want to try this thing out. How do I create a ticket?

10

Send an email to support@smartthings.com

Tagging @Brad_ST

11

Email support as above. But id stay on the phone if you have been on this long

Let us know what they say/do

12

Well they said they donā€™t support device handlers and any errors we get while adding them is not something they can help us with. I have only had ST for a mo or so and Im worried they will take away the old app and half my stuff will stop working :frowning:
Is ST the only hub that uses 3rd party handlers? Is that why so many people like it?

Now i only get this line
Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

13

Its an ide issue not the DH. Mabey this is an excuse or indication they are shutting down the old ide in favour of the new portal

14

UPDATE: I installed the new app and clicked ADD DEVICE MANUALLY and clicked Valve and it showed DOME in the list. I clicked that and a few secs later it was added. Now it shows in the old app as well. So I didnt need the device handler after all, I just had to add it into the newer ST app.

15

i event tryed creating a fresh DH using the CT100 Thermostat
example DH and even that wont save

16

it wont let me turn off (set to ā€˜noneā€™) the git hub link, could th error be related to git hub connection?

Oh No! Something Went Wrong!

Error

500: Internal Server Error

URI

/ide/device/update

Reference Id

4cc32a88-fc34-4715-96f7-e107185edf2a

Date

Fri Dec 21 10:35:22 UTC 2018

17

Try using incognito/private browsing window.

18

Unlikely since the new portal is only for SmartApps and DTHā€™s can only be done through the Groovy platform. Plus there are too many customers using the old groovy apps, shutting it down would do more harm than good.

19

Didnā€™t work ā€¦

20

Thanks for everyoneā€™s patience. As of 11:30 AM EST this issue is resolved.

2 Likes