Problem with DB Reorganisation

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

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

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

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

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

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