Automic Workload Automation

  • 1.  Installation RA core v12.1

    Posted Sep 27, 2018 04:19 AM

    Bonjour,

     

    J'ai créer un agent RA sur un de mes nœuds AE avec l'archive ucxjcitx.tar.gz

    Lorsque j'essaye de le démarrer j'ai ce message dans la log

     

    20180927/092443.149 - U00011610 Cannot continue because Agent 'RA01' does not exist in client zero. Please create the Agent object before starting the Agent.
    20180927/092443.149 - U02003012 An unknown message from partner 'AEHPRD#CP001' could not be processed.

    sur client 0 je n'ai pas de template agents RA

    à priori le core est bien prévu sur mon AE

    j'ai à priori des licences pour les RA

     

    Qu'ai je loupé ??

     

    Cordialement,

    Didier



  • 2.  Re: Installation RA core v12.1

    Posted Sep 27, 2018 08:24 AM

    Bonjour Didier,

     

    Il faut charger la solution correspondant à l'agent (par exemple RA FTP) dans la base de données de l'Automation engine, via DB load.

     

    Vous pouvez vous référer à ce post pour plus de détails : https://communities.ca.com/message/242097599?commentID=242097599#comment-242097599 

     

    Cordialement,

    Antoine



  • 3.  Re: Installation RA core v12.1

    Posted Sep 28, 2018 05:26 AM

    Oui, je me souvient de ça...

    Mais ça sort en erreur quand j'essaye

     

    [automic@ddesvr9701 bin]$ ./ucybdbld -C0 -B -X/opt/Automic/Agents/RA/bin/WebService_REST_solution.jar -I./ucybdbld.ini
    ========================================================
    Starting C++ batch mode loader...
    User account (user/domain) <AUTOMIC/>
    Startup parameter <-C0 -B -X/opt/Automic/Agents/RA/bin/WebService_REST_solution.jar -I./ucybdbld.ini >
    Application name <./ucybdbld>
    Launch from </opt/Automic/Utility/bin/>
    LoadLibrary pointer = <0x1364450>
    20180927/142852.641 - U00033125 Operating System: <UC4_ON_UNIX>
    20180927/142852.641 - U00033125 Operating System: <UC4_ON_UNIX_LINUX>
    20180927/142852.641 - U00038002 DLL 'ucybdbld', version '12.1.2+build.956'. Start parameter: '-C0 -B -X/opt/Automic/Agents/RA/bin/WebService_REST_solution.jar -I./ucybdbld.ini ', (changelist '1525855589').
    20180927/142852.641 - U00038259 Build Date: '2018-05-10', '06:55:29'
    20180927/142852.649 - ----------------------------------------------------------------------------------------------------
    20180927/142852.649 -
    20180927/142852.649 - [GLOBAL]
    20180927/142852.649 - language=(E,D)
    20180927/142852.649 - logging=../temp/ucybdbld_log_##.txt
    20180927/142852.649 - logCount=10
    20180927/142852.649 - helplib=uc.msl
    20180927/142852.649 - helpcache=ALL
    20180927/142852.649 - path=.
    20180927/142852.649 - cmd="javaw" -Xmx512m -cp .;./lookandfeel.jar -jar ucybdbLd.jar
    20180927/142852.649 - title=UCYBDBLd
    20180927/142852.649 - docu_path=../../Documentation/uc4/webhelp
    20180927/142852.649 - input=../db/
    20180927/142852.649 -
    20180927/142852.649 - [TRACE]
    20180927/142852.649 - file=../temp/ucybdbld_trace_##.txt
    20180927/142852.649 - trccount=10
    20180927/142852.649 - database=0
    20180927/142852.649 -
    20180927/142852.649 - [ODBC]
    20180927/142852.649 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=onemfr;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P1
    20180927/142852.649 - -------------------------------------------------

     

    ou

     

    [automic@ddesvr9701 bin]$ ./ucybdbld -C0 -B -X/opt/Automic/Agents/RA/bin/FtpAgent_solution.jar -I./ucybdbld.ini
    ========================================================
    Starting C++ batch mode loader...
    User account (user/domain) <AUTOMIC/>
    Startup parameter <-C0 -B -X/opt/Automic/Agents/RA/bin/FtpAgent_solution.jar -I./ucybdbld.ini >
    Application name <./ucybdbld>
    Launch from </opt/Automic/Utility/bin/>
    LoadLibrary pointer = <0x1465450>
    20180927/143110.917 - U00033125 Operating System: <UC4_ON_UNIX>
    20180927/143110.917 - U00033125 Operating System: <UC4_ON_UNIX_LINUX>
    20180927/143110.917 - U00038002 DLL 'ucybdbld', version '12.1.2+build.956'. Start parameter: '-C0 -B -X/opt/Automic/Agents/RA/bin/FtpAgent_solution.jar -I./ucybdbld.ini ', (changelist '1525855589').
    20180927/143110.917 - U00038259 Build Date: '2018-05-10', '06:55:29'
    20180927/143110.926 - ----------------------------------------------------------------------------------------------------
    20180927/143110.926 -
    20180927/143110.926 - [GLOBAL]
    20180927/143110.926 - language=(E,D)
    20180927/143110.926 - logging=../temp/ucybdbld_log_##.txt
    20180927/143110.926 - logCount=10
    20180927/143110.926 - helplib=uc.msl
    20180927/143110.926 - helpcache=ALL
    20180927/143110.926 - path=.
    20180927/143110.926 - cmd="javaw" -Xmx512m -cp .;./lookandfeel.jar -jar ucybdbLd.jar
    20180927/143110.926 - title=UCYBDBLd
    20180927/143110.926 - docu_path=../../Documentation/uc4/webhelp
    20180927/143110.926 - input=../db/
    20180927/143110.926 -
    20180927/143110.926 - [TRACE]
    20180927/143110.926 - file=../temp/ucybdbld_trace_##.txt
    20180927/143110.926 - trccount=10
    20180927/143110.926 - database=0
    20180927/143110.926 -
    20180927/143110.926 - [ODBC]
    20180927/143110.926 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=onemfr;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P1
    20180927/143110.926 - ----------------------------------------------------------------------------------------------------
    Application return code = 1

     

    Il n'y a aucune trace en plus

     

    A noter que mes utility fonctionnent, j'ai chargé les initial data et la license avec le ucybdbld lors de l'installation des noeuds...

     

    Tout ce qui est sur le serveur viens de l'archive d'installation Automic.Workload.Automation_12.1.2_2018-09-06

     

    Cordialement,

    Didier



  • 4.  Re: Installation RA core v12.1

    Posted Oct 03, 2018 04:11 AM

    Bonjour Didier,

     

    Pouvez-vous essayer avec "ucybdbld.jar" au lieu de juste "ucybdbld" ?

     

    J'a reproduit de mon côté, et cette commande devrait fonctionner:

    ./ucybdbld.jar -B -X/opt/Automic/Agents/RA/bin/FtpAgent_solution.jar 

     

    Les paramètres "-C0" et "-I./ucybdbld.ini" ne sont pas nécessaires : pas besoin de charger la solution dans le client 0 en particulier, et par défaut "ucybdbld.ini" est utilisé.

     

    Cordialement,

    Antoine



  • 5.  Re: Installation RA core v12.1

    Posted Oct 03, 2018 08:27 AM

    Bonjour,

     

    On ne peut pas exécuter un .jar directement. Il faudrait utiliser java -d64 -jar ./ucybdbld.jar -B -X/opt/Automic/Agents/RA/bin/FtpAgent_solution.jar 

     

    mais ça ne fonctionne pas plus.

    Le lancement via le jar est encapsulé dans le .sh mais destiné à lancer la version graphique sur Unix

     

    ./ucybdbld.sh
    Exception in thread "main" java.awt.HeadlessException:
    No X11 DISPLAY variable was set, but this program performed an operation which requires it.
    at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:204)
    at java.awt.Window.<init>(Window.java:536)
    at java.awt.Frame.<init>(Frame.java:420)
    at java.awt.Frame.<init>(Frame.java:385)
    at javax.swing.JFrame.<init>(JFrame.java:189)
    at com.ucutil.ucdbload.UCYDBLoadUI.<init>(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.<init>(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.main(Unknown Source)

     

    Et devinez quoi ? je n'ai pas d'émulateur X11 sous la main !



  • 6.  Re: Installation RA core v12.1

    Posted Oct 03, 2018 10:39 AM

    Bonjour Didier,

     

    J'avais testé sous Windows, du coup il n' y avait pas besoin de préciser "java -jar" car le chemin d'accès à java était dans la variable %PATH%.

     

    J'ai donc retesté sous Linux (CentOS 7), en me connectant avec MobaXTerm et ai été confronté au même problème que vous:

     

    J'ai ensuite testé en me connectant via PuTTy, et, Ô Joie! cela a fonctionné:

     

    Le premier soft (MobaXTerm) comporte un X Server par défaut, tandis que PuTTy, non.

     

    Mon collègue Roney.Uba a trouvé la solution : en passant la valeur de la variable $DISPLAY à un contenu vide via la commande "export DISPLAY=", la même commande fonctionne :

     

    Moralité : Pouvez-vous passer la valeur de $DISPLAY à un contenu vide, et tenter à nouveau ?

     

    Cordialement,

    Antoine



  • 7.  Re: Installation RA core v12.1

    Posted Oct 04, 2018 02:16 AM

    J'ai peur que l'on s'égare...

     

    Je suis connecté via putty, il n'y à pas de valeur DISPLAY et le binaire d'import me renvoi un code retour 1

     

    [ec2-user@ddesvr9701 ~]$ sudo su - automic
    Last login: Wed Oct 3 14:11:54 CEST 2018 on pts/0
    [automic@ddesvr9701 Automic]$ echo $DISPLAY

    [automic@ddesvr9701 Automic]$ cd Utility/bin/

    [automic@ddesvr9701 bin]$ ./ucybdbld -B -X/tmp/WebService_REST_solution.jar
    ========================================================
    Starting C++ batch mode loader...
    User account (user/domain) <AUTOMIC/>
    Startup parameter <-B -X/tmp/WebService_REST_solution.jar >
    Application name <./ucybdbld>
    Launch from </opt/Automic/Utility/bin/>
    LoadLibrary pointer = <0x21b2450>
    20181004/075320.484 - U00033125 Operating System: <UC4_ON_UNIX>
    20181004/075320.484 - U00033125 Operating System: <UC4_ON_UNIX_LINUX>
    20181004/075320.484 - U00038002 DLL 'ucybdbld', version '12.1.2+build.956'. Start parameter: '-B -X/tmp/WebService_REST_solution.jar ', (changelist '1525855589').
    20181004/075320.484 - U00038259 Build Date: '2018-05-10', '06:55:29'
    20181004/075320.492 - ----------------------------------------------------------------------------------------------------
    20181004/075320.492 - [GLOBAL]
    20181004/075320.492 - language = (E,D)
    20181004/075320.492 - logging = ../temp/ucybdbld_log_##.txt
    20181004/075320.492 - logcount = 20
    20181004/075320.492 - helplib = uc.msl
    20181004/075320.492 - helpcache = ALL
    20181004/075320.492 - docu_path = ../../Documentation/uc4/webhelp
    20181004/075320.492 - input = ../db/
    20181004/075320.492 -
    20181004/075320.492 -
    20181004/075320.492 - [TRACE]
    20181004/075320.492 - file = ../temp/ucybdbld_trace_##.txt
    20181004/075320.492 - trccount = 20
    20181004/075320.492 - database = 0
    20181004/075320.492 - ; 0=no
    20181004/075320.492 - ; 1=SQL
    20181004/075320.492 - ; 2=OPC
    20181004/075320.492 - ; 3=BindParam
    20181004/075320.492 - ; 4=data fields
    20181004/075320.492 -
    20181004/075320.492 -
    20181004/075320.492 - [ODBC]
    20181004/075320.492 - ; ODBCVAR xxxxxxxx
    20181004/075320.492 - ; |||||||+ type of SQL-Syntax N=SQL-SERVER O=ORACLE D=DB2 Z=DB2/OS390
    20181004/075320.492 - ; ||||||+- R=compress messages and local memory
    20181004/075320.492 - ; |||||+-- O = with userid, N = without userid
    20181004/075320.492 - ; ||||+--- I=OCI/CLI N=ODBC
    20181004/075320.492 - ; |||+---- not used
    20181004/075320.492 - ; ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!)
    20181004/075320.492 - ; |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks)
    20181004/075320.492 - ; +------- S = use Server-Cursor (SQL-SERVER)
    20181004/075320.492 - ;
    20181004/075320.492 - ; SNNNNNRN for SQL-Server either Standard-Client or Native-Client without using Mars_Connection
    20181004/075320.492 - ; NNNNNNRN for SQL-Server utilizing Native-Client (Mars_Connection=Yes is required)
    20181004/075320.492 - ; NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface)
    20181004/075320.492 - ; NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface)
    20181004/075320.492 - ;
    20181004/075320.492 - ; Oracle with OCI
    20181004/075320.492 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=onemfr;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,C ODESET=WE8ISO8859P1
    20181004/075320.492 - ----------------------------------------------------------------------------------------------------
    Application return code = 1

     

    si je lance

    [automic@ddesvr9701 bin]$ java -d64 -jar ./ucybdbld.jar -B -X/tmp/WebService_REST_solution.jar
    Exception in thread "main" java.lang.UnsatisfiedLinkError: no ucybdbld in java.library.path
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1867)
    at java.lang.Runtime.loadLibrary0(Runtime.java:870)
    at java.lang.System.loadLibrary(System.java:1122)
    at com.ucutil.ucdbload.CJNIInterface.m_InitializeLibrary(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.<init>(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.main(Unknown Source)

     

    ça ne fonctionne pas et c'est normal puisque ça doit lancer la version IHM X11 et que le DISPLAY et vide

    de plus X11 n'est pas installé

    ma question concerne bien le chargement d'une solution RA en utilisant le binaire Unix ucybdbld 

     

    J'ai déjà effectué cette action sur d'autres installations et c'est pour cela que je suis très surpris que cela ne fonctionne pas...

     

    Sur cette installation j'ai chargé les initial data et la licence lors de l'installation sans soucis...

     

    cd /opt/Automic/Utility/bin
    ./ucybdbld -B -X/opt/Automic/Utility/db/general/12.1/UC_UPD.TXT

    ./ucybdbld -B -X/opt/Automic/Licence/ER51543.tx



  • 8.  Re: Installation RA core v12.1

    Posted Oct 04, 2018 04:05 AM

    Bonjour Didier,

     

    Il faut utiliser la version Java (.jar) de DB Load pour charger les solutions RA, qui elles-mêmes sont des archives java (.jar). Cela ne fonctionne pas avec l'exécutable "standard". Pas de souci de ce type cependant avec les fichiers .txt, .sql, etc.

     

    Du coup, l'objectif est de lancer ucybdbld.jar sans qu'il cherche à initialiser le display - en mode batch donc. Cela pourrait être un bug - si l'exécutable est lancé en mode batch (-B) il ne devrait pas chercher à lancer l'interface graphique. Je vous invite à vous rapprocher du support si vous souhaitez le remonter.

     

    Par ailleurs, si vraiment cela ne fonctionne pas, peut-être serait-il plus simple d'exécuter DB Load depuis un autre hôte. En effet seule la connexion à la base de données est nécessaire:

    SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=onemfr;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P1

    Vous aurez cependant besoin d'un client Oracle, et que la connexion soit renseignée dans tnsnames.ora.

     

    En espérant que cela vous aide.

     

    Cordialement,

    Antoine



  • 9.  Re: Installation RA core v12.1
    Best Answer

    Posted Oct 04, 2018 04:24 AM

    Ok, j'ai finalement compris...

    Le début de la solution était dans le dernier message d'erreur

     

    [automic@ddesvr9701 bin]$ java -d64 -jar ./ucybdbld.jar -B -X/tmp/WebService_REST_solution.jar
    Exception in thread "main" java.lang.UnsatisfiedLinkError: no ucybdbld in java.library.path
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1867)
    at java.lang.Runtime.loadLibrary0(Runtime.java:870)
    at java.lang.System.loadLibrary(System.java:1122)
    at com.ucutil.ucdbload.CJNIInterface.m_InitializeLibrary(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.<init>(Unknown Source)
    at com.ucutil.ucdbload.CUCYDBLoad.main(Unknown Source)

     

    Donc il faut ajouter /opt/Automic/Utility/bin dans la variable LD_LIBRARY_PATH au niveau du profile

    Et là, ça fonctionne mieux !

     

    [automic@ddesvr9701 bin]$ java -jar ./ucybdbld.jar -B -X/tmp/WebService_REST_solution.jar
    20181004/101241.769 - U00033125 Operating System: <UC4_ON_UNIX>
    20181004/101241.769 - U00033125 Operating System: <UC4_ON_UNIX_LINUX>
    20181004/101241.769 - U00033116 Program is running in Java version: '1.8.0_181'
    20181004/101241.769 - U00038002 DLL 'ucybdbld', version '12.1.2+build.956'. Start parameter: ' -B -X/TMP/WEBSERVICE_REST_SOLUTION.JAR', (changelist '1525855589').
    20181004/101241.769 - U00038259 Build Date: '2018-05-10', '06:55:29'
    20181004/101241.815 - ----------------------------------------------------------------------------------------------------
    20181004/101241.815 - [GLOBAL]
    20181004/101241.815 - language = (E,D)
    20181004/101241.815 - logging = ../temp/ucybdbld_log_##.txt
    20181004/101241.815 - logcount = 20
    20181004/101241.815 - helplib = uc.msl
    20181004/101241.815 - helpcache = ALL
    20181004/101241.815 - docu_path = ../../Documentation/uc4/webhelp
    20181004/101241.815 - input = ../db/
    20181004/101241.815 -
    20181004/101241.815 -
    20181004/101241.815 - [TRACE]
    20181004/101241.815 - file = ../temp/ucybdbld_trace_##.txt
    20181004/101241.815 - trccount = 20
    20181004/101241.815 - database = 0
    20181004/101241.815 - ; 0=no
    20181004/101241.815 - ; 1=SQL
    20181004/101241.815 - ; 2=OPC
    20181004/101241.815 - ; 3=BindParam
    20181004/101241.815 - ; 4=data fields
    20181004/101241.815 -
    20181004/101241.815 -
    20181004/101241.815 - [ODBC]
    20181004/101241.815 - ; ODBCVAR xxxxxxxx
    20181004/101241.815 - ; |||||||+ type of SQL-Syntax N=SQL-SERVER O=ORACLE D=DB2 Z=DB2/OS390
    20181004/101241.815 - ; ||||||+- R=compress messages and local memory
    20181004/101241.815 - ; |||||+-- O = with userid, N = without userid
    20181004/101241.815 - ; ||||+--- I=OCI/CLI N=ODBC
    20181004/101241.815 - ; |||+---- not used
    20181004/101241.815 - ; ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!)
    20181004/101241.815 - ; |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks)
    20181004/101241.815 - ; +------- S = use Server-Cursor (SQL-SERVER)
    20181004/101241.815 - ;
    20181004/101241.815 - ; SNNNNNRN for SQL-Server either Standard-Client or Native-Client without using Mars_Connection
    20181004/101241.815 - ; NNNNNNRN for SQL-Server utilizing Native-Client (Mars_Connection=Yes is required)
    20181004/101241.815 - ; NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface)
    20181004/101241.815 - ; NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface)
    20181004/101241.815 - ;
    20181004/101241.815 - ; Oracle with OCI
    20181004/101241.815 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=onemfr;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P1
    20181004/101241.815 - ----------------------------------------------------------------------------------------------------
    20181004/101241.879 - U00033103 Automation Engine - Utilities Version 12.1.2+build.555 @ ddesvr9701.vefdir.veolia.net
    20181004/101242.501 - U00038207 The jar archive is signed:
    20181004/101242.502 - Issued to: CN=Automic Software GmbH, OU=Secure Application Development, O=Automic Software GmbH, L=Vienna, ST=Vienna, C=AT
    20181004/101242.502 - Issued by: CN=thawte SHA256 Code Signing CA, O="thawte, Inc.", C=US
    20181004/101242.502 - Valid from: Tue Jun 09 02:00:00 CEST 2015
    20181004/101242.502 - Valid to: Fri Jun 09 01:59:59 CEST 2017
    20181004/101243.614 - U00038207 The jar archive is signed:
    20181004/101243.614 - Issued to: CN=Automic Software GmbH, OU=Secure Application Development, O=Automic Software GmbH, L=Vienna, ST=Vienna, C=AT
    20181004/101243.614 - Issued by: CN=thawte SHA256 Code Signing CA, O="thawte, Inc.", C=US
    20181004/101243.614 - Valid from: Tue Jun 09 02:00:00 CEST 2015
    20181004/101243.614 - Valid to: Fri Jun 09 01:59:59 CEST 2017
    20181004/101244.121 - U00038091 Change application directory to '/opt/Automic/Utility/bin'.
    20181004/101244.152 - U00003545 UCUDB: Opening database ...
    20181004/101244.152 - U00029112 UCUDB - Length of the DB-History area: 100
    20181004/101244.208 - U00029114 UCUDB - ALTER SESSION: NLS_LANGUAGE=AMERICAN
    20181004/101244.208 - U00029114 UCUDB - ALTER SESSION: NLS_TERRITORY=AMERICA
    20181004/101244.209 - U00029109 UCUDB: Local information from client environment
    20181004/101244.209 - U00003535 DB INFO: 'OCI_NLS_LANGUAGE = AMERICAN'
    20181004/101244.209 - U00003535 DB INFO: 'OCI_NLS_TERRITORY = AMERICA'
    20181004/101244.209 - U00003535 DB INFO: 'OCI_NLS_CHARACTER_SET = WE8ISO8859P1'
    20181004/101244.209 - U00029110 UCUDB - Session parameters:
    20181004/101244.209 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_CURRENCY = $'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_SORT = BINARY'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_COMP = BINARY'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = CHAR'
    20181004/101244.209 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
    20181004/101244.209 - U00003535 DB INFO: 'SID = 347'
    20181004/101244.210 - U00029111 UCUDB - Database parameters:
    20181004/101244.210 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_CURRENCY = $'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_CHARACTERSET = WE8ISO8859P1'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_SORT = BINARY'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_COMP = BINARY'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_NCHAR_CHARACTERSET = AL16UTF16'
    20181004/101244.210 - U00003535 DB INFO: 'NLS_RDBMS_VERSION = 11.2.0.4.0'
    20181004/101244.210 - U00029115 UCUDB - OPEN Database handles DB-HENV: 7fc358953d80 DB-HDBC: 0
    20181004/101244.211 - U00003535 DB INFO: 'DATABASE-NAME = ONEMFR'
    20181004/101244.211 - U00003535 DB INFO: 'DBMS-NAME = Oracle Database 11g'
    20181004/101244.211 - U00003535 DB INFO: 'DBMS-VER = 11.2.0.4.0 - 64bit Production'
    20181004/101244.211 - U00003535 DB INFO: 'ODBC-VER = ODBC not used'
    20181004/101244.211 - U00003535 DB INFO: 'DRIVER-NAME = Oracle Call Interface'
    20181004/101244.211 - U00003535 DB INFO: 'DRIVER-ODBC-VER ='
    20181004/101244.211 - U00003535 DB INFO: 'DRIVER-VER = Compiled May 9 2018'
    20181004/101244.211 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE ='
    20181004/101244.211 - U00003535 DB INFO: 'TXN-CAPABLE ='
    20181004/101244.211 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION ='
    20181004/101244.211 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION ='
    20181004/101244.211 - U00003535 DB INFO: 'POS-OPERATIONS ='
    20181004/101244.211 - U00003535 DB INFO: 'POSITIONED-STATEMENTS ='
    20181004/101244.211 - U00003535 DB INFO: 'SCROLL-CONCURRENCY ='
    20181004/101244.211 - U00003535 DB INFO: 'SCROLL-OPTIONS ='
    20181004/101244.211 - U00003535 DB INFO: 'STATIC-SENSITIVITY ='
    20181004/101244.211 - U00003535 DB INFO: 'LOCK-TYPES ='
    20181004/101244.211 - U00003535 DB INFO: 'ODBC_TRACE = 0'
    20181004/101244.212 - U00003532 UCUDB: Checking data source ...
    20181004/101247.845 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '511946169'/'542 (1000/1.844096 s)'
    20181004/101247.845 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470
    20181004/101248.045 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '3:923.921.000'
    20181004/101248.045 - U00003525 UCUDB: ===> ''
    20181004/101248.046 - U00038091 Change application directory to '../db/'.
    20181004/101248.061 - U00021200 *********************************************ILM SETTINGS***********************************************
    20181004/101248.062 - U00021202 ILM installed N
    20181004/101248.062 - U00021203 ********************************************************************************************************
    20181004/101248.062 - U00038164 Loading RA Solution.
    20181004/101248.063 - U00038257 Version check result:
    Version of the RA Solution: '4.4.1'.
    Version of database objects: '12.1.2+hf.2.build.1683'.

     

    20181004/101248.063 - U00038149 Generating RA object 'WEBSERVICEREST'.
    20181004/101248.094 - U00038167 Generating RA Agent 'WEBSERVICEREST'
    20181004/101248.106 - U00038168 RA Agent 'WEBSERVICEREST' successfully loaded.
    20181004/101248.107 - U00038151 RA object 'WEBSERVICEREST' successfully created.
    20181004/101248.107 - U00038152 Generating RA Subcomponent 'REST'.
    20181004/101248.121 - U00038156 RA Subcomponent 'REST' successfully generated.
    20181004/101248.122 - U00038157 Generating RA connection 'RESTCONNECTION'.
    20181004/101248.130 - U00038158 RA connection 'RESTCONNECTION' successfully generated.
    20181004/101248.130 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent/components.xml'.
    20181004/101248.131 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent/components.xml' successfully loaded.
    20181004/101248.131 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent/gui/REST.xml'.
    20181004/101248.923 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent/gui/REST.xml' successfully loaded.
    20181004/101248.924 - U00038160 Changing filename from 'ConnectionPanelDef.xml' to 'RestConnection.xml'
    20181004/101248.924 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent/extcit/RestConnection/gui/RestConnection.xml'.
    20181004/101248.981 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent/extcit/RestConnection/gui/RestConnection.xml' successfully loaded.
    20181004/101248.981 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent/gui/AgentPanelDef.xml'.
    20181004/101249.643 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent/gui/AgentPanelDef.xml' successfully loaded.
    20181004/101249.643 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent/message.properties'.
    20181004/101249.648 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent/message.properties' successfully loaded.
    20181004/101249.648 - U00038162 Loading file: 'Signature'.
    20181004/101249.649 - U00038163 File 'Signature' successfully loaded.
    20181004/101249.664 - U00038162 Loading file: '/tmp/WebService_REST/WebService_REST_Agent_deploy_file.jar'.
    20181004/101254.523 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'INSR' time: '4:819.804.000'
    20181004/101254.523 - U00003525 UCUDB: ===> 'INSERT INTO OBLOB (OBLOB_OH_Idnr, OBLOB_Name, OBLOB_Type, OBLOB_ContentLen, OBLOB_Content, OBLOB_Filename, OBLOB_HostAttrType, OBLOB_SW, OBLOB_ReplaceVar, OBLOB_HW) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
    20181004/101254.523 - U00038163 File '/tmp/WebService_REST/WebService_REST_Agent_deploy_file.jar' successfully loaded.
    20181004/101254.528 - U00038165 RA Solution loaded successfully.
    20181004/101254.528 - U00038272 Loading RA Plugins.
    20181004/101254.529 - U00038269 Version check result:
    Version of the RA Plugins: '4.4.1'.
    Version of database objects: '12.1.2+hf.2.build.1683'.

     

    20181004/101254.536 - U00038162 Loading file: '/tmp/WebService_REST/ecc-ae-sheet-ra-webservice-rest.jar'.
    20181004/101254.584 - U00038163 File '/tmp/WebService_REST/ecc-ae-sheet-ra-webservice-rest.jar' successfully loaded.
    20181004/101254.587 - U00038273 RA Plugins loaded successfully.
    20181004/101254.611 - U00003523 UCUDB: Maximum time required for a DB call: '4:819.804.000'.
    20181004/101254.611 - U00003522 UCUDB: Database closed. Total time for DB calls: '10:393.970.999' seconds.
    20181004/101254.611 - U00003549 UCUDB: ' 2295' 'OTHERS ' calls took '0:012.480.000' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 23' 'SELECT ' calls took '0:035.352.999' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 3' 'EXECUTE ' calls took '3:924.748.999' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 4' 'UPDATE ' calls took '0:002.967.000' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 3103' 'INSERT ' calls took '6:412.974.000' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 23' 'READ ' calls took '0:000.359.000' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 6401' 'CLOSESTMT ' calls took '0:000.420.999' sec.
    20181004/101254.611 - U00003549 UCUDB: ' 1016' 'TRANSACT ' calls took '0:004.668.000' sec.