Versions Compared

Version Old Version 1 New Version 2
Changes made by

Kateryna Senchenko

Kateryna Senchenko

Saved on

Key

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

...

Code Block
UPDATE {TENANT_ID}_mod_data_import_converter_storage.match_profiles
SET "jsonb" = jsonb_set("jsonb", '{childProfiles}', '[]')

UPDATE {TENANT_ID}_mod_data_import_converter_storage.match_profiles
SET "jsonb" = jsonb_set("jsonb", '{parentProfiles}', '[]')

UPDATE {TENANT_ID}_mod_data_import_converter_storage.action_profiles
SET "jsonb" = jsonb_set("jsonb", '{childProfiles}', '[]')

UPDATE {TENANT_ID}_mod_data_import_converter_storage.action_profiles
SET "jsonb" = jsonb_set("jsonb", '{parentProfiles}', '[]') 

UPDATE {TENANT_ID}_mod_data_import_converter_storage.job_profiles
SET "jsonb" = jsonb_set("jsonb", '{childProfiles}', '[]')

UPDATE {TENANT_ID}_mod_data_import_converter_storage.job_profiles
SET "jsonb" = jsonb_set("jsonb", '{parentProfiles}', '[]') 

UPDATE {TENANT_ID}_mod_data_import_converter_storage.mapping_profiles
SET "jsonb" = jsonb_set("jsonb", '{childProfiles}', '[]')

UPDATE {TENANT_ID}_mod_data_import_converter_storage.mapping_profiles
SET "jsonb" = jsonb_set("jsonb", '{parentProfiles}', '[]')

Deleting data from \ {TENANT_ID\}_mod_data_import_converter_storage.profile_snapshots might also be required. In case there are errors in mod-source-record-manager - module should be restarted to clean up the caches.