Defects
SBM: Database locks are detected, ns.log errors unlockAndUpdateLastCronTriggeredDate, saveTime, deleteByNoShowOnClose
| ID: | D27943 | |
| Published: | 10 March 2023 | |
| Updated: | 20 April 2023 |
Defect Id
DEF347979
Originally Reported Against
SBM 12.0
Resolved In
SBM 12.1 Hotfix
Description
Errors in the ns.log include:
- ERROR 04-12-2022 03:42:32 [CronJob] -- Unexpected error during processing event with id=892251, event notificationId=440javax.persistence.TransactionRequiredException: Executing an update/delete queryat org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:413)at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1668)at com.serena.sbm.persistence.NotificationEventDAOImpl.lambda$unlockAndUpdateLastCronTriggeredDate$28(NotificationEventDAOImpl.java:546)at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:385)at org.springframework.orm.hibernate5.HibernateTemplate.execute(HibernateTemplate.java:337)at com.serena.sbm.persistence.NotificationEventDAOImpl.unlockAndUpdateLastCronTriggeredDate(NotificationEventDAOImpl.java:539)
- ERROR 04-12-2022 03:42:30 [DueDateService] -- Unexpected exception occuredjavax.persistence.TransactionRequiredException: Executing an update/delete queryat org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:413)at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1668)at com.serena.sbm.persistence.NotificationEventDAOImpl.lambda$saveTime$20(NotificationEventDAOImpl.java:426)at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:385)at org.springframework.orm.hibernate5.HibernateTemplate.execute(HibernateTemplate.java:337)at com.serena.sbm.persistence.NotificationEventDAOImpl.saveTime(NotificationEventDAOImpl.java:422)
- ERROR 04-12-2022 03:42:30 [Events] -- Exception thrown while processing events:javax.persistence.TransactionRequiredException: Executing an update/delete queryat org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:413)at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1668)at com.serena.sbm.persistence.ItemNotificationDAOImpl.lambda$deleteByNoShowOnClose$5(ItemNotificationDAOImpl.java:74)at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:385)at org.springframework.orm.hibernate5.HibernateTemplate.execute(HibernateTemplate.java:337)at com.serena.sbm.persistence.ItemNotificationDAOImpl.deleteByNoShowOnClose(ItemNotificationDAOImpl.java:71)
