[2026-01-19 00:01:05] Production.INFO: next invoice date [2026-01-19 00:01:05] Production.INFO: 2026-02-19 [2026-01-19 00:01:05] Production.INFO: getdaysdiff [2026-01-19 00:01:05] Production.INFO: +31 [2026-01-19 00:01:05] Production.INFO: call prc_setAccountDiscountPlan (108,15,1,31,31,'RMScheduler',2026-01-19 00:01:05,1,0,,,0) [2026-01-19 00:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-18 21:01:06 [end_date_ymd] => 2026-01-19 00:01:06 [RateCDR] => 1 ) [2026-01-19 00:01: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-01-18 21:01:06' and `end` < '2026-01-19 00:01: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-01-19 01:02:04] Production.ERROR: Array ( [start_date_ymd] => 2026-01-18 22:02:04 [end_date_ymd] => 2026-01-19 01:02:04 [RateCDR] => 1 ) [2026-01-19 01:02:04] 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-01-18 22:02:04' and `end` < '2026-01-19 01:02:04' 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-01-19 01:02:16] Production.INFO: count ==494 [2026-01-19 01:02:16] Production.ERROR: pbx CDR StartTime 2026-01-18 22:02:04 - End Time 2026-01-19 01:02:04 [2026-01-19 01:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 01:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16588622', 'tblTempUsageDetail_20' ) start [2026-01-19 01:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16588622', 'tblTempUsageDetail_20' ) end [2026-01-19 01:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16588622', 'tblTempVendorCDR_20' ) start [2026-01-19 01:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16588622', 'tblTempVendorCDR_20' ) end [2026-01-19 01:02:16] Production.INFO: ProcessCDR(1,16588622,1,1,2) [2026-01-19 01:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16588622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 01:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16588622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 01:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16588622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 01:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16588622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 01:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16588622', 'tblTempUsageDetail_20' ) start [2026-01-19 01:09:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16588622', 'tblTempUsageDetail_20' ) end [2026-01-19 01:09:25] Production.ERROR: pbx prc_insertCDR start [2026-01-19 01:09:25] Production.ERROR: pbx prc_insertCDR end [2026-01-19 01:09:27] Production.INFO: ==28302== Releasing lock... [2026-01-19 01:09:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 01:09:27] Production.INFO: 35.25 MB #Memory Used# [2026-01-19 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-18 23:02:05 [end_date_ymd] => 2026-01-19 02:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-18 23:02:05' and `end` < '2026-01-19 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-01-19 02:02:17] Production.INFO: count ==459 [2026-01-19 02:02:18] Production.ERROR: pbx CDR StartTime 2026-01-18 23:02:05 - End Time 2026-01-19 02:02:05 [2026-01-19 02:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16588869', 'tblTempUsageDetail_20' ) start [2026-01-19 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16588869', 'tblTempUsageDetail_20' ) end [2026-01-19 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16588869', 'tblTempVendorCDR_20' ) start [2026-01-19 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16588869', 'tblTempVendorCDR_20' ) end [2026-01-19 02:02:18] Production.INFO: ProcessCDR(1,16588869,1,1,2) [2026-01-19 02:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16588869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 02:05:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16588869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 02:05:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16588869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 02:09:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16588869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 02:09:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16588869', 'tblTempUsageDetail_20' ) start [2026-01-19 02:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16588869', 'tblTempUsageDetail_20' ) end [2026-01-19 02:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-19 02:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-19 02:09:26] Production.INFO: ==1963== Releasing lock... [2026-01-19 02:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 02:09:26] Production.INFO: 32.25 MB #Memory Used# [2026-01-19 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 00:02:05 [end_date_ymd] => 2026-01-19 03:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-19 00:02:05' and `end` < '2026-01-19 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-01-19 03:02:17] Production.INFO: count ==382 [2026-01-19 03:02:17] Production.ERROR: pbx CDR StartTime 2026-01-19 00:02:05 - End Time 2026-01-19 03:02:05 [2026-01-19 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589116', 'tblTempUsageDetail_20' ) start [2026-01-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589116', 'tblTempUsageDetail_20' ) end [2026-01-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589116', 'tblTempVendorCDR_20' ) start [2026-01-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589116', 'tblTempVendorCDR_20' ) end [2026-01-19 03:02:17] Production.INFO: ProcessCDR(1,16589116,1,1,2) [2026-01-19 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16589116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 03:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16589116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 03:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16589116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 03:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16589116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 03:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589116', 'tblTempUsageDetail_20' ) start [2026-01-19 03:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589116', 'tblTempUsageDetail_20' ) end [2026-01-19 03:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-19 03:09:24] Production.ERROR: pbx prc_insertCDR end [2026-01-19 03:09:24] Production.INFO: ==7410== Releasing lock... [2026-01-19 03:09:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 03:09:24] Production.INFO: 31.25 MB #Memory Used# [2026-01-19 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 01:02:06 [end_date_ymd] => 2026-01-19 04:02:06 [RateCDR] => 1 ) [2026-01-19 04: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-01-19 01:02:06' and `end` < '2026-01-19 04: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-01-19 04:02:18] Production.INFO: count ==244 [2026-01-19 04:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 01:02:06 - End Time 2026-01-19 04:02:06 [2026-01-19 04:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589364', 'tblTempUsageDetail_20' ) start [2026-01-19 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589364', 'tblTempUsageDetail_20' ) end [2026-01-19 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589364', 'tblTempVendorCDR_20' ) start [2026-01-19 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589364', 'tblTempVendorCDR_20' ) end [2026-01-19 04:02:18] Production.INFO: ProcessCDR(1,16589364,1,1,2) [2026-01-19 04:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16589364,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 04:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16589364,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 04:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16589364,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 04:09:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16589364,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 04:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589364', 'tblTempUsageDetail_20' ) start [2026-01-19 04:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589364', 'tblTempUsageDetail_20' ) end [2026-01-19 04:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-19 04:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-19 04:09:18] Production.INFO: ==13316== Releasing lock... [2026-01-19 04:09:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 04:09:18] Production.INFO: 30.25 MB #Memory Used# [2026-01-19 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 02:02:05 [end_date_ymd] => 2026-01-19 05:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-19 02:02:05' and `end` < '2026-01-19 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-01-19 05:02:18] Production.INFO: count ==162 [2026-01-19 05:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 02:02:05 - End Time 2026-01-19 05:02:05 [2026-01-19 05:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589612', 'tblTempUsageDetail_20' ) start [2026-01-19 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589612', 'tblTempUsageDetail_20' ) end [2026-01-19 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589612', 'tblTempVendorCDR_20' ) start [2026-01-19 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589612', 'tblTempVendorCDR_20' ) end [2026-01-19 05:02:18] Production.INFO: ProcessCDR(1,16589612,1,1,2) [2026-01-19 05:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16589612,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 05:05:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16589612,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 05:05:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16589612,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 05:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16589612,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 05:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589612', 'tblTempUsageDetail_20' ) start [2026-01-19 05:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589612', 'tblTempUsageDetail_20' ) end [2026-01-19 05:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-19 05:09:24] Production.ERROR: pbx prc_insertCDR end [2026-01-19 05:09:24] Production.INFO: ==19567== Releasing lock... [2026-01-19 05:09:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 05:09:24] Production.INFO: 29.5 MB #Memory Used# [2026-01-19 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 03:02:06 [end_date_ymd] => 2026-01-19 06:02:06 [RateCDR] => 1 ) [2026-01-19 06: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-01-19 03:02:06' and `end` < '2026-01-19 06: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-01-19 06:02:18] Production.INFO: count ==140 [2026-01-19 06:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 03:02:06 - End Time 2026-01-19 06:02:06 [2026-01-19 06:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589859', 'tblTempUsageDetail_20' ) start [2026-01-19 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16589859', 'tblTempUsageDetail_20' ) end [2026-01-19 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589859', 'tblTempVendorCDR_20' ) start [2026-01-19 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16589859', 'tblTempVendorCDR_20' ) end [2026-01-19 06:02:18] Production.INFO: ProcessCDR(1,16589859,1,1,2) [2026-01-19 06:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16589859,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 06:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16589859,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 06:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16589859,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 06:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16589859,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 06:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589859', 'tblTempUsageDetail_20' ) start [2026-01-19 06:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16589859', 'tblTempUsageDetail_20' ) end [2026-01-19 06:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-19 06:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-19 06:09:33] Production.INFO: ==26288== Releasing lock... [2026-01-19 06:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 06:09:33] Production.INFO: 29.5 MB #Memory Used# [2026-01-19 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 04:02:05 [end_date_ymd] => 2026-01-19 07:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-19 04:02:05' and `end` < '2026-01-19 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-01-19 07:02:17] Production.INFO: count ==106 [2026-01-19 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-19 04:02:05 - End Time 2026-01-19 07:02:05 [2026-01-19 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590106', 'tblTempUsageDetail_20' ) start [2026-01-19 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590106', 'tblTempUsageDetail_20' ) end [2026-01-19 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590106', 'tblTempVendorCDR_20' ) start [2026-01-19 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590106', 'tblTempVendorCDR_20' ) end [2026-01-19 07:02:17] Production.INFO: ProcessCDR(1,16590106,1,1,2) [2026-01-19 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16590106,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 07:04:49] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16590106,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 07:04:49] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16590106,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 07:08:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16590106,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 07:08:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590106', 'tblTempUsageDetail_20' ) start [2026-01-19 07:08:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590106', 'tblTempUsageDetail_20' ) end [2026-01-19 07:08:48] Production.ERROR: pbx prc_insertCDR start [2026-01-19 07:08:48] Production.ERROR: pbx prc_insertCDR end [2026-01-19 07:08:48] Production.INFO: ==32613== Releasing lock... [2026-01-19 07:08:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 07:08:48] Production.INFO: 28.75 MB #Memory Used# [2026-01-19 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 05:02:06 [end_date_ymd] => 2026-01-19 08:02:06 [RateCDR] => 1 ) [2026-01-19 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-01-19 05:02:06' and `end` < '2026-01-19 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-01-19 08:02:18] Production.INFO: count ==150 [2026-01-19 08:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 05:02:06 - End Time 2026-01-19 08:02:06 [2026-01-19 08:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590353', 'tblTempUsageDetail_20' ) start [2026-01-19 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590353', 'tblTempUsageDetail_20' ) end [2026-01-19 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590353', 'tblTempVendorCDR_20' ) start [2026-01-19 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590353', 'tblTempVendorCDR_20' ) end [2026-01-19 08:02:18] Production.INFO: ProcessCDR(1,16590353,1,1,2) [2026-01-19 08:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16590353,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 08:04:54] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16590353,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 08:04:54] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16590353,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 08:08:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16590353,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 08:08:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590353', 'tblTempUsageDetail_20' ) start [2026-01-19 08:08:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590353', 'tblTempUsageDetail_20' ) end [2026-01-19 08:08:56] Production.ERROR: pbx prc_insertCDR start [2026-01-19 08:08:56] Production.ERROR: pbx prc_insertCDR end [2026-01-19 08:08:56] Production.INFO: ==6398== Releasing lock... [2026-01-19 08:08:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 08:08:56] Production.INFO: 29.25 MB #Memory Used# [2026-01-19 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 06:02:05 [end_date_ymd] => 2026-01-19 09:02:05 [RateCDR] => 1 ) [2026-01-19 09: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-01-19 06:02:05' and `end` < '2026-01-19 09: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-01-19 09:02:17] Production.INFO: count ==961 [2026-01-19 09:02:17] Production.ERROR: pbx CDR StartTime 2026-01-19 06:02:05 - End Time 2026-01-19 09:02:05 [2026-01-19 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590600', 'tblTempUsageDetail_20' ) start [2026-01-19 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590600', 'tblTempUsageDetail_20' ) end [2026-01-19 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590600', 'tblTempVendorCDR_20' ) start [2026-01-19 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590600', 'tblTempVendorCDR_20' ) end [2026-01-19 09:02:18] Production.INFO: ProcessCDR(1,16590600,1,1,2) [2026-01-19 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16590600,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 09:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16590600,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 09:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16590600,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 09:09:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16590600,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 09:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590600', 'tblTempUsageDetail_20' ) start [2026-01-19 09:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590600', 'tblTempUsageDetail_20' ) end [2026-01-19 09:09:36] Production.ERROR: pbx prc_insertCDR start [2026-01-19 09:09:36] Production.ERROR: pbx prc_insertCDR end [2026-01-19 09:09:36] Production.INFO: ==12833== Releasing lock... [2026-01-19 09:09:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 09:09:36] Production.INFO: 36 MB #Memory Used# [2026-01-19 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 07:02:06 [end_date_ymd] => 2026-01-19 10:02:06 [RateCDR] => 1 ) [2026-01-19 10: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-01-19 07:02:06' and `end` < '2026-01-19 10: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-01-19 10:02:21] Production.INFO: count ==2980 [2026-01-19 10:02:22] Production.ERROR: pbx CDR StartTime 2026-01-19 07:02:06 - End Time 2026-01-19 10:02:06 [2026-01-19 10:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 10:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590847', 'tblTempUsageDetail_20' ) start [2026-01-19 10:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16590847', 'tblTempUsageDetail_20' ) end [2026-01-19 10:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590847', 'tblTempVendorCDR_20' ) start [2026-01-19 10:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16590847', 'tblTempVendorCDR_20' ) end [2026-01-19 10:02:22] Production.INFO: ProcessCDR(1,16590847,1,1,2) [2026-01-19 10:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16590847,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 10:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16590847,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 10:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16590847,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 10:09:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16590847,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 10:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590847', 'tblTempUsageDetail_20' ) start [2026-01-19 10:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16590847', 'tblTempUsageDetail_20' ) end [2026-01-19 10:09:31] Production.ERROR: pbx prc_insertCDR start [2026-01-19 10:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-19 10:09:33] Production.INFO: ==18078== Releasing lock... [2026-01-19 10:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 10:09:33] Production.INFO: 50.25 MB #Memory Used# [2026-01-19 11:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 08:02:06 [end_date_ymd] => 2026-01-19 11:02:06 [RateCDR] => 1 ) [2026-01-19 11: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-01-19 08:02:06' and `end` < '2026-01-19 11: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-01-19 11:02:19] Production.INFO: count ==5254 [2026-01-19 11:02:22] Production.ERROR: pbx CDR StartTime 2026-01-19 08:02:06 - End Time 2026-01-19 11:02:06 [2026-01-19 11:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591094', 'tblTempUsageDetail_20' ) start [2026-01-19 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591094', 'tblTempUsageDetail_20' ) end [2026-01-19 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591094', 'tblTempVendorCDR_20' ) start [2026-01-19 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591094', 'tblTempVendorCDR_20' ) end [2026-01-19 11:02:22] Production.INFO: ProcessCDR(1,16591094,1,1,2) [2026-01-19 11:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16591094,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 11:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16591094,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 11:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16591094,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 11:09:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16591094,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 11:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591094', 'tblTempUsageDetail_20' ) start [2026-01-19 11:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591094', 'tblTempUsageDetail_20' ) end [2026-01-19 11:09:36] Production.ERROR: pbx prc_insertCDR start [2026-01-19 11:09:39] Production.ERROR: pbx prc_insertCDR end [2026-01-19 11:09:39] Production.INFO: ==22979== Releasing lock... [2026-01-19 11:09:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 11:09:39] Production.INFO: 67.5 MB #Memory Used# [2026-01-19 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 09:02:06 [end_date_ymd] => 2026-01-19 12:02:06 [RateCDR] => 1 ) [2026-01-19 12: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-01-19 09:02:06' and `end` < '2026-01-19 12: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-01-19 12:02:27] Production.INFO: count ==6415 [2026-01-19 12:02:30] Production.ERROR: pbx CDR StartTime 2026-01-19 09:02:06 - End Time 2026-01-19 12:02:06 [2026-01-19 12:02:30] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 12:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591341', 'tblTempUsageDetail_20' ) start [2026-01-19 12:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591341', 'tblTempUsageDetail_20' ) end [2026-01-19 12:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591341', 'tblTempVendorCDR_20' ) start [2026-01-19 12:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591341', 'tblTempVendorCDR_20' ) end [2026-01-19 12:02:31] Production.INFO: ProcessCDR(1,16591341,1,1,2) [2026-01-19 12:02:31] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16591341,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 12:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16591341,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 12:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16591341,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 12:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16591341,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 12:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591341', 'tblTempUsageDetail_20' ) start [2026-01-19 12:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591341', 'tblTempUsageDetail_20' ) end [2026-01-19 12:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-19 12:09:38] Production.ERROR: pbx prc_insertCDR end [2026-01-19 12:09:38] Production.INFO: ==27527== Releasing lock... [2026-01-19 12:09:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 12:09:38] Production.INFO: 76.25 MB #Memory Used# [2026-01-19 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 10:02:05 [end_date_ymd] => 2026-01-19 13:02:05 [RateCDR] => 1 ) [2026-01-19 13: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-01-19 10:02:05' and `end` < '2026-01-19 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-01-19 13:02:19] Production.INFO: count ==6392 [2026-01-19 13:02:22] Production.ERROR: pbx CDR StartTime 2026-01-19 10:02:05 - End Time 2026-01-19 13:02:05 [2026-01-19 13:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591588', 'tblTempUsageDetail_20' ) start [2026-01-19 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591588', 'tblTempUsageDetail_20' ) end [2026-01-19 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591588', 'tblTempVendorCDR_20' ) start [2026-01-19 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591588', 'tblTempVendorCDR_20' ) end [2026-01-19 13:02:23] Production.INFO: ProcessCDR(1,16591588,1,1,2) [2026-01-19 13:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16591588,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 13:05:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16591588,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 13:05:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16591588,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 13:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16591588,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 13:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591588', 'tblTempUsageDetail_20' ) start [2026-01-19 13:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591588', 'tblTempUsageDetail_20' ) end [2026-01-19 13:09:44] Production.ERROR: pbx prc_insertCDR start [2026-01-19 13:09:47] Production.ERROR: pbx prc_insertCDR end [2026-01-19 13:09:47] Production.INFO: ==31925== Releasing lock... [2026-01-19 13:09:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 13:09:47] Production.INFO: 76 MB #Memory Used# [2026-01-19 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 11:02:05 [end_date_ymd] => 2026-01-19 14:02:05 [RateCDR] => 1 ) [2026-01-19 14: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-01-19 11:02:05' and `end` < '2026-01-19 14: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-01-19 14:02:20] Production.INFO: count ==6577 [2026-01-19 14:02:23] Production.ERROR: pbx CDR StartTime 2026-01-19 11:02:05 - End Time 2026-01-19 14:02:05 [2026-01-19 14:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591835', 'tblTempUsageDetail_20' ) start [2026-01-19 14:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16591835', 'tblTempUsageDetail_20' ) end [2026-01-19 14:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591835', 'tblTempVendorCDR_20' ) start [2026-01-19 14:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16591835', 'tblTempVendorCDR_20' ) end [2026-01-19 14:02:24] Production.INFO: ProcessCDR(1,16591835,1,1,2) [2026-01-19 14:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16591835,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 14:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16591835,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 14:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16591835,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 14:09:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16591835,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 14:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591835', 'tblTempUsageDetail_20' ) start [2026-01-19 14:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16591835', 'tblTempUsageDetail_20' ) end [2026-01-19 14:09:23] Production.ERROR: pbx prc_insertCDR start [2026-01-19 14:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-19 14:09:26] Production.INFO: ==4357== Releasing lock... [2026-01-19 14:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 14:09:26] Production.INFO: 77.5 MB #Memory Used# [2026-01-19 15:02:04] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 12:02:04 [end_date_ymd] => 2026-01-19 15:02:04 [RateCDR] => 1 ) [2026-01-19 15:02:04] 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-01-19 12:02:04' and `end` < '2026-01-19 15:02:04' 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-01-19 15:02:18] Production.INFO: count ==6423 [2026-01-19 15:02:21] Production.ERROR: pbx CDR StartTime 2026-01-19 12:02:04 - End Time 2026-01-19 15:02:04 [2026-01-19 15:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 15:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592082', 'tblTempUsageDetail_20' ) start [2026-01-19 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592082', 'tblTempUsageDetail_20' ) end [2026-01-19 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592082', 'tblTempVendorCDR_20' ) start [2026-01-19 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592082', 'tblTempVendorCDR_20' ) end [2026-01-19 15:02:22] Production.INFO: ProcessCDR(1,16592082,1,1,2) [2026-01-19 15:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16592082,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 15:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16592082,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 15:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16592082,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 15:09:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16592082,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 15:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592082', 'tblTempUsageDetail_20' ) start [2026-01-19 15:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592082', 'tblTempUsageDetail_20' ) end [2026-01-19 15:09:27] Production.ERROR: pbx prc_insertCDR start [2026-01-19 15:09:29] Production.ERROR: pbx prc_insertCDR end [2026-01-19 15:09:29] Production.INFO: ==8644== Releasing lock... [2026-01-19 15:09:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 15:09:29] Production.INFO: 76.5 MB #Memory Used# [2026-01-19 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 13:02:05 [end_date_ymd] => 2026-01-19 16:02:05 [RateCDR] => 1 ) [2026-01-19 16: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-01-19 13:02:05' and `end` < '2026-01-19 16: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-01-19 16:02:20] Production.INFO: count ==6342 [2026-01-19 16:02:23] Production.ERROR: pbx CDR StartTime 2026-01-19 13:02:05 - End Time 2026-01-19 16:02:05 [2026-01-19 16:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592329', 'tblTempUsageDetail_20' ) start [2026-01-19 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592329', 'tblTempUsageDetail_20' ) end [2026-01-19 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592329', 'tblTempVendorCDR_20' ) start [2026-01-19 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592329', 'tblTempVendorCDR_20' ) end [2026-01-19 16:02:24] Production.INFO: ProcessCDR(1,16592329,1,1,2) [2026-01-19 16:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16592329,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 16:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16592329,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 16:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16592329,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 16:09:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16592329,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 16:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592329', 'tblTempUsageDetail_20' ) start [2026-01-19 16:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592329', 'tblTempUsageDetail_20' ) end [2026-01-19 16:09:28] Production.ERROR: pbx prc_insertCDR start [2026-01-19 16:09:30] Production.ERROR: pbx prc_insertCDR end [2026-01-19 16:09:30] Production.INFO: ==13172== Releasing lock... [2026-01-19 16:09:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 16:09:30] Production.INFO: 75.75 MB #Memory Used# [2026-01-19 17:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 14:02:06 [end_date_ymd] => 2026-01-19 17:02:06 [RateCDR] => 1 ) [2026-01-19 17: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-01-19 14:02:06' and `end` < '2026-01-19 17: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-01-19 17:02:20] Production.INFO: count ==5866 [2026-01-19 17:02:23] Production.ERROR: pbx CDR StartTime 2026-01-19 14:02:06 - End Time 2026-01-19 17:02:06 [2026-01-19 17:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592576', 'tblTempUsageDetail_20' ) start [2026-01-19 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592576', 'tblTempUsageDetail_20' ) end [2026-01-19 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592576', 'tblTempVendorCDR_20' ) start [2026-01-19 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592576', 'tblTempVendorCDR_20' ) end [2026-01-19 17:02:23] Production.INFO: ProcessCDR(1,16592576,1,1,2) [2026-01-19 17:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16592576,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 17:05:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16592576,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 17:05:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16592576,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 17:09:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16592576,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 17:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592576', 'tblTempUsageDetail_20' ) start [2026-01-19 17:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592576', 'tblTempUsageDetail_20' ) end [2026-01-19 17:09:36] Production.ERROR: pbx prc_insertCDR start [2026-01-19 17:09:40] Production.ERROR: pbx prc_insertCDR end [2026-01-19 17:09:40] Production.INFO: ==18156== Releasing lock... [2026-01-19 17:09:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 17:09:40] Production.INFO: 72.25 MB #Memory Used# [2026-01-19 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 15:02:05 [end_date_ymd] => 2026-01-19 18:02:05 [RateCDR] => 1 ) [2026-01-19 18: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-01-19 15:02:05' and `end` < '2026-01-19 18: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-01-19 18:02:18] Production.INFO: count ==5254 [2026-01-19 18:02:21] Production.ERROR: pbx CDR StartTime 2026-01-19 15:02:05 - End Time 2026-01-19 18:02:05 [2026-01-19 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592821', 'tblTempUsageDetail_20' ) start [2026-01-19 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16592821', 'tblTempUsageDetail_20' ) end [2026-01-19 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592821', 'tblTempVendorCDR_20' ) start [2026-01-19 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16592821', 'tblTempVendorCDR_20' ) end [2026-01-19 18:02:21] Production.INFO: ProcessCDR(1,16592821,1,1,2) [2026-01-19 18:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16592821,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 18:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16592821,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 18:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16592821,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 18:09:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16592821,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 18:09:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592821', 'tblTempUsageDetail_20' ) start [2026-01-19 18:09:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16592821', 'tblTempUsageDetail_20' ) end [2026-01-19 18:09:47] Production.ERROR: pbx prc_insertCDR start [2026-01-19 18:09:48] Production.ERROR: pbx prc_insertCDR end [2026-01-19 18:09:48] Production.INFO: ==22665== Releasing lock... [2026-01-19 18:09:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 18:09:48] Production.INFO: 67.5 MB #Memory Used# [2026-01-19 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 16:02:06 [end_date_ymd] => 2026-01-19 19:02:06 [RateCDR] => 1 ) [2026-01-19 19: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-01-19 16:02:06' and `end` < '2026-01-19 19: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-01-19 19:02:25] Production.INFO: count ==4017 [2026-01-19 19:02:27] Production.ERROR: pbx CDR StartTime 2026-01-19 16:02:06 - End Time 2026-01-19 19:02:06 [2026-01-19 19:02:27] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 19:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593068', 'tblTempUsageDetail_20' ) start [2026-01-19 19:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593068', 'tblTempUsageDetail_20' ) end [2026-01-19 19:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593068', 'tblTempVendorCDR_20' ) start [2026-01-19 19:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593068', 'tblTempVendorCDR_20' ) end [2026-01-19 19:02:27] Production.INFO: ProcessCDR(1,16593068,1,1,2) [2026-01-19 19:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16593068,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 19:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16593068,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 19:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16593068,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 19:09:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16593068,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 19:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593068', 'tblTempUsageDetail_20' ) start [2026-01-19 19:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593068', 'tblTempUsageDetail_20' ) end [2026-01-19 19:09:32] Production.ERROR: pbx prc_insertCDR start [2026-01-19 19:09:32] Production.ERROR: pbx prc_insertCDR end [2026-01-19 19:09:33] Production.INFO: ==27163== Releasing lock... [2026-01-19 19:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 19:09:33] Production.INFO: 58.25 MB #Memory Used# [2026-01-19 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 17:02:05 [end_date_ymd] => 2026-01-19 20:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-19 17:02:05' and `end` < '2026-01-19 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-01-19 20:02:18] Production.INFO: count ==2646 [2026-01-19 20:02:19] Production.ERROR: pbx CDR StartTime 2026-01-19 17:02:05 - End Time 2026-01-19 20:02:05 [2026-01-19 20:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593315', 'tblTempUsageDetail_20' ) start [2026-01-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593315', 'tblTempUsageDetail_20' ) end [2026-01-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593315', 'tblTempVendorCDR_20' ) start [2026-01-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593315', 'tblTempVendorCDR_20' ) end [2026-01-19 20:02:19] Production.INFO: ProcessCDR(1,16593315,1,1,2) [2026-01-19 20:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16593315,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 20:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16593315,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 20:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16593315,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 20:09:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16593315,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 20:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593315', 'tblTempUsageDetail_20' ) start [2026-01-19 20:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593315', 'tblTempUsageDetail_20' ) end [2026-01-19 20:09:37] Production.ERROR: pbx prc_insertCDR start [2026-01-19 20:09:37] Production.ERROR: pbx prc_insertCDR end [2026-01-19 20:09:37] Production.INFO: ==31824== Releasing lock... [2026-01-19 20:09:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 20:09:37] Production.INFO: 48.25 MB #Memory Used# [2026-01-19 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 18:02:05 [end_date_ymd] => 2026-01-19 21:02:05 [RateCDR] => 1 ) [2026-01-19 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-01-19 18:02:05' and `end` < '2026-01-19 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-01-19 21:02:17] Production.INFO: count ==1836 [2026-01-19 21:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 18:02:05 - End Time 2026-01-19 21:02:05 [2026-01-19 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593562', 'tblTempUsageDetail_20' ) start [2026-01-19 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593562', 'tblTempUsageDetail_20' ) end [2026-01-19 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593562', 'tblTempVendorCDR_20' ) start [2026-01-19 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593562', 'tblTempVendorCDR_20' ) end [2026-01-19 21:02:18] Production.INFO: ProcessCDR(1,16593562,1,1,2) [2026-01-19 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16593562,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 21:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16593562,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 21:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16593562,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 21:09:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16593562,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 21:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593562', 'tblTempUsageDetail_20' ) start [2026-01-19 21:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593562', 'tblTempUsageDetail_20' ) end [2026-01-19 21:09:38] Production.ERROR: pbx prc_insertCDR start [2026-01-19 21:09:39] Production.ERROR: pbx prc_insertCDR end [2026-01-19 21:09:39] Production.INFO: ==4871== Releasing lock... [2026-01-19 21:09:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 21:09:39] Production.INFO: 42 MB #Memory Used# [2026-01-19 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 19:02:05 [end_date_ymd] => 2026-01-19 22:02:05 [RateCDR] => 1 ) [2026-01-19 22: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-01-19 19:02:05' and `end` < '2026-01-19 22: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-01-19 22:02:17] Production.INFO: count ==1435 [2026-01-19 22:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 19:02:05 - End Time 2026-01-19 22:02:05 [2026-01-19 22:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593809', 'tblTempUsageDetail_20' ) start [2026-01-19 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16593809', 'tblTempUsageDetail_20' ) end [2026-01-19 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593809', 'tblTempVendorCDR_20' ) start [2026-01-19 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16593809', 'tblTempVendorCDR_20' ) end [2026-01-19 22:02:18] Production.INFO: ProcessCDR(1,16593809,1,1,2) [2026-01-19 22:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16593809,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 22:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16593809,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 22:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16593809,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 22:09:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16593809,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 22:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593809', 'tblTempUsageDetail_20' ) start [2026-01-19 22:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16593809', 'tblTempUsageDetail_20' ) end [2026-01-19 22:09:17] Production.ERROR: pbx prc_insertCDR start [2026-01-19 22:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-19 22:09:18] Production.INFO: ==10421== Releasing lock... [2026-01-19 22:09:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 22:09:18] Production.INFO: 39.25 MB #Memory Used# [2026-01-19 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-19 20:02:05 [end_date_ymd] => 2026-01-19 23:02:05 [RateCDR] => 1 ) [2026-01-19 23: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-01-19 20:02:05' and `end` < '2026-01-19 23: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-01-19 23:02:17] Production.INFO: count ==981 [2026-01-19 23:02:18] Production.ERROR: pbx CDR StartTime 2026-01-19 20:02:05 - End Time 2026-01-19 23:02:05 [2026-01-19 23:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16594056', 'tblTempUsageDetail_20' ) start [2026-01-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16594056', 'tblTempUsageDetail_20' ) end [2026-01-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16594056', 'tblTempVendorCDR_20' ) start [2026-01-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16594056', 'tblTempVendorCDR_20' ) end [2026-01-19 23:02:18] Production.INFO: ProcessCDR(1,16594056,1,1,2) [2026-01-19 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16594056,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 23:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16594056,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-19 23:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16594056,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 23:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16594056,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-19 23:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16594056', 'tblTempUsageDetail_20' ) start [2026-01-19 23:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16594056', 'tblTempUsageDetail_20' ) end [2026-01-19 23:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-19 23:09:24] Production.ERROR: pbx prc_insertCDR end [2026-01-19 23:09:24] Production.INFO: ==16002== Releasing lock... [2026-01-19 23:09:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-19 23:09:24] Production.INFO: 36 MB #Memory Used#