[JRASERVER-67234] OfBiz operations fail with "ERROR: operator does not exist" when JIRA is connected to Postgres - Create and track feature requests for Atlassian products.

Type: Bug
Resolution: Unresolved
Priority: Low (View bug fix roadmap)
Fix Version/s: None
Affects Version/s: 7.2.0, 7.9.0
Component/s: Issue - Fields
Labels:
- devhelp

Introduced in Version:
7.02
Symptom Severity:
Severity 2 - Major
Bug Fix Policy:
View Atlassian Server bug fix policy

Summary

Customers using Postgres 9.3 trying to remove an options used by Checklist for Jira custom field encounters an error:

(ERROR: operator does not exist: numeric ~~ bigint

The same problem is partially fixed by JRASERVER-20554. This one was never discovered.

Internally, the add-on is using the findByLike method of the OfBiz delegator to clean up data in the CustomFieldValue table when an option is delete.

Affects Jira versios: 7.2.0 - 7.9.0

See logs for more details

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

ChecklistOptionsCleaner.java
4 kB
30/Apr/2018 5:01 AM
ofBiz_exception_postgres.log
10 kB
30/Apr/2018 5:01 AM

relates to

JRASERVER-20554 Some operations fail with "ERROR: operator does not exist" when JIRA is connected to Postgres 8.3+

Closed

was cloned as

JRASERVER-71249 Deleting a custom field fails with "No operator matches the given name and argument type" when JIRA is connected to Postgres

Gathering Impact

is depended on by: DEVHELP-1178 Failed to load

There are no comments yet on this issue.

Assignee:: Unassigned

Reporter:: Yves Riel [Okapya]

Affected customers:: 2 This affects my team

Watchers:: 5 Start watching this issue

Created:: 30/Apr/2018 4:56 AM

Updated:: 02/Jul/2020 2:40 PM