OnCommand Insight DataWarehouse backups fail due to a transaction timeout

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 182

Visibility:: Public

Votes:: 0

Category:: oncommand-insight-data-warehouse

Specialty:: oci

Last Updated:

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 back

Yet, 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'