Genesys Engage on-premises

 View Only

Discussion Thread View

  • 1.  Interaction Server Starting with Error DOpenServerX failed

    Posted 07-07-2019 08:39
    Hello Community,

    I'm facing an error when starting Interaction Server as shown below. 

    From Interaction Server Logs, I can see the below log error:
    2019-07-07T07:21:07.613 Std 04503 Connected to primary DBServer 'IXN_DBServer' at host 'pureengage2', port 9040
    2019-07-07T07:21:07.614 Std 04503 Connected to IXN_DBServer 'oracle' at host 'pureengage2', port 9040
    2019-07-07T07:21:07.640 Std 04502 Cannot connect to primary DBServer 'IXN_DBServer' at host 'pureengage2', port 9040, reason '[DOpenServerX failed (disconnected)]'

    When testing DB connectivity with isql on my Linux instance, the connection established normally as below
    [root@pureengage2 ~]# isql -v ora
    +---------------------------------------+
    | Connected! | 

    Have anyone faced this error before? I followed all the steps from Genesys docs and everything looks fine !!

    My Development environment include the following 
    Red Hat Enterprise Linux Server release 6.5
    oracle-xe-11.2.0-1.0.x86_64
    unixODBC-2.2.14-12.el6_3.x86_64

    and Genesys components releases are: 
    Interaction Server 8.5.201.05
    DB Server 8.1.302.03
    DAP 8.1.3
    ConfServ 8.5.101.23

    Any advice is highly appreciated.

    Thanks,
    #DigitalChannels

    ------------------------------
    Youssef Atef
    Advanced Technology Solutions Int
    ------------------------------


  • 2.  RE: Interaction Server Starting with Error DOpenServerX failed

    Posted 07-07-2019 09:38
    Have you tried to telnet from the IXN server host to Port 9040 on the host where the dbserver is? You should be able to successfully connect to that port from the IXN Server host.

    Regards,
    Daniel



    Original Message


  • 3.  RE: Interaction Server Starting with Error DOpenServerX failed

    Posted 07-07-2019 09:53
    Hi Daniel,

    Thanks for your reply. Yes, I can telnet port 9040 without any issue. 

    Both IXN DB Server & IXN Server are on the same host.

    Thanks,

    ------------------------------
    Youssef Atef
    Advanced Technology Solutions Int
    ------------------------------

    Original Message


  • 4.  RE: Interaction Server Starting with Error DOpenServerX failed

    Posted 07-08-2019 01:21
    What do the DBServer logs show?

    ------------------------------
    Jason Mclennan
    Commonwealth Bank of Australia
    ------------------------------

    Original Message


  • 5.  RE: Interaction Server Starting with Error DOpenServerX failed

    Posted 07-08-2019 09:55
    Hi Jason,

    Thanks for your reply.

    From DBServer logs, I can see that port 9040 is opened for listening as below
    08:47:16.925 Std 04525 Port 9040 opened for listening

    Then when starting IXN Server, I can see the following logs
    ./dbclient_oracle
    pid = 13293
    id = 1
    expiration_time = 2019-07-08T08:48:49
    client copy = 0
    DbClient name =
    /Statistics
    name = App (Interaction Server,pureengage2,9030)
    req_rcvd = 4
    req_sent = 3
    data_rcvd = 368
    data_send = 60
    invalid_params = 0
    abandoned_req = 0
    abandon_req_fail = 0
    error_start_client = 0
    invalid_register_req = 0
    msg_error = 0
    pending_requests = 0
    pending_queue_size = 0
    max_pending_requests = 0
    max_pending_queue_size = 0
    GServer (0x25ff610) is being removed. numofclients = 0,current numofserveritems = 1
    GServer: new_client: fd=11, found server=10
    08:48:34.164 Trc 04521 New client 54552 connected from '127.0.0.1'
    08:48:34.164 Dbg 10745 'App: 127.0.0.1:54552' registered; protocol version '1.4' id '3'
    08:48:34.164 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 3', request id '0'
    08:48:34.164 Dbg 10750 Start client request, dbprocesses per client '1'
    08:48:34.164 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 3', request id '7'
    08:48:34.165 Std 05022 Process './dbclient_oracle' started
    08:48:34.193 Std 02024 OS signal 'SIGCHLD' received
    08:48:34.193 Std 05024 Process './dbclient_oracle' abnormally terminated, error code 1127
    08:48:34.193 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App (Interaction Server,pureengage2,9030)', request id '-1'
    Listener (port id = internal-0-0 fd = 12) is being closed. Checking for clients on listener...
    Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
    Client App (Interaction Server,pureengage2,9030) is being closed. Current numofclients=1

    It seems to be an issue with Oracle DB Client but I don't know how to trace it ?

    Appreciate your advice

    Thanks

    ------------------------------
    Youssef Atef
    Advanced Technology Solutions Int
    ------------------------------

    Original Message


  • 6.  RE: Interaction Server Starting with Error DOpenServerX failed

    Posted 07-08-2019 17:58
    I'm guessing that maybe your environment variables arent being linked properly.  See the below knowledge article:
    In DB Server logs we see "dbclient_oracle' abnormally terminated" and cannot connect to the database. To over come this we have to stop all the applications running in that host and restart the lca, Only after that the db-servers will start working. 
    • Oracle Database
    • UNIX based OS
    • Cannot connect application to the database
    In the DB Server logs locate the following error messages:

    Std 05022 Process './dbclient_oracle' started
    Std 02024 OS signal 'SIGCHLD' received
    Std 05024 Process './dbclient_oracle' abnormally terminated, error code 1127

    Find out which method the oracle libraries are set for DB Server. This will either be set as environment variable or included in shared library list. Places to look are:
    • /home/<user>/.bash_profile
    • /home/<user>/.bashrc
    • /etc/profile.d/*.sh
    • /etc/ld.so.conf
    • /etc/ld.so.conf.d/*.conf
    • LCA/DB Server start script.
    If the environment variables are already set in bash_profile then likely this is not being sourced or this profile does not match the scenario in which the OS is being used. Interactive vs Non-Interactive shells.
    • Missing required environment variables
    Method 1:

    Include the oracle libraries into the shared library list. For example if libraries are located at :/usr/lib/oracle/11.2/client64/ 

    1) Go to directory /etc/ld.so.conf.d 
    2) Create a file called oracle-11.2-client64.conf
    3) Add the line /usr/lib/oracle/11.2/client64/ 
    4) ln -s libclntsh.so.11.1 libclntsh.so from  /usr/lib/oracle/11.2/client64/  path
    5) Execute ldconfig
    6) Use ldconfig -v to ensure it lists the new library path
    7) Use ldconfig -p to ensure the current cache picked up the path

    Note: This method is independent of shell profiles. Also this method is only a replacement for the environment variable LD_LIBRARY_PATH.

    Method 2:

    Set the environment variable LD_LIBRARY_PATH.

    Option 1: Create shell script in the following place
    • /etc/profile.d/custom-env.sh
    • Inside the shell script set the environment variables as required
    Option 2: Set variables in ~/.bash_profile or ~/.profile

    Note: If DB Server resides on the same host as the DBMS please ensure to have the following set as well:
    • PATH
    • ORACLE_HOME
    • TNS_ADMIN
    • ORACLE_SID (if used)
    • When the LCA application is started it will load all current environment variables that were exported at this time. If the environment variables required for DB Server are not exported at the time of LCA startup but after then the DB Server will encounter the error code 1127. The reason for this is that DB Server is a child process of the parent process LCA and child processes obtain the environment variables of their parent process. This means that DB Server did not see all the required libraries at start up.
    • For further information on how the different profiles are loaded please contact your Unix System Administrator
    • For further requirements on DB Server please review the DB Server User's Manual 8.1 from the Management Framework documentation portal.


    ------------------------------
    Jason Mclennan
    Commonwealth Bank of Australia
    ------------------------------

    Original Message


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources