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

XMLWordPrintable

    • 7.02
    • Severity 2 - Major

      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

        1. ChecklistOptionsCleaner.java
          4 kB
        2. ofBiz_exception_postgres.log
          10 kB

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

              Created:
              Updated: