WE

Hi All,

Sitting with a problem. Doing an ARIS upgrade for a client, ARIS 7 to ARIS 9.8.7. The database was backed up from ARIS 7 to a local machine.

Started restoring the database (700Mb<), and due to a network error, the restore stopped.

The following day, when trying to restore the database, an ARIS error occurs, informing me that the database already exists, but obviously I can't see it in ARIS.

The client is using SQL 2008 R2.

Any ideas how to resolve this?

Thanks,

Willem

by Frank Weyand
Posted on Thu, 06/29/2017 - 09:20

Hi,

you need the admintool to delete the database, since it is not visible due to the fact that it is not "completely" imported.

Using the admin tool, with command "list all", you can see all databases.

There will be a database with the state "restoring" having a database name with a GUID identifier.

You need to delete the database with :

       delete "<database name including id>" force

where as <database name including id> is you database name with the identified, which means everything until the value of the "kind" column.

Bye,

Frank

0
by Willem Engelbrecht Author
Posted on Thu, 06/29/2017 - 10:46

Hi Frank,

Thank you so much, it worked like a charm.

Just as an after-thought, the state was "migrating".

Cheers,

Willem

0
by Frank Weyand
Posted on Thu, 06/29/2017 - 11:27

Ah, yes, sure, you are right... from the ARIS Architect, you do not see a difference whether you use a 7.2 database or one from 9.x.

But internally, this is a difference: ARIS 7.x databases are migrated, ARIS 9.x databases are restored.

Bye,

Frank

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