DB server is disconnected from the database

Hi all,

I hope this issue isn’t out of scope ???

I am facing a problem connecting to Icon DB

log DB server
"
+0000 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver…
+0000 odbcerr: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
+0000 MSG_ERROR status=‘dbNotOpened’ msg='[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ’
"
Log ICON
" Std 04502 Cannot connect to CFG ‘DBServer_icon’ at host ‘S00STE024’, port 1436, reason ‘DB server is disconnected from the database’"

the interaction concentrator version is 8.1.514.56 on Windows Server 2019 and DB MS SQL Server 2016

I tried with ODBC Driver 11 for SQL Server and ODBC Driver 13 for SQL , the error message is the same on DBServer

I tested the connexion with ODBC Data Source Administator and the connexion was succesful with both version of drivers

What did i miss ?

Br

Try to connect from Windows ODBC settings, it is good to discard connectivity/configuration issues

Hi,

It’s working from Windows ODBC settings , I created DSN and tested the connexion

Br,

Can you post DAP and full DBServer log?

hi,
this is dbserver log

Genesys Database Server, Version:‘8.5.100.12’
Copyright (c) 1997-2021 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 8.5.100.87 C2
Loglib: 8.5.100.56
Gmessagelib: 8.5.100.25
GServicelib: 8.5.100.42
Mngmlib: 8.5.100.10
Confservlib: 8.5.100.45
Lcalib: 8.5.100.38
Build platform: i686-winnt-vs12-64
Application name: DBServer_icon
Application type: RealDBServer (46)
Command line: multiserver.exe -service DBServer64 -app DBServer_icon -host S00STE001 -port 2020 -sstart
Host name: MYHOST
DST: TZ = 1, timeb = 1
Time zone: -3600, Romance Standard Time, Romance Daylight Time
UTC time: 2022-04-22T09:08:28.662
Local time: 2022-04-22T11:08:28.662
Start time (UTC): 2022-04-22T09:08:28
Running time: 0:00:00:00
Host info: Windows Server 2019 Standard (17763.rs5_release.180914-1434.2803)
File: (1) C:\GCTI\Logs\DBServer_icon\DBServer_icon.20220422_110828_663.log

11:08:28.662 Trc 04112 The Log Output of type ‘C:\GCTI\Logs\DBServer_icon\DBServer_icon’ has been created and opened
11:08:28.662 Trc 04110 Option ‘verbose’ has been set to the value ‘all’
11:08:28.662 Trc 04110 Option ‘buffering’ has been set to the value ‘yes’
11:08:28.662 Trc 04110 Option ‘expire’ has been set to the value ‘5 file’
11:08:28.662 Trc 04110 Option ‘segment’ has been set to the value ‘2000’
11:08:28.662 Trc 04110 Option ‘spool’ has been set to the value ‘’
11:08:28.662 Trc 04110 Option ‘snapshot’ has been set to the value ‘’
11:08:28.662 Trc 04110 Option ‘recovery-timeout’ has been set to the value ‘30’
11:08:28.662 Trc 04110 Option ‘keep-startup-file’ has been set to the value ‘no’
11:08:28.662 Trc 04110 Option ‘MessageFile’ has been set to the value ‘RealDBServer.lms’
11:08:28.662 Trc 04110 Option ‘time-format’ has been set to the value ‘time’
11:08:28.662 Trc 04110 Option ‘time-convert’ has been set to the value ‘local’
11:08:28.662 Trc 04110 Option ‘message-format’ has been set to the value ‘short’
11:08:28.662 Trc 04110 Option ‘memory-storage-size’ has been set to the value ‘2 Mb’
11:08:28.662 Trc 04110 Option ‘compatible-output-priority’ has been set to the value ‘no’
11:08:28.662 Trc 04110 Option ‘print-attributes’ has been set to the value ‘no’
11:08:28.662 Trc 04110 Option ‘check-point’ has been set to the value ‘1’
11:08:28.662 Trc 04110 Option ‘memory’ has been set to the value ‘’
11:08:28.662 Trc 04113 The Log Output of type ‘stderr’ has been closed and deleted
11:08:28.662 Trc 04112 The Log Output of type ‘C:\GCTI\Logs\DBServer_icon\DBServer_icon’ has been created and opened
11:08:28.662 Trc 06084 Configuration option set: ‘dbserver’:‘management-port’ = ‘4041’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocesses_per_client’ = ‘1’
11:08:28.662 Trc 06084 Configuration option set: ‘dbserver’:‘dbprocess_name’ = ‘./dbclient_sybase’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘oracle_name’ = ‘./dbclient_oracle’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘informix_name’ = ‘./dbclient_informix’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘msql_name’ = ‘./dbclient_msql’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘sybase_name’ = ‘./dbclient_sybase’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘postgre_name’ = ‘./dbclient_postgre’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘connect_break_time’ = ‘1200’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘tran_batch_mode’ = ‘0’
11:08:28.662 Trc 06085 Configuration option set to default value: ‘dbserver’:‘db2_name’ = ‘./dbclient_db2’
Open LCALayer on port=4999
LCA Library version 8.5.100.38
11:08:28.662 Std 05060 Application started
Opening listeners…

