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
1
19.2k
3
by Martin Schröder
Posted on Fri, 06/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:
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%"
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),
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)
