Profile picture for user BPS

Good day colleagues,

 

We found in our database "dead" model - we cannot do nothing with that - neither open nor delete. And of course we cannot restore from backup by merge.

 

Checking DB by Admintool we found that there is something wrong with DB:

 

Did anybody get the same issue? Is any way to "optimize" DB?

 

Thanks!

File attachments
by Vassiliki Spentzou
Posted on Wed, 03/07/2018 - 12:00

Via ARIS Server Administrator, lock the DB, then run checkdb, then optimizedb, then unlock it

 

0
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Wed, 03/07/2018 - 13:06

...and after checkdb also add checkreferences and then run optimizedb incl_archive. before you unlock the database again.

The document ReleaseNotes.pdf of ARIS 10.0 SR2c (located in the root folder of the ARIS DVD) explains the reason for repairing a database bug which might occur in ARIS 10.0, SR1, SR2, or SR2b.

Cheers

Rune

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Author
Posted on Wed, 03/07/2018 - 16:21

Thank you!!!

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Author
Posted on Mon, 03/12/2018 - 14:38

New problem but this time optimization did not help ((

Any ideas how to fix it?

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Author
Posted on Mon, 03/12/2018 - 16:25

In reply to by rbe

Rune, I'm just asking here because the Global support is too slowly (we have access it of course), the last opened ticket performed for one month and as a result we were suggested to send DB to them... what unacceptable of course. So no, we were even not going to do this. I hope it should be standard method that will help us.

Regards,

Alex

0
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Mon, 03/12/2018 - 17:27

In reply to by BPS

It's hard to solve a technical issue in this forum, particularly, when our support already offered inspecting your database with our internal tools. Do you see any security risk in providing your database to our support?

Cheers

Rune

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Author
Posted on Tue, 03/13/2018 - 07:09

Rune, I agree that it is impossible to solve some problems, but you see first problem was solved in distance, second unfortunately not.

I don’t see any critical problem to give the base, but the Client sees. We cannot stop the project even for day just to fix DB (but it definitely will not be a day), what then should we do? If even the DB will be fixed, we should merge the data from the current (damaged) base to fixed base, that could damage it again. So it should be some local way to fix it.

I’m just worrying of two things:

1. Frequency of these problems emerging – the last one is the second case in two weeks.

2. Will these “dead” models inside the DB spread / affect or even generate new issues.

Anyway thanks for help.

0
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Tue, 03/13/2018 - 09:39

In reply to by BPS

If sending the database isn't an option for your customer, our support staff offer a remote session for inspecting the issue live in the system. Maybe this way they could be able to find the root cause why the database issues occurred in the first place.

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Author
Posted on Tue, 03/13/2018 - 10:15

It could be an option, thanks

0

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