ARIS SCRIPTS - execution registration, conversion SAX to JAVA

Posted by Sergei Real-Picture

Posted on Mon, 05/31/2010 - 14:52 in Professional ARIS

We need to track ARIS BA scripts (SAX and Java) execution by users and collect statistics about such events.

ARIS is used by many users simulatneously. Preferable solution - to have a record in the SQL database about user name and parameters (models/groups or what ever).

There is also need for getting report about script names and parameters. Is there any other way but manual to get information about ARIS script author, description?

I have a task to manage and migrate and convert many scripts - from SAX to Java. Is there other way but manual to move scripts from SAX to Java? I heard about script converter - would be handy to automate this task.

Thanks in advance for ideas how this can be achieved.

Sergei.

24.5k

by Alexander Cherednichenko

Posted on Mon, 05/31/2010 - 21:18

Сергей, по поводу отслеживания запуска скриптов - ИМХО, проще на арисовском сервере сделать расшареную папку и вести лог (txt, excel), а в скрипты, которые Вы используете добавить стандартный код (это конечно не решит проблему отслеживания запуска предустановленных скриптов).

По поводу конвертера - он криворукий, поэтому можно перенести только максимально примитивные скрипты. Мы сталкивались с проблемой - конвертация кирилицы (в комментах, диалогах, формах и т.д.), многие методы не переносятся и т.п. Что-либо сложное нам пришлось переносить руками.

by Milan Slivka

Posted on Mon, 06/14/2010 - 15:41

Hi Sergei, to track scripts you can just simply add to the end of each script piece of code to log each execution:

var sLogFile = "Aris_" +Context.getScriptInfo(Constants.SCRIPT_VERSION)+ "_script_activity_log.log";
    var oFileToWrite = new java.io.File(Context.getTempPath(),sLogFile);
    var oWriter = new java.io.FileWriter(oFileToWrite, true);
    var sLogMessage = new String(nowStart.getFullYear() + ((nowStart.getMonth()+1) < 10 ? "0"+(nowStart.getMonth()+1):(nowStart.getMonth()+1)) + (nowStart.getDate() < 10 ? "0"+nowStart.getDate():nowStart.getDate()));
    sLogMessage += new String("|" + Context.getScriptInfo(Constants.SCRIPT_NAME));
    sLogMessage += new String("|" + Context.getSelectedPath()+Context.getSelectedFile());
    sLogMessage += new String("|" + ArisData.getActiveDatabase().ActiveUser().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().ActiveFilter().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().getDbLanguage().Name(g_nLoc));
    sLogMessage += new String("|" + sStart + "|" + sEnd);
    sLogMessage += new String("|" + sDuration);
    sLogMessage += new String("\n");
    oWriter.write(sLogMessage);
    oWriter.close();

Milan

by Sergei Real-Picture Author

Posted on Mon, 06/14/2010 - 16:25

Hi, Milan.

This code is good however it could be exception (file lock) when several users will run the same script simultaneously.

We have hunderds of licenses to run simultaneously and therefore are looking for the registraion of the script execution in SQL database.

Registration in LOG file will require further sych with SQL database and therefore is not the best option so far.

The script log and script execution results will be used to tune up user support and educational courses for ARIS users.

Thanks for the code, pretty usable in case when we will have SQL code for registration.

by Martin Schröder

Posted on Fri, 06/18/2010 - 19:29

Hi Sergei,

only two hints (please see ARIS installation&administrarion-guide by IDS for details)

1) if you have configured your Business Server to create an accounting log you will find it in:

    %arishome71%\server\accounting\arisaccountlog.xml

I found that for each execution of a VB script on Business Server a <session> with <clienttype>WIN is logged with time stamps. These sessions stick out if only ABDesigner or Architect Client access the server.

2) for each execution of JavaScripts on a Business Server there will be records of selected options per user in:

%arishome71%\server\templates\scriptservice\internal\ReportRegistry.cfg

Hope it helps, Martin

by Sergei Real-Picture Author

Posted on Sat, 06/19/2010 - 15:59

Hi, Martin.

Thanks for the tips - we will try it.

What we are after - registration of the script, user, model and some statistics of the script execution (if script produces any). The statistical data is needed for the purpose to track common errors/issues and tune training towards this issues elimination.

Script registration in the SQL database would be ideal.

Thanks againfor your information.

Sergei