OCM hangs while retrieving call list…
Sample DBServer Log:
DBClient Oracle, Copyright (c) 1997-2006 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 7.2.000.03
DB Common part version: 7.2.000.03
Vendor supported versions: Oracle 8i, 9i
Build on ‘powerpc-aix4.3.2.0’
Oracle: id=‘6.1’ req=‘-1’ Connection to multiserver created, host ‘aixctidb01’, port ‘42943’, socket ‘4’
+0028 MSG_STARTDB status=‘6’
Oracle: id=‘6.1’ req=‘3’ Protocols versions: dbclient=‘00010003’ dbserver=‘00010003’ dblib=‘00010002’
+0000 Open DB: username = ‘cticall’, database = ‘CTIP’, dbserver = ‘CTIP’
+0151 MSG_DBOPENED status=‘DBM_SUCCESS’ msg=‘Open DB success’
10:49:43.979 Dbg 10743 ‘Oracle: 6.1’ is spare
10:49:43.979 Dbg 10739 Oracle: id=‘6.1’ req=‘0’ Chmode to extended packet on sock 4
10:49:43.982 Dbg 10741 ‘App: 6’ has put request id=‘4’ into queue
10:49:43.982 Dbg 10737 Forwarding request ‘4’ from ‘App: 6’ to ‘Oracle: 6.1’
10:49:43.982 Dbg 10743 ‘Oracle: 6.1’ is spare
10:49:44.022 Dbg 10749 Forwarding response ‘4.1’ from ‘Oracle: 6.1’ to ‘App: 6’
10:49:44.022 Dbg 10749 Forwarding response ‘4.2’ from ‘Oracle: 6.1’ to ‘App: 6’
10:49:44.022 Dbg 10739 Oracle: id=‘6.1’ req=‘4’ SQL: SELECT count(*) FROM user_views WHERE view_name=‘TEST_PROD’
+0039 Executed SQL statement ‘SELECT’, start retrieve records…
+0039 MSG_RETRIEVED2 status=‘DBM_SUCCESS’
+0039 MSG_RETRIEVED status=‘DBM_NOMORE’
10:49:44.174 Dbg 10741 ‘App: 6’ has put request id=‘5’ into queue
10:49:44.174 Dbg 10737 Forwarding request ‘5’ from ‘App: 6’ to ‘Oracle: 6.1’
10:49:44.174 Dbg 10743 ‘Oracle: 6.1’ is spare
10:49:44.204 Dbg 10749 Forwarding response ‘5.1’ from ‘Oracle: 6.1’ to ‘App: 6’
10:49:44.204 Dbg 10749 Forwarding response ‘5.2’ from ‘Oracle: 6.1’ to ‘App: 6’
10:49:44.204 Dbg 10739 Oracle: id=‘6.1’ req=‘5’ SQL: SELECT count(*) FROM user_tables WHERE table_name=‘TEST_PROD’
+0027 Executed SQL statement ‘SELECT’, start retrieve records…
+0030 MSG_RETRIEVED2 status=‘DBM_SUCCESS’
+0030 MSG_RETRIEVED status=‘DBM_NOMORE’
10:49:47.902 Dbg 10741 ‘App: 6’ has put request id=‘6’ into queue
10:49:47.902 Dbg 10737 Forwarding request ‘6’ from ‘App: 6’ to ‘Oracle: 6.1’
10:49:47.902 Dbg 10743 ‘Oracle: 6.1’ is spare
10:49:48.060 Dbg 10749 Forwarding response ‘6.1’ from ‘Oracle: 6.1’ to ‘App: 6’
10:49:48.060 Dbg 10739 Oracle: id=‘6.1’ req=‘6’ SQL: CREATE TABLE Test_Prod(record_id INTEGER NOT NULL UNIQUE,phone VARCHAR2(64) NOT NULL,phone_type INTEGER NOT NULL,record_type INTEGER NOT NULL,record_status INTEGER NOT NULL,call_result INTEGER NULL,attempt INTEGER NOT NULL,dial_sched_time INTEGER NULL,call_time INTEGER NULL,daily_from INTEGER NOT NULL,daily_till INTEGER NOT NULL,tz_dbid INTEGER NOT NULL,campaign_id INTEGER NULL,agent_id VARCHAR2(32) NULL,chain_id INTEGER NOT NULL,chain_n INTEGER NOT NULL,treatments VARCHAR2(255) NULL,CoCode VARC …
+0158 MSG_SQLEXECUTED status=‘DBM_SUCCESS’
10:49:48.062 Dbg 10741 ‘App: 6’ has put request id=‘7’ into queue
10:49:48.062 Dbg 10737 Forwarding request ‘7’ from ‘App: 6’ to ‘Oracle: 6.1’
10:49:48.062 Dbg 10743 ‘Oracle: 6.1’ is spare
10:49:53.076 Std 05023 Process ‘dbclient_oracle’ stopped <<<<<<<<<<<< this should not have occured
/dbclient_oracle
pid = 1868008
id = 4
expiration_time = 2009-08-06T10:49:52
client copy = 0