OAS: How do I remove a connection with multiple dependent DV objects I cannot see.

Matthew Kegerise

Hi everyone,

I've been asked to do some OAS DV cleanup and to specifically remove some unauthorized connections created by users in DV. When I attempt to remove a specific connection, if it has DV objects dependent on it, I get an error. Is there a way to remove a connection and it's dependencies in DV on the server? Or, how can I see what DV datasets are dependent on a specific connection?

Mostafa Morsy-Oracle

@Matthew Kegerise

Found a workaround you can use

https://www.youtube.com/watch?v=QWi06ivvcDI

SteveF-Oracle

Hi @Matthew Kegerise,

Can you share with the community the following:

• The OAS update you are using.
• The exact error message (or screenshot)
• Where you are deleting the connection (Console > Connections?)
• Does your user have the BIServiceAdministrator role?

To add, in latter updates of OAS, you can use Content Management to see ownership, or take ownership, but it would be helpful to understand the above questions.

Mostafa Morsy-Oracle

@Matthew Kegerise

There is already an Idea Lab for this Request Please up vote for it

https://community.oracle.com/products/oracleanalytics/discussion/19160/show-list-of-impacted-objects-while-deleting-the-connection-in-dv