Uploaded image for project: 'FOLIO'
  1. FOLIO
  2. FOLIO-3630

"f_unaccent(text)" function not found in reference environments

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • None
    • CP: Sprint 152, CP: Sprint 154
    • Core: Platform
    • TBD

    Description

      Occasionally we have seen an error from the UI in the reference environments which reports:

      operation GET on resource XXX failed, saying: ERROR: function f_unaccent(text) does not exist (42883)

      Superficially, it appears to be coming primarily from endpoints that pull data from mod-inventory-storage, though more investigation is needed.

      This function should be created in the module schema for RMB modules when the module is initialized for the tenant (so it may be a build problem). Strangely, the problem doesn't always occur, and different builds using the same module versions may not exhibit the same symptoms.

      TestRail: Results

        Attachments

          1. image-2022-11-16-13-14-17-495.png
            140 kB
            Erin Nettifee
          2. mod-inventory-storage-snapshot.log.gz
            3.36 MB
            Wayne Schneider
          3. mod-inventory-storage-snapshot-2.log.gz
            1.03 MB
            Wayne Schneider
          4. Snapshot Inventory Ref Data.mp4
            3.04 MB
            Ann-Marie Breaux

          Issue Links

            Activity

              People

                julianladisch Julian Ladisch
                wayne Wayne Schneider
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases