REporting 6.1 / Can not open ODS and IS ODS db

NICE CXone API & Integrations
1

When Data Sourcer starts we get the following msg:

Cannot Initialize Statistics, because DB Server is not ready.

Waiting For DB Server… Mon Feb 11 16:03:12 2002

Error from DBServer172.31.12.160:4070[508] Database Error:

Error: Cannot Open Database ‘’ on ‘CTIPROD5’

Will attempt to reconnect in 10 seconds

It’s a Windows 2000 Server with Oracle 8.1.7 (we migrate from 8.1.6)

ODS db is installed (CTIPROD5) on that machine.

Data Sourcer is connected to RepDBServer (version 6.1.000.09) through a ODSDAP.

Here is what the log of RepDBServer tells us:

Genesys Client version: 6.1.000.09

DB Common part version: 6.1.000.09

Vendor library version: 7.3.4

Build on ‘winnt’

=02/11/02 14:36:33.400 DBClient Oracle: id=‘0’ appid=‘528’ req=‘1’ Connection to multiserver created, host ‘ROMEO’, port ‘4070’, socket ‘424’

=02/11/02 14:36:33.400 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘1’ msg_id=‘MSG_STARTDB’ status=‘528’

Send message ‘MSG_OPENDB’ to ‘DbClient (1032,540)’, reqid='2’Send message ‘MSG_EXTPACKETS’ to ‘Application (528)’, reqid='0’Send message ‘MSG_EXTPACKET’ to ‘DbClient (1032,540)’, reqid=‘0’+02/11/02 14:36:33.978 DbClient (1032,540) is spare

=02/11/02 14:36:33.978 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘2’ Protocols versions: dbclient=‘00010000’ dbserver=‘00010000’ dblib=‘00010002’

=02/11/02 14:36:33.978 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘2’ OpenDB: username = ‘DATA_SOURCER’, database = ‘’, dbserver = ‘CTIPROD5’

=02/11/02 14:36:33.978 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘2’ Action ‘OpenDB’ failure:

=02/11/02 14:36:33.978 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘2’ OpenDB failure

=02/11/02 14:36:33.978 DBClient Oracle: id=‘1032’ appid=‘528’ req=‘2’ msg_id=‘MSG_ERROR’ status=‘30’ msg=’

If I use another DBServer (version 6.1.000.08) running on another machine where Oracle 8.1.6 is installed, Data Sourcer is able to connect to the CTIPROD5 db located on the other server (Oracle 8.1.7).

Any help will be appreciated.

Thanks

2

Ova,

try this simple one first:

can you access that DB using SQLPLUS from the machine that gives you that error?

just try sqlplus DATA_SOURCER/<password_here>@CTIPROD5

If not, then you just need to set up an alias on that machine (tnsnames.ora) under $ORACLE_HOME/network/admin

Tell me if it worked!

3

Hi Jeff,

I already check this and yes, I can connect to CTIPROD5 using SQLPlus from the server where CTIPROD5 and the RepDBServer are located.

Previously it was working… with Oracle 8.1.6 and DBServer 6.1.000.8! Then as recommended by Genesys I ask the DB Team to upgrade Oracle to 8.1.7. I also received the new version of Framework (6.1.0005.02) so I decided to install DBServer 6.1.000.9 instead of 6.1.000.8.

Any idea?

Thanks

4

Hi, Olivier, without trying a billion different things, you say that if you try to conect to the same DB from a different machine running 8.1.6 it is fine, right?

Have you tried running the same version of db server on W2K as the one you used on a different machine? What about checking dbserver.conf? Are they identical? I thought W2K+G6.1+Oracle 8.1.7 is not supported by Genesys… Was W2K supported ?

Vic

5

Hi Vic,

Here is the summary of the tests I performed so far…

If DataSourcer (installed on server2, version 6.1.012.02) tries to access CTIPROD5 (server2, Oracle 8.1.7) via the DBSERVER(server2, 6.1.009) it fails: OpenDb failure.

If DataSourcer (installed on server2, version 6.1.012.02) tries to access CTIPROD5 (server2, Oracle 8.1.7) via the DBSERVER(server2, version 6.1.008) it fails: OpenDb failure.

If DataSourcer (installed on server2, version 6.1.012.02) tries to access CTIPROD5 (server2, Oracle 8.1.7) via the DBSERVER(server1, version 6.1.008) it works.

The last test I can do is to let DataSourcer (installed on server2, version 6.1.012.02) try to access CTIPROD5(server2, Oracle 8.1.7) via the DBSERVER(server1, version 6.1.009).

BUT as on server1 everything runs fine I don’t want to upgrade DBServer to 6.1.009 to perform this test.

Cheers,

Olivier

6

Olivier,

thank you for all the testing info. I looks like :

  1. your environment settings are wrong

  2. you dbserver.conf settings are wrong

  3. I have no clue

Can you please post dbserver.conf, and environment (env) definitions from the machine that has the problems?

What did Genesys support say?

Vic

7

Hello Vic,

Genesys Support have tested the same setup on their install and they are getting the same OpenDB failures. They’ve sent the ticket to the US for further recommendations. Wait and see…

8

Interesting!

I was playing with DS in Windows 2000 configuration with Oracle 8.1.6 on UNIX and we did not have any problems.

Does it mean that we should not bundle DS and Oracle 8.1.7 on the same machine?