Skip to main content

We recently updated the Data Sources connection, and all Catalog items that were using the old connection are no longer working in the monitoring projects. When I expand the catalog items, an error message appears: "You are looking at a deleted item."

However, if I create a new catalog item and add it as an attribute in the monitoring project, it works perfectly fine.

My question is: How can I update the existing catalog items to use the new connection? Do I need to manually recreate all these catalog items with the new connection, or is there a way to automatically switch all catalog items from the deleted connection to the new one

Hi ​@Susan24us,

if it’s just about updating the connection, you need to use the API to update the reference to the new connection for all relevant catalog items. You can use the ONE Desktop and ONE Metadata Writer step:

 

The new_connection_id has to store the GID of the new connection (when you open the connection, the ID is in the URL).

But please note, the origin path for the tables have to still correspond, which means the names of the database and schemas must still be the same, otherwise the items will still fail.

Are you sure you deleted just the connection and not any location? The error message suggests that the catalog items were actually deleted.. This might require deeper analysis and if that’s the case, I would kindly ask you to report it to our support team and they can assist you further.

Kind regards,

Anna


Reply