Contact Server not connecting to Database

NICE CXone API & Integrations
1

Hi!!

When i start my Contact server service, it starts and stops. Following is the error i am getting in the Log file:::::

12/05/08 20:13:39.859 Standard gcti1 RK_CS_PRIM_PROD GCTI-63-55109 Server initialized successfully…

LCALayer: REventRegistered on LCA…

12/05/08 20:13:39.859 Trace gcti1 RK_CS_PRIM_PROD GCTI-63-20205 Initializing database connection…
12/05/08 20:13:40.874 Standard gcti1 RK_CS_PRIM_PROD GCTI-63-20304 Failed to initialize database: Genesys.icc.servers._contact_server._database_request_processor_exception: initialization: com.inet.tds.SQLException: Connection refused: connect
12/05/08 20:13:40.874 Standard gcti1 RK_CS_PRIM_PROD GCTI-63-55206 Shutting down server…
12/05/08 20:13:40.874 Trace gcti1 RK_CS_PRIM_PROD GCTI-63-55207 Shutting down connection manager…

Please help me out with this…i have configured all batch files, configuration file and CME application according to genesys recommendation but still not able to get this up.

Thanks,
Ansh

2

Hi Ansh,

The logs says Contact Server can’t connect to database as the connection was refused. Check following:

  • Universal Contact Server (UCS) has connection to right DAP (see Multimedia Deployment Guide for details)
  • DAP for UCS has to be JDBC-enabled
  • It is possible to connect to SQL Server from host where UCS is running

Log - increase log level to “debug” to get more detailed information about the error

R.

3

Thanks for suggestions R. I enabled JDBC connection and all other things are fine. But it is still not connecting and shows same error.

I already have log level set to all, which included debug as well.
Please Advice me on this.

Thanks,
Ansh

1 Like
4

Can you ping your SQL server? Can you telnet to the SQL Server port?

2 Likes
5

Ansh,

Please check following

  • DAP configuration
    • no DBServer is selected on “General” tab
    • host where your SQL Server is running and port of your SQL Server are specified on “Server Info” tab
  • connection to SQL Server is possible - use ping and/or telnet as suggested by Cavagnaro

What version of UCS and SQL Server do you have?

R.

1 Like
6

You guys are awesome. Thanks a lot R. and cavagnaro.

The port was not listening and i made it to listen and now all is up.

Thanks again for the help.