Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-67234

OfBiz operations fail with "ERROR: operator does not exist" when JIRA is connected to Postgres

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 7.2.0, 7.9.0
    • Issue - Fields

    Description

      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

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-20554 Some operations fail with "ERROR: operator does not exist" when JIRA is connected to Postgres 8.3+

          • Medium - Medium priority issues
          • Closed
          was cloned as

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-71249 Deleting a custom field fails with "No operator matches the given name and argument type" when JIRA is connected to Postgres

          • Low - Low priority issues
          • Gathering Impact
          is depended on by

          DEVHELP-1178 Loading...

          Activity

            People

              Unassigned Unassigned
              e0615f94a661 Yves Riel [Okapya]
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: