OCI DWH fails to connect to reporting server due to the installation directory being write protected
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.logfile, 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.logfile
\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