Disabling the web metric collection for Hue


You see the following error in the Hue server logs: DatabaseError: ORA-01000: maximum open cursors exceeded, when you are using Oracle as the backend database for Hue.


Cloudera Manager Agent collects web metrics from the Hue server to monitor its health. At times, the number of metrics that are collected can exhaust the number of available cursors on the Oracle database, resulting in the ORA-01000: maximum open cursors exceeded error.


  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue > Configuration and deselect the Web Metric Collection option.
    Image showing the web metric collection and web metric collection duration options under Hue configurations in Cloudera Manager.
  3. Click Save Changes.
  4. Restart the Hue service.