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

      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

          Form Name

            [JRASERVER-67234] OfBiz operations fail with "ERROR: operator does not exist" when JIRA is connected to Postgres

            Henrique Bittencourt (Inactive) made changes -
            Link New: This issue was cloned as JRASERVER-71249 [ JRASERVER-71249 ]
            Mateusz Walas (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            Mateusz Walas (Inactive) made changes -
            Occurrence Factor New: 10% [ 12830 ]
            Bugfix Automation Bot made changes -
            Minimum Version New: 7.02
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2846739 ] New: JAC Bug Workflow v3 [ 2930105 ]
            Owen made changes -
            Symptom Severity Original: Major [ 14431 ] New: Severity 2 - Major [ 15831 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2667047 ] New: JAC Bug Workflow v2 [ 2846739 ]
            Status Original: Open [ 1 ] New: Needs Triage [ 10030 ]
            Anne Calantog made changes -
            Labels New: devhelp
            Anne Calantog made changes -
            Attachment New: ChecklistOptionsCleaner.java [ 314609 ]
            Attachment New: ofBiz_exception_postgres.log [ 314610 ]
            Anne Calantog made changes -
            Link New: This issue relates to JRASERVER-20554 [ JRASERVER-20554 ]

              Unassigned Unassigned
              e0615f94a661 Yves Riel [Okapya]
              Affected customers:
              2 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated: