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
          Anne Calantog
        2. ofBiz_exception_postgres.log
          10 kB
          Anne Calantog

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

                Created:
                Updated: