Murano dashboard "Applications" tab is unavailable

[Sergey Murashov]

Steps to reproduce:
1. Install OS+MURANO from 168 iso
2. Log in WebUI
3. Navigate to Murano>Applications

Actual result:
We get the following traceback:
HTTPInternalServerError at /murano/catalog/index
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/eventlet/wsgi.py", line 389, in handle_one_response
    result = self.application(self.environ, start_response)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 130, in __call__
    resp = self.call_func(req, *args, **self.kwargs)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 195, in call_func
    return self.func(req, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/muranoapi/openstack/common/wsgi.py", line 197, in __call__
    response = req.get_response(self.application)
  File "/usr/lib/python2.6/site-packages/webob/request.py", line 1296, in send
    application, catch_exc_info=False)
  File "/usr/lib/python2.6/site-packages/webob/request.py", line 1260, in call_application
    app_iter = application(self.environ, start_response)
  File "/usr/lib/python2.6/site-packages/keystoneclient/middleware/auth_token.py", line 582, in __call__
    return self.app(env, start_response)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 130, in __call__
    resp = self.call_func(req, *args, **self.kwargs)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 195, in call_func
    return self.func(req, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/muranoapi/openstack/common/wsgi.py", line 197, in __call__
    response = req.get_response(self.application)
  File "/usr/lib/python2.6/site-packages/webob/request.py", line 1296, in send
    application, catch_exc_info=False)
  File "/usr/lib/python2.6/site-packages/webob/request.py", line 1260, in call_application
    app_iter = application(self.environ, start_response)
  File "/usr/lib/python2.6/site-packages/paste/urlmap.py", line 203, in __call__
    return app(environ, start_response)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
    return resp(environ, start_response)
  File "/usr/lib/python2.6/site-packages/Routes-1.12.3-py2.6.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
    return resp(environ, start_response)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 130, in __call__
    resp = self.call_func(req, *args, **self.kwargs)
  File "/usr/lib/python2.6/site-packages/webob/dec.py", line 195, in call_func
    return self.func(req, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/muranoapi/openstack/common/wsgi.py", line 384, in __call__
    action_result = self.execute_action(action, request, **action_args)
  File "/usr/lib/python2.6/site-packages/muranoapi/openstack/common/wsgi.py", line 398, in execute_action
    return self.dispatch(self.controller, action, request, **action_args)
  File "/usr/lib/python2.6/site-packages/muranoapi/openstack/common/wsgi.py", line 407, in dispatch
    return method(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/muranoapi/api/v1/catalog.py", line 152, in search
    packages = db_api.package_search(filters, req.context)
  File "/usr/lib/python2.6/site-packages/muranoapi/db/catalog/api.py", line 263, in package_search
    query = session.query(pkg).filter(pkg.enabled)
  File "<string>", line 1, in <lambda>
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 50, in generate
    fn(self, *args[1:], **kw)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 1177, in filter
    "filter() argument must be of type "
ArgumentError: filter() argument must be of type sqlalchemy.sql.ClauseElement or string
 (HTTP 500)

[Igor Marnat (imarnat)]

Issue was reproduced using build 176:

{"build_id": "2014-05-02_02-07-11", "mirantis": "yes", "build_number": "176", "ostf_sha": "134765fcb5a07dce0cd1bb399b2290c988c3c63b", "nailgun_sha": "621dbc810c52d5150ad0cc1edb8e8be379985097", "production": "docker", "api": "1.0", "fuelmain_sha": "95c35c199c2efc03fb105d090c5a42525430b7b3", "astute_sha": "3cffebde1e5452f5dbf8f744c6525fc36c7afbf3", "release": "5.0", "fuellib_sha": "b558bb39b7f94ce08ecfc3c20892742206c9878d"}

Steps ro reproduce:
Create env - nonHA, Centos, neutron with GRE
Enable Sahara, Murano, Ceilometer
Add 3 nodes, deploy (Windows host, virtualbox)

After the deployment can't open tab Murano->Applications, there is a message "Something went wrong"

[Igor Marnat (imarnat)]

Same thing for Murano only (without Sahara and Ceilometer)

[Igor Marnat (imarnat)]

Same thing in build 179

[Igor Marnat (imarnat)]

Error 500 in Murano logs.

[Timur Nurlygayanov (tnurlygayanov)]

Reproduced on 180 ISO too, need to build ISO with the latest Murano code.

[Anastasia Palkina (apalkina)]

Verified on ISO #214
"build_id": "2014-05-21_01-10-31",
"mirantis": "yes",
"build_number": "214",
"ostf_sha": "353f918197ec53a00127fd28b9151f248a2a2d30",
"nailgun_sha": "0b6e8eabaccad2aa29519561ce7cde9df9292964",
"production": "docker",
"api": "1.0",
"fuelmain_sha": "910f262f85e94bef08e0e9b9d6230ad890bf139e",
"astute_sha": "9a0d86918724c1153b5f70bdae008dea8572fd3e",
"release": "5.0",
"fuellib_sha": "3d92142a5643af82596f0450e39282550a45e5db"