Bug 1440157
| Summary: | Long integer value in Tasks on Satellite WebU gives error: Oops, we're sorry but something went wrong PG::Error: ERROR: value "1489607391328" is out of range for type integer | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Renu Chauhan <rchauhan> |
| Component: | Tasks Plugin | Assignee: | satellite6-bugs <satellite6-bugs> |
| Status: | CLOSED WONTFIX | QA Contact: | |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 6.2.8 | CC: | aruzicka, inecas, jcallaha, mhulan, oshtaier, sgraessl |
| Target Milestone: | Unspecified | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-11-30 14:49:16 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Created redmine issue http://projects.theforeman.org/issues/19246 from this bug The Satellite Team is attempting to provide an accurate backlog of bugzilla requests which we feel will be resolved in the next few releases. We do not believe this bugzilla will meet that criteria, and have plans to close it out in 1 month. This is not a reflection on the validity of the request, but a reflection of the many priorities for the product. If you have any concerns about this, feel free to contact Rich Jerrido or Bryan Kearney or your account team. If we do not hear from you, we will close this bug out. Thank you. Thank you for your interest in Satellite 6. We have evaluated this request, and while we recognize that it is a valid request, we do not expect this to be implemented in the product in the foreseeable future. This is due to other priorities for the product, and not a reflection on the request itself. We are therefore closing this out as WONTFIX. If you have any concerns about this, please do not reopen. Instead, feel free to contact Rich Jerrido or Bryan Kearney. Thank you. |
Description of problem: When put a long integer, 1489607391328 for example into the Task Search then receive the following error: Oops, we're sorry but something went wrong PG::Error: ERROR: value "1489607391328" is out of range for type integer LINE 11: WHERE "foreman_tasks_task_groups"."id" = '1489607391328' ))... ^ : SELECT DISTINCT "foreman_tasks_tasks"."id", "foreman_tasks_tasks"."started_at" AS alias_0 FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" LEFT OUTER JOIN "foreman_tasks_task_group_members" ON "foreman_tasks_task_group_members"."task_id" = "foreman_tasks_tasks"."id" LEFT OUTER JOIN "foreman_tasks_task_groups" ON "foreman_tasks_task_groups"."id" = "foreman_tasks_task_group_members"."task_group_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 '%1489607391328%' OR "foreman_tasks_tasks"."label" ILIKE '%1489607391328%' OR "foreman_tasks_tasks"."state" ILIKE '%1489607391328%' OR "foreman_tasks_tasks"."result" ILIKE '%1489607391328%' OR "foreman_tasks_tasks"."parent_task_id" ILIKE '%1489607391328%' OR foreman_tasks_locks."resource_type" ILIKE '1489607391328' OR foreman_tasks_locks."resource_type" = '1489607391328' OR users.login = '1489607391328' or users.firstname = '1489607391328' OR users.login ILIKE '1489607391328' or users.firstname ILIKE '1489607391328' OR users.login ILIKE '1489607391328' or users.firstname ILIKE '1489607391328' OR "foreman_tasks_tasks"."id" IN (SELECT "foreman_tasks_tasks"."id" FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_task_group_members" ON "foreman_tasks_tasks"."id" = "foreman_tasks_task_group_members"."task_id" INNER JOIN "foreman_tasks_task_groups" ON "foreman_tasks_task_group_members"."task_group_id" = "foreman_tasks_task_groups"."id" WHERE "foreman_tasks_task_groups"."id" = '1489607391328' ))) ORDER BY "foreman_tasks_tasks"."started_at" DESC NULLS LAST LIMIT 20 OFFSET 0 and in the tasks state it gives error as: Runtime Error RESTEASY001185: Could not find resource for relative : /products//content/1489607391328 of full path: https://localhost:8443/candlepin/products//content/1489607391328?enabled=true at org.jboss.resteasy.core.registry.PathParamSegment.matchPattern:209" Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Go to Satellite WebUI --> Monitor --> Tasks --> Put the integer value (Eg 1489607391328 2. 3. Actual results: A error message is displayed Expected results: It should show the task. Additional info: