[2025-11-10 00:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-09 21:00:07 [end_date_ymd] => 2025-11-10 00:00:07 [RateCDR] => 1 ) [2025-11-10 00:00:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-09 21:00:07' and `end` < '2025-11-10 00:00:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 00:00:20] Production.INFO: count ==921 [2025-11-10 00:00:21] Production.ERROR: pbx CDR StartTime 2025-11-09 21:00:07 - End Time 2025-11-10 00:00:07 [2025-11-10 00:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173431', 'tblTempUsageDetail_20' ) start [2025-11-10 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173431', 'tblTempUsageDetail_20' ) end [2025-11-10 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173431', 'tblTempVendorCDR_20' ) start [2025-11-10 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173431', 'tblTempVendorCDR_20' ) end [2025-11-10 00:00:21] Production.INFO: ProcessCDR(1,16173431,1,1,2) [2025-11-10 00:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16173431,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 00:00:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16173431,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 00:00:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16173431,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 00:00:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16173431,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 00:00:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173431', 'tblTempUsageDetail_20' ) start [2025-11-10 00:00:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173431', 'tblTempUsageDetail_20' ) end [2025-11-10 00:00:34] Production.ERROR: pbx prc_insertCDR start [2025-11-10 00:00:34] Production.ERROR: pbx prc_insertCDR end [2025-11-10 00:00:36] Production.INFO: ==26381== Releasing lock... [2025-11-10 00:00:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 00:00:36] Production.INFO: 38 MB #Memory Used# [2025-11-10 01:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-09 22:00:06 [end_date_ymd] => 2025-11-10 01:00:06 [RateCDR] => 1 ) [2025-11-10 01:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-09 22:00:06' and `end` < '2025-11-10 01:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 01:00:23] Production.INFO: count ==584 [2025-11-10 01:00:24] Production.ERROR: pbx CDR StartTime 2025-11-09 22:00:06 - End Time 2025-11-10 01:00:06 [2025-11-10 01:00:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 01:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173678', 'tblTempUsageDetail_20' ) start [2025-11-10 01:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173678', 'tblTempUsageDetail_20' ) end [2025-11-10 01:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173678', 'tblTempVendorCDR_20' ) start [2025-11-10 01:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173678', 'tblTempVendorCDR_20' ) end [2025-11-10 01:00:24] Production.INFO: ProcessCDR(1,16173678,1,1,2) [2025-11-10 01:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16173678,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 01:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16173678,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 01:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16173678,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 01:00:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16173678,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 01:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173678', 'tblTempUsageDetail_20' ) start [2025-11-10 01:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173678', 'tblTempUsageDetail_20' ) end [2025-11-10 01:00:33] Production.ERROR: pbx prc_insertCDR start [2025-11-10 01:00:33] Production.ERROR: pbx prc_insertCDR end [2025-11-10 01:00:33] Production.INFO: ==30923== Releasing lock... [2025-11-10 01:00:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 01:00:33] Production.INFO: 33 MB #Memory Used# [2025-11-10 02:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-09 23:00:06 [end_date_ymd] => 2025-11-10 02:00:06 [RateCDR] => 1 ) [2025-11-10 02:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-09 23:00:06' and `end` < '2025-11-10 02:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 02:00:19] Production.INFO: count ==591 [2025-11-10 02:00:19] Production.ERROR: pbx CDR StartTime 2025-11-09 23:00:06 - End Time 2025-11-10 02:00:06 [2025-11-10 02:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173925', 'tblTempUsageDetail_20' ) start [2025-11-10 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16173925', 'tblTempUsageDetail_20' ) end [2025-11-10 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173925', 'tblTempVendorCDR_20' ) start [2025-11-10 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16173925', 'tblTempVendorCDR_20' ) end [2025-11-10 02:00:19] Production.INFO: ProcessCDR(1,16173925,1,1,2) [2025-11-10 02:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16173925,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 02:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16173925,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 02:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16173925,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 02:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16173925,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 02:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173925', 'tblTempUsageDetail_20' ) start [2025-11-10 02:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16173925', 'tblTempUsageDetail_20' ) end [2025-11-10 02:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-10 02:00:29] Production.ERROR: pbx prc_insertCDR end [2025-11-10 02:00:30] Production.INFO: ==2886== Releasing lock... [2025-11-10 02:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 02:00:30] Production.INFO: 33 MB #Memory Used# [2025-11-10 03:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 00:00:06 [end_date_ymd] => 2025-11-10 03:00:06 [RateCDR] => 1 ) [2025-11-10 03:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 00:00:06' and `end` < '2025-11-10 03:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 03:00:18] Production.INFO: count ==559 [2025-11-10 03:00:18] Production.ERROR: pbx CDR StartTime 2025-11-10 00:00:06 - End Time 2025-11-10 03:00:06 [2025-11-10 03:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174171', 'tblTempUsageDetail_20' ) start [2025-11-10 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174171', 'tblTempUsageDetail_20' ) end [2025-11-10 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174171', 'tblTempVendorCDR_20' ) start [2025-11-10 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174171', 'tblTempVendorCDR_20' ) end [2025-11-10 03:00:18] Production.INFO: ProcessCDR(1,16174171,1,1,2) [2025-11-10 03:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16174171,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 03:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16174171,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 03:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16174171,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 03:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16174171,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 03:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174171', 'tblTempUsageDetail_20' ) start [2025-11-10 03:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174171', 'tblTempUsageDetail_20' ) end [2025-11-10 03:00:28] Production.ERROR: pbx prc_insertCDR start [2025-11-10 03:00:28] Production.ERROR: pbx prc_insertCDR end [2025-11-10 03:00:28] Production.INFO: ==7489== Releasing lock... [2025-11-10 03:00:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 03:00:28] Production.INFO: 33 MB #Memory Used# [2025-11-10 04:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 01:00:07 [end_date_ymd] => 2025-11-10 04:00:07 [RateCDR] => 1 ) [2025-11-10 04:00:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 01:00:07' and `end` < '2025-11-10 04:00:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 04:00:19] Production.INFO: count ==411 [2025-11-10 04:00:20] Production.ERROR: pbx CDR StartTime 2025-11-10 01:00:07 - End Time 2025-11-10 04:00:07 [2025-11-10 04:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 04:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174420', 'tblTempUsageDetail_20' ) start [2025-11-10 04:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174420', 'tblTempUsageDetail_20' ) end [2025-11-10 04:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174420', 'tblTempVendorCDR_20' ) start [2025-11-10 04:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174420', 'tblTempVendorCDR_20' ) end [2025-11-10 04:00:20] Production.INFO: ProcessCDR(1,16174420,1,1,2) [2025-11-10 04:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16174420,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 04:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16174420,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 04:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16174420,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 04:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16174420,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 04:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174420', 'tblTempUsageDetail_20' ) start [2025-11-10 04:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174420', 'tblTempUsageDetail_20' ) end [2025-11-10 04:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-10 04:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-10 04:00:30] Production.INFO: ==11992== Releasing lock... [2025-11-10 04:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 04:00:30] Production.INFO: 32.25 MB #Memory Used# [2025-11-10 05:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 02:00:06 [end_date_ymd] => 2025-11-10 05:00:06 [RateCDR] => 1 ) [2025-11-10 05:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 02:00:06' and `end` < '2025-11-10 05:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 05:00:19] Production.INFO: count ==245 [2025-11-10 05:00:19] Production.ERROR: pbx CDR StartTime 2025-11-10 02:00:06 - End Time 2025-11-10 05:00:06 [2025-11-10 05:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 05:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174668', 'tblTempUsageDetail_20' ) start [2025-11-10 05:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174668', 'tblTempUsageDetail_20' ) end [2025-11-10 05:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174668', 'tblTempVendorCDR_20' ) start [2025-11-10 05:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174668', 'tblTempVendorCDR_20' ) end [2025-11-10 05:00:19] Production.INFO: ProcessCDR(1,16174668,1,1,2) [2025-11-10 05:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16174668,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 05:00:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16174668,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 05:00:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16174668,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 05:00:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16174668,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 05:00:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174668', 'tblTempUsageDetail_20' ) start [2025-11-10 05:00:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174668', 'tblTempUsageDetail_20' ) end [2025-11-10 05:00:25] Production.ERROR: pbx prc_insertCDR start [2025-11-10 05:00:25] Production.ERROR: pbx prc_insertCDR end [2025-11-10 05:00:25] Production.INFO: ==16568== Releasing lock... [2025-11-10 05:00:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 05:00:25] Production.INFO: 30.25 MB #Memory Used# [2025-11-10 06:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 03:00:06 [end_date_ymd] => 2025-11-10 06:00:06 [RateCDR] => 1 ) [2025-11-10 06:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 03:00:06' and `end` < '2025-11-10 06:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 06:00:18] Production.INFO: count ==129 [2025-11-10 06:00:18] Production.ERROR: pbx CDR StartTime 2025-11-10 03:00:06 - End Time 2025-11-10 06:00:06 [2025-11-10 06:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174914', 'tblTempUsageDetail_20' ) start [2025-11-10 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16174914', 'tblTempUsageDetail_20' ) end [2025-11-10 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174914', 'tblTempVendorCDR_20' ) start [2025-11-10 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16174914', 'tblTempVendorCDR_20' ) end [2025-11-10 06:00:18] Production.INFO: ProcessCDR(1,16174914,1,1,2) [2025-11-10 06:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16174914,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 06:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16174914,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 06:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16174914,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 06:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16174914,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 06:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174914', 'tblTempUsageDetail_20' ) start [2025-11-10 06:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16174914', 'tblTempUsageDetail_20' ) end [2025-11-10 06:00:28] Production.ERROR: pbx prc_insertCDR start [2025-11-10 06:00:28] Production.ERROR: pbx prc_insertCDR end [2025-11-10 06:00:28] Production.INFO: ==21136== Releasing lock... [2025-11-10 06:00:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 06:00:28] Production.INFO: 29.25 MB #Memory Used# [2025-11-10 07:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 04:00:06 [end_date_ymd] => 2025-11-10 07:00:06 [RateCDR] => 1 ) [2025-11-10 07:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 04:00:06' and `end` < '2025-11-10 07:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 07:00:18] Production.INFO: count ==117 [2025-11-10 07:00:18] Production.ERROR: pbx CDR StartTime 2025-11-10 04:00:06 - End Time 2025-11-10 07:00:06 [2025-11-10 07:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175162', 'tblTempUsageDetail_20' ) start [2025-11-10 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175162', 'tblTempUsageDetail_20' ) end [2025-11-10 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175162', 'tblTempVendorCDR_20' ) start [2025-11-10 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175162', 'tblTempVendorCDR_20' ) end [2025-11-10 07:00:18] Production.INFO: ProcessCDR(1,16175162,1,1,2) [2025-11-10 07:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16175162,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 07:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16175162,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 07:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16175162,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 07:00:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16175162,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 07:00:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175162', 'tblTempUsageDetail_20' ) start [2025-11-10 07:00:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175162', 'tblTempUsageDetail_20' ) end [2025-11-10 07:00:27] Production.ERROR: pbx prc_insertCDR start [2025-11-10 07:00:27] Production.ERROR: pbx prc_insertCDR end [2025-11-10 07:00:27] Production.INFO: ==25745== Releasing lock... [2025-11-10 07:00:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 07:00:27] Production.INFO: 29 MB #Memory Used# [2025-11-10 08:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 05:00:06 [end_date_ymd] => 2025-11-10 08:00:06 [RateCDR] => 1 ) [2025-11-10 08:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 05:00:06' and `end` < '2025-11-10 08:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 08:00:18] Production.INFO: count ==232 [2025-11-10 08:00:18] Production.ERROR: pbx CDR StartTime 2025-11-10 05:00:06 - End Time 2025-11-10 08:00:06 [2025-11-10 08:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175409', 'tblTempUsageDetail_20' ) start [2025-11-10 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175409', 'tblTempUsageDetail_20' ) end [2025-11-10 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175409', 'tblTempVendorCDR_20' ) start [2025-11-10 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175409', 'tblTempVendorCDR_20' ) end [2025-11-10 08:00:18] Production.INFO: ProcessCDR(1,16175409,1,1,2) [2025-11-10 08:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16175409,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 08:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16175409,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 08:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16175409,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 08:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16175409,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 08:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175409', 'tblTempUsageDetail_20' ) start [2025-11-10 08:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175409', 'tblTempUsageDetail_20' ) end [2025-11-10 08:00:28] Production.ERROR: pbx prc_insertCDR start [2025-11-10 08:00:28] Production.ERROR: pbx prc_insertCDR end [2025-11-10 08:00:28] Production.INFO: ==30814== Releasing lock... [2025-11-10 08:00:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 08:00:28] Production.INFO: 30.25 MB #Memory Used# [2025-11-10 09:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 06:00:06 [end_date_ymd] => 2025-11-10 09:00:06 [RateCDR] => 1 ) [2025-11-10 09:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 06:00:06' and `end` < '2025-11-10 09:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 09:00:18] Production.INFO: count ==1185 [2025-11-10 09:00:19] Production.ERROR: pbx CDR StartTime 2025-11-10 06:00:06 - End Time 2025-11-10 09:00:06 [2025-11-10 09:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175656', 'tblTempUsageDetail_20' ) start [2025-11-10 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175656', 'tblTempUsageDetail_20' ) end [2025-11-10 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175656', 'tblTempVendorCDR_20' ) start [2025-11-10 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175656', 'tblTempVendorCDR_20' ) end [2025-11-10 09:00:19] Production.INFO: ProcessCDR(1,16175656,1,1,2) [2025-11-10 09:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16175656,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 09:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16175656,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 09:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16175656,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 09:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16175656,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 09:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175656', 'tblTempUsageDetail_20' ) start [2025-11-10 09:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175656', 'tblTempUsageDetail_20' ) end [2025-11-10 09:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-10 09:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-10 09:00:30] Production.INFO: ==2920== Releasing lock... [2025-11-10 09:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 09:00:30] Production.INFO: 38.5 MB #Memory Used# [2025-11-10 10:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 07:00:07 [end_date_ymd] => 2025-11-10 10:00:07 [RateCDR] => 1 ) [2025-11-10 10:00:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 07:00:07' and `end` < '2025-11-10 10:00:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 10:00:24] Production.INFO: count ==3207 [2025-11-10 10:00:26] Production.ERROR: pbx CDR StartTime 2025-11-10 07:00:07 - End Time 2025-11-10 10:00:07 [2025-11-10 10:00:26] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 10:00:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175903', 'tblTempUsageDetail_20' ) start [2025-11-10 10:00:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16175903', 'tblTempUsageDetail_20' ) end [2025-11-10 10:00:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175903', 'tblTempVendorCDR_20' ) start [2025-11-10 10:00:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16175903', 'tblTempVendorCDR_20' ) end [2025-11-10 10:00:26] Production.INFO: ProcessCDR(1,16175903,1,1,2) [2025-11-10 10:00:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16175903,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 10:00:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16175903,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 10:00:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16175903,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 10:00:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16175903,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 10:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175903', 'tblTempUsageDetail_20' ) start [2025-11-10 10:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16175903', 'tblTempUsageDetail_20' ) end [2025-11-10 10:00:37] Production.ERROR: pbx prc_insertCDR start [2025-11-10 10:00:40] Production.ERROR: pbx prc_insertCDR end [2025-11-10 10:00:40] Production.INFO: ==7777== Releasing lock... [2025-11-10 10:00:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 10:00:40] Production.INFO: 53 MB #Memory Used# [2025-11-10 11:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 08:00:06 [end_date_ymd] => 2025-11-10 11:00:06 [RateCDR] => 1 ) [2025-11-10 11:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 08:00:06' and `end` < '2025-11-10 11:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 11:00:21] Production.INFO: count ==5253 [2025-11-10 11:00:23] Production.ERROR: pbx CDR StartTime 2025-11-10 08:00:06 - End Time 2025-11-10 11:00:06 [2025-11-10 11:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 11:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176150', 'tblTempUsageDetail_20' ) start [2025-11-10 11:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176150', 'tblTempUsageDetail_20' ) end [2025-11-10 11:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176150', 'tblTempVendorCDR_20' ) start [2025-11-10 11:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176150', 'tblTempVendorCDR_20' ) end [2025-11-10 11:00:24] Production.INFO: ProcessCDR(1,16176150,1,1,2) [2025-11-10 11:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16176150,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 11:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16176150,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 11:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16176150,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 11:00:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16176150,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 11:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176150', 'tblTempUsageDetail_20' ) start [2025-11-10 11:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176150', 'tblTempUsageDetail_20' ) end [2025-11-10 11:00:36] Production.ERROR: pbx prc_insertCDR start [2025-11-10 11:00:38] Production.ERROR: pbx prc_insertCDR end [2025-11-10 11:00:38] Production.INFO: ==12724== Releasing lock... [2025-11-10 11:00:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 11:00:38] Production.INFO: 67.5 MB #Memory Used# [2025-11-10 12:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 09:00:06 [end_date_ymd] => 2025-11-10 12:00:06 [RateCDR] => 1 ) [2025-11-10 12:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 09:00:06' and `end` < '2025-11-10 12:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 12:00:23] Production.INFO: count ==6578 [2025-11-10 12:00:27] Production.ERROR: pbx CDR StartTime 2025-11-10 09:00:06 - End Time 2025-11-10 12:00:06 [2025-11-10 12:00:27] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 12:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176397', 'tblTempUsageDetail_20' ) start [2025-11-10 12:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176397', 'tblTempUsageDetail_20' ) end [2025-11-10 12:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176397', 'tblTempVendorCDR_20' ) start [2025-11-10 12:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176397', 'tblTempVendorCDR_20' ) end [2025-11-10 12:00:27] Production.INFO: ProcessCDR(1,16176397,1,1,2) [2025-11-10 12:00:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16176397,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 12:00:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16176397,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 12:00:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16176397,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 12:00:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16176397,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 12:00:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176397', 'tblTempUsageDetail_20' ) start [2025-11-10 12:00:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176397', 'tblTempUsageDetail_20' ) end [2025-11-10 12:00:40] Production.ERROR: pbx prc_insertCDR start [2025-11-10 12:00:44] Production.ERROR: pbx prc_insertCDR end [2025-11-10 12:00:44] Production.INFO: ==17730== Releasing lock... [2025-11-10 12:00:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 12:00:44] Production.INFO: 77.5 MB #Memory Used# [2025-11-10 13:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 10:00:06 [end_date_ymd] => 2025-11-10 13:00:06 [RateCDR] => 1 ) [2025-11-10 13:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 10:00:06' and `end` < '2025-11-10 13:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 13:00:20] Production.INFO: count ==6448 [2025-11-10 13:00:24] Production.ERROR: pbx CDR StartTime 2025-11-10 10:00:06 - End Time 2025-11-10 13:00:06 [2025-11-10 13:00:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176644', 'tblTempUsageDetail_20' ) start [2025-11-10 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176644', 'tblTempUsageDetail_20' ) end [2025-11-10 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176644', 'tblTempVendorCDR_20' ) start [2025-11-10 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176644', 'tblTempVendorCDR_20' ) end [2025-11-10 13:00:24] Production.INFO: ProcessCDR(1,16176644,1,1,2) [2025-11-10 13:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16176644,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 13:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16176644,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 13:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16176644,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 13:00:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16176644,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 13:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176644', 'tblTempUsageDetail_20' ) start [2025-11-10 13:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176644', 'tblTempUsageDetail_20' ) end [2025-11-10 13:00:36] Production.ERROR: pbx prc_insertCDR start [2025-11-10 13:00:39] Production.ERROR: pbx prc_insertCDR end [2025-11-10 13:00:39] Production.INFO: ==22417== Releasing lock... [2025-11-10 13:00:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 13:00:39] Production.INFO: 76.5 MB #Memory Used# [2025-11-10 14:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 11:00:06 [end_date_ymd] => 2025-11-10 14:00:06 [RateCDR] => 1 ) [2025-11-10 14:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 11:00:06' and `end` < '2025-11-10 14:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 14:00:21] Production.INFO: count ==6263 [2025-11-10 14:00:24] Production.ERROR: pbx CDR StartTime 2025-11-10 11:00:06 - End Time 2025-11-10 14:00:06 [2025-11-10 14:00:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 14:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176891', 'tblTempUsageDetail_20' ) start [2025-11-10 14:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16176891', 'tblTempUsageDetail_20' ) end [2025-11-10 14:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176891', 'tblTempVendorCDR_20' ) start [2025-11-10 14:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16176891', 'tblTempVendorCDR_20' ) end [2025-11-10 14:00:25] Production.INFO: ProcessCDR(1,16176891,1,1,2) [2025-11-10 14:00:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16176891,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 14:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16176891,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 14:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16176891,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 14:00:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16176891,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 14:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176891', 'tblTempUsageDetail_20' ) start [2025-11-10 14:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16176891', 'tblTempUsageDetail_20' ) end [2025-11-10 14:00:37] Production.ERROR: pbx prc_insertCDR start [2025-11-10 14:00:40] Production.ERROR: pbx prc_insertCDR end [2025-11-10 14:00:40] Production.INFO: ==27359== Releasing lock... [2025-11-10 14:00:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 14:00:40] Production.INFO: 75.25 MB #Memory Used# [2025-11-10 15:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 12:00:06 [end_date_ymd] => 2025-11-10 15:00:06 [RateCDR] => 1 ) [2025-11-10 15:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 12:00:06' and `end` < '2025-11-10 15:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 15:00:20] Production.INFO: count ==5562 [2025-11-10 15:00:23] Production.ERROR: pbx CDR StartTime 2025-11-10 12:00:06 - End Time 2025-11-10 15:00:06 [2025-11-10 15:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177138', 'tblTempUsageDetail_20' ) start [2025-11-10 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177138', 'tblTempUsageDetail_20' ) end [2025-11-10 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177138', 'tblTempVendorCDR_20' ) start [2025-11-10 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177138', 'tblTempVendorCDR_20' ) end [2025-11-10 15:00:23] Production.INFO: ProcessCDR(1,16177138,1,1,2) [2025-11-10 15:00:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16177138,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 15:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16177138,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 15:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16177138,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 15:00:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16177138,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 15:00:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177138', 'tblTempUsageDetail_20' ) start [2025-11-10 15:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177138', 'tblTempUsageDetail_20' ) end [2025-11-10 15:00:35] Production.ERROR: pbx prc_insertCDR start [2025-11-10 15:00:37] Production.ERROR: pbx prc_insertCDR end [2025-11-10 15:00:37] Production.INFO: ==32138== Releasing lock... [2025-11-10 15:00:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 15:00:37] Production.INFO: 69.75 MB #Memory Used# [2025-11-10 16:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 13:00:06 [end_date_ymd] => 2025-11-10 16:00:06 [RateCDR] => 1 ) [2025-11-10 16:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 13:00:06' and `end` < '2025-11-10 16:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 16:00:22] Production.INFO: count ==5736 [2025-11-10 16:00:25] Production.ERROR: pbx CDR StartTime 2025-11-10 13:00:06 - End Time 2025-11-10 16:00:06 [2025-11-10 16:00:25] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 16:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177385', 'tblTempUsageDetail_20' ) start [2025-11-10 16:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177385', 'tblTempUsageDetail_20' ) end [2025-11-10 16:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177385', 'tblTempVendorCDR_20' ) start [2025-11-10 16:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177385', 'tblTempVendorCDR_20' ) end [2025-11-10 16:00:25] Production.INFO: ProcessCDR(1,16177385,1,1,2) [2025-11-10 16:00:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16177385,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 16:00:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16177385,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 16:00:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16177385,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 16:00:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16177385,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 16:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177385', 'tblTempUsageDetail_20' ) start [2025-11-10 16:00:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177385', 'tblTempUsageDetail_20' ) end [2025-11-10 16:00:38] Production.ERROR: pbx prc_insertCDR start [2025-11-10 16:00:40] Production.ERROR: pbx prc_insertCDR end [2025-11-10 16:00:40] Production.INFO: ==4263== Releasing lock... [2025-11-10 16:00:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 16:00:40] Production.INFO: 71.25 MB #Memory Used# [2025-11-10 17:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 14:00:06 [end_date_ymd] => 2025-11-10 17:00:06 [RateCDR] => 1 ) [2025-11-10 17:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 14:00:06' and `end` < '2025-11-10 17:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 17:00:20] Production.INFO: count ==5590 [2025-11-10 17:00:23] Production.ERROR: pbx CDR StartTime 2025-11-10 14:00:06 - End Time 2025-11-10 17:00:06 [2025-11-10 17:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 17:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177632', 'tblTempUsageDetail_20' ) start [2025-11-10 17:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177632', 'tblTempUsageDetail_20' ) end [2025-11-10 17:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177632', 'tblTempVendorCDR_20' ) start [2025-11-10 17:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177632', 'tblTempVendorCDR_20' ) end [2025-11-10 17:00:23] Production.INFO: ProcessCDR(1,16177632,1,1,2) [2025-11-10 17:00:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16177632,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 17:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16177632,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 17:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16177632,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 17:00:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16177632,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 17:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177632', 'tblTempUsageDetail_20' ) start [2025-11-10 17:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177632', 'tblTempUsageDetail_20' ) end [2025-11-10 17:00:35] Production.ERROR: pbx prc_insertCDR start [2025-11-10 17:00:38] Production.ERROR: pbx prc_insertCDR end [2025-11-10 17:00:38] Production.INFO: ==8709== Releasing lock... [2025-11-10 17:00:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 17:00:38] Production.INFO: 70 MB #Memory Used# [2025-11-10 18:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 15:00:06 [end_date_ymd] => 2025-11-10 18:00:06 [RateCDR] => 1 ) [2025-11-10 18:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 15:00:06' and `end` < '2025-11-10 18:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 18:00:19] Production.INFO: count ==5112 [2025-11-10 18:00:22] Production.ERROR: pbx CDR StartTime 2025-11-10 15:00:06 - End Time 2025-11-10 18:00:06 [2025-11-10 18:00:22] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 18:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177876', 'tblTempUsageDetail_20' ) start [2025-11-10 18:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16177876', 'tblTempUsageDetail_20' ) end [2025-11-10 18:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177876', 'tblTempVendorCDR_20' ) start [2025-11-10 18:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16177876', 'tblTempVendorCDR_20' ) end [2025-11-10 18:00:22] Production.INFO: ProcessCDR(1,16177876,1,1,2) [2025-11-10 18:00:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16177876,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 18:00:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16177876,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 18:00:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16177876,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 18:00:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16177876,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 18:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177876', 'tblTempUsageDetail_20' ) start [2025-11-10 18:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16177876', 'tblTempUsageDetail_20' ) end [2025-11-10 18:00:33] Production.ERROR: pbx prc_insertCDR start [2025-11-10 18:00:35] Production.ERROR: pbx prc_insertCDR end [2025-11-10 18:00:35] Production.INFO: ==12996== Releasing lock... [2025-11-10 18:00:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 18:00:35] Production.INFO: 66.5 MB #Memory Used# [2025-11-10 19:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 16:00:06 [end_date_ymd] => 2025-11-10 19:00:06 [RateCDR] => 1 ) [2025-11-10 19:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 16:00:06' and `end` < '2025-11-10 19:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 19:00:19] Production.INFO: count ==3864 [2025-11-10 19:00:21] Production.ERROR: pbx CDR StartTime 2025-11-10 16:00:06 - End Time 2025-11-10 19:00:06 [2025-11-10 19:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178123', 'tblTempUsageDetail_20' ) start [2025-11-10 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178123', 'tblTempUsageDetail_20' ) end [2025-11-10 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178123', 'tblTempVendorCDR_20' ) start [2025-11-10 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178123', 'tblTempVendorCDR_20' ) end [2025-11-10 19:00:21] Production.INFO: ProcessCDR(1,16178123,1,1,2) [2025-11-10 19:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16178123,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 19:00:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16178123,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 19:00:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16178123,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 19:00:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16178123,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 19:00:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178123', 'tblTempUsageDetail_20' ) start [2025-11-10 19:00:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178123', 'tblTempUsageDetail_20' ) end [2025-11-10 19:00:32] Production.ERROR: pbx prc_insertCDR start [2025-11-10 19:00:33] Production.ERROR: pbx prc_insertCDR end [2025-11-10 19:00:33] Production.INFO: ==17309== Releasing lock... [2025-11-10 19:00:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 19:00:33] Production.INFO: 57.25 MB #Memory Used# [2025-11-10 20:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 17:00:06 [end_date_ymd] => 2025-11-10 20:00:06 [RateCDR] => 1 ) [2025-11-10 20:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 17:00:06' and `end` < '2025-11-10 20:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 20:00:18] Production.INFO: count ==2703 [2025-11-10 20:00:20] Production.ERROR: pbx CDR StartTime 2025-11-10 17:00:06 - End Time 2025-11-10 20:00:06 [2025-11-10 20:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178370', 'tblTempUsageDetail_20' ) start [2025-11-10 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178370', 'tblTempUsageDetail_20' ) end [2025-11-10 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178370', 'tblTempVendorCDR_20' ) start [2025-11-10 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178370', 'tblTempVendorCDR_20' ) end [2025-11-10 20:00:20] Production.INFO: ProcessCDR(1,16178370,1,1,2) [2025-11-10 20:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16178370,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 20:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16178370,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 20:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16178370,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 20:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16178370,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 20:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178370', 'tblTempUsageDetail_20' ) start [2025-11-10 20:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178370', 'tblTempUsageDetail_20' ) end [2025-11-10 20:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-10 20:00:31] Production.ERROR: pbx prc_insertCDR end [2025-11-10 20:00:31] Production.INFO: ==21935== Releasing lock... [2025-11-10 20:00:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 20:00:31] Production.INFO: 49.5 MB #Memory Used# [2025-11-10 21:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 18:00:06 [end_date_ymd] => 2025-11-10 21:00:06 [RateCDR] => 1 ) [2025-11-10 21:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 18:00:06' and `end` < '2025-11-10 21:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 21:00:18] Production.INFO: count ==1934 [2025-11-10 21:00:19] Production.ERROR: pbx CDR StartTime 2025-11-10 18:00:06 - End Time 2025-11-10 21:00:06 [2025-11-10 21:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178617', 'tblTempUsageDetail_20' ) start [2025-11-10 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178617', 'tblTempUsageDetail_20' ) end [2025-11-10 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178617', 'tblTempVendorCDR_20' ) start [2025-11-10 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178617', 'tblTempVendorCDR_20' ) end [2025-11-10 21:00:19] Production.INFO: ProcessCDR(1,16178617,1,1,2) [2025-11-10 21:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16178617,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 21:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16178617,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 21:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16178617,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 21:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16178617,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 21:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178617', 'tblTempUsageDetail_20' ) start [2025-11-10 21:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178617', 'tblTempUsageDetail_20' ) end [2025-11-10 21:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-10 21:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-10 21:00:30] Production.INFO: ==26741== Releasing lock... [2025-11-10 21:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 21:00:30] Production.INFO: 42.75 MB #Memory Used# [2025-11-10 22:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 19:00:07 [end_date_ymd] => 2025-11-10 22:00:07 [RateCDR] => 1 ) [2025-11-10 22:00:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 19:00:07' and `end` < '2025-11-10 22:00:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 22:00:19] Production.INFO: count ==1600 [2025-11-10 22:00:19] Production.ERROR: pbx CDR StartTime 2025-11-10 19:00:07 - End Time 2025-11-10 22:00:07 [2025-11-10 22:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178863', 'tblTempUsageDetail_20' ) start [2025-11-10 22:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16178863', 'tblTempUsageDetail_20' ) end [2025-11-10 22:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178863', 'tblTempVendorCDR_20' ) start [2025-11-10 22:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16178863', 'tblTempVendorCDR_20' ) end [2025-11-10 22:00:20] Production.INFO: ProcessCDR(1,16178863,1,1,2) [2025-11-10 22:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16178863,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 22:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16178863,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 22:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16178863,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 22:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16178863,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 22:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178863', 'tblTempUsageDetail_20' ) start [2025-11-10 22:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16178863', 'tblTempUsageDetail_20' ) end [2025-11-10 22:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-10 22:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-10 22:00:30] Production.INFO: ==31038== Releasing lock... [2025-11-10 22:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 22:00:30] Production.INFO: 40.25 MB #Memory Used# [2025-11-10 23:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-10 20:00:06 [end_date_ymd] => 2025-11-10 23:00:06 [RateCDR] => 1 ) [2025-11-10 23:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-11-10 20:00:06' and `end` < '2025-11-10 23:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-11-10 23:00:18] Production.INFO: count ==1189 [2025-11-10 23:00:18] Production.ERROR: pbx CDR StartTime 2025-11-10 20:00:06 - End Time 2025-11-10 23:00:06 [2025-11-10 23:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-10 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16179111', 'tblTempUsageDetail_20' ) start [2025-11-10 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16179111', 'tblTempUsageDetail_20' ) end [2025-11-10 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16179111', 'tblTempVendorCDR_20' ) start [2025-11-10 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16179111', 'tblTempVendorCDR_20' ) end [2025-11-10 23:00:18] Production.INFO: ProcessCDR(1,16179111,1,1,2) [2025-11-10 23:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16179111,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 23:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16179111,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-10 23:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16179111,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 23:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16179111,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-10 23:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16179111', 'tblTempUsageDetail_20' ) start [2025-11-10 23:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16179111', 'tblTempUsageDetail_20' ) end [2025-11-10 23:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-10 23:00:29] Production.ERROR: pbx prc_insertCDR end [2025-11-10 23:00:29] Production.INFO: ==2949== Releasing lock... [2025-11-10 23:00:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-10 23:00:29] Production.INFO: 37 MB #Memory Used#