Skip to main content
NetApp Knowledge Base

DWH backup job failed error "Failed to generate dwh and cognos backup"

Views:
60
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

OnCommand Insight Data warehouse 7.3.5 (DWH)

Issue

The DWH backup failed with below error

2020-12-12 10:02:00,142 INFO [Thread-3014 (ActiveMQ-client-global-threads)] BackupScheduleBean (BackupScheduleBean.java:50) - Starting Create Backup
2020-12-12 10:02:01,112 ERROR [default task-969] DwhRestApplication (DwhRestApplication.java:128) - Failed to get user cognos_admin, error: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.3.9.Final.jar!/:5.3.9.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.3.9.Final.jar!/:5.3.9.Final]
Caused by: java.sql.SQLException: No operations allowed after statement closed.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[?:?]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) ~[?:?]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) ~[?:?]
2020-12-12 10:02:01,737 ERROR [Thread-3014 (ActiveMQ-client-global-threads)] BackupScheduleBean (BackupScheduleBean.java:72) - Failed to generate dwh and cognos backup.
com.netapp.sanscreen.dwh.upgrade.UpgradeException: Failed to connect to reporting server, server might be down. Confirm reporting server availability and try again.
at com.netapp.sanscreen.dwh.upgrade.Backup.backup(Backup.java:99) ~[upgrade.jar:?]
at com.netapp.sanscreen.dwh.upgrade.UpgradeManagerBean.backupToFile(UpgradeManagerBean.java:116) ~[upgrade.jar:?]
at sun.reflect.GeneratedMethodAccessor8871.invoke(Unknown Source) ~[?:?]
Caused by: com.netapp.sanscreen.dwh.cognos.CognosClientException: Failed to connect to reporting server, server might be down. Confirm reporting server availability and try again.
at com.netapp.sanscreen.dwh.cognos.CognosClient.open(CognosClient.java:96) ~[cognos.jar:?]
at com.netapp.sanscreen.dwh.cognos.CognosClient.(CognosClient.java:76) ~[cognos.jar:?]
at com.netapp.sanscreen.dwh.upgrade.Backup.createCognosBackupFiles(Backup.java:188) ~[upgrade.jar:?]
at com.netapp.sanscreen.dwh.upgrade.Backup.backup(Backup.java:82) ~[upgrade.jar:?]
... 309 more
Caused by: org.apache.axis.AxisFault: CM-REQ-4342 An error occurred with the client.
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222) ~[axis.jar:?]
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129) ~[axis.jar:?]
 
 
Symptoms
 
1) DWH server was going to a freeze state for couple of days and when there is manual activity on server the server behaves normally.
 
2) Unable to login to reporting portal intermittently.

 

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