Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

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

Views:
135
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.

 

Scan to view the article on your device
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