Bug 1117554

Description of problem:
Attempting to filter tasks under Monitor -> Tasks results in the following SQL error.  In this case, I just attempted to filter 'Red', but entering any filter string in the search box results in a similar error.


Oops, we're sorry but something went wrong
 
Error
PGError: ERROR: zero-length delimited identifier at or near """" LINE 6: ...ks"."result" ILIKE '%Red%' OR foreman_tasks_locks."" ILIKE '... ^ : SELECT "foreman_tasks_tasks".* FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" INNER JOIN foreman_tasks_locks AS foreman_tasks_locks_owner ON (foreman_tasks_locks_owner.task_id = foreman_tasks_tasks.id AND foreman_tasks_locks_owner.resource_type = 'User' AND foreman_tasks_locks_owner.name = 'task_owner') INNER JOIN users ON (users.id = foreman_tasks_locks_owner.resource_id) WHERE (("foreman_tasks_tasks"."id" ILIKE '%Red%' OR "foreman_tasks_tasks"."label" ILIKE '%Red%' OR "foreman_tasks_tasks"."state" ILIKE '%Red%' OR "foreman_tasks_tasks"."result" ILIKE '%Red%' OR foreman_tasks_locks."" ILIKE 'Red' OR users."" ILIKE 'Red' OR users."" ILIKE 'Red')) ORDER BY "foreman_tasks_tasks"."started_at" DESC NULLS LAST LIMIT 20 OFFSET 0

If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries.

ActiveRecord::StatementInvalid
PGError: ERROR: zero-length delimited identifier at or near """" LINE 6: ...ks"."result" ILIKE '%Red%' OR foreman_tasks_locks."" ILIKE '... ^ : SELECT "foreman_tasks_tasks".* FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" INNER JOIN foreman_tasks_locks AS foreman_tasks_locks_owner ON (foreman_tasks_locks_owner.task_id = foreman_tasks_tasks.id AND foreman_tasks_locks_owner.resource_type = 'User' AND foreman_tasks_locks_owner.name = 'task_owner') INNER JOIN users ON (users.id = foreman_tasks_locks_owner.resource_id) WHERE (("foreman_tasks_tasks"."id" ILIKE '%Red%' OR "foreman_tasks_tasks"."label" ILIKE '%Red%' OR "foreman_tasks_tasks"."state" ILIKE '%Red%' OR "foreman_tasks_tasks"."result" ILIKE '%Red%' OR foreman_tasks_locks."" ILIKE 'Red' OR users."" ILIKE 'Red' OR users."" ILIKE 'Red')) ORDER BY "foreman_tasks_tasks"."started_at" DESC NULLS LAST LIMIT 20 OFFSET 0
app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
lib/middleware/catch_json_parse_errors.rb:9:in `call' 

Version-Release number of selected component (if applicable):

ruby193-rubygem-foreman-redhat_access-0.0.4-1.el6sat.noarch
rubygem-hammer_cli_foreman_tasks-0.0.3-2.el6sat.noarch
foreman-ovirt-1.6.0.21-1.el6sat.noarch
foreman-proxy-1.6.0.9-1.el6sat.noarch
katello-ca-1.0-1.noarch
foreman-compute-1.6.0.21-1.el6sat.noarch
ruby193-rubygem-foreman-tasks-0.6.3-2.el6sat.noarch
ruby193-rubygem-foreman_hooks-0.3.5-2.el6sat.noarch
foreman-selinux-1.6.0-5.el6sat.noarch
foreman-1.6.0.21-1.el6sat.noarch
foreman-vmware-1.6.0.21-1.el6sat.noarch
ruby193-rubygem-foreman_discovery-1.3.0-0.1.rc2.el6sat.noarch
pulp-katello-0.3-3.el6sat.noarch
katello-1.5.0-26.el6sat.noarch
rubygem-hammer_cli_foreman-0.1.1-9.el6sat.noarch
foreman-postgresql-1.6.0.21-1.el6sat.noarch
katello-installer-0.0.53-1.el6sat.noarch
foreman-gce-1.6.0.21-1.el6sat.noarch
foreman-libvirt-1.6.0.21-1.el6sat.noarch
ruby193-rubygem-katello-1.5.0-65.el6sat.noarch
ruby193-rubygem-foreman_bootdisk-2.0.6-1.1.el6sat.noarch
katello-certs-tools-1.5.5-1.el6sat.noarch
rubygem-hammer_cli_katello-0.0.4-7.el6sat.noarch

How reproducible:
Always

Steps to Reproduce:
1. Login as Admin
2. Go to Monitor -> Tasks
3. Enter anything into Filter box.

Actual results:
Error above

Expected results:
Search results should be displayed.