Profile picture for user shameem

Dear All,

It is recommended to carry out the process of DB reorganisation often so as to have a neat database.

Well I tried this lately and had the following error message:

So what I did was to back up the same DB and restore it locally using ARIS Business Architect. Then I ran the reorganisation process.

Oddly enough the process was successful

Has anybody encountered the same issue?

Grateful if you could please give me some advises and comments.

 

Thanks beforehand

 

Cheers

 

Shameem

by Uwe Roediger
Posted on Mon, 12/28/2009 - 10:57

Hello Shameem,

I assume the first try of reorganization was on an ARIS server in your network? In this case a server problem occured, but I cannot make a diagnosis here. You should send the log files from the server installation, where it not worked, to our support, they should be able find the reason.

Best regards

Uwe

0
by Ismael Shameem Etowar Author
Posted on Mon, 12/28/2009 - 14:56

Hello Uwe,

Thanks for your response:)

I shall send the log and config files to ARIS Global Support.

On my way home I was thinking same as you too. I think there was a problem with the server:):)

Thanks for your advice.

 

Cheers

 

Shameem

0
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Mon, 01/04/2010 - 14:31

Hello Shameem,

reorganizing is not only useful to have a "neat" DB.
Only after reorganizing (with deletion of object occurences) you can be sure of reports yielding correct results. Our concern has been for example out-dated occurences of object connections.

I reorganize and backup DBs as a daily maintenance task on the server by means of
- a scheduled windows task
- running a batch script
- calling ArisAdm71.exe (provided in %ARISHOME71%\Javaclient\)

As the task is executed on the application server there is no trouble with network errors - or only if you use a remote DB server connected to the ARIS Business application server.
One thing to check in the batch is whether the ARIS service is running.

Hope this helps
Cheers, Martin

0
by Ismael Shameem Etowar Author
Posted on Thu, 02/04/2010 - 02:12

Hi Martin,

First of all my apologies for thanking you a bit late for your feedback :).

That's indeed a very good idea of scheduling the DB reorganisation on a daily basis.

As I am still new to ARIS, everyday I learn new and interesting features about this wondeful and powerful platform:)

Thanks a lot.

 

Cheers

 

Shameem

0
by Mona Essam
Posted on Wed, 02/27/2013 - 14:17

Hi Martin,

i need to know the script of  DB reorganisation on windows server platform as i want to schedule a job to automatically run it on daily basis.

thanks,

Mona

0
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Tue, 06/04/2013 - 16:14

Hello Mona,

I am using arisadm71.exe in batch mode as described here, writing to a log file.

For the commands and detailed syntax of arisadm7*.exe cf. the Aris Installation and Administration guide (Start Menu>ARIS>docs or PDF in your installation directory)

Regards, Martin

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