Skip to main content
NetApp Knowledge Base

OnCommand Insight Data Warehouse fails to connect to reporting server due to inadequate memory and CPU reservations

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

Applies to

  • OnCommand Insight (OCI) 7.3.X
  • OnCommand Insight Data warehouse (DWH) 7.3.X

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
 
Caused by: java.sql.SQLException: No operations allowed after statement closed.
 
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.
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.
Caused by: org.apache.axis.AxisFault: CM-REQ-4342 An error occurred with the client.
 
 
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 into Cognos reporting portal intermittently.

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device