Versions Compared

Version Old Version 8 New Version Current
Changes made by

Aliaksei Harbuz

Aliaksei Harbuz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In Kiwi, Lotus and Morning Glory bugfests those invalid identifiers have been replaced with temporary values.

To get instances ids with incorrect identifiers execute:

Code Block
languagesql
titleinstances ids with incorrect idntifiers
SELECT DISTINCT id
  FROM   {tenant}_mod_inventory_storage.instance t, jsonb_array_elements(t.jsonb->'identifiers') elem
  WHERE  elem->>'identifierTypeId' 
  IN ('59378436-9645-4add-b05f-6afc69bdc8d0', '9024e225-7a68-4f2c-bcf1-81013fb8a6f0', 'fe19bae4-da28-472b-be90-d442e2428ead')

According BF-318 it is necessary to :

  1. Identify the instance records with invalid identifiers type
  2. Remove the reference to the invalid identifiers from the instance record

...