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

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

    XMLWordPrintable

Details

    Description

      Summary

      Customers using Postgres 10.13 trying to remove custom fields encounter an error:

      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM public.customfieldvalue WHERE CUSTOMFIELD=? (ERROR: operator does not exist: character varying = bigint
      Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      Position: 156)

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

      Attachments

        Issue Links

          is cloned from

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

          • Low - Low priority issues
          • Gathering Impact
          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
          is depended on by

          DEVHELP-1178 Loading...

          Activity

            People

              Unassigned Unassigned
              hbittencourt Henrique Bittencourt (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: