For hosted customers please raise a new case online and reference the title of this article.
For Self-Hosted Customers:
Remove Wisdom configuration from non-live after copying the live database.
You’ll need to do this after copying a live database to a non-live system, if the non-live system doesn’t need Wisdom access. Leaving the Wisdom configuration in place without the rest of the integration setup can cause errors in Mosaic or even trigger updates in the live Wisdom system.
If you want to remove the Wisdom integration/configuration from Mosaic, just run the SQL below.
delete from MO_EXTERNAL_SYS_END_PROPERTIES where EXTERNAL_SYSTEM_CODE = 'WISDOM'
delete from mo_external_systems where EXTERNAL_SYSTEM_CODE = 'WISDOM'
delete from mo_external_sys_features where external_system_code = 'WISDOM'
delete from mo_external_sys_endpoints where EXTERNAL_SYSTEM_CODE = 'WISDOM'
delete from MO_EXTERNAL_SYS_PROPERTIES where EXTERNAL_SYSTEM_CODE = 'WISDOM'
delete from mo_ext_sys_feature_properties where EXTERNAL_SYSTEM_CODE = 'WISDOM'