OnCommand Insight DataWarehouse backups fail due to a transaction timeout
Applies to
OnCommand Insight DataWarehouse (DWH) 7.3.x
Issue
Backups fail with similar errors
<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 backYet, in the dwh_upgrade.log, the backup is compressed successfully
<InstallDrive>\SANscreen\wildfly\standalone\log\dwh_upgrade.log
2020-01-11 19:09:57,762 INFO [Thread-55 (ActiveMQ-client-global-threads-869291688)] Backup (Backup.java:114) - Compressed dump temp files [E:\SANScreen_DwH\SANscreen\cognos\c10_64\deployment\cognos_7.3.1_sitename_DWH_content_store.zip, E:\SANScreen_DwH\SANscreen\cognos\c10_64\deployment\DailyBackup.zip, E:\SANScreen_DwH\SANscreen\wildfly\standalone\deployments\download.war\dwh_7.3.1_sitename_DWH_all_5859255573720676053.sql] to 'E:\SANScreen_DwH\SANscreen\wildfly\standalone\deployments\download.war\dwh_7.3.1_sitename_DWH_all_5859255573720676053.zip'