I have an issue with whereas I am unable to completely remove a mashup and it's data. If I have a mashup called MyMashUpOne with some data using the MachineName key, and I no longer need it or need to make significant changes to it, I can remove it from the Admin Console as a data source, but it is persistent in the User Console. History is turned off, I'm using the 'INV is latest' option and have removed all the sources and potential history via the inventory summary. This also prevents me from creating a new mashup with same headers. Anyone else experienced these issues, or can confirm that once they remove a mashup the data is also removed from the publish database on next normalize ?
Aug 20, 2023 09:23 PM - edited Aug 20, 2023 09:24 PM
Hi @jeremy-m , the below SQL statement can help to clean the data from both database and the User Console by the Inventory ID. You may want to run the below SQL and then re-run the normalize job (without the Mashup file, or with the new Mashup file that you want to normalize) to repopulate the data.
1. get the inventory ID from the Inventory Summary or the Analyze report in User Console UI, let's say the ID = 123456789;
2. Run the below query one by one in the BDNA_PUBLISH database;
EXEC NBI_PURGE_INV_SP 123456789; EXECUTE PUBLISH_CLEARDATA @inv_id = 123456789, @task_id = NULL; EXECUTE NBI_NM_CLEANUP_FACTS_SP '123456789'; EXECUTE NBI_NM_CLEANUP_DIMS_SP '123456789'; EXECUTE NBI_NM_CLEANUP_PURGEDINVID_SP '123456789';
3. Rerun the Normalize job without the mashup file or with your new mashup files.
If you need further assistance, please feel free to log a support ticket.
Aug 22, 2023 08:30 PM