Accessing HUE Metastore Manager in BDA 4.4.0/CDH 5.5.1 Gives Errors: "Failed to retrieve tables for database..." and "Unable to access databases. Query Server or Metastore may be down" (Doc ID 2279625.1)

Last updated on JUNE 24, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Information in this document applies to any platform.

Symptoms

An error is raised on BDA V4.4.0/CDH 5.5.1 when navigating to the HUE Metastore Manager (HMS) via the web browser.

Failed to retrieve tables for database: mydb

Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret=*, guid=")\*")), orientation=0, maxRows=5000): TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='Expected state FINISHED, but found ERROR', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Expected state FINISHED, but found ERROR:26:25', 'org.apache.hive.service.cli.operation.Operation:assertState:Operation.java:164', 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:311', 'org.apache.hive.service.cli.operation.OperationManager:getOperationNextRowSet:OperationManager.java:262', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:732', 'sun.reflect.GeneratedMethodAccessor15:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:497', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:422', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1671', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy19:fetchResults::-1', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:438', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:695', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults

This happens for only one user and this same user also encounters errors when trying to to run a query in Hue (i.e. using a describe command):

"Expected state FINISHED, but found ERROR

Your query has the following error(s):
Unable to access databases. Query Server or Metastore may be down."

This problem happens with both Google Chrome and Internet Explorer web browsers and persists even after clearing the browser cache. The user that encounters this error is a member of a group called '<group_name>.' Other users in this same group, do not experience the error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms