Help Center> MapReduce Service> FAQs> Big Data Service Development> What Can I Do If the Excel File Downloaded by Hue Cannot Be Opened?
Updated on 2023-10-19 GMT+08:00

What Can I Do If the Excel File Downloaded by Hue Cannot Be Opened?

This section applies only to versions earlier than MRS 3.x.

  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 are the same as those in the actual environment.)
    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.

Big Data Service Development FAQs

more