Support Questions

Find answers, ask questions, and share your expertise

HUE 2.3, CDH 4.3 list_workflows, list_coordinators exceptions

avatar
Expert Contributor

Hi, suddenly we've clicked

"GET /oozie/list_workflows/ HTTP/1.1"

 

And got exception. What do we do wrong?

 

 

19:19:54.000INFOaccess
10.100.141.164 devops - "GET /oozie/list_workflows/ HTTP/1.1"
19:19:54.000INFOmiddleware
Processing exception: User matching query does not exist.: Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg/django/core/handlers/base.py", line 100, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/apps/oozie/src/oozie/views/editor.py", line 70, in list_workflows
'json_jobs': json.dumps(list(data.values_list('id', flat=True))),
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/desktop/core/src/desktop/lib/django_util.py", line 221, in render
**kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/desktop/core/src/desktop/lib/django_util.py", line 144, in _render_to_response
return django_mako.render_to_response(template, *args, **kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/desktop/core/src/desktop/lib/django_mako.py", line 117, in render_to_response
return HttpResponse(render_to_string(template_name, data_dictionary), **kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/desktop/core/src/desktop/lib/django_mako.py", line 106, in render_to_string_normal
result = template.render(**data_dict)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Mako-0.7.2-py2.6.egg/mako/template.py", line 412, in render
return runtime._render(self, self.callable_, args, data)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Mako-0.7.2-py2.6.egg/mako/runtime.py", line 766, in _render
**_kwargs_for_callable(callable_, data))
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Mako-0.7.2-py2.6.egg/mako/runtime.py", line 798, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Mako-0.7.2-py2.6.egg/mako/runtime.py", line 824, in _exec_template
callable_(context, *args, **kwargs)
File "/tmp/tmp6o407q/oozie/editor/list_workflows.mako.py", line 219, in render_body
__M_writer(escape(unicode( workflow.owner.username )))
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg/django/db/models/fields/related.py", line 302, in __get__
rel_obj = QuerySet(self.field.rel.to).using(db).get(**params)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg/django/db/models/query.py", line 341, in get
% self.model._meta.object_name)
DoesNotExist: User matching query does not exist.
1 ACCEPTED SOLUTION

avatar
Expert Contributor

Magic tricks with ids didn't help. They brought more problem during migration later.
We did partial migration (users+their saved pig/hive/impala scripts/queries) from sqlite to postgre and the problem gone.
The problem is solved for us.

View solution in original post

10 REPLIES 10

avatar
Expert Contributor

Magic tricks with ids didn't help. They brought more problem during migration later.
We did partial migration (users+their saved pig/hive/impala scripts/queries) from sqlite to postgre and the problem gone.
The problem is solved for us.