Automic Workload Automation

Expand all | Collapse all

Automic Automation 12.3 JWP - jdbc error

  • 1.  Automic Automation 12.3 JWP - jdbc error

    Posted 08-06-2019 12:17 PM
    Hi All,
    I have installed the new version of Automic Automation, 12.3 on Windows Server 2016 standard - x64.

    Database connection via ODBC is ok, and AE DBLoad Utility run ok to load initial data and structure on the new empty DB (AE).

    When I try to start the JWP process from service manager dialog, it returns this error:

    "20190806/180134.120 - 1 U00003545 UCUDB: Opening database ...
    20190806/180134.402 - 1 U00003611 DB OPEN executed. Return Code = '18456'
    20190806/180134.402 - 1 U00003590 UCUDB - DB error: 'S0001', 'Login failed for user 'userAE'. ClientConnectionId:d3ee4fd6-6c1f-43ed-beda-629d7a27f02f', '18456', 'com.microsoft.sqlserver.jdbc.SQLServerException'".

    I have installed the new jdbc driver and copy the jar file mssql-jdbc-7.2.2.jre8 on AutomationEngine/bin/lib dir.

    JAVA_HOME is set on environment variables (C:\Program Files\Java\jre1.8.0_111).

    ucsrvjp.jar file is present under automation engine installation dir.

    What I have missed or have I did wrong?

    Any help will be very appreciated!

    Thank you in advance!

    Claudia




  • 2.  RE: Automic Automation 12.3 JWP - jdbc error

    Posted 08-06-2019 12:20 PM
    ​Hi.

    Is your database user actually called "userAE"? This seems ... unusual at least.

    Check your files, especially the ucsrv.ini and there specificially the connection string, maybe there's a typo where the user is specified?

    Hth,


  • 3.  RE: Automic Automation 12.3 JWP - jdbc error

    Posted 08-06-2019 02:56 PM
    Hi Carsten,
    thanks for your reply.
    Db user is "userAE", and with this same user connection to the DB via ODBC driver is ok.

    I think there is some java configuration missing, or wrong...

    Any ideas?

    Many thanks for your help!

    Claudia



  • 4.  RE: Automic Automation 12.3 JWP - jdbc error

    Posted 08-07-2019 11:13 AM
    There is a JWP setup switch in the manual.  It will query you for answers to questions about your db and modify your ucsrv.ini accordingly, JWP section only.

    --
    ~~~~~~~~~~~~~~~~~~~~~~~~
    Scott Hughes
    Verizon  (505) 373-7872
    scott.hughes1@verizon.com 
    ~~~~~~~~~~~~~~~~~~~~~~~~





  • 5.  RE: Automic Automation 12.3 JWP - jdbc error

    Posted 08-08-2019 03:50 AM
    Hi All,
    thanks for your help.
    We solved the issue setting new port (1444) for MS-SQL Instance.
    The reason was we have two instance of MS-SQL Servere on the same server (MS-SQLServer 2012 and MS-SQLServer 2017).

    Claudia