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:
223
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

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.