Help Center> MapReduce Service> User Guide (ME-Abu Dhabi Region)> FAQs> Big Data Service Development> What If an Excel File Downloaded on Hue Failed to Open?
Updated on 2022-12-08 GMT+08:00

What If an Excel File Downloaded on Hue Failed to Open?

  1. Log in to a Master node as user root and switch to user omm.

    su - omm

  2. Check whether the current node is the active OMS node.

    sh ${BIGDATA_HOME}/om-0.0.1/sbin/status-oms.sh

    If active is displayed in the command output, the node is the active node. Otherwise, log in to the other Master node.

    Figure 1 Active OMS node
  3. Go to the ${BIGDATA_HOME}/Apache-httpd-*/conf directory.

    cd ${BIGDATA_HOME}/Apache-httpd-*/conf

  4. Open the httpd.conf file.

    vim httpd.conf

  5. Search for 21201 in the file and delete the following content from the file (The values of proxy_ip and proxy_port in Figure 2 are examples only):
    ProxyHTMLEnable On
    SetEnv PROXY_PREFIX=https://[proxy_ip]:[proxy_port]
    ProxyHTMLURLMap (https?:\/\/[^:]*:[0-9]*.*) ${PROXY_PREFIX}/proxyRedirect=$1 RV
    Figure 2 Content to be deleted
  6. Save the modification and exit.
  7. Open the httpd.conf file again, search for proxy_hue_port, and delete the following content:
    ProxyHTMLEnable On
    SetEnv PROXY_PREFIX=https://[proxy_ip]:[proxy_port]
    ProxyHTMLURLMap (https?:\/\/[^:]*:[0-9]*.*) ${PROXY_PREFIX}/proxyRedirect=$1 RV
    Figure 3 Content to be deleted
  8. Save the modification and exit.
  9. Run the following command to restart the httpd process:

    sh ${BIGDATA_HOME}/Apache-httpd-*/setup/restarthttpd.sh

  10. Check whether the httpd.conf file on the standby Master node is modified. If the file is modified, no further action is required. If the file is not modified, modify the httpd.conf file on the standby Master node in the same way. You do not need to restart the httpd process.
  11. Download the Excel file again. You can open the file successfully.