We have installed Genesys 6.1 software (not using CPD) on PBX Avaya G3. We use Oracle 8.1.7 database for all Genesys DBservers. We have tried also with MSSQL but we face the same problem.
The problem is that outbound campaign is not calling to the numbers specified in call list (in fact it is not calling at all). The outbound campaign is loaded in Progressive (we have tried all modes) mode and we can see from OCS log that we have ready agents:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1.
Outbound DBServer log shows that we are getting disconnected from Oracle
“004523 Connection to client Oracle: 21.1 closed, reason client disconnected”
and then new connection is established so maybe it could be a hint.
For details please see below in pieces of OCS and Outbound DBServer logs.
Outbound DB server log:
04/25/02 12:31:04.156 Dbc Oracle: id=‘21.1’ req=‘204’ SQL: CREATE OR REPLACE PROCEDURE sp110106 …
+0094 MSG_SQLEXECUTED status=‘DBM_SUCCESS’
04/25/02 12:31:04.406 Debug ctptwpl1 DBServer_Out GCTI4610743 ‘Oracle: 21.1’ is spare
04/25/02 12:31:04.406 Debug ctptwpl1 DBServer_Out GCTI4610749 Forwarding request ‘205.1’ from ‘Oracle: 21.1’ to ‘App: 21’
04/25/02 12:31:04.250 Dbc Oracle: id=‘21.1’ req=‘205’ MSG_COMMITED status=‘DBM_SUCCESS’ text=‘COMMIT TRANSACTION’
04/25/02 12:31:04.453 Debug ctptwpl1 DBServer_Out GCTI4610741 ‘App: 21’ has put request id=‘206’ into queue
04/25/02 12:31:04.453 Debug ctptwpl1 DBServer_Out GCTI4610737 Forwarding request ‘206’ from ‘App: 21’ to ‘Oracle: 21.1’
04/25/02 12:31:04.453 Debug ctptwpl1 DBServer_Out GCTI4610741 ‘App: 21’ has put request id=‘207’ into queue
04/25/02 12:31:04.453 Debug ctptwpl1 DBServer_Out GCTI4610743 ‘Oracle: 21.1’ is spare
04/25/02 12:31:04.453 Debug ctptwpl1 DBServer_Out GCTI4610737 Forwarding request ‘207’ from ‘App: 21’ to ‘Oracle: 21.1’
04/25/02 12:31:04.468 Debug ctptwpl1 DBServer_Out GCTI4610749 Forwarding request ‘206.1’ from ‘Oracle: 21.1’ to ‘App: 21’
04/25/02 12:31:04.453 Dbc Oracle: id=‘21.1’ req=‘206’ SQL: DELETE ReadyRecord WHERE camp_dbid = 110 AND group_dbid = 104 AND list_dbid = 106
+0000 MSG_SQLEXECUTED status=‘DBM_SUCCESS’
04/25/02 12:31:04.640 Debug ctptwpl1 DBServer_Out GCTI4610743 ‘Oracle: 21.1’ is spare
04/25/02 12:31:12.906 Standard ctptwpl1 DBServer_Out GCTI04523 Connection to client Oracle: 21.1 closed, reason client disconnected
04/25/02 12:31:12.906 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_DISCONNECTED’ to ‘App: 21’, request id ‘1’
/Statistics
name = Oracle: 21.1
app_name = App: 21
req_rcvd = 149
req_sent = 49
data_rcvd = 12156
data_sent = 8915
msg_error = 0
msg_log = 48
04/25/02 12:31:12.921 Trace ctptwpl1 DBServer_Out GCTI04521 New client 4719 connected from 10.214.6.65
04/25/02 12:31:12.921 Debug ctptwpl1 DBServer_Out GCTI4610745 ‘App: 10.214.6.65:4719’ registered; protocol version ‘1.0’ id ‘22’
04/25/02 12:31:12.921 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_EXTPACKETS’ to ‘App: 22’, request id ‘0’
04/25/02 12:31:12.937 Debug ctptwpl1 DBServer_Out GCTI4610750 Start client request, dbprocesses per client '1
04/25/02 12:31:12.937 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_CLIENTSTARTED’ to ‘App: 22’, request id ‘208’
04/25/02 12:31:12.953 Standard ctptwpl1 DBServer_Out GCTI05022 Process dbclient_oracle started
04/25/02 12:31:12.984 Standard ctptwpl1 DBServer_Out GCTI05023 Process dbclient_oracle stopped
/dbclient_oracle
pid = 3388
id = 59
expiration_time = 2002425T12:31:42
client copy = 0
04/25/02 12:31:13.031 Trace ctptwpl1 DBServer_Out GCTI04521 New client 4721 connected from 10.214.6.65
04/25/02 12:31:13.062 Debug ctptwpl1 DBServer_Out GCTI4610745 ‘dbclient_oracle’ registered; protocol version ‘1.2’ id ‘22.1’
04/25/02 12:31:13.062 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_OPENDB’ to ‘Oracle: 22.1’, request id ‘209’
04/25/02 12:31:13.062 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_EXTPACKETS’ to ‘App: 22’, request id ‘0’
04/25/02 12:31:13.062 Debug ctptwpl1 DBServer_Out GCTI4610734 Send message ‘MSG_EXTPACKET’ to ‘Oracle: 22.1’, request id ‘0’
04/25/02 12:31:13.078 Debug ctptwpl1 DBServer_Out GCTI4610743 ‘Oracle: 22.1’ is spare
04/25/02 12:31:13.343 Debug ctptwpl1 DBServer_Out GCTI4610749 Forwarding request ‘209.1’ from ‘Oracle: 22.1’ to ‘App: 22’
04/25/02 12:31:12.953 Dbc Oracle: id=‘22.1’ req=‘1’
DBClient Oracle, Copyright (c) 19972002 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 6.5.000.08
DB Common part version: 6.5.000.08
Vendor supported versions: Oracle 7.3.x, 8i, 9i
Build on ‘winnt’
OCS server log:
CM_DBCampaign DBID: 110, Status: CMS_ACTIVE … Active
request to 1000002 message RequestDistributeUserEvent
AttributeUserData [322] 00 0D 01 00..
'GSW_STAT_EVENT' 1
'GSW_CAMPAIGN_DBID' 110
'GSW_CALL_LIST_DBID' 0
'GSW_GROUP_DBID' 104
'GSW_AGENT_DBID' 0
'GSW_CALL_RESULT' 0
'GSW_CAMPAIGN_COMPLETE' 0
'GSW_LIST_COMPLETE' 0
'GSW_PORTS' 0
'GSW_DIAL_MODE' 2
'GSW_APLICATION_ID' 174
'GSW_CALLBACK_TYPE' 0
'GSW_SCHED_REC_NUM' 0
AttributeCommunicationDN 'COMDN'
04/25/02 12:31:01.906 Trace localhost OCServer GCTI1231008 Call Manager Client registered: Dialer DBID 0
04/25/02 12:31:01.921 Trace localhost OCServer GCTI1231010 Desktop Call Manager Client registered: Group DBID 104
04/25/02 12:31:01.921 Trace localhost OCServer GCTI1250087 New CMSWGroup for group with DBID = 104 was created
GroupCampaign Message. Loading a campaign.
acdGroupDBID: 104. acdGroupName: POLAND. CampaignDBID: 104. CampaignName: Campaign3.
dialerState: 0. switchState: 0. campGroupState: 4.
dialMode: 2. optMethod: 1. optimizeGoal: 80.
gcIsActive: 2. isRecordFlag: 1. isSysReadyFlag: 1.
isPortFlag: 1. isAgentFlag: 1.
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 1 Status: 2
: DBEvent: 48 RequestID: 0 Status: 1 Class: 0 Server: 0 DBClient: 1
: NO pRecord
CM_DBRequest Type:1 Server:0
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 1 Status: 2
: DBEvent: 39 RequestID: 159 Status: 1 Class: 0 Server: 0 DBClient: 1
: NO pRecord
received from fd=552 message EventACK
AttributeUserEvent RequestDistributeUserEvent
AttributeThisDN 'COMDN'
AttributeTimeinSecs 1019730588
AttributeTimeinuSecs 453000
AttributeCustomerID 'Resources'
04/25/02 12:31:02.000 Trace localhost OCServer GCTI1250002 TEvent: Unknown TEvent
04/25/02 12:31:02.000 Trace localhost OCServer GCTI1250017 Default TEvent processing
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 1 Status: 2
: DBEvent: 48 RequestID: 0 Status: 1 Class: 0 Server: 0 DBClient: 1
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 1 Status: 2
: DBEvent: 27 RequestID: 160 Status: 1 Class: 0 Server: 0 DBClient: 59
: NO pRecord
CM_DBCallList :: MSG_DBOPENED Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 1 Status: 2
CM_DBCallList :: CheckCallListTable Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2
CM_DBRequest Type:4 Server:0
:SELECT RequestID: 161 :select count(*) as ISEXISTS from user_tables where table_name = 'OCCALLLIST2' NumRecords:1
Connected to server 'DAP_Out' on socket '568'
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 24
: DBEvent: 30 RequestID: 161 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘OCCALLLIST2’
: ISEXISTS = 1
CM_DBRequest Type:4 Server:0
:SELECT RequestID: 162 :select count(*) as ISEXISTS from user_tables where table_name = 'READYRECORD' NumRecords:1
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 10
: DBEvent: 30 RequestID: 161 Status: 99 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘OCCALLLIST2’
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 10
: DBEvent: 30 RequestID: 162 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘READYRECORD’
: ISEXISTS = 1
CM_DBRequest Type:4 Server:0
:SELECT RequestID: 163 :select count(*) as ISEXISTS from user_tables where table_name = 'TIMEZONES' NumRecords:1
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 9
: DBEvent: 30 RequestID: 162 Status: 99 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘READYRECORD’
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 9
: DBEvent: 30 RequestID: 163 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘TIMEZONES’
: ISEXISTS = 1
CM_DBCallList :: UpdateTimezones Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2
CM_DBRequest Type:6 Server:0
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 165 :delete from TimeZones where CampaignDBID=110
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 166 :insert into TimeZones (DBID,Offset,CampaignDBID) values (109,19800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 167 :insert into TimeZones (DBID,Offset,CampaignDBID) values (110,21600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 168 :insert into TimeZones (DBID,Offset,CampaignDBID) values (111,25200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 169 :insert into TimeZones (DBID,Offset,CampaignDBID) values (112,28800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 170 :insert into TimeZones (DBID,Offset,CampaignDBID) values (114,32400,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 171 :insert into TimeZones (DBID,Offset,CampaignDBID) values (113,32400,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 172 :insert into TimeZones (DBID,Offset,CampaignDBID) values (117,39600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 173 :insert into TimeZones (DBID,Offset,CampaignDBID) values (116,36000,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 174 :insert into TimeZones (DBID,Offset,CampaignDBID) values (115,34200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 175 :insert into TimeZones (DBID,Offset,CampaignDBID) values (119,39600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 176 :insert into TimeZones (DBID,Offset,CampaignDBID) values (118,43200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 177 :insert into TimeZones (DBID,Offset,CampaignDBID) values (121,32400,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 178 :insert into TimeZones (DBID,Offset,CampaignDBID) values (120,36000,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 179 :insert into TimeZones (DBID,Offset,CampaignDBID) values (123,25200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 180 :insert into TimeZones (DBID,Offset,CampaignDBID) values (122,28800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 181 :insert into TimeZones (DBID,Offset,CampaignDBID) values (126,18000,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 182 :insert into TimeZones (DBID,Offset,CampaignDBID) values (125,21600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 183 :insert into TimeZones (DBID,Offset,CampaignDBID) values (124,25200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 184 :insert into TimeZones (DBID,Offset,CampaignDBID) values (128,14400,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 185 :insert into TimeZones (DBID,Offset,CampaignDBID) values (127,18000,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 186 :insert into TimeZones (DBID,Offset,CampaignDBID) values (130,10800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 187 :insert into TimeZones (DBID,Offset,CampaignDBID) values (129,12600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 188 :insert into TimeZones (DBID,Offset,CampaignDBID) values (132,3600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 189 :insert into TimeZones (DBID,Offset,CampaignDBID) values (131,10800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 190 :insert into TimeZones (DBID,Offset,CampaignDBID) values (101,0,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 191 :insert into TimeZones (DBID,Offset,CampaignDBID) values (102,3600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 192 :insert into TimeZones (DBID,Offset,CampaignDBID) values (103,7200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 193 :insert into TimeZones (DBID,Offset,CampaignDBID) values (104,7200,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 194 :insert into TimeZones (DBID,Offset,CampaignDBID) values (105,10800,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 195 :insert into TimeZones (DBID,Offset,CampaignDBID) values (106,12600,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 196 :insert into TimeZones (DBID,Offset,CampaignDBID) values (107,14400,110)
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 197 :insert into TimeZones (DBID,Offset,CampaignDBID) values (108,18000,110)
CM_DBRequest Type:7 Server:0
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 30 RequestID: 163 Status: 99 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘TIMEZONES’
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 40 RequestID: 164 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:BEGIN TRANSACTION
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 165 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:delete from TimeZones where CampaignDBID=110
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 166 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (109,19800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 167 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (110,21600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 168 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (111,25200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 169 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (112,28800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 170 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (114,32400,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 171 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (113,32400,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 172 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (117,39600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 173 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (116,36000,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 174 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (115,34200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 175 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (119,39600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 176 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (118,43200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 177 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (121,32400,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 178 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (120,36000,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 179 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (123,25200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 180 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (122,28800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 181 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (126,18000,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 182 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (125,21600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 183 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (124,25200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 184 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (128,14400,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 185 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (127,18000,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 186 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (130,10800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 187 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (129,12600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 188 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (132,3600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 189 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (131,10800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 190 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (101,0,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 191 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (102,3600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 192 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (103,7200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 193 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (104,7200,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 194 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (105,10800,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 195 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (106,12600,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 196 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (107,14400,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 29 RequestID: 197 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:insert into TimeZones (DBID,Offset,CampaignDBID) values (108,18000,110)
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 13
: DBEvent: 21 RequestID: 198 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:COMMIT TRANSACTION
: NO pRecord
CM_DBRequest Type:4 Server:0
:SELECT RequestID: 199 :select count(*) as ISEXISTS from user_tables where table_name = 'MAXLISTID' NumRecords:1
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 16
: DBEvent: 30 RequestID: 199 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘MAXLISTID’
: ISEXISTS = 1
CM_DBRequest Type:6 Server:0
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 201 :CREATE OR REPLACE PROCEDURE sm110106
(p_ChainID NUMBER, p_ChainN NUMBER, p_InsRecId OUT VARCHAR2, p_MaxChainId OUT VARCHAR2, p_MaxChainN OUT VARCHAR2)
AS
BEGIN
DECLARE
v_recid NUMBER;
v_chainid NUMBER;
v_chainn NUMBER;
BEGIN
p_InsRecId := ‘0’;
p_MaxChainId := ‘1’;
p_MaxChainN := ‘1’;
insert into maxlistid select ‘OCCalllist2’ as tablename, max(record_id),max(chain_id) from OCCalllist2;
IF p_ChainID > 0 AND p_ChainN > 0 THEN
SELECT COUNT(*) INTO v_recid from OCCalllist2 WHERE chain_id = p_ChainID AND chain_n = p_ChainN;
IF v_recid > 0 THEN
RETURN;
END IF;
select max(maxrecid) into v_recid from maxlistid where tablename=‘OCCalllist2’;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,p_ChainID);
delete from maxlistid where maxrecid < v_recid AND maxchainid < p_ChainID AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (p_ChainID);
p_MaxChainN := TO_CHAR (p_ChainN);
RETURN;
END IF;
IF p_ChainID > 0 THEN
SELECT COUNT(*) INTO v_recid from OCCalllist2 WHERE chain_id = p_ChainID;
IF v_recid > 0 THEN
select max(chain_n) into v_chainn from OCCalllist2 where chain_id = p_ChainID;
v_chainn := nvl (v_chainn, 0)+1;
IF v_chainn < 0 THEN
v_chainn := 0;
END IF;
ELSE
v_chainn := 0;
END IF;
select max(maxrecid) into v_recid from maxlistid where tablename=‘OCCalllist2’;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,p_ChainID);
delete from maxlistid where maxrecid < v_recid AND maxchainid < p_ChainN AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (p_ChainID);
p_MaxChainN := TO_CHAR (v_chainn);
RETURN;
END IF;
select max(maxchainid),max(maxrecid) into v_chainid, v_recid from maxlistid where tablename=‘OCCalllist2’;
v_chainid := nvl (v_chainid, 0)+1;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,v_chainid);
delete from maxlistid where maxrecid < v_recid AND maxchainid < v_chainid AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (v_chainid);
p_MaxChainN := TO_CHAR (v_chainn);
END;
END sm110106;
CM_DBRequest Type:7 Server:0
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 20
: DBEvent: 30 RequestID: 199 Status: 99 Class: 0 Server: 0 DBClient: 59
SQL:select count(*) as ISEXISTS from user_tables where table_name = ‘MAXLISTID’
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 20
: DBEvent: 40 RequestID: 200 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:BEGIN TRANSACTION
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 20
: DBEvent: 29 RequestID: 201 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:CREATE OR REPLACE PROCEDURE sm110106
(p_ChainID NUMBER, p_ChainN NUMBER, p_InsRecId OUT VARCHAR2, p_MaxChainId OUT VARCHAR2, p_MaxChainN OUT VARCHAR2)
AS
BEGIN
DECLARE
v_recid NUMBER;
v_chainid NUMBER;
v_chainn NUMBER;
BEGIN
p_InsRecId := ‘0’;
p_MaxChainId := ‘1’;
p_MaxChainN := ‘1’;
insert into maxlistid select ‘OCCalllist2’ as tablename, max(record_id),max(chain_id) from OCCalllist2;
IF p_ChainID > 0 AND p_ChainN > 0 THEN
SELECT COUNT(*) INTO v_recid from OCCalllist2 WHERE chain_id = p_ChainID AND chain_n = p_ChainN;
IF v_recid > 0 THEN
RETURN;
END IF;
select max(maxrecid) into v_recid from maxlistid where tablename=‘OCCalllist2’;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,p_ChainID);
delete from maxlistid where maxrecid < v_recid AND maxchainid < p_ChainID AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (p_ChainID);
p_MaxChainN := TO_CHAR (p_ChainN);
RETURN;
END IF;
IF p_ChainID > 0 THEN
SELECT COUNT(*) INTO v_recid from OCCalllist2 WHERE chain_id = p_ChainID;
IF v_recid > 0 THEN
select max(chain_n) into v_chainn from OCCalllist2 where chain_id = p_ChainID;
v_chainn := nvl (v_chainn, 0)+1;
IF v_chainn < 0 THEN
v_chainn := 0;
END IF;
ELSE
v_chainn := 0;
END IF;
select max(maxrecid) into v_recid from maxlistid where tablename=‘OCCalllist2’;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,p_ChainID);
delete from maxlistid where maxrecid < v_recid AND maxchainid < p_ChainN AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (p_ChainID);
p_MaxChainN := TO_CHAR (v_chainn);
RETURN;
END IF;
select max(maxchainid),max(maxrecid) into v_chainid, v_recid from maxlistid where tablename=‘OCCalllist2’;
v_chainid := nvl (v_chainid, 0)+1;
v_recid := nvl (v_recid, 0)+1;
insert into maxlistid (tablename,maxrecid,maxchainid) values(‘OCCalllist2’,v_recid,v_chainid);
delete from maxlistid where maxrecid < v_recid AND maxchainid < v_chainid AND tablename=‘OCCalllist2’;
p_InsRecId := TO_CHAR (v_recid);
p_MaxChainId := TO_CHAR (v_chainid);
p_MaxChainN := TO_CHAR (v_chainn);
END;
END sm110106;
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 20
: DBEvent: 21 RequestID: 202 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:COMMIT TRANSACTION
: NO pRecord
CM_DBRequest Type:6 Server:0
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 204 :CREATE OR REPLACE PROCEDURE sp110106
(p_CampID VARCHAR2, p_GroupID VARCHAR2, p_ListID VARCHAR2, p_RecType NUMBER,
p_NumRec NUMBER, p_CTime VARCHAR2, p_TTime VARCHAR2, p_ReadyCount OUT VARCHAR2, p_MaxChainId OUT VARCHAR2)
AS
BEGIN
DECLARE
v_CampDBID NUMBER := TO_NUMBER (p_CampID);
v_GroupDBID NUMBER := TO_NUMBER (p_GroupID);
v_ListDBID NUMBER := TO_NUMBER (p_ListID);
v_CurrTime NUMBER := TO_NUMBER (p_CTime);
v_TestTime NUMBER := TO_NUMBER (p_TTime);
v_ReadyCount NUMBER;
v_MaxChainId NUMBER;
v_chain_id NUMBER;
v_counter NUMBER := 1;
v_find NUMBER;
BEGIN
DELETE READYRECORD WHERE camp_dbid = v_CampDBID
AND group_dbid = v_GroupDBID AND list_dbid = v_ListDBID;
SELECT COUNT(chain_id) INTO v_ReadyCount FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND CampaignDBID = v_CampDBID
AND tz_dbid = DBID
AND chain_n = 0
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
;
p_ReadyCount := TO_CHAR (nvl(v_ReadyCount,0));
SELECT MAX(chain_id) INTO v_MaxChainId FROM OCCalllist2;
p_MaxChainId := TO_CHAR (nvl(v_MaxChainId,0));
IF p_RecType = 0 THEN
INSERT INTO READYRECORD SELECT v_CampDBID,v_GroupDBID,v_ListDBID,p_RecType,‘OCCalllist2’ as tablename,chain_id
FROM ( select rownum r123, chain_id from (select DISTINCT chain_id FROM
(select * FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND record_type = 2
AND tz_dbid = DBID
AND CampaignDBID = v_CampDBID
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
) ) ) WHERE r123 < p_NumRec+1;
ELSE
INSERT INTO READYRECORD SELECT v_CampDBID,v_GroupDBID,v_ListDBID,p_RecType,‘OCCalllist2’ as tablename,chain_id
FROM ( select rownum r123, chain_id from (select DISTINCT chain_id FROM
(select * FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND record_type BETWEEN 3 AND 6
AND tz_dbid = DBID
AND CampaignDBID = v_CampDBID
AND campaign_id = v_CampDBID
AND dial_sched_time < v_TestTime
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
) ) ) WHERE r123 < p_NumRec+1;
END IF;
UPDATE OCCalllist2 SET record_status = 2, campaign_id = v_CampDBID
WHERE record_status = 1
AND record_type BETWEEN 2 AND 6
AND chain_id IN (SELECT chain_id from ReadyRecord WHERE
camp_dbid = v_CampDBID AND group_dbid = v_GroupDBID AND list_dbid = v_ListDBID);
END;
END sp110106;
CM_DBRequest Type:7 Server:0
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 4
: DBEvent: 40 RequestID: 203 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:BEGIN TRANSACTION
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 4
: DBEvent: 29 RequestID: 204 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:CREATE OR REPLACE PROCEDURE sp110106
(p_CampID VARCHAR2, p_GroupID VARCHAR2, p_ListID VARCHAR2, p_RecType NUMBER,
p_NumRec NUMBER, p_CTime VARCHAR2, p_TTime VARCHAR2, p_ReadyCount OUT VARCHAR2, p_MaxChainId OUT VARCHAR2)
AS
BEGIN
DECLARE
v_CampDBID NUMBER := TO_NUMBER (p_CampID);
v_GroupDBID NUMBER := TO_NUMBER (p_GroupID);
v_ListDBID NUMBER := TO_NUMBER (p_ListID);
v_CurrTime NUMBER := TO_NUMBER (p_CTime);
v_TestTime NUMBER := TO_NUMBER (p_TTime);
v_ReadyCount NUMBER;
v_MaxChainId NUMBER;
v_chain_id NUMBER;
v_counter NUMBER := 1;
v_find NUMBER;
BEGIN
DELETE READYRECORD WHERE camp_dbid = v_CampDBID
AND group_dbid = v_GroupDBID AND list_dbid = v_ListDBID;
SELECT COUNT(chain_id) INTO v_ReadyCount FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND CampaignDBID = v_CampDBID
AND tz_dbid = DBID
AND chain_n = 0
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
;
p_ReadyCount := TO_CHAR (nvl(v_ReadyCount,0));
SELECT MAX(chain_id) INTO v_MaxChainId FROM OCCalllist2;
p_MaxChainId := TO_CHAR (nvl(v_MaxChainId,0));
IF p_RecType = 0 THEN
INSERT INTO READYRECORD SELECT v_CampDBID,v_GroupDBID,v_ListDBID,p_RecType,‘OCCalllist2’ as tablename,chain_id
FROM ( select rownum r123, chain_id from (select DISTINCT chain_id FROM
(select * FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND record_type = 2
AND tz_dbid = DBID
AND CampaignDBID = v_CampDBID
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
) ) ) WHERE r123 < p_NumRec+1;
ELSE
INSERT INTO READYRECORD SELECT v_CampDBID,v_GroupDBID,v_ListDBID,p_RecType,‘OCCalllist2’ as tablename,chain_id
FROM ( select rownum r123, chain_id from (select DISTINCT chain_id FROM
(select * FROM OCCalllist2, TIMEZONES
WHERE record_status = 1
AND record_type BETWEEN 3 AND 6
AND tz_dbid = DBID
AND CampaignDBID = v_CampDBID
AND campaign_id = v_CampDBID
AND dial_sched_time < v_TestTime
AND ((v_CurrTime+Offset) 86400*floor ((v_CurrTime+Offset)/86400))
BETWEEN daily_from AND daily_till
) ) ) WHERE r123 < p_NumRec+1;
END IF;
UPDATE OCCalllist2 SET record_status = 2, campaign_id = v_CampDBID
WHERE record_status = 1
AND record_type BETWEEN 2 AND 6
AND chain_id IN (SELECT chain_id from ReadyRecord WHERE
camp_dbid = v_CampDBID AND group_dbid = v_GroupDBID AND list_dbid = v_ListDBID);
END;
END sp110106;
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 4
: DBEvent: 21 RequestID: 205 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:COMMIT TRANSACTION
: NO pRecord
CM_DBRequest Type:5 Server:0
:CHDATA RequestID: 206 :DELETE ReadyRecord WHERE camp_dbid = 110 AND group_dbid = 104 AND list_dbid = 106
CM_DBRequest Type:3 Server:0
:SPCALL RequestID: 207 :sp110106 p_CampID = '110', p_GroupID = '104', p_ListID = '106', p_RecType = 1, p_NumRec = 6, p_CTime = '37864', p_TTime = '1019731664', p_ReadyCount = @out, p_MaxChainId = @out
CM_DBCallList :: ExecuteSP ID 207 Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 SQL: sp110106 p_CampID = ‘110’, p_GroupID = ‘104’, p_ListID = ‘106’, p_RecType = 1, p_NumRec = 6, p_CTime = ‘37864’, p_TTime = ‘1019731664’, p_ReadyCount = @out, p_MaxChainId = @out
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 5
: DBEvent: 29 RequestID: 206 Status: 1 Class: 0 Server: 0 DBClient: 59
SQL:DELETE ReadyRecord WHERE camp_dbid = 110 AND group_dbid = 104 AND list_dbid = 106
: NO pRecord
request to 1000002 message RequestDistributeUserEvent
AttributeUserData [322] 00 0D 01 00..
'GSW_STAT_EVENT' 2
'GSW_CAMPAIGN_DBID' 110
'GSW_CALL_LIST_DBID' 0
'GSW_GROUP_DBID' 104
'GSW_AGENT_DBID' 0
'GSW_CALL_RESULT' 0
'GSW_CAMPAIGN_COMPLETE' 0
'GSW_LIST_COMPLETE' 0
'GSW_PORTS' 0
'GSW_DIAL_MODE' 2
'GSW_APLICATION_ID' 174
'GSW_CALLBACK_TYPE' 0
'GSW_SCHED_REC_NUM' 0
AttributeCommunicationDN 'COMDN'
04/25/02 12:31:09.343 Trace localhost OCServer GCTI1231020 Release all Agents request processing: Dialer DBID: 0
04/25/02 12:31:09.359 Standard localhost OCServer GCTI1231021 Error during Release all Agents request processing: Dialer not found: Dialer DBID: 0
CM_DBCampaign DBID: 110, Status: CMS_UNLOADING … Unload
received from fd=552 message EventACK
AttributeUserEvent RequestDistributeUserEvent
AttributeThisDN 'COMDN'
AttributeTimeinSecs 1019730595
AttributeTimeinuSecs 875000
AttributeCustomerID 'Resources'
04/25/02 12:31:09.421 Trace localhost OCServer GCTI1250002 TEvent: Unknown TEvent
04/25/02 12:31:09.421 Trace localhost OCServer GCTI1250017 Default TEvent processing
CM_DBCampaign DBID: 110, Status: CMS_UNLOADING … Unload
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 2 Status: 5
: DBEvent: 26 RequestID: 1 Status: 8 Class: 0 Server: 0 DBClient: 1
: NO pRecord
start opening of server 'DAP_Out' ...
Waiting for connection to server 'DAP_Out' on socket '612'
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 3 Status: 5
: DBEvent: 48 RequestID: 0 Status: 1 Class: 0 Server: 3 DBClient: 1
: NO pRecord
CM_DBRequest Type:1 Server:3
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 3 Status: 5
: DBEvent: 39 RequestID: 208 Status: 1 Class: 0 Server: 3 DBClient: 1
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 3 Status: 5
: DBEvent: 48 RequestID: 0 Status: 1 Class: 0 Server: 3 DBClient: 1
: NO pRecord
CM_DBCallList :: PrintDBEvent Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 3 Status: 5
: DBEvent: 27 RequestID: 209 Status: 1 Class: 0 Server: 3 DBClient: 60
: NO pRecord
CM_DBCallList :: MSG_DBOPENED Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2 message: DBStatus: 3 Status: 5
Connected to server 'DAP_Out' on socket '612'
CM_DBCampaign Records: 0 Chains: 0 Name: Campaign3 ::CheckUnloadComplete
CM_DBCampaign Records: 0 Chains: 0 Name: Campaign3 ::CheckUnloadComplete message: ReadyToDie
04/25/02 12:31:15.046 Trace localhost OCServer GCTI1231020 Release all Agents request processing: Dialer DBID: 0
04/25/02 12:31:15.046 Standard localhost OCServer GCTI1231021 Error during Release all Agents request processing: Dialer not found: Dialer DBID: 0
GroupCampaign Message. Unloading a campaign.
acdGroupDBID: 104. acdGroupName: POLAND. CampaignDBID: 104. CampaignName: Campaign3.
dialerState: 0. switchState: 0. campGroupState: 0.
dialMode: 2. optMethod: 1. optimizeGoal: 80.
gcIsActive: 2. isRecordFlag: 1. isSysReadyFlag: 1.
isPortFlag: 1. isAgentFlag: 1.
GroupCampaign Message. Destructing a campaign.
acdGroupDBID: 104. acdGroupName: POLAND. CampaignDBID: 104. CampaignName: Campaign3.
dialerState: 0. switchState: 0. campGroupState: 0.
dialMode: 2. optMethod: 1. optimizeGoal: 80.
gcIsActive: 2. isRecordFlag: 1. isSysReadyFlag: 1.
isPortFlag: 1. isAgentFlag: 1.
04/25/02 12:31:18.078 Trace localhost OCServer GCTI1231009 Call Manager Client unregistered: Dialer DBID 0
04/25/02 12:31:18.078 Trace localhost OCServer GCTI1231011 Desktop Call Manager Client unregistered: Group DBID 104
CM_DBRequest Type:2 Server:3
dbserver DAP_Out is being closed Received disconnect from application ‘DAP_Out’
Server 'DAP_Out' is being deleted.
CM_DBCallList :: List deleted Name: OCCalllist szServer: GENPRD01 szDatabase: TableName: OCCalllist2
CM_DBCampaign Records: 0 Chains: 0 Name: Campaign3 ::Campaign deleted
CM_DBCampaign DBID: 103, New Status: CMS_STARTED … Start Old Status: 2
request to 1000002 message RequestDistributeUserEvent
AttributeUserData [322] 00 0D 01 00..
'GSW_STAT_EVENT' 3
'GSW_CAMPAIGN_DBID' 103
'GSW_CALL_LIST_DBID' 0
'GSW_GROUP_DBID' 112
'GSW_AGENT_DBID' 0
'GSW_CALL_RESULT' 0
'GSW_CAMPAIGN_COMPLETE' 0
'GSW_LIST_COMPLETE' 0
'GSW_PORTS' 0
'GSW_DIAL_MODE' 2
'GSW_APLICATION_ID' 174
'GSW_CALLBACK_TYPE' 0
'GSW_SCHED_REC_NUM' 0
AttributeCommunicationDN 'COMDN'
GroupCampaign Message. Start dialing.
acdGroupDBID: 112. acdGroupName: OUTBOUND. CampaignDBID: 112. CampaignName: CAMPAIGN1.
dialerState: 0. switchState: 0. campGroupState: 5.
dialMode: 2. optMethod: 1. optimizeGoal: 80.
gcIsActive: 2. isRecordFlag: 1. isSysReadyFlag: 1.
isPortFlag: 1. isAgentFlag: 1.
received from fd=552 message EventACK
AttributeUserEvent RequestDistributeUserEvent
AttributeThisDN 'COMDN'
AttributeTimeinSecs 1019730626
AttributeTimeinuSecs 203000
AttributeCustomerID 'Resources'
04/25/02 12:31:39.750 Trace localhost OCServer GCTI1250002 TEvent: Unknown TEvent
04/25/02 12:31:39.750 Trace localhost OCServer GCTI1250017 Default TEvent processing
04/25/02 12:31:40.421> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 0.
Predictive data:
Calls predicted: 1.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 2. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
request to 1000002 message RequestDistributeUserEvent
AttributeUserData [322] 00 0D 01 00..
'GSW_STAT_EVENT' 10
'GSW_CAMPAIGN_DBID' 103
'GSW_CALL_LIST_DBID' 0
'GSW_GROUP_DBID' 112
'GSW_AGENT_DBID' 0
'GSW_CALL_RESULT' 0
'GSW_CAMPAIGN_COMPLETE' 0
'GSW_LIST_COMPLETE' 0
'GSW_PORTS' 0
'GSW_DIAL_MODE' 2
'GSW_APLICATION_ID' 174
'GSW_CALLBACK_TYPE' 0
'GSW_SCHED_REC_NUM' 0
AttributeCommunicationDN 'COMDN'
received from fd=552 message EventACK
AttributeUserEvent RequestDistributeUserEvent
AttributeThisDN 'COMDN'
AttributeTimeinSecs 1019730626
AttributeTimeinuSecs 984000
AttributeCustomerID 'Resources'
04/25/02 12:31:40.546 Trace localhost OCServer GCTI1250002 TEvent: Unknown TEvent
04/25/02 12:31:40.546 Trace localhost OCServer GCTI1250017 Default TEvent processing
04/25/02 12:31:41.468> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 5.
Predictive data:
Calls predicted: 2.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:42.500> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 10.
Predictive data:
Calls predicted: 1.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 2. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:43.515> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 15.
Predictive data:
Calls predicted: 2.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:44.546> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 20.
Predictive data:
Calls predicted: 1.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 2. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:45.562> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 25.
Predictive data:
Calls predicted: 2.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:46.593> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 30.
Predictive data:
Calls predicted: 1.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 2. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
received from fd=552 message EventAbandoned
AttributeCallType 2
AttributeCallID 409
AttributeConnID 006700dc08420163
AttributeUserData [16] 00 01 01 00..
'PegTD' 2
AttributeDNIS '351'
AttributeANI '447144898'
AttributeCustomerID 'Resources'
AttributeThisDN '7616'
AttributeThisDNRole 2
AttributeOtherDN '447144898'
AttributeOtherDNRole 1
AttributeOtherQueue '7912'
AttributeCallState 0
AttributeTimeinSecs 1019730633
AttributeTimeinuSecs 734000
04/25/02 12:31:47.296 Trace localhost OCServer GCTI1250002 TEvent: EventAbandoned
04/25/02 12:31:47.296 Trace localhost OCServer GCTI1250035 Send CallState to clients:record 0, gctiCallState = 0, CmCallState =1
04/25/02 12:31:47.312 Trace localhost OCServer GCTI1250035 Send CallState to clients:record 0, gctiCallState = 0, CmCallState =1
04/25/02 12:31:47.625> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 35.
Predictive data:
Calls predicted: 2.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:48.640> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 40.
Predictive data:
Calls predicted: 1.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 2. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
04/25/02 12:31:49.671> ACDGroup Message.
acdGroupDBID: 112. acdGroupName: OUTBOUND.
GroupCampaign List:
Campaign DBID: 103. Name: CAMPAIGN1. Mode: Progressive. SentCalls: 0. SentEngageCalls: 0. NoRecords: 45.
Predictive data:
Calls predicted: 2.
Expected values: Busy Factor= 1.000. Abandon Rate= 0.000. Wait Time= 0.000
Real values: Busy Factor= 0.000. Abandon Rate= 0.000. Wait Time= 0.000
Current Statistics:
Ready Outbound Agents: 2. Total Agents: 2. Ready Agents: 2.
Hit Ratio: 1.000. Call Duration: 120.000. Last Forecast: 1. Really Dialed: 0.
Additional Calls: 0. Removed Calls: 0. Established Calls: 0. Abandoned Calls: 0.
