"MultipleObjectsReturned" Error Raised in Hue After Upgrade to BDA V4.6/CDH 5.8.2 (Doc ID 2206932.1)

Last updated on DECEMBER 10, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.6.0 and later
Linux x86-64

Symptoms

After upgrading from BDA V4.4 (CDH 5.5.1) to BDA V4.6 (CDH 5.8.2) the error below is raised in Hue after login or during any kind of action in the Hue Web UI. Hence queries can not be run.

[10/Nov/2016 11:11:05 +0100] api2 ERROR Error running <function get_document at 0x7fb9b88b1aa0>
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/desktop/core/src/desktop/api2.py", line 53, in decorator
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/desktop/core/src/desktop/api2.py", line 145, in get_document
document = Document2.objects.get_by_path(user=request.user, path=path)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/desktop/core/src/desktop/models.py", line 948, in get_by_path
doc = Document2.objects.get_home_directory(user)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/desktop/core/src/desktop/models.py", line 938, in get_home_directory
return self.get(owner=user, parent_directory=None, name=Document2.HOME_DIR, type='directory')
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/manager.py", line 151, in get
return self.get_queryset().get(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 313, in get
(self.model._meta.object_name, num))
MultipleObjectsReturned: get() returned more than one Document2 -- it returned 3!

 

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