Port id ‘default’:
Open server port: = (
“protocol” = “addp”
“addp-timeout” = “0”
“addp-remote-timeout” = “0”
“addp-trace” = “off”
“name” = “DBServer_icon”
“server-type” = “46”
“backlog” = “5”
“port” = “1436”
)
11:08:29.687 Std 04525 Port 1436 opened for listening
Updating primary/backup config server info 99 0
Primary config server (dbid)(host)(port): (99)(S00STE001)(2020)
Error while retrieving backup config server info.


LCALayer: REventRegistered on LCA…


LCALayer: The local host is under control of Management Layer. SCS ‘SCS’ has connected to the LCA from the host ‘’ on the socket 888.
GServer: new_client: fd=600, found server=596
11:08:43.151 Trc 04521 New client 54141 connected from ‘192.168.103.99’
11:08:43.167 Dbg 10745 ‘App: 192.168.103.99:54141’ registered; protocol version ‘1.4’ id ‘1’
11:08:43.167 Dbg 10734 Send message ‘MSG_EXTPACKETS’ to ‘App: 1’, request id ‘0’
11:08:43.167 Dbg 10750 Start client request, dbprocesses per client ‘1’
11:08:43.167 Dbg 10734 Send message ‘MSG_CLIENTSTARTED’ to ‘App: 1’, request id ‘2’
11:08:43.214 Std 05022 Process ‘./dbclient_msql’ started
GServer: new_client: fd=624, found server=608
11:08:43.245 Trc 04521 New client 54143 connected from ‘127.0.0.1’
11:08:43.245 Dbg 10745 ‘./dbclient_msql’ registered; protocol version ‘1.4’ id ‘1.1’
11:08:43.245 Dbg 10734 Send message ‘MSG_OPENDB’ to ‘MS SQL: 1.1’, request id ‘3’
11:08:43.245 Dbg 10734 Send message ‘MSG_EXTPACKETS’ to ‘App (ICON_CFG,MYHOST,4030)’, request id ‘0’
11:08:43.245 Dbg 10734 Send message ‘MSG_EXTPACKET’ to ‘MS SQL: 1.1’, request id ‘0’
11:08:43.245 Dbg 10743 ‘MS SQL: 1.1’ is spare
11:08:43.573 Dbg 10739 ODBC: id=‘1.1’ req=‘-1’
DBClient ODBC, Copyright (c) 1997-2021 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 8.5.101.44
DB Common part version: 8.5.101.44
Vendor supported versions: “ODBC”
Process ID: 2996
Build on ‘i686-winnt-vs12-64’
+0015 Connection to multiserver created, host ‘localhost’, port ‘54142’, socket ‘248’
+0015 MSG_STARTDB status=‘DBM_SUCCESS’
ODBC: id=‘1.1’ req=‘3’ Protocols versions: dbclient=‘00010004’ dbserver=‘00010004’ dblib=‘00010004’
+0000 Database Access Point in TKVList:
+0000 section “default”:
+0000 “dbengine” = “mssql”
+0000 “dbserver” = “DBHOST\SQL014”
+0000 “dbname” = “IDBCFG”
+0000 “username” = “genesys”
+0000 “password” = “***”
+0000 “dbcase” = “any”
+0000 “db-request-timeout” = “10”
+0000 section “dbclient”:
+0000 “utf8-ucs2” = “true”
+0000 “max-binding-memory” = 250
+0000 0000023F52989640,hDBC=1388669328,1388669328
+0000 Open DB: username = ‘genesys’, database = ‘IDBCFG’, dbserver = ‘DBHOST\SQL014’
+0235 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver…
+0328 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+0328 MSG_ERROR status=‘dbNotOpened’ msg='[Microsoft][ODBC SQL Server Driver]Dialog failed ’

