[2026-03-24 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 21:02:06 [end_date_ymd] => 2026-03-24 00:02:06 [RateCDR] => 1 ) [2026-03-24 00:02: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` >= '2026-03-23 21:02:06' and `end` < '2026-03-24 00:02: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 ,'') [2026-03-24 00:02:29] Production.INFO: count ==659 [2026-03-24 00:02:30] Production.ERROR: pbx CDR StartTime 2026-03-23 21:02:06 - End Time 2026-03-24 00:02:06 [2026-03-24 00:02:30] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967512', 'tblTempUsageDetail_20' ) start [2026-03-24 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967512', 'tblTempUsageDetail_20' ) end [2026-03-24 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967512', 'tblTempVendorCDR_20' ) start [2026-03-24 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967512', 'tblTempVendorCDR_20' ) end [2026-03-24 00:02:30] Production.INFO: ProcessCDR(1,16967512,1,1,2) [2026-03-24 00:02:30] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16967512,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 00:06:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16967512,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 00:06:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16967512,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 00:10:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16967512,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 00:10:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967512', 'tblTempUsageDetail_20' ) start [2026-03-24 00:10:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967512', 'tblTempUsageDetail_20' ) end [2026-03-24 00:10:49] Production.ERROR: pbx prc_insertCDR start [2026-03-24 00:10:49] Production.ERROR: pbx prc_insertCDR end [2026-03-24 00:10:51] Production.INFO: ==20899== Releasing lock... [2026-03-24 00:10:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 00:10:51] Production.INFO: 37.75 MB #Memory Used# [2026-03-24 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 22:02:05 [end_date_ymd] => 2026-03-24 01:02:05 [RateCDR] => 1 ) [2026-03-24 01:02:05] 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` >= '2026-03-23 22:02:05' and `end` < '2026-03-24 01:02:05' 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 ,'') [2026-03-24 01:02:17] Production.INFO: count ==496 [2026-03-24 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 22:02:05 - End Time 2026-03-24 01:02:05 [2026-03-24 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967759', 'tblTempUsageDetail_20' ) start [2026-03-24 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967759', 'tblTempUsageDetail_20' ) end [2026-03-24 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967759', 'tblTempVendorCDR_20' ) start [2026-03-24 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967759', 'tblTempVendorCDR_20' ) end [2026-03-24 01:02:17] Production.INFO: ProcessCDR(1,16967759,1,1,2) [2026-03-24 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16967759,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 01:06:02] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16967759,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 01:06:02] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16967759,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 01:10:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16967759,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 01:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967759', 'tblTempUsageDetail_20' ) start [2026-03-24 01:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967759', 'tblTempUsageDetail_20' ) end [2026-03-24 01:10:36] Production.ERROR: pbx prc_insertCDR start [2026-03-24 01:10:36] Production.ERROR: pbx prc_insertCDR end [2026-03-24 01:10:36] Production.INFO: ==25691== Releasing lock... [2026-03-24 01:10:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 01:10:36] Production.INFO: 32.25 MB #Memory Used# [2026-03-24 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 23:02:05 [end_date_ymd] => 2026-03-24 02:02:05 [RateCDR] => 1 ) [2026-03-24 02:02:05] 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` >= '2026-03-23 23:02:05' and `end` < '2026-03-24 02:02:05' 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 ,'') [2026-03-24 02:02:17] Production.INFO: count ==478 [2026-03-24 02:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 23:02:05 - End Time 2026-03-24 02:02:05 [2026-03-24 02:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968006', 'tblTempUsageDetail_20' ) start [2026-03-24 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968006', 'tblTempUsageDetail_20' ) end [2026-03-24 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968006', 'tblTempVendorCDR_20' ) start [2026-03-24 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968006', 'tblTempVendorCDR_20' ) end [2026-03-24 02:02:17] Production.INFO: ProcessCDR(1,16968006,1,1,2) [2026-03-24 02:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16968006,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 02:05:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16968006,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 02:05:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16968006,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 02:10:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16968006,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 02:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968006', 'tblTempUsageDetail_20' ) start [2026-03-24 02:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968006', 'tblTempUsageDetail_20' ) end [2026-03-24 02:10:42] Production.ERROR: pbx prc_insertCDR start [2026-03-24 02:10:43] Production.ERROR: pbx prc_insertCDR end [2026-03-24 02:10:43] Production.INFO: ==30294== Releasing lock... [2026-03-24 02:10:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 02:10:43] Production.INFO: 32 MB #Memory Used# [2026-03-24 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 00:02:05 [end_date_ymd] => 2026-03-24 03:02:05 [RateCDR] => 1 ) [2026-03-24 03:02:05] 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` >= '2026-03-24 00:02:05' and `end` < '2026-03-24 03:02:05' 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 ,'') [2026-03-24 03:02:16] Production.INFO: count ==409 [2026-03-24 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 00:02:05 - End Time 2026-03-24 03:02:05 [2026-03-24 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968253', 'tblTempUsageDetail_20' ) start [2026-03-24 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968253', 'tblTempUsageDetail_20' ) end [2026-03-24 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968253', 'tblTempVendorCDR_20' ) start [2026-03-24 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968253', 'tblTempVendorCDR_20' ) end [2026-03-24 03:02:17] Production.INFO: ProcessCDR(1,16968253,1,1,2) [2026-03-24 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16968253,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 03:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16968253,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 03:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16968253,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 03:10:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16968253,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 03:10:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968253', 'tblTempUsageDetail_20' ) start [2026-03-24 03:10:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968253', 'tblTempUsageDetail_20' ) end [2026-03-24 03:10:29] Production.ERROR: pbx prc_insertCDR start [2026-03-24 03:10:29] Production.ERROR: pbx prc_insertCDR end [2026-03-24 03:10:29] Production.INFO: ==2465== Releasing lock... [2026-03-24 03:10:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 03:10:29] Production.INFO: 32.5 MB #Memory Used# [2026-03-24 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 01:02:05 [end_date_ymd] => 2026-03-24 04:02:05 [RateCDR] => 1 ) [2026-03-24 04:02:05] 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` >= '2026-03-24 01:02:05' and `end` < '2026-03-24 04:02:05' 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 ,'') [2026-03-24 04:02:16] Production.INFO: count ==304 [2026-03-24 04:02:16] Production.ERROR: pbx CDR StartTime 2026-03-24 01:02:05 - End Time 2026-03-24 04:02:05 [2026-03-24 04:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968501', 'tblTempUsageDetail_20' ) start [2026-03-24 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968501', 'tblTempUsageDetail_20' ) end [2026-03-24 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968501', 'tblTempVendorCDR_20' ) start [2026-03-24 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968501', 'tblTempVendorCDR_20' ) end [2026-03-24 04:02:16] Production.INFO: ProcessCDR(1,16968501,1,1,2) [2026-03-24 04:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16968501,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 04:05:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16968501,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 04:05:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16968501,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 04:10:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16968501,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 04:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968501', 'tblTempUsageDetail_20' ) start [2026-03-24 04:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968501', 'tblTempUsageDetail_20' ) end [2026-03-24 04:10:27] Production.ERROR: pbx prc_insertCDR start [2026-03-24 04:10:27] Production.ERROR: pbx prc_insertCDR end [2026-03-24 04:10:27] Production.INFO: ==7052== Releasing lock... [2026-03-24 04:10:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 04:10:27] Production.INFO: 31.25 MB #Memory Used# [2026-03-24 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 02:02:05 [end_date_ymd] => 2026-03-24 05:02:05 [RateCDR] => 1 ) [2026-03-24 05:02:05] 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` >= '2026-03-24 02:02:05' and `end` < '2026-03-24 05:02:05' 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 ,'') [2026-03-24 05:02:17] Production.INFO: count ==183 [2026-03-24 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 02:02:05 - End Time 2026-03-24 05:02:05 [2026-03-24 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968749', 'tblTempUsageDetail_20' ) start [2026-03-24 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968749', 'tblTempUsageDetail_20' ) end [2026-03-24 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968749', 'tblTempVendorCDR_20' ) start [2026-03-24 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968749', 'tblTempVendorCDR_20' ) end [2026-03-24 05:02:17] Production.INFO: ProcessCDR(1,16968749,1,1,2) [2026-03-24 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16968749,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 05:06:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16968749,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 05:06:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16968749,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 05:11:07] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16968749,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 05:11:07] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968749', 'tblTempUsageDetail_20' ) start [2026-03-24 05:11:08] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968749', 'tblTempUsageDetail_20' ) end [2026-03-24 05:11:08] Production.ERROR: pbx prc_insertCDR start [2026-03-24 05:11:08] Production.ERROR: pbx prc_insertCDR end [2026-03-24 05:11:08] Production.INFO: ==11630== Releasing lock... [2026-03-24 05:11:08] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 05:11:08] Production.INFO: 29.75 MB #Memory Used# [2026-03-24 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 03:02:05 [end_date_ymd] => 2026-03-24 06:02:05 [RateCDR] => 1 ) [2026-03-24 06:02:05] 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` >= '2026-03-24 03:02:05' and `end` < '2026-03-24 06:02:05' 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 ,'') [2026-03-24 06:02:17] Production.INFO: count ==101 [2026-03-24 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 03:02:05 - End Time 2026-03-24 06:02:05 [2026-03-24 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968996', 'tblTempUsageDetail_20' ) start [2026-03-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16968996', 'tblTempUsageDetail_20' ) end [2026-03-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968996', 'tblTempVendorCDR_20' ) start [2026-03-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16968996', 'tblTempVendorCDR_20' ) end [2026-03-24 06:02:17] Production.INFO: ProcessCDR(1,16968996,1,1,2) [2026-03-24 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16968996,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 06:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16968996,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 06:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16968996,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 06:10:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16968996,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 06:10:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968996', 'tblTempUsageDetail_20' ) start [2026-03-24 06:10:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16968996', 'tblTempUsageDetail_20' ) end [2026-03-24 06:10:34] Production.ERROR: pbx prc_insertCDR start [2026-03-24 06:10:34] Production.ERROR: pbx prc_insertCDR end [2026-03-24 06:10:34] Production.INFO: ==16308== Releasing lock... [2026-03-24 06:10:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 06:10:34] Production.INFO: 28.75 MB #Memory Used# [2026-03-24 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 04:02:05 [end_date_ymd] => 2026-03-24 07:02:05 [RateCDR] => 1 ) [2026-03-24 07:02:05] 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` >= '2026-03-24 04:02:05' and `end` < '2026-03-24 07:02:05' 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 ,'') [2026-03-24 07:02:17] Production.INFO: count ==85 [2026-03-24 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 04:02:05 - End Time 2026-03-24 07:02:05 [2026-03-24 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969243', 'tblTempUsageDetail_20' ) start [2026-03-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969243', 'tblTempUsageDetail_20' ) end [2026-03-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969243', 'tblTempVendorCDR_20' ) start [2026-03-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969243', 'tblTempVendorCDR_20' ) end [2026-03-24 07:02:17] Production.INFO: ProcessCDR(1,16969243,1,1,2) [2026-03-24 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16969243,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 07:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16969243,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 07:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16969243,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 07:10:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16969243,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 07:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969243', 'tblTempUsageDetail_20' ) start [2026-03-24 07:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969243', 'tblTempUsageDetail_20' ) end [2026-03-24 07:10:36] Production.ERROR: pbx prc_insertCDR start [2026-03-24 07:10:36] Production.ERROR: pbx prc_insertCDR end [2026-03-24 07:10:36] Production.INFO: ==20833== Releasing lock... [2026-03-24 07:10:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 07:10:36] Production.INFO: 28.5 MB #Memory Used# [2026-03-24 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 05:02:06 [end_date_ymd] => 2026-03-24 08:02:06 [RateCDR] => 1 ) [2026-03-24 08:02: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` >= '2026-03-24 05:02:06' and `end` < '2026-03-24 08:02: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 ,'') [2026-03-24 08:02:17] Production.INFO: count ==149 [2026-03-24 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 05:02:06 - End Time 2026-03-24 08:02:06 [2026-03-24 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969490', 'tblTempUsageDetail_20' ) start [2026-03-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969490', 'tblTempUsageDetail_20' ) end [2026-03-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969490', 'tblTempVendorCDR_20' ) start [2026-03-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969490', 'tblTempVendorCDR_20' ) end [2026-03-24 08:02:17] Production.INFO: ProcessCDR(1,16969490,1,1,2) [2026-03-24 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16969490,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 08:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16969490,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 08:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16969490,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 08:10:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16969490,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 08:10:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969490', 'tblTempUsageDetail_20' ) start [2026-03-24 08:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969490', 'tblTempUsageDetail_20' ) end [2026-03-24 08:10:36] Production.ERROR: pbx prc_insertCDR start [2026-03-24 08:10:36] Production.ERROR: pbx prc_insertCDR end [2026-03-24 08:10:36] Production.INFO: ==25283== Releasing lock... [2026-03-24 08:10:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 08:10:36] Production.INFO: 29.5 MB #Memory Used# [2026-03-24 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 06:02:06 [end_date_ymd] => 2026-03-24 09:02:06 [RateCDR] => 1 ) [2026-03-24 09:02: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` >= '2026-03-24 06:02:06' and `end` < '2026-03-24 09:02: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 ,'') [2026-03-24 09:02:17] Production.INFO: count ==639 [2026-03-24 09:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 06:02:06 - End Time 2026-03-24 09:02:06 [2026-03-24 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969737', 'tblTempUsageDetail_20' ) start [2026-03-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969737', 'tblTempUsageDetail_20' ) end [2026-03-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969737', 'tblTempVendorCDR_20' ) start [2026-03-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969737', 'tblTempVendorCDR_20' ) end [2026-03-24 09:02:17] Production.INFO: ProcessCDR(1,16969737,1,1,2) [2026-03-24 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16969737,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 09:05:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16969737,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 09:05:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16969737,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 09:10:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16969737,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 09:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969737', 'tblTempUsageDetail_20' ) start [2026-03-24 09:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969737', 'tblTempUsageDetail_20' ) end [2026-03-24 09:10:37] Production.ERROR: pbx prc_insertCDR start [2026-03-24 09:10:37] Production.ERROR: pbx prc_insertCDR end [2026-03-24 09:10:37] Production.INFO: ==29834== Releasing lock... [2026-03-24 09:10:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 09:10:37] Production.INFO: 33.25 MB #Memory Used# [2026-03-24 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 07:02:05 [end_date_ymd] => 2026-03-24 10:02:05 [RateCDR] => 1 ) [2026-03-24 10:02:05] 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` >= '2026-03-24 07:02:05' and `end` < '2026-03-24 10:02:05' 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 ,'') [2026-03-24 10:02:16] Production.INFO: count ==2255 [2026-03-24 10:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 07:02:05 - End Time 2026-03-24 10:02:05 [2026-03-24 10:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969984', 'tblTempUsageDetail_20' ) start [2026-03-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16969984', 'tblTempUsageDetail_20' ) end [2026-03-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969984', 'tblTempVendorCDR_20' ) start [2026-03-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16969984', 'tblTempVendorCDR_20' ) end [2026-03-24 10:02:18] Production.INFO: ProcessCDR(1,16969984,1,1,2) [2026-03-24 10:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16969984,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 10:06:05] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16969984,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 10:06:05] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16969984,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 10:10:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16969984,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 10:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969984', 'tblTempUsageDetail_20' ) start [2026-03-24 10:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16969984', 'tblTempUsageDetail_20' ) end [2026-03-24 10:10:38] Production.ERROR: pbx prc_insertCDR start [2026-03-24 10:10:41] Production.ERROR: pbx prc_insertCDR end [2026-03-24 10:10:41] Production.INFO: ==2239== Releasing lock... [2026-03-24 10:10:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 10:10:41] Production.INFO: 45.5 MB #Memory Used# [2026-03-24 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 08:02:05 [end_date_ymd] => 2026-03-24 11:02:05 [RateCDR] => 1 ) [2026-03-24 11:02:05] 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` >= '2026-03-24 08:02:05' and `end` < '2026-03-24 11:02:05' 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 ,'') [2026-03-24 11:02:22] Production.INFO: count ==3896 [2026-03-24 11:02:24] Production.ERROR: pbx CDR StartTime 2026-03-24 08:02:05 - End Time 2026-03-24 11:02:05 [2026-03-24 11:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 11:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970231', 'tblTempUsageDetail_20' ) start [2026-03-24 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970231', 'tblTempUsageDetail_20' ) end [2026-03-24 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970231', 'tblTempVendorCDR_20' ) start [2026-03-24 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970231', 'tblTempVendorCDR_20' ) end [2026-03-24 11:02:25] Production.INFO: ProcessCDR(1,16970231,1,1,2) [2026-03-24 11:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16970231,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 11:06:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16970231,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 11:06:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16970231,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 11:11:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16970231,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 11:11:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970231', 'tblTempUsageDetail_20' ) start [2026-03-24 11:11:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970231', 'tblTempUsageDetail_20' ) end [2026-03-24 11:11:33] Production.ERROR: pbx prc_insertCDR start [2026-03-24 11:11:36] Production.ERROR: pbx prc_insertCDR end [2026-03-24 11:11:36] Production.INFO: ==6872== Releasing lock... [2026-03-24 11:11:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 11:11:36] Production.INFO: 57.25 MB #Memory Used# [2026-03-24 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 09:02:05 [end_date_ymd] => 2026-03-24 12:02:05 [RateCDR] => 1 ) [2026-03-24 12:02:05] 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` >= '2026-03-24 09:02:05' and `end` < '2026-03-24 12:02:05' 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 ,'') [2026-03-24 12:02:20] Production.INFO: count ==5233 [2026-03-24 12:02:22] Production.ERROR: pbx CDR StartTime 2026-03-24 09:02:05 - End Time 2026-03-24 12:02:05 [2026-03-24 12:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 12:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970478', 'tblTempUsageDetail_20' ) start [2026-03-24 12:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970478', 'tblTempUsageDetail_20' ) end [2026-03-24 12:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970478', 'tblTempVendorCDR_20' ) start [2026-03-24 12:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970478', 'tblTempVendorCDR_20' ) end [2026-03-24 12:02:23] Production.INFO: ProcessCDR(1,16970478,1,1,2) [2026-03-24 12:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16970478,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 12:06:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16970478,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 12:06:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16970478,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 12:11:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16970478,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 12:11:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970478', 'tblTempUsageDetail_20' ) start [2026-03-24 12:11:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970478', 'tblTempUsageDetail_20' ) end [2026-03-24 12:11:23] Production.ERROR: pbx prc_insertCDR start [2026-03-24 12:11:26] Production.ERROR: pbx prc_insertCDR end [2026-03-24 12:11:26] Production.INFO: ==11372== Releasing lock... [2026-03-24 12:11:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 12:11:26] Production.INFO: 67.5 MB #Memory Used# [2026-03-24 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 10:02:05 [end_date_ymd] => 2026-03-24 13:02:05 [RateCDR] => 1 ) [2026-03-24 13:02: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` >= '2026-03-24 10:02:05' and `end` < '2026-03-24 13:02:05' 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 ,'') [2026-03-24 13:02:20] Production.INFO: count ==5528 [2026-03-24 13:02:22] Production.ERROR: pbx CDR StartTime 2026-03-24 10:02:05 - End Time 2026-03-24 13:02:05 [2026-03-24 13:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970725', 'tblTempUsageDetail_20' ) start [2026-03-24 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970725', 'tblTempUsageDetail_20' ) end [2026-03-24 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970725', 'tblTempVendorCDR_20' ) start [2026-03-24 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970725', 'tblTempVendorCDR_20' ) end [2026-03-24 13:02:23] Production.INFO: ProcessCDR(1,16970725,1,1,2) [2026-03-24 13:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16970725,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 13:06:03] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16970725,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 13:06:03] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16970725,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 13:10:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16970725,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 13:10:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970725', 'tblTempUsageDetail_20' ) start [2026-03-24 13:10:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970725', 'tblTempUsageDetail_20' ) end [2026-03-24 13:10:32] Production.ERROR: pbx prc_insertCDR start [2026-03-24 13:10:35] Production.ERROR: pbx prc_insertCDR end [2026-03-24 13:10:35] Production.INFO: ==16025== Releasing lock... [2026-03-24 13:10:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 13:10:35] Production.INFO: 69.75 MB #Memory Used# [2026-03-24 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 11:02:06 [end_date_ymd] => 2026-03-24 14:02:06 [RateCDR] => 1 ) [2026-03-24 14:02: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` >= '2026-03-24 11:02:06' and `end` < '2026-03-24 14:02: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 ,'') [2026-03-24 14:02:18] Production.INFO: count ==5771 [2026-03-24 14:02:21] Production.ERROR: pbx CDR StartTime 2026-03-24 11:02:06 - End Time 2026-03-24 14:02:06 [2026-03-24 14:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970972', 'tblTempUsageDetail_20' ) start [2026-03-24 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16970972', 'tblTempUsageDetail_20' ) end [2026-03-24 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970972', 'tblTempVendorCDR_20' ) start [2026-03-24 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16970972', 'tblTempVendorCDR_20' ) end [2026-03-24 14:02:22] Production.INFO: ProcessCDR(1,16970972,1,1,2) [2026-03-24 14:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16970972,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 14:06:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16970972,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 14:06:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16970972,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 14:10:51] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16970972,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 14:10:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970972', 'tblTempUsageDetail_20' ) start [2026-03-24 14:10:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16970972', 'tblTempUsageDetail_20' ) end [2026-03-24 14:10:51] Production.ERROR: pbx prc_insertCDR start [2026-03-24 14:10:53] Production.ERROR: pbx prc_insertCDR end [2026-03-24 14:10:53] Production.INFO: ==21344== Releasing lock... [2026-03-24 14:10:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 14:10:53] Production.INFO: 71.5 MB #Memory Used# [2026-03-24 15:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 12:02:06 [end_date_ymd] => 2026-03-24 15:02:06 [RateCDR] => 1 ) [2026-03-24 15:02: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` >= '2026-03-24 12:02:06' and `end` < '2026-03-24 15:02: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 ,'') [2026-03-24 15:02:21] Production.INFO: count ==5829 [2026-03-24 15:02:23] Production.ERROR: pbx CDR StartTime 2026-03-24 12:02:06 - End Time 2026-03-24 15:02:06 [2026-03-24 15:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971219', 'tblTempUsageDetail_20' ) start [2026-03-24 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971219', 'tblTempUsageDetail_20' ) end [2026-03-24 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971219', 'tblTempVendorCDR_20' ) start [2026-03-24 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971219', 'tblTempVendorCDR_20' ) end [2026-03-24 15:02:24] Production.INFO: ProcessCDR(1,16971219,1,1,2) [2026-03-24 15:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16971219,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 15:06:15] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16971219,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 15:06:15] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16971219,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 15:10:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16971219,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 15:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971219', 'tblTempUsageDetail_20' ) start [2026-03-24 15:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971219', 'tblTempUsageDetail_20' ) end [2026-03-24 15:10:42] Production.ERROR: pbx prc_insertCDR start [2026-03-24 15:10:45] Production.ERROR: pbx prc_insertCDR end [2026-03-24 15:10:45] Production.INFO: ==25773== Releasing lock... [2026-03-24 15:10:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 15:10:45] Production.INFO: 72 MB #Memory Used# [2026-03-24 16:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 13:02:06 [end_date_ymd] => 2026-03-24 16:02:06 [RateCDR] => 1 ) [2026-03-24 16:02: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` >= '2026-03-24 13:02:06' and `end` < '2026-03-24 16:02: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 ,'') [2026-03-24 16:02:20] Production.INFO: count ==5848 [2026-03-24 16:02:23] Production.ERROR: pbx CDR StartTime 2026-03-24 13:02:06 - End Time 2026-03-24 16:02:06 [2026-03-24 16:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971466', 'tblTempUsageDetail_20' ) start [2026-03-24 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971466', 'tblTempUsageDetail_20' ) end [2026-03-24 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971466', 'tblTempVendorCDR_20' ) start [2026-03-24 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971466', 'tblTempVendorCDR_20' ) end [2026-03-24 16:02:24] Production.INFO: ProcessCDR(1,16971466,1,1,2) [2026-03-24 16:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16971466,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 16:06:02] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16971466,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 16:06:02] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16971466,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 16:10:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16971466,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 16:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971466', 'tblTempUsageDetail_20' ) start [2026-03-24 16:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971466', 'tblTempUsageDetail_20' ) end [2026-03-24 16:10:42] Production.ERROR: pbx prc_insertCDR start [2026-03-24 16:10:46] Production.ERROR: pbx prc_insertCDR end [2026-03-24 16:10:46] Production.INFO: ==30224== Releasing lock... [2026-03-24 16:10:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 16:10:46] Production.INFO: 72 MB #Memory Used# [2026-03-24 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 14:02:05 [end_date_ymd] => 2026-03-24 17:02:05 [RateCDR] => 1 ) [2026-03-24 17:02:05] 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` >= '2026-03-24 14:02:05' and `end` < '2026-03-24 17:02:05' 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 ,'') [2026-03-24 17:02:20] Production.INFO: count ==5706 [2026-03-24 17:02:23] Production.ERROR: pbx CDR StartTime 2026-03-24 14:02:05 - End Time 2026-03-24 17:02:05 [2026-03-24 17:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971713', 'tblTempUsageDetail_20' ) start [2026-03-24 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971713', 'tblTempUsageDetail_20' ) end [2026-03-24 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971713', 'tblTempVendorCDR_20' ) start [2026-03-24 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971713', 'tblTempVendorCDR_20' ) end [2026-03-24 17:02:24] Production.INFO: ProcessCDR(1,16971713,1,1,2) [2026-03-24 17:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16971713,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 17:06:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16971713,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 17:06:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16971713,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 17:10:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16971713,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 17:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971713', 'tblTempUsageDetail_20' ) start [2026-03-24 17:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971713', 'tblTempUsageDetail_20' ) end [2026-03-24 17:10:45] Production.ERROR: pbx prc_insertCDR start [2026-03-24 17:10:48] Production.ERROR: pbx prc_insertCDR end [2026-03-24 17:10:48] Production.INFO: ==2829== Releasing lock... [2026-03-24 17:10:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 17:10:48] Production.INFO: 71 MB #Memory Used# [2026-03-24 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 15:02:06 [end_date_ymd] => 2026-03-24 18:02:06 [RateCDR] => 1 ) [2026-03-24 18:02: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` >= '2026-03-24 15:02:06' and `end` < '2026-03-24 18:02: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 ,'') [2026-03-24 18:02:18] Production.INFO: count ==5081 [2026-03-24 18:02:21] Production.ERROR: pbx CDR StartTime 2026-03-24 15:02:06 - End Time 2026-03-24 18:02:06 [2026-03-24 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971960', 'tblTempUsageDetail_20' ) start [2026-03-24 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16971960', 'tblTempUsageDetail_20' ) end [2026-03-24 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971960', 'tblTempVendorCDR_20' ) start [2026-03-24 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16971960', 'tblTempVendorCDR_20' ) end [2026-03-24 18:02:22] Production.INFO: ProcessCDR(1,16971960,1,1,2) [2026-03-24 18:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16971960,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 18:06:15] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16971960,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 18:06:15] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16971960,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 18:10:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16971960,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 18:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971960', 'tblTempUsageDetail_20' ) start [2026-03-24 18:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16971960', 'tblTempUsageDetail_20' ) end [2026-03-24 18:10:45] Production.ERROR: pbx prc_insertCDR start [2026-03-24 18:10:47] Production.ERROR: pbx prc_insertCDR end [2026-03-24 18:10:47] Production.INFO: ==7351== Releasing lock... [2026-03-24 18:10:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 18:10:47] Production.INFO: 66.25 MB #Memory Used# [2026-03-24 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 16:02:05 [end_date_ymd] => 2026-03-24 19:02:05 [RateCDR] => 1 ) [2026-03-24 19:02:05] 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` >= '2026-03-24 16:02:05' and `end` < '2026-03-24 19:02:05' 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 ,'') [2026-03-24 19:02:17] Production.INFO: count ==4120 [2026-03-24 19:02:19] Production.ERROR: pbx CDR StartTime 2026-03-24 16:02:05 - End Time 2026-03-24 19:02:05 [2026-03-24 19:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972206', 'tblTempUsageDetail_20' ) start [2026-03-24 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972206', 'tblTempUsageDetail_20' ) end [2026-03-24 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972206', 'tblTempVendorCDR_20' ) start [2026-03-24 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972206', 'tblTempVendorCDR_20' ) end [2026-03-24 19:02:20] Production.INFO: ProcessCDR(1,16972206,1,1,2) [2026-03-24 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16972206,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 19:05:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16972206,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 19:05:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16972206,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 19:10:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16972206,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 19:10:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972206', 'tblTempUsageDetail_20' ) start [2026-03-24 19:10:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972206', 'tblTempUsageDetail_20' ) end [2026-03-24 19:10:25] Production.ERROR: pbx prc_insertCDR start [2026-03-24 19:10:26] Production.ERROR: pbx prc_insertCDR end [2026-03-24 19:10:26] Production.INFO: ==11895== Releasing lock... [2026-03-24 19:10:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 19:10:26] Production.INFO: 59.25 MB #Memory Used# [2026-03-24 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 17:02:05 [end_date_ymd] => 2026-03-24 20:02:05 [RateCDR] => 1 ) [2026-03-24 20:02:05] 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` >= '2026-03-24 17:02:05' and `end` < '2026-03-24 20:02:05' 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 ,'') [2026-03-24 20:02:17] Production.INFO: count ==2728 [2026-03-24 20:02:18] Production.ERROR: pbx CDR StartTime 2026-03-24 17:02:05 - End Time 2026-03-24 20:02:05 [2026-03-24 20:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972453', 'tblTempUsageDetail_20' ) start [2026-03-24 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972453', 'tblTempUsageDetail_20' ) end [2026-03-24 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972453', 'tblTempVendorCDR_20' ) start [2026-03-24 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972453', 'tblTempVendorCDR_20' ) end [2026-03-24 20:02:19] Production.INFO: ProcessCDR(1,16972453,1,1,2) [2026-03-24 20:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16972453,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 20:06:06] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16972453,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 20:06:06] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16972453,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 20:10:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16972453,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 20:10:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972453', 'tblTempUsageDetail_20' ) start [2026-03-24 20:10:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972453', 'tblTempUsageDetail_20' ) end [2026-03-24 20:10:40] Production.ERROR: pbx prc_insertCDR start [2026-03-24 20:10:40] Production.ERROR: pbx prc_insertCDR end [2026-03-24 20:10:40] Production.INFO: ==16412== Releasing lock... [2026-03-24 20:10:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 20:10:40] Production.INFO: 49 MB #Memory Used# [2026-03-24 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 18:02:05 [end_date_ymd] => 2026-03-24 21:02:05 [RateCDR] => 1 ) [2026-03-24 21:02:05] 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` >= '2026-03-24 18:02:05' and `end` < '2026-03-24 21:02:05' 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 ,'') [2026-03-24 21:02:16] Production.INFO: count ==1876 [2026-03-24 21:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 18:02:05 - End Time 2026-03-24 21:02:05 [2026-03-24 21:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972700', 'tblTempUsageDetail_20' ) start [2026-03-24 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972700', 'tblTempUsageDetail_20' ) end [2026-03-24 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972700', 'tblTempVendorCDR_20' ) start [2026-03-24 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972700', 'tblTempVendorCDR_20' ) end [2026-03-24 21:02:17] Production.INFO: ProcessCDR(1,16972700,1,1,2) [2026-03-24 21:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16972700,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 21:06:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16972700,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 21:06:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16972700,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 21:10:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16972700,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 21:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972700', 'tblTempUsageDetail_20' ) start [2026-03-24 21:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972700', 'tblTempUsageDetail_20' ) end [2026-03-24 21:10:43] Production.ERROR: pbx prc_insertCDR start [2026-03-24 21:10:44] Production.ERROR: pbx prc_insertCDR end [2026-03-24 21:10:44] Production.INFO: ==20798== Releasing lock... [2026-03-24 21:10:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 21:10:44] Production.INFO: 42.25 MB #Memory Used# [2026-03-24 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 19:02:06 [end_date_ymd] => 2026-03-24 22:02:06 [RateCDR] => 1 ) [2026-03-24 22:02: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` >= '2026-03-24 19:02:06' and `end` < '2026-03-24 22:02: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 ,'') [2026-03-24 22:02:17] Production.INFO: count ==1237 [2026-03-24 22:02:18] Production.ERROR: pbx CDR StartTime 2026-03-24 19:02:06 - End Time 2026-03-24 22:02:06 [2026-03-24 22:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972947', 'tblTempUsageDetail_20' ) start [2026-03-24 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16972947', 'tblTempUsageDetail_20' ) end [2026-03-24 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972947', 'tblTempVendorCDR_20' ) start [2026-03-24 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16972947', 'tblTempVendorCDR_20' ) end [2026-03-24 22:02:18] Production.INFO: ProcessCDR(1,16972947,1,1,2) [2026-03-24 22:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16972947,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 22:06:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16972947,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 22:06:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16972947,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 22:10:57] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16972947,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 22:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972947', 'tblTempUsageDetail_20' ) start [2026-03-24 22:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16972947', 'tblTempUsageDetail_20' ) end [2026-03-24 22:10:57] Production.ERROR: pbx prc_insertCDR start [2026-03-24 22:10:57] Production.ERROR: pbx prc_insertCDR end [2026-03-24 22:10:57] Production.INFO: ==25245== Releasing lock... [2026-03-24 22:10:57] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 22:10:57] Production.INFO: 37.75 MB #Memory Used# [2026-03-24 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 20:02:06 [end_date_ymd] => 2026-03-24 23:02:06 [RateCDR] => 1 ) [2026-03-24 23:02: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` >= '2026-03-24 20:02:06' and `end` < '2026-03-24 23:02: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 ,'') [2026-03-24 23:02:19] Production.INFO: count ==1039 [2026-03-24 23:02:19] Production.ERROR: pbx CDR StartTime 2026-03-24 20:02:06 - End Time 2026-03-24 23:02:06 [2026-03-24 23:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-24 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973194', 'tblTempUsageDetail_20' ) start [2026-03-24 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973194', 'tblTempUsageDetail_20' ) end [2026-03-24 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973194', 'tblTempVendorCDR_20' ) start [2026-03-24 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973194', 'tblTempVendorCDR_20' ) end [2026-03-24 23:02:19] Production.INFO: ProcessCDR(1,16973194,1,1,2) [2026-03-24 23:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16973194,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 23:06:12] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16973194,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-24 23:06:12] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16973194,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 23:10:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16973194,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-24 23:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973194', 'tblTempUsageDetail_20' ) start [2026-03-24 23:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973194', 'tblTempUsageDetail_20' ) end [2026-03-24 23:10:48] Production.ERROR: pbx prc_insertCDR start [2026-03-24 23:10:48] Production.ERROR: pbx prc_insertCDR end [2026-03-24 23:10:48] Production.INFO: ==29678== Releasing lock... [2026-03-24 23:10:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-24 23:10:48] Production.INFO: 36.5 MB #Memory Used#