SMART VIEW ERROR “CANNOT CONNECT TO THE PROVIDER. MAKE SURE IT IS RUNNING IN THE SPECIFIED HOST/PORT. ERROR(503) ” WHEN OPENING HYPERION PLANNING CONNECTION.

WHEN ATTEMPTING TO CONNECT FROM SMART VIEW TO HYPERION PLANNING THE FOLLOWING ERROR MESSAGE IS DISPLAYED:

Cannot connect to the provider. Make sure it is running in the specified host/port. Error(503)

This occurs due to The OHS server Timeout for APS is set too low. In configuration file mod_wl_ohs.conf the values for  “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” are too low and the connection to Smart View is timing out.

1. Shutdown the Essbase Server service or process.
2. Backup the mod_wl_ohs.conf configuration file. The file is found in the following location on your APS server:
   C:\Oracle\Middleware\user_projects\epmsystem\httpConfig\ohs\config\OHS\ohs_component
3. In mod_wl_ohs.conf increase the timeout in seconds for the “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” properties within the location section for APS:
   SetHandler weblogic-handler
   WeblogicCluster :13080
   WLIOTimeoutSecs 1800
   WLSocketTimeoutSecs 1800
4. Save the modified mod_wl_ohs.conf file.
5. Restart the Oracle HTTP Server and the WebLogic Managed server service or process for APS.