Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Ansh on December 05, 2008, 02:57:25 PM

Title: Contact Server not connecting to Database
Post by: Ansh on December 05, 2008, 02:57:25 PM

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

Title: Re: Contact Server not connecting to Database
Post by: René on December 05, 2008, 03:33:30 PM

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.

Title: Re: Contact Server not connecting to Database
Post by: Ansh on December 08, 2008, 11:21:31 AM

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

Title: Re: Contact Server not connecting to Database
Post by: cavagnaro on December 08, 2008, 05:52:59 PM

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

Title: Re: Contact Server not connecting to Database
Post by: René on December 08, 2008, 10:39:20 PM

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.

Title: Re: Contact Server not connecting to Database
Post by: Ansh on December 09, 2008, 11:33:31 AM

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.