Profile picture for user mtsuperPQ

Hi, is there an alternative to "Reorganize Database" that shows me "objects and connection definitions that do not have occurrences in any model in the database", without actually deleting them?

In other words, the equivalent of a semantic check on a model, so that I can clean up the orphaned connection definitions myself? 

We're using ARIS Advanced.

Thanks

by Frank Weyand
Posted on Wed, 02/21/2024 - 13:08

Hi,

that could be easily done by a report script, but er this no out-of-the-box solution for this requirement.

Bye,

Frank

1
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Fri, 02/23/2024 - 15:26

Hello Mark,

here are two reports submitted by the community: 

https://ariscommunity.com/users/mark-van-kampen/2011-04-19-report-objects-without-occurences

But at a glimpse this pivotal line of code should be corrected to:

// if(objects[x].OccList().length > 0) // has occurrence!
if(objects[x].OccList().length == 0)    // has no occurrence

https://ariscommunity.com/users/mikhubb/2021-11-02-relationshipsconnections-occurrences-and-db-reorganization

So you should be careful to check the source code and test it in a safe environment before running it on productive content.

If you want to find more search this

Regards, Martin

1
by Mark Tucker Author
Posted on Fri, 02/23/2024 - 18:37

Thanks, Martin

The report works if I run it as is (it shows all objects with occurrences). But, if I change the line of code (to show all objects without connections)

if(objects[x].OccList().length > 0)

to:

if(objects[x].OccList().length == 0)

it runs but the output shows as empty. My goal is to find objects that have no connections in a model. Am I reading this right?

Thanks for your help

0
by Michael Hubbard
Posted on Wed, 03/13/2024 - 19:35

In reply to by mtsuperPQ

I have attached a report script that I created that finds Objects with No Occurrences. This works for me, and I have confirmed it matches what the report of the same from the Database Reorganization.

Hope it works for you. Adjust it as you see fit. :-)

0
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Mon, 02/26/2024 - 17:43

Hello Mark,

which report did you try?

The first one by looks for object occurrences only.

The second one attached by Michael Hubbard should list Connection_Definitions_Without_Occurrences, but I have not used it.

The question of objects with no connections needs a different approach:

Find objects (by type? any other search criteria?) and check their occurrences for "surrounding" connections with these report API methods: CxnOccList or Cxns

Cf. Script help on your server: /abs/help/en/script/ba/#/home/r_O_ObjOcc_cxnocclist/en/1

Regards, Martin

1

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock