Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

OnCommand Insight DataWarehouse backups fail due to a transaction timeout

Views:
60
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'

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support