OnCommand Insight DataWarehouse のバックアップは、トランザクションタイムアウトのために失敗します
に適用されます
OnCommand Insight DataWarehouse ( DWH ) 7.3.x
問題
バックアップは、同様のエラーで失敗します
<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
ただし、dwh_upgrade.log
では、バックアップは正常に圧縮されます
<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'