Automic Workload Automation

 View Only
Expand all | Collapse all

Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

  • 1.  Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 17, 2020 07:08 AM
    Hello All

    We are in middle of upgrading our system where DB is same but application server is new. after db LOAD when we tried starting Service manager we are getting below error -

    [1] + Memory fault             nohup ./ucybsmgr -i/applications/uc4/v123/servicemanager/bin/ucybsmgr_srv.ini AE12SRV &

     ./ucybsmgr -i/applications/uc4/v123/servicemanager/bin/ucybsmgr_srv.ini AE12SRV
    Segmentation fault


    and for CP -

    20201017/115730.634 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error '/lib64/libnnz12.so: undefined symbol: slts_runmode'.
    20201017/115730.635 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
    20201017/115730.635 - U00003410 Server 'UC4QA#CP' version '12.3.2+hf.1.build.1584364211340' ended abnormally.

    i created some symbolic links for missing library error but it is not working . I am not sure if our env vara is having some issues or where we need to look.
    Please Help

    Thank you

    ------------------------------
    Shaivi Chauhan
    ------------------------------


  • 2.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 17, 2020 07:10 AM
      |   view attached
    uploading some logs

    ------------------------------
    Shaivi Chauhan
    ------------------------------

    Attachment(s)

    zip
    Logs_31.zip   22 KB 1 version


  • 3.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 19, 2020 02:21 AM
    Hi @Deactivated User

    1. I suspect the LD_LIBRARY_PATH hasn't been set (https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Manual/AE/InstalltheAE_ServiceManager.htm?Highlight=ld_lib)
    2. the CP-logs show that you're using an old server.ini. 

    WP port definition is obsolete with V12.3

    20201016/131425.413 - [PORTS]
    20201016/131425.413 - ;
    20201016/131425.413 - ; [PORTS]
    20201016/131425.413 - ;
    20201016/131425.413 - ; cp1: Assignment of communication processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - cp1=2217
    20201016/131425.413 - ;
    20201016/131425.413 - ; cp2: Assignment of communication processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - cp2=2218
    20201016/131425.413 - ;
    20201016/131425.413 - ; cp3: Assignment of communication processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - cp3=2219
    20201016/131425.413 - ;
    20201016/131425.413 - ; cp4: Assignment of communication processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - cp4=2220
    20201016/131425.413 - ;
    20201016/131425.413 - ; cp5: Assignment of communication processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - cp5=2221
    20201016/131425.413 - ;
    20201016/131425.413 - ; wp1: Assignment of work processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - wp1=2271
    20201016/131425.413 - ;
    20201016/131425.413 - ; wp2: Assignment of work processes and port numbers.
    20201016/131425.413 - ;
    20201016/131425.413 - wp2=2272
    20201016/131425.413 - ;

    Cheers
    Christoph 





    ------------------------------
    ----------------------------------------------------------------
    Automic AE Consultant and Trainer since 2000
    ----------------------------------------------------------------
    ------------------------------



  • 4.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 19, 2020 05:01 AM
    Hello Christoph,
    Thank you so much for checking , we did modify the config files and downloaded the HF 4 for v12.3.3 but now we are getting different error-

    /1/org.eclipse.osgi/38/0/.cp/lib/xdb6.jar"' at 'org.eclipse.osgi.framework.util.SecureAction.getZipFile():317'.
    20201019/095202.147 - 39 U00045015 The previous error was caused by 'java.util.zip.ZipException: "zip file is empty"' at 'java.util.zip.ZipFile.open()'.
    20201019/095202.148 - 39 U00003620 Routine 'com.automic.kernel.impl.DefaultExceptionHandler' forces trace because of error.
    20201019/095202.281 - 39 U00045025 OSGI ['fragment_xmlparserv2.jar']: 'FrameworkEvent ERROR'
    20201019/095202.281 - 29 U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
    20201019/095202.282 - 39 Unhandled Exception in thread Framework Event Dispatcher: Equinox Container: a79a2d4e-61f2-4734-83c0-bc171edd9cde
    20201019/095202.283 - 29 U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
    20201019/095202.283 - 39 U00045014 Exception 'java.util.zip.ZipException: "Exception in opening zip file: /applications/uc4/v123/server/bin/configuration
    /1/org.eclipse.osgi/39/0/.cp/lib/xmlparserv2.jar"' at 'org.eclipse.osgi.framework.util.SecureAction.getZipFile():317'.
    20201019/095202.285 - 39 U00045015 The previous error was caused by 'java.util.zip.ZipException: "zip file is empty"' at 'java.util.zip.ZipFile.open()'.
    20201019/095202.285 - 39 U00003620 Routine 'com.automic.kernel.impl.DefaultExceptionHandler' forces trace because of error.
    20201019/095202.421 - 39 U00045025 OSGI ['fragment_xdb6.jar']: 'FrameworkEvent ERROR'
    20201019/095202.421 - 29 U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'

    ------------------------------
    Shaivi Chauhan
    ------------------------------



  • 5.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 19, 2020 05:53 AM
    Hi Shaivi Chauhan, 

    Have you modified the existing (old) ucsrv.ini or the new one? I recommend to not use the old one, instead modify and use the new one.

    There are still to many parameters that can possible be set up wrong. It would help if you post the ucsrv.ini file or the complete server's log/trace file

    Cheers
    Christoph 


    ------------------------------
    ----------------------------------------------------------------
    Automic AE Consultant and Trainer since 2000
    ----------------------------------------------------------------
    ------------------------------



  • 6.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 20, 2020 12:07 AM
    Hello Christoph,
    we use the new ini and modify the value there only -
    ;
    ; Automic Configuration File for Automation Engine
    ;
    [GLOBAL]
    ;
    ; system: AE system name
    ; The name can consist of a maximum of 8 characters. Allowed are the upper-case letters A to Z, numbers and "_".
    ;
    system=UC4QA
    ;
    ; language: The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.
    ; if a message text is not available in the primary language the secondary language will be taken.
    ; E - english
    ; D - german
    ; F - french
    ;
    language=(E,D)
    ;
    ; logging: Full file name pattern for log file names
    ; $$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components
    ; * is replaced by the 3 digit number of a Worker Process.
    ; ## is replaced by the log file sequence number after the existing log files' corresponding numbers have been raised by one during startup of the component.
    ; z/OS components only:
    ; If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.
    ; The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):
    ; "recfm" = (all 27 z/OS plus * and A record formats are valid)
    ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    ; "blksize" = (0, each positive number up to 32760)
    ; "space" = ([CYL,TRK],(prim,sec,directory))
    ;
    logging=../temp/$$srv_log_*_##.txt
    ;
    ; logCount: number of log files being kept on disk
    ;
    logCount=10
    ;
    ; helplib: name of the message text library
    ;
    helplib=uc.msl
    ;
    ; helpcache: Availability of the messages and language dependent strings.
    ; ALL - The complete message file is held in the RAM.
    ; NONE - Always read from the hard drive.
    ; CONTROLS - All language dependant strings that are necessary in order to display the dialog program are held in the RAM (not relevant for the Automation En
    gine).
    ;
    helpcache=ALL
    ;
    ; startMode: Automation Engine system startup mode.
    ; NORMAL - Normal AE start
    ; COLD - AE cold start. All task queues are cleared.
    ;
    startMode=NORMAL
    ;
    ; snmp: SNMP connection.
    ; 0 - No SNMP connection.
    ; 1 - SNMP connection is active.
    ; 2 - SNMP connection is active. SNMP Traps are additionally logged in the Windows Event Viewer.
    ;
    snmp=1
    ;
    ; nodename: The description of the dialog process environment.
    ;
    nodename=UC4QA_1
    ;
    ; primaryMode: The mode of the primary work process (PWP).
    ; The primary work process serves to process special messages.
    ; This parameter can be used to specify whether it should also serve as normal work process.
    ; 1 - The PWP processes only own messages. This is only possible if a further work process is active.
    ; 0 - The PWP also processes messages which can generally be processed by work processes.
    ;
    primaryMode=1
    ;
    ; exception: Exception handling.
    ; With this option being activated, messages that caused a server process crash are intercepted and moved to quarantine. Doing so protects your AE system bec
    ause intercepted messages will not affect further worker processes.
    ; 0 - exception handler turned off
    ; 1 - exception handler tuned on
    ;
    exception=1
    ;
    ; systemStop: Client handling after Server-process start.
    ; NORMAL - Client status remains unchanged.
    ; YES - All clients are stopped after Server-process start.
    ;
    systemStop=NORMAL

    [CPMSGTYPES]
    ;
    ; srvquery: Determines which process responds to the agent's life sign message
    ; This setting has a performance impact. If the CP layer responds than the workload is distributed as agents are connected to different CP's whereas only one
    Primary WP exists in a system. Furthermore there is no need to hand over the agent's life sign messages to the PWP via the message queue tables which safes
    database IO's
    ; 0 - The primary work process (PWP) responds to the agent's live sign messages. (Slower)
    ; 1 - The communication processes (CPs) respond to the agent's live sign messages. (Faster)
    ;
    srvquery=0

    [CACHE]
    ;
    ; script: The maximum cache size (bytes) for script.
    ;
    script=3000000
    ;
    ; vara: The maximum cache size (bytes) for variables.
    ;
    vara=3000000
    ;
    ; mqmem: The maximum cache size (in bytes) for the mqmem table records.
    ;
    mqmem=3000000

    [TRACE]
    ;
    ; file: The path and the file name of the trace file.
    ; Any file name for a text file with several place holders for current system information:
    ; $$ is replaced by server process type (WP or CP) in the context of a server process.
    ; * is replaced by the three-digit process number in the context of a server process.
    ; ## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.
    ; xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).
    ; z/OS components only:
    ; The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:
    ; "recfm" = (all 27 record formats of z/OS plus * and A are valid)
    ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    ; "blksize" = (0, each positive number up to 32760)
    ; "space" = ([CYL,TRK],(prim,sec,directory))
    ;
    file=../temp/$$srv_trc_*_##.txt
    ;
    ; trccount: Number of stored trace files
    ;
    trccount=10
    ;
    ; tcp/ip: traceflag
    ;
    tcp/ip=9
    ;
    ; database: traceflags
    ; 0 - no trace
    ; 1 - SQL
    ; 2 - OPC
    ; 3 - Bind parameters
    ; 4 - Data fields
    ;
    database=0
    ;
    ; trc03: traceflag
    ;
    trc03=9
    ;
    ; srcall: traceflag
    ;
    srcall=9
    ;
    ; memio: traceflag
    ;
    memio=9
    ;
    ; jcl: traceflag
    ;
    jcl=9
    ;
    ; memsv: traceflag
    ;
    memsv=9
    ;
    ; snmp: traceflag
    ;
    snmp=9
    ;
    ; zuxml: traceflag
    ;
    zuxml=9
    ;
    ; cache: traceflag
    ;
    cache=9
    ;
    ; trc11: traceflag
    ;
    trc11=9
    ;
    ; ucds: traceflag
    ;
    ucds=9
    ;
    ; xscript: traceflag
    ;
    xscript=9
    ;
    ; uc4global: traceflag
    ;
    uc4global=9
    ;
    ; trc15: traceflag
    ;
    trc15=9
    ;
    ; trc16: traceflag
    ;
    trc16=9
    ;
    ; memtrace: traceflag
    ; 0 - This setting enables writing into the file when a WP starts.
    ; 1 - This setting enables writing into the memory when a WP starts.
    ;
    memtrace=0

    [TCP/IP]
    ;
    ; aliveTimeout: The duration in seconds in which the AE.Nonstop-Server expects a message from the primary work process.
    ; If this time span is exceeded, the AE.Nonstop-Server becomes the primary work process.
    ;
    aliveTimeout=600
    ;
    ; bindAddr: IP address the component uses to connect.
    ; Use this parameter if the connection should be established via a particular IP address (for example, the computer has more than one network interface card)
    .
    ;
    ;bindAddr=111.1.1.1
    ;
    ; bindLocal: Consideration of local host 127.0.0.1 (IPv4) or ::1 (IPv6).
    ; Use this parameter together with BINDADDR=.
    ; 0 - No listen socket is created.
    ; 1 - An additional listen socket is created on the local host.
    ;
    ;bindLocal=0
    ;
    ; chiffre: Encryption for transfer.
    ; 0 - Non-encrypted transfer.
    ; 1 - Transfers are encrypted.
    ;
    ;chiffre=1
    ;
    ; connect: The time interval in seconds for the reestablishment of connections after a loss of connection.
    ;
    ; For the Automation Engine: reconnect between Server Processes
    ; For Agents: reconnect to the Engine
    ; For the zOS Event Monitor: reconnect to the Agent
    ; For the Proxy: reconnect to Automation Engine or Server Proxy
    ;
    connect=120
    ;
    ; hostName: If you use this parameter, the UserInterfaces, CallAPIS and agents receive the information about the CPs that are known in the system via host n
    ame and port and not via the IP address and port during the CP selection phase while the connection to the Automation Engine is being established. In doing s
    o, you can avoid firewall and other NATproblems.
    ; Set hostname=*OWN if you want the operating system to retrieve the host name on which the CP is running.
    ;
    ;hostName=
    ;
    ; listenQueue: The maximum number of login requests in the list queue.
    ;
    listenQueue=2030
    ;
    ; maxMsgSize: Maximum length of messages (in bytes) that a CP (Server communication process) or an Agent accepts in Bytes.
    ;
    maxMsgSize=31457280
    ;
    ; netarea: The name of the net area of the server processes
    ; Default value: Name of the AE system
    ; This value affects the CP selection of components such as agents. For more detailed information about this parameter, see chapter Net Areas in AE.
    ;
    ;netarea=
    ;
    ; pwpPort: The port number of the primary work process.
    ;
    pwpPort=2270
    ;
    ; report: The time interval in seconds in which an Agent sends or the Automation Engine saves the logging to the database.
    ;
    report=20
    ;
    ; retryWait: The time intervals in seconds during which the server processes attempt to get a free port number from the port list in [PORTS] section.
    ; Format: (number, interval)
    ; number = Maximum number of attempts that should be made in order to obtain a free port from the port list.
    ; interval = Waiting period in seconds between attempts.
    ;
    retryWait=(3,10)
    ;
    ; retryWaitPwp: This parameter is exclusively used by work processes.
    ; They cyclically try to connect to primary-work-process port at system start or when the connection has been lost.
    ; Format: (number, interval)
    ;
    retryWaitPwp=(3,30)
    ;
    ; sendBufferSize: The size of the TCP/IP input buffer for the messages that should be sent (in bytes).
    ; The default value that depends on the system environment is used when you do not define this setting or when you define the value 0.
    ;
    sendBufferSize=1024k
    ;
    ; recvBufferSize: The size of the TCP/IP input buffer for the message that should be received (in bytes).
    ; The default value that depends on the system environment is used when you do not define this setting or when you define the value 0.
    ;
    recvBufferSize=1024k
    ;
    ; serverConnectionVerify: This checks whether the TCP/IP connection with a partner has been entered in the AE database table MQSRV and whether the IP address
    specified in the database complies with this connection's IP address.
    ; Activate this setting if the server should reject connections where the IP addresses do not match.
    ; 0 - The TCP/IP connection and the IP address are not checked.
    ; 1 - Activates the query.
    ;
    serverConnectionVerify=0
    ;
    ; snmp: The port number that the Automation Engine uses in order to connect to the AE SNMP Subagent.
    ;
    snmp=7777
    ;
    ; snmpReconnect: The interval in seconds that the system needs in order to reconnect to the AE SNMP Subagent after a connection loss.
    ;
    snmpReconnect=500
    ;
    ; tcp_KeepAlive_Time: The time interval in seconds in which keep-alive packets are sent in order to keep connections.
    ; The default value that depends on the system environment is used when you do not define this setting or when you define the value 0.
    ;
    tcp_KeepAlive_Time=6600
    ;
    ; tcp_Nodelay: This defines the use of the Nagle algorithm for the connections of the Automation Engine.
    ; 0 - Activates Nagle algorithm on all sockets.
    ; 1 - Deactivates the Nagle algorithm on all sockets.
    ;
    tcp_Nodelay=1

    [PORTS]
    ;
    ; [PORTS]
    ;
    ; cp1: Assignment of communication processes and port numbers.
    ;
    cp1=2217
    ;
    ; cp2: Assignment of communication processes and port numbers.
    ;
    cp2=2218
    ;
    ; cp3: Assignment of communication processes and port numbers.
    ;
    cp3=2219
    ;
    ; cp4: Assignment of communication processes and port numbers.
    ;
    cp4=2220
    ;
    ; cp5: Assignment of communication processes and port numbers.
    ;
    cp5=2221
    ;
    ; wp1: Assignment of work processes and port numbers.
    ;
    wp1=2271
    ;
    ; wp2: Assignment of work processes and port numbers.
    ;
    wp2=2272
    ;
    ; wp3: Assignment of work processes and port numbers.
    ;
    wp3=2273
    ;
    ; wp4: Assignment of work processes and port numbers.
    ;
    wp4=2274
    ;
    ; wp5: Assignment of work processes and port numbers.
    ;
    wp5=2275
    ;
    ; wp6: Assignment of work processes and port numbers.
    ;
    wp6=2276
    ;
    ; wp7: Assignment of work processes and port numbers.
    ;
    wp7=2277
    ;
    ; wp8: Assignment of work processes and port numbers.
    ;
    wp8=2278
    ;
    ; wp9: Assignment of work processes and port numbers.
    ;
    wp9=2279
    ;
    ; wp10: Assignment of work processes and port numbers.
    ;
    wp10=2280
    ;
    ; wp11: Assignment of work processes and port numbers.
    ;
    wp11=2281
    ;
    ; wp12: Assignment of work processes and port numbers.
    ;
    wp12=2282
    ;
    ; wp13: Assignment of work processes and port numbers.
    ;
    wp13=2283
    ;
    ; wp14: Assignment of work processes and port numbers.
    ;
    wp14=2284
    ;
    ; JCP.PORTS: List of semicolon-separated ports or a range of ports to which JCPs will bind. JCPs bind in the order as listed.
    ; Use this setting if you do not want JCPs to automatically bind to random ports.
    ; A range can be specified with a dash (-) in between a starting and an ending port.
    ;
    ;JCP.PORTS=2317
    ;
    ; JWP.SYNC.PORTS: List of semicolon-separated ports or ranges of ports on which JWPs will listen for incoming connections from WPs. JWPs bind in the order as
    listed.
    ; Use this setting if you do not want JWPs to automatically bind to random ports.
    ; A range can be specified with a dash (-) in between a starting and an ending port.
    ;
    ;JWP.SYNC.PORTS=2271-2279

    [DB_SERVICE]
    ;
    ; cp: Address of the AE system's communication process to which the agent should connect.
    ; Allowed formats:
    ; DNS name:port number
    ; TCP/IP address:port number
    ;
    cp=localhost:2217
    ;
    ; name: Name of the database agent that should be used to resolve variables.
    ; The name of the agent computer (host name) is used if nothing has been defined.
    ; The agent name is limited to 32 characters. The following characters are allowed: A-Z, 0-9, $, @, _, -, .
    ; A hyphen ( "-") can be used for the agent name in the configuration file for reasons of compatibility to former Automation Engine versions. Newly created a
    gents must not include hyphens in their names.
    ;
    name=
    ;
    ; tcp/ip: traceflag
    ;
    tcp/ip=0
    ;
    ; initialPackage: Path and name of the file that contains the authentication package.
    ; When it starts, the agent reads this file and stores the information it includes in the file specified in the parameter KeyStore=. The original file is the
    n deleted.
    ;
    initialPackage=
    ;
    ; keyStore: Path and name of the file that contains information about the authentication package (see InitialPackage=).
    ;
    keyStore=KStore.ini
    ;
    ; connect: Time interval in seconds in which the agent attempts to establish connection to the Automation Engines. This affects the connection setup for a re
    start or after a lost connection.
    ;
    connect=60
    ;
    ; retention_time: Number of seconds after which an unused database connection should be terminated.
    ;
    retention_time=60
    ;
    ; retry: Number of connection attempts to the database.
    ;
    ; The number that is specified in this parameter determines how often the agent attempts to connect to the database. After the nth failed attempt, the job en
    ds with status ENDED_NOT_OK.
    ;
    ; The agent continues to connect to the database if this parameter has not been specified in the INI file. The job remains active until the database is avail
    able again or until it is canceled.
    ;
    retry=10
    ;
    ; optimize: Database optimization.
    ; Optimization means, that if you select data with a key, the db-service automatically optimizes the query to a new statement where the given key is part of
    the statement. If the query does not return any data or results in an error, the original query is executed.
    ; 0 - Database optimization off.
    ; 1 - Database optimization on.
    ;
    optimize=1

    [ODBC]
    ;
    ; sqlDriverConnect: Connection String for the database.
    ; General format of the connection string is "OBDCVAR=<cmd>,<odbc-string>"
    ;
    ; <cmd> is an eight figure command field for controlling database accesses like follows
    ; 1. Position = N - Do not use server cursor.
    ; 1. Position = S - Use server cursor (MS SQL Server 2000).
    ; 2. Position = N - Do not reestablish database connection after 1000 commits.
    ; 2. Position = D - Disconnect database after 1000 commits (perhaps due to memory problems).
    ; 3. Position = N - Field names are compared case-sensitively (Oracle).
    ; 3. Position = J - Field names are compared case-insensitively (Oracle).
    ; 4. Position = N - Not used.
    ; 5. Position = N - Type of database connection: ODBC.
    ; 5. Position = I - Type of database connection: OCI/CLI.
    ; 6. Position = N - Database access without User ID.
    ; 6. Position = O - Database access with User ID.
    ; 7. Position = N - Compression is deactivated.
    ; 7. Position = R - Compression is activated.
    ; 8. Position = Type of SQL Syntax; N - MS SQL Server.
    ; 8. Position = Type of SQL Syntax; O - Oracle.
    ; 8. Position = Type of SQL Syntax; D - DB2.
    ; 8. Position = Type of SQL Syntax; P - PostgreSQL.
    ;
    ; <odbc-string> contains standard and vendor related keywords and values
    ; DSN - Alias name of the database connection.
    ; UID - User ID for database access. Note that this parameter is case sensitive.
    ; PWD - Password for database access.
    ; ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes - Microsoft SQL Server with MARS
    ; ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2 - Microsoft SQL Server without MARS
    ; ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 - Oracle
    ; ODBCVAR=NNJNIORP,host=localhost port=5432 dbname=UC4 user=UC4 password=--1037B2E22BF022EBE2 connect_timeout=10 client_encoding=LATIN9 - PostgreSQL
    ;
    SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4QA;UID=uc4;PWD=--1071FC31885EB705723B032448E5B01D57;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO885
    9P15

    [JDBC]
    ;
    ; sqlDriverConnect: The JDBC connection string to connect JAVA based worker processes (JWP) to the database.
    ; jdbc:sqlserver://localhost:1433;databaseName=AUTOMIC - MS SQL Server
    ; jdbc:db2://localhost:50000/AUTOMIC - DB2
    ; jdbc:oracle:thin:@//localhost:1521/AUTOMIC - ORACLE
    ; jdbc:postgresql://localhost:5432/AUTOMIC - PostgreSQL
    ;
    ;sqlDriverConnect=jdbc:sqlserver://localhost:1433;databaseName=AUTOMIC
    SQLDRIVERCONNECT=jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=fmstuc4022)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=UC4DB.fms
    tuc4022.dcrm.fms_sg.de)))

    [JWP]
    ;
    ; allowDbTracing: By default, JWP will ignore the traceflag set for database operations for performance resons. Set this to "0" to explicitly disable db-trac
    ing according to DATABASE traceflag.
    ; 0 - Database operations will never write to tracefile, even when enabled using traceflags.
    ; 1 - Database operations will write to tracefile when and how it is configured in traceflags.
    ;
    ;allowDbTracing=1
    ;
    ; libpath: Semicolon separated list of directories where to look for optional external 3rd party libraries. Configure this with path to CyberArk SDK library
    if you want to enable CyberArk integration.
    ;
    ;libpath=

    [REST]
    ;
    ; host: Hostname where the REST API will be reachable from external. Configure this when using an SSL Termination proxy.
    ;
    ;host=
    ;
    ; port: Port where the REST API will accept HTTP/HTTPS requests
    ;
    port=8088
    ;
    ; sslEnabled: Defines if HTTP or HTTPS will be used
    ; 0 - HTTP will be used
    ; 1 - HTTPS will be used
    ;
    sslEnabled=0
    ;
    ; keystore: Path and file where the keystore for the SSL certificate is stored
    ;
    keystore=./httpsKeyfile
    ;
    ; keystorePassword: Password of the keystore File
    ;
    keystorePassword=changeit
    ;
    ; keyPassword: Password for the Keys protection
    ;
    keyPassword=changeit
    ;
    ; parallelDbConnections: The maximal number of parallel connections to the database so requests can be processed at the same time
    ; 1..99 - Number of parallel connections
    ;
    parallelDbConnections=5
    ;
    ; sessionTimeout: Session timeout in seconds, if a session is not used within this time span the AE user session is closed
    ; 2..2147483648 - seconds (maxvalue 2^31)
    ;
    sessionTimeout=120
    ;
    ; corsSupportEnabled: Enable or disable the Access-Control-Allow-Origin response header configured with CORSACCESSCONTROLALLOWORIGIN, more details: https://d
    eveloper.mozilla.org/en-US/docs/Web/HTTP/CORS.
    ; 0 - CORS requests are not allowed
    ; 1 - CORS requests are allowed
    ;
    corsSupportEnabled=0
    ;
    ; corsAccessControlAllowOrigin: This sets the The Access-Control-Allow-Origin response header which indicates whether the response can be shared with resourc
    es with the given origin. If multiple origins are allowed, they must be separated with char ','. Use char '*' if all origins should be allowed.
    ;
    corsAccessControlAllowOrigin=*
    ;
    ; gzipSupportEnabled: Enable GZIP compression for REST API responses.
    ; 0 - gzip support is disabled
    ; 1 - gzip support is enabled
    ;
    gzipSupportEnabled=0
    ;
    ; minPoolSize: Minimum number of threads waiting for incoming requests, raise this if you expect multiple parallel requests to maximize the response time.
    ;
    minPoolSize=8
    ;
    ; maxPoolSize: Maximum number of threads waiting for incoming requests.
    ;
    maxPoolSize=200
    ;
    ; idleTimeout: Set the maximum idle time for threads in the thread pool. Threads that are idle for longer than this period may be stopped.
    ;
    idleTimeout=60000

    [OBJECTSEARCH]
    ;
    ; index.cache.folder: Path to the folder where the search index wil be stored.
    ;
    index.cache.folder=indexCache
    ;
    ; update.batch.size: Amount of objects that get indexed simultaneously
    ;
    update.batch.size=1000

    [CAPKI]
    ;
    ; certificate: Path to the file where the certificate is stored
    ;
    ;certificate=
    ;
    ; key: Path to the file containing the private key
    ;
    ;key=
    ;
    ; chain: Some certificates may require an intermediate certificate for validation if the signing certificate authority is not trusted directly. The location
    of the intermediate certificate can be set here.
    ;
    ;chain=
    ;
    ; trusted_cert_folder: Path to the trusted certificate files
    ;
    ;trusted_cert_folder=

    Thank you

    ------------------------------
    Shaivi Chauhan
    ------------------------------



  • 7.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 20, 2020 08:40 AM
    @Deactivated User 

    To me it still seems to be an old ucsrv.ini as it shows the definition of WPs. In V12.3 there's no WP definition (except PWP) anymore. Please check that before we proceed. Also check this post: https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=3e1ade31-5ff2-473d-b547-5e96499a5163&CommunityKey=2e1b01c9-f310-4635-829f-aead2f6587c4&tab=digestviewer#bm3e1ade31-5ff2-473d-b547-5e96499a5163

    The screen shot I provided displays the ucsrv.ini from V12.2 and V12.3
    Apart from that, the CP log says:

    20201019/095224.704 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error './libnnz12.so: undefined symbol: slts_runmode'.
    20201019/095224.704 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).

    It seems something is wrong with the DB connection. 

    Cheers
    Christoph

    ------------------------------
    ----------------------------------------------------------------
    Automic AE Consultant and Trainer since 2000
    ----------------------------------------------------------------
    ------------------------------



  • 8.  RE: Getting erorrs while starting the UC4 services after the upgrade from 12.1 to 12.3 on new RHEL 7 server

    Posted Oct 20, 2020 12:08 AM
      |   view attached
    uploading the service manager and cp log

    ------------------------------
    Shaivi Chauhan
    ------------------------------

    Attachment(s)

    zip
    Logs_19_10.zip   48 KB 1 version