Skip to main content
NetApp Knowledge Base

OCI DWH fails to connect to reporting server due to the installation directory being write protected

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

Applies to

  • OnCommand Insight (OCI)
  • OnCommand Insight Data Warehouse (DWH)
  • IBM Cognos
  • Microsoft Windows Server

Issue

  • OnCommand Insight Data Warehouse displays the following error:
"Failed to connect to reporting server, server might be down. Confirm reporting server availability and try again."
  • This error is also repeated in the dwh.log file, accompanied by several other identifying log lines

\SANscreen\log\dwh.log

2022-03-09 06:02:00,109 INFO  [Thread-8 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:74) - >>>>>>>>>>>>>>>>>> Starting Job{name='Backup', id=1950957}
2022-03-09 06:02:00,109 INFO  [Thread-8 (ActiveMQ-client-global-threads)] BackupScheduleBean (BackupScheduleBean.java:67) - Starting Create Backup
2022-03-09 06:02:00,468 ERROR [Thread-8 (ActiveMQ-client-global-threads)] BackupScheduleBean (BackupScheduleBean.java:89) - Failed to generate dwh and cognos backup.
javax.ejb.EJBException: 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.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: ; nested exception is:
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
2022-03-09 06:02:00,484 ERROR [Thread-8 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:135) - Job{name='Backup', id=1950957} failed
com.netapp.sanscreen.dwh.backup.BackupException: Failed to generate backup.

  • The log line that really narrows down the real issue is found in the cogserver.log file

\SANscreen\log\cogserver.log

2022-03-09T15:17:22.023-0500       ERROR  com.cognos.pogo.reportservice.ProcessManager                [com.cognos.pogo.async.service.connection.bibustkserver.BIBusTKServerConnectionFactory-queryProcessManager-ProcessMgrThread] NA      External Report Server process External Process cannot be started
java.io.IOException: Cannot run program "D:\Program Files\SANscreen\cognos\analytics\ibm-jre\jre\bin\java.exe" (in directory "D:\Program Files\SANscreen\cognos\analytics\wlp"): CreateProcess error=19, The media is write protected
[...]
Caused by: java.io.IOException: CreateProcess error=19, The media is write protected

 

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.