11:08:43.573 Dbg 10749 Forwarding response ‘3.1’ from ‘MS SQL: 1.1’ to ‘App (ICON_CFG,MYHOST,4030)’
11:08:43.573 Dbg 10734 Send message ‘MSG_DISCONNECTED’ to ‘App (ICON_CFG,MYHOST,4030)’, request id ‘-1’
11:08:43.573 Dbg 10734 Send message ‘MSG_DISCONNECTED’ to ‘MS SQL: 1.1’, request id ‘-1’
/Statistics
name = MS SQL: 1.1
app_name = App (ICON_CFG,MYHOST,4030)
req_rcvd = 5
req_sent = 3
data_rcvd = 1620
data_sent = 386
msg_error = 1
msg_log = 1
Client MS SQL: 1.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 608) 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 (ICON_CFG,MYHOST,4030) is being closed. Current numofclients=1

br,

It seems your MS ODBC Driver configuration is not valid - try to check connectivity via ODBC apart Genesys apps

Hi Kubig
Thank you for the rely

I tested with ODBC Data Administrator and the connexion was suucesful.

I don’t understand this ==> Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver…

In my System DNS i specified ODBC driver 17 for SQL Server

Br,

Looks like you are using a SQL server instance: dbserver = 'DBHOST\SQL014
Try to modify your DAP, and add ', in the end of option DBMS Name

In you case dbserver = 'DBHOST\SQL014,1433

Or the port you actually are using!

:frowning:
+0000 Open DB: username = ‘genesys’, database = ‘DBCFG’, dbserver = ‘DBHOST\SQL014,1436’
+0062 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver…
+0078 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+0078 MSG_ERROR status=‘dbNotOpened’ msg='[Microsoft][ODBC SQL Server Driver]Dialog failed ’

Is the firewall OK for that port?
Post please you DAP conf

I tested 3 configuration
DBHOST\SQL014,1436
DBHOST\SQL014
DBHOST,1436

We have 2 db on server DBHOST one on 1433 , 1436

I think that the problem is that I am using the database password and not the password of the schema DBCFG.

I will test this later when our DBA send the password ::slight_smile: ::slight_smile:

Also check the bit version of running apps and installed/configured ODBC

and on which one is your ICON DB created?

As per your password comment…you already tested ODBC so wouldn’t make sense that you are using a new user/password

That is why I am asking your DAP conf, please help us help you by providing info as requested :wink:

It’s working with this configuration
DBMS = DBHOST\SQL014
My DBA send me the right passeword

My test was successful because there was 2 db on the same serveur. and the login was the same.

When I tested connectivity with ODBC data source administrator, I idid’nt change the option “change the default database”.