Automated Reorg via batch desired, but not working

Last activity on October 1, 2023 - 11:21 19.2k Views 3 Replies Professional ARIS

Gerald Schroeder on May 18, 2016

Hello,

on our ARIS9 Connect-Server I try to use a script to reorganize automatically all databases of a tenant via batch-file

(to start that before the daily db-export).

When I start the ARIS Server Administrator in interactive mode and submit the command "reorg all NO_DEFS" anything works fine like expected. Object-Definitions with no occurrences on models are deleted.

(btw: it took me some time to check out that I have to use NO_DEFS as parameter instead of delete what was the right choice for ARIS7! I did not find any advice in the documentation for the parameters, but after a while staring at it - it was the only concusive possibility ...)

So I proceeded in constructing a appropiate batch-file that can be executed by win-taskscheduler.

But when I execute the so constructed cmd with the same command, with the same properties as

tenant, user-credentials and server-name,

then the progress in the command-window is showing that the script is succesfully starting the ARIS Server Administrator and connected to the server, is writing a log-file with unfortunally no useful hints, is running over all databases but

is not deleting any of my prepared object occurrences for the testing issues.

I am quite shure that there are no open sessions on the db's ...

Now I'm looking for usefull hints and thank you in advance

Gerald Schroeder

Bookmark

Notify Moderator

3 Replies

rem CMD behaves slightly different on each Windows version, this works on a Win 2012 Server rem concatenate the command line of variables set ARIS9BATCHES_ARISADM_EXE=C:\SoftwareAG\ARIS9.8\tools\ArisAdm\arisadm90.exe rem this lengthy statement may be wrapped in your browser rem but must go IN A SINGLE LINE set ARIS9BATCHES_ARISADM_PARAMS=-t "%ARIS9BATCHES_TENANT%" -s %ARIS9BATCHES_DESIGN_SERVER_HOST%%ARIS9BATCHES_DESIGN_SERVER_PORT% -u "%ARIS9BATCHES_TENANT_SYSTEM_USER%" "%ARIS9BATCHES_TENANT_SYSTEM_PASSWORD%" set ARIS9BATCHES_RUNADM="%ARIS9BATCHES_ARISADM_EXE%" %ARIS9BATCHES_ARISADM_PARAMS% rem finally execute all of the above with even more arguments of your choice %ARIS9BATCHES_RUNADM% -l "%ARIS9BATCHES_LOGS% backup all "%BACKUP_TARGET_ADB%"

Upcoming events

Tuesday, November 18, 2025 - 17:00

ARIS Roadshow 2025 in Crystal City

Wednesday, November 19, 2025 - 10:30

PzM Summit Austria

Thursday, November 20, 2025 - 12:00

ARIS Roadshow 2025 in Amsterdam

Thursday, November 27, 2025 - 08:30

BPM Summit

All events

Reset Password

Martin Schröder on June 24, 2016 - 18:18

Greetings from Schröder to Schroeder!

I had the same problem migrating my backup batch from 7.2 to 9.8.2. Eventually I found that calling arisadm90.exe from a Command batch needs a careful "quoting" of arguments like password:

I hope this helps

Re: reorg options

Support promised me to complete the reorg syntax help (and Admin Guide) with release Aris 9.8.4.

Description quoted from SAG Support Incident 5226845:

Semantically reorganizes the database <dbname> or all databases by deleting all objects and connection definitions that do not have occurrences in any model.

Options available:

NO_DEFS (object definitions without occurrences will be removed; this is the default, if no options are specified).

CXNDEFS_IN_MATRIX_MODELS (connection definitions without occurrences are not being removed, if they are still used in a matrix model),

USERDEF_CONTENT_SYMBOLS (userdefined symbols, which are not allowed by the server´s current methodology, will be replaced by the original default symbol),

USERDEF_CONTENT_MODELS (userdefined models, which are not allowed by the server´s current methodology, will be removed),

USERDEF_CONTENT_ATTRS (userdefined attributes, which are not allowed by the server´s current methodology, will be removed),

Regards, Martin

or register to reply.

Gerald Schroeder Author on June 24, 2016 - 19:24

Hello Martin - or should I write Good Evening 8o)

thank you a lot for your reply!! I did not expect any more comments on my post.

I am very curious about if your suggestions will work with my environement, but ...

now I will go home for the weekend.

On monday I will make that work and will tell you about my efforts.

Unfortunately the migration is still not finished by battling so many little things 8o((

I decided not to come to the next AUG-RM in Wiesbaden next tuesday,

but I hope we will meet in future ARIS-Usergroup Events.

Greetings from Cologne

Gerald

Runé Becker on July 12, 2016 - 19:24

BTW: ARIS Server Administrator is also available on every ARIS Design/Connect Server even without installed ARIS clients. You can find the batch file here: (adjust the sizing _m to your installation type: _s or _l)

C:\SoftwareAG\ARIS9.8\server\bin\work\work_abs_m\tools\arisadm\arisadm.bat

Cheers

Rune