OnCommand Insight DataWarehouse backups fail due to a transaction timeout
- Views:
- 343
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-insight-data-warehouse
- Specialty:
- oci
- Last Updated:
Applies to
OnCommand Insight DataWarehouse (DWH) 7.3.x
Issue
The DWH backup fails with the following error:
<InstallDrive>\SANscreen\wildfly\standalone\log\dwh.log
2020-01-11 19:17:16,498 ERROR [Thread-55 (ActiveMQ-client-global-threads-869291688)] BackupScheduleBean (BackupScheduleBean.java:67) - Failed to generate and send dwh and cognos reports.
javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff1e85aac5:17d2ef61:5e18fbf6:13441 status: ActionStatus.ABORTED >
2020-01-11 19:17:16,573 ERROR [Thread-55 (ActiveMQ-client-global-threads-869291688)] JobDispatcherBean (JobDispatcherBean.java:106) - Job{name='Backup', id=104114} failed
javax.ejb.EJBTransactionRolledbackException: Transaction rolled back