Problem with DB Reorganisation script

To automatically start a reorganization of an ARIS Database you can schedule the following windows batch file:

reorg.bat

Set the Database-Admin and Site-Admin password in the script!

Call the batch with the database name in the "JavaClient" directory e.g.  

Regards,

Jens

Hi Jens,

thank you for your reply, but i need further assistance please.. i am usually creating my scripts inside ARIS Business Architect for SAP 7.1

In the scripts tab and using cfg and bat file where the bat file just call the cfg file so in this case where should i write your script :

{

@echo off

Set DBADMIN=DBADMIN

Set SITEADMIN=SITEADMIN

ArisAdm72.exe -l reorg.log -s localhost -pa "%SITEADMIN%" -p "%DBADMIN%" reorg "%1"

}

beside that i have a lots of database where am going to mention which database should be re-organized?? and what i should write in the cfg file??

sorry for the tooo many questions :S but am still a beginner and need support.

thanks,

Mona

Hi Mona,

you can not start a reorg automatically  within ARIS Architect / ARIS script.

You have to call the ARIS Admin Tool via the batch script I've posted before. 

The sceenshot is an example how to call the batch script.

1. Create a new file within ARIS Client directory and copy the script into this file. 
2. Change the passwords for DBADMIN and SITEADMIN if you are using not the default.
3. Start the script by calling the batchfile and with the ARIS database name for the database you want to reorganize.

Regards,

Jens

Afternoon all,

Sorry to highjack the topic. I have a crisis and seem to have lost everything.

I was trying to add more modules on my installation and ran the installation file. While it was confirming to remove everything and creating a backup, i cancelled the operation.

Now my databases are no longer visible and I can't seem to get them. I can find the aris.db, aris.props and aris.log which were created duting the operation. The log file has a list of my original databases.

How can i get my databases back? PLEASE HELP!

Dear jens,

could u please provide an example on how to Call the batch with the database name in the "JavaClient" directory as i can not view the attached screenshot

thanks,

Mona

Hello Mona,

if the batch file is in the ARIS JAVA Client directory e.g. "C:\Programm Files\ARIS7.2\JavaClient" you can call the batch for example like this:

reorg "DemoDB-United motors Group"

This will reorganize the ARIS database "DemoDB-United motors Group"

Hope this helps?

Regards,

Jens

Jens...Thanks a millioooooooooooooooooooon i do really appreciate your help in this issue..i have applied your solution and it worked.

thanks a lot :) i owe u