[2026-01-12 00:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 21:01:06 [end_date_ymd] => 2026-01-12 00:01:06 [RateCDR] => 1 ) [2026-01-12 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-11 21:01:06' and `end` < '2026-01-12 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-12 00:01:20] Production.INFO: count ==477 [2026-01-12 00:01:20] Production.ERROR: pbx CDR StartTime 2026-01-11 21:01:06 - End Time 2026-01-12 00:01:06 [2026-01-12 00:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 00:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546869', 'tblTempUsageDetail_20' ) start [2026-01-12 00:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546869', 'tblTempUsageDetail_20' ) end [2026-01-12 00:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546869', 'tblTempVendorCDR_20' ) start [2026-01-12 00:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546869', 'tblTempVendorCDR_20' ) end [2026-01-12 00:01:20] Production.INFO: ProcessCDR(1,16546869,1,1,2) [2026-01-12 00:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16546869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 00:04:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16546869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 00:04:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16546869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 00:08:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16546869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 00:08:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546869', 'tblTempUsageDetail_20' ) start [2026-01-12 00:08:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546869', 'tblTempUsageDetail_20' ) end [2026-01-12 00:08:49] Production.ERROR: pbx prc_insertCDR start [2026-01-12 00:08:49] Production.ERROR: pbx prc_insertCDR end [2026-01-12 00:08:51] Production.INFO: ==20556== Releasing lock... [2026-01-12 00:08:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 00:08:51] Production.INFO: 35.25 MB #Memory Used# [2026-01-12 01:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 22:01:06 [end_date_ymd] => 2026-01-12 01:01:06 [RateCDR] => 1 ) [2026-01-12 01:01:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-11 22:01:06' and `end` < '2026-01-12 01: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-12 01:01:23] Production.INFO: count ==481 [2026-01-12 01:01:24] Production.ERROR: pbx CDR StartTime 2026-01-11 22:01:06 - End Time 2026-01-12 01:01:06 [2026-01-12 01:01:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 01:01:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547116', 'tblTempUsageDetail_20' ) start [2026-01-12 01:01:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547116', 'tblTempUsageDetail_20' ) end [2026-01-12 01:01:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547116', 'tblTempVendorCDR_20' ) start [2026-01-12 01:01:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547116', 'tblTempVendorCDR_20' ) end [2026-01-12 01:01:24] Production.INFO: ProcessCDR(1,16547116,1,1,2) [2026-01-12 01:01:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16547116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 01:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16547116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 01:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16547116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 01:08:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16547116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 01:08:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547116', 'tblTempUsageDetail_20' ) start [2026-01-12 01:08:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547116', 'tblTempUsageDetail_20' ) end [2026-01-12 01:08:36] Production.ERROR: pbx prc_insertCDR start [2026-01-12 01:08:36] Production.ERROR: pbx prc_insertCDR end [2026-01-12 01:08:36] Production.INFO: ==31073== Releasing lock... [2026-01-12 01:08:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 01:08:36] Production.INFO: 32.25 MB #Memory Used# [2026-01-12 02:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 23:01:05 [end_date_ymd] => 2026-01-12 02:01:05 [RateCDR] => 1 ) [2026-01-12 02:01: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-11 23:01:05' and `end` < '2026-01-12 02:01: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-12 02:01:18] Production.INFO: count ==424 [2026-01-12 02:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 23:01:05 - End Time 2026-01-12 02:01:05 [2026-01-12 02:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547363', 'tblTempUsageDetail_20' ) start [2026-01-12 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547363', 'tblTempUsageDetail_20' ) end [2026-01-12 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547363', 'tblTempVendorCDR_20' ) start [2026-01-12 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547363', 'tblTempVendorCDR_20' ) end [2026-01-12 02:01:19] Production.INFO: ProcessCDR(1,16547363,1,1,2) [2026-01-12 02:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16547363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 02:04:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16547363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 02:04:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16547363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 02:08:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16547363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 02:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547363', 'tblTempUsageDetail_20' ) start [2026-01-12 02:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547363', 'tblTempUsageDetail_20' ) end [2026-01-12 02:08:23] Production.ERROR: pbx prc_insertCDR start [2026-01-12 02:08:23] Production.ERROR: pbx prc_insertCDR end [2026-01-12 02:08:23] Production.INFO: ==8760== Releasing lock... [2026-01-12 02:08:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 02:08:23] Production.INFO: 32 MB #Memory Used# [2026-01-12 03:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 00:01:06 [end_date_ymd] => 2026-01-12 03:01:06 [RateCDR] => 1 ) [2026-01-12 03: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-12 00:01:06' and `end` < '2026-01-12 03: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-12 03:01:20] Production.INFO: count ==554 [2026-01-12 03:01:20] Production.ERROR: pbx CDR StartTime 2026-01-12 00:01:06 - End Time 2026-01-12 03:01:06 [2026-01-12 03:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 03:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547610', 'tblTempUsageDetail_20' ) start [2026-01-12 03:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547610', 'tblTempUsageDetail_20' ) end [2026-01-12 03:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547610', 'tblTempVendorCDR_20' ) start [2026-01-12 03:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547610', 'tblTempVendorCDR_20' ) end [2026-01-12 03:01:20] Production.INFO: ProcessCDR(1,16547610,1,1,2) [2026-01-12 03:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16547610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 03:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16547610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 03:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16547610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 03:08:06] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16547610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 03:08:06] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547610', 'tblTempUsageDetail_20' ) start [2026-01-12 03:08:07] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547610', 'tblTempUsageDetail_20' ) end [2026-01-12 03:08:07] Production.ERROR: pbx prc_insertCDR start [2026-01-12 03:08:07] Production.ERROR: pbx prc_insertCDR end [2026-01-12 03:08:07] Production.INFO: ==13634== Releasing lock... [2026-01-12 03:08:07] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 03:08:07] Production.INFO: 32.75 MB #Memory Used# [2026-01-12 04:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 01:01:06 [end_date_ymd] => 2026-01-12 04:01:06 [RateCDR] => 1 ) [2026-01-12 04: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-12 01:01:06' and `end` < '2026-01-12 04: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-12 04:01:18] Production.INFO: count ==427 [2026-01-12 04:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 01:01:06 - End Time 2026-01-12 04:01:06 [2026-01-12 04:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547858', 'tblTempUsageDetail_20' ) start [2026-01-12 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16547858', 'tblTempUsageDetail_20' ) end [2026-01-12 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547858', 'tblTempVendorCDR_20' ) start [2026-01-12 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16547858', 'tblTempVendorCDR_20' ) end [2026-01-12 04:01:18] Production.INFO: ProcessCDR(1,16547858,1,1,2) [2026-01-12 04:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16547858,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 04:03:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16547858,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 04:03:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16547858,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 04:07:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16547858,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 04:07:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547858', 'tblTempUsageDetail_20' ) start [2026-01-12 04:07:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16547858', 'tblTempUsageDetail_20' ) end [2026-01-12 04:07:25] Production.ERROR: pbx prc_insertCDR start [2026-01-12 04:07:25] Production.ERROR: pbx prc_insertCDR end [2026-01-12 04:07:25] Production.INFO: ==18315== Releasing lock... [2026-01-12 04:07:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 04:07:25] Production.INFO: 31.75 MB #Memory Used# [2026-01-12 05:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 02:01:06 [end_date_ymd] => 2026-01-12 05:01:06 [RateCDR] => 1 ) [2026-01-12 05: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-12 02:01:06' and `end` < '2026-01-12 05: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-12 05:01:18] Production.INFO: count ==346 [2026-01-12 05:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 02:01:06 - End Time 2026-01-12 05:01:06 [2026-01-12 05:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548106', 'tblTempUsageDetail_20' ) start [2026-01-12 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548106', 'tblTempUsageDetail_20' ) end [2026-01-12 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548106', 'tblTempVendorCDR_20' ) start [2026-01-12 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548106', 'tblTempVendorCDR_20' ) end [2026-01-12 05:01:18] Production.INFO: ProcessCDR(1,16548106,1,1,2) [2026-01-12 05:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16548106,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 05:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16548106,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 05:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16548106,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 05:08:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16548106,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 05:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548106', 'tblTempUsageDetail_20' ) start [2026-01-12 05:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548106', 'tblTempUsageDetail_20' ) end [2026-01-12 05:08:18] Production.ERROR: pbx prc_insertCDR start [2026-01-12 05:08:18] Production.ERROR: pbx prc_insertCDR end [2026-01-12 05:08:18] Production.INFO: ==23850== Releasing lock... [2026-01-12 05:08:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 05:08:18] Production.INFO: 31.25 MB #Memory Used# [2026-01-12 06:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 03:01:06 [end_date_ymd] => 2026-01-12 06:01:06 [RateCDR] => 1 ) [2026-01-12 06: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-12 03:01:06' and `end` < '2026-01-12 06: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-12 06:01:18] Production.INFO: count ==113 [2026-01-12 06:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 03:01:06 - End Time 2026-01-12 06:01:06 [2026-01-12 06:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548353', 'tblTempUsageDetail_20' ) start [2026-01-12 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548353', 'tblTempUsageDetail_20' ) end [2026-01-12 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548353', 'tblTempVendorCDR_20' ) start [2026-01-12 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548353', 'tblTempVendorCDR_20' ) end [2026-01-12 06:01:18] Production.INFO: ProcessCDR(1,16548353,1,1,2) [2026-01-12 06:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16548353,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 06:04:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16548353,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 06:04:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16548353,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 06:08:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16548353,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 06:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548353', 'tblTempUsageDetail_20' ) start [2026-01-12 06:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548353', 'tblTempUsageDetail_20' ) end [2026-01-12 06:08:21] Production.ERROR: pbx prc_insertCDR start [2026-01-12 06:08:21] Production.ERROR: pbx prc_insertCDR end [2026-01-12 06:08:21] Production.INFO: ==29708== Releasing lock... [2026-01-12 06:08:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 06:08:21] Production.INFO: 28.75 MB #Memory Used# [2026-01-12 07:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 04:01:05 [end_date_ymd] => 2026-01-12 07:01:05 [RateCDR] => 1 ) [2026-01-12 07: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-12 04:01:05' and `end` < '2026-01-12 07:01: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-12 07:01:17] Production.INFO: count ==100 [2026-01-12 07:01:17] Production.ERROR: pbx CDR StartTime 2026-01-12 04:01:05 - End Time 2026-01-12 07:01:05 [2026-01-12 07:01:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 07:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548600', 'tblTempUsageDetail_20' ) start [2026-01-12 07:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548600', 'tblTempUsageDetail_20' ) end [2026-01-12 07:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548600', 'tblTempVendorCDR_20' ) start [2026-01-12 07:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548600', 'tblTempVendorCDR_20' ) end [2026-01-12 07:01:17] Production.INFO: ProcessCDR(1,16548600,1,1,2) [2026-01-12 07:01:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16548600,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 07:04:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16548600,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 07:04:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16548600,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 07:08:00] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16548600,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 07:08:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548600', 'tblTempUsageDetail_20' ) start [2026-01-12 07:08:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548600', 'tblTempUsageDetail_20' ) end [2026-01-12 07:08:00] Production.ERROR: pbx prc_insertCDR start [2026-01-12 07:08:00] Production.ERROR: pbx prc_insertCDR end [2026-01-12 07:08:00] Production.INFO: ==2669== Releasing lock... [2026-01-12 07:08:00] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 07:08:00] Production.INFO: 28.75 MB #Memory Used# [2026-01-12 08:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 05:01:05 [end_date_ymd] => 2026-01-12 08:01:05 [RateCDR] => 1 ) [2026-01-12 08:01: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-12 05:01:05' and `end` < '2026-01-12 08:01: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-12 08:01:18] Production.INFO: count ==179 [2026-01-12 08:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 05:01:05 - End Time 2026-01-12 08:01:05 [2026-01-12 08:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548846', 'tblTempUsageDetail_20' ) start [2026-01-12 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16548846', 'tblTempUsageDetail_20' ) end [2026-01-12 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548846', 'tblTempVendorCDR_20' ) start [2026-01-12 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16548846', 'tblTempVendorCDR_20' ) end [2026-01-12 08:01:18] Production.INFO: ProcessCDR(1,16548846,1,1,2) [2026-01-12 08:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16548846,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 08:04:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16548846,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 08:04:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16548846,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 08:07:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16548846,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 08:07:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548846', 'tblTempUsageDetail_20' ) start [2026-01-12 08:07:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16548846', 'tblTempUsageDetail_20' ) end [2026-01-12 08:07:56] Production.ERROR: pbx prc_insertCDR start [2026-01-12 08:07:56] Production.ERROR: pbx prc_insertCDR end [2026-01-12 08:07:56] Production.INFO: ==8510== Releasing lock... [2026-01-12 08:07:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 08:07:56] Production.INFO: 29.75 MB #Memory Used# [2026-01-12 09:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 06:01:05 [end_date_ymd] => 2026-01-12 09:01:05 [RateCDR] => 1 ) [2026-01-12 09:01: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-12 06:01:05' and `end` < '2026-01-12 09:01: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-12 09:01:18] Production.INFO: count ==913 [2026-01-12 09:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 06:01:05 - End Time 2026-01-12 09:01:05 [2026-01-12 09:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 09:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549094', 'tblTempUsageDetail_20' ) start [2026-01-12 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549094', 'tblTempUsageDetail_20' ) end [2026-01-12 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549094', 'tblTempVendorCDR_20' ) start [2026-01-12 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549094', 'tblTempVendorCDR_20' ) end [2026-01-12 09:01:19] Production.INFO: ProcessCDR(1,16549094,1,1,2) [2026-01-12 09:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16549094,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 09:04:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16549094,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 09:04:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16549094,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 09:08:01] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16549094,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 09:08:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549094', 'tblTempUsageDetail_20' ) start [2026-01-12 09:08:02] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549094', 'tblTempUsageDetail_20' ) end [2026-01-12 09:08:02] Production.ERROR: pbx prc_insertCDR start [2026-01-12 09:08:04] Production.ERROR: pbx prc_insertCDR end [2026-01-12 09:08:04] Production.INFO: ==14552== Releasing lock... [2026-01-12 09:08:04] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 09:08:04] Production.INFO: 34.75 MB #Memory Used# [2026-01-12 10:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 07:01:06 [end_date_ymd] => 2026-01-12 10:01:06 [RateCDR] => 1 ) [2026-01-12 10: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-12 07:01:06' and `end` < '2026-01-12 10: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-12 10:01:19] Production.INFO: count ==2912 [2026-01-12 10:01:20] Production.ERROR: pbx CDR StartTime 2026-01-12 07:01:06 - End Time 2026-01-12 10:01:06 [2026-01-12 10:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 10:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549341', 'tblTempUsageDetail_20' ) start [2026-01-12 10:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549341', 'tblTempUsageDetail_20' ) end [2026-01-12 10:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549341', 'tblTempVendorCDR_20' ) start [2026-01-12 10:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549341', 'tblTempVendorCDR_20' ) end [2026-01-12 10:01:21] Production.INFO: ProcessCDR(1,16549341,1,1,2) [2026-01-12 10:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16549341,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 10:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16549341,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 10:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16549341,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 10:08:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16549341,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 10:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549341', 'tblTempUsageDetail_20' ) start [2026-01-12 10:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549341', 'tblTempUsageDetail_20' ) end [2026-01-12 10:08:21] Production.ERROR: pbx prc_insertCDR start [2026-01-12 10:08:23] Production.ERROR: pbx prc_insertCDR end [2026-01-12 10:08:23] Production.INFO: ==19183== Releasing lock... [2026-01-12 10:08:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 10:08:23] Production.INFO: 49.5 MB #Memory Used# [2026-01-12 11:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 08:01:06 [end_date_ymd] => 2026-01-12 11:01:06 [RateCDR] => 1 ) [2026-01-12 11: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-12 08:01:06' and `end` < '2026-01-12 11: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-12 11:01:20] Production.INFO: count ==4882 [2026-01-12 11:01:22] Production.ERROR: pbx CDR StartTime 2026-01-12 08:01:06 - End Time 2026-01-12 11:01:06 [2026-01-12 11:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 11:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549588', 'tblTempUsageDetail_20' ) start [2026-01-12 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549588', 'tblTempUsageDetail_20' ) end [2026-01-12 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549588', 'tblTempVendorCDR_20' ) start [2026-01-12 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549588', 'tblTempVendorCDR_20' ) end [2026-01-12 11:01:23] Production.INFO: ProcessCDR(1,16549588,1,1,2) [2026-01-12 11:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16549588,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 11:05:12] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16549588,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 11:05:12] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16549588,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 11:09:00] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16549588,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 11:09:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549588', 'tblTempUsageDetail_20' ) start [2026-01-12 11:09:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549588', 'tblTempUsageDetail_20' ) end [2026-01-12 11:09:01] Production.ERROR: pbx prc_insertCDR start [2026-01-12 11:09:06] Production.ERROR: pbx prc_insertCDR end [2026-01-12 11:09:06] Production.INFO: ==23962== Releasing lock... [2026-01-12 11:09:06] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 11:09:06] Production.INFO: 64.75 MB #Memory Used# [2026-01-12 12:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 09:01:06 [end_date_ymd] => 2026-01-12 12:01:06 [RateCDR] => 1 ) [2026-01-12 12: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-12 09:01:06' and `end` < '2026-01-12 12: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-12 12:01:22] Production.INFO: count ==6247 [2026-01-12 12:01:25] Production.ERROR: pbx CDR StartTime 2026-01-12 09:01:06 - End Time 2026-01-12 12:01:06 [2026-01-12 12:01:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 12:01:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549835', 'tblTempUsageDetail_20' ) start [2026-01-12 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16549835', 'tblTempUsageDetail_20' ) end [2026-01-12 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549835', 'tblTempVendorCDR_20' ) start [2026-01-12 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16549835', 'tblTempVendorCDR_20' ) end [2026-01-12 12:01:26] Production.INFO: ProcessCDR(1,16549835,1,1,2) [2026-01-12 12:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16549835,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 12:05:12] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16549835,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 12:05:12] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16549835,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 12:08:59] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16549835,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 12:08:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549835', 'tblTempUsageDetail_20' ) start [2026-01-12 12:08:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16549835', 'tblTempUsageDetail_20' ) end [2026-01-12 12:08:59] Production.ERROR: pbx prc_insertCDR start [2026-01-12 12:09:02] Production.ERROR: pbx prc_insertCDR end [2026-01-12 12:09:02] Production.INFO: ==29253== Releasing lock... [2026-01-12 12:09:02] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 12:09:02] Production.INFO: 75 MB #Memory Used# [2026-01-12 13:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 10:01:07 [end_date_ymd] => 2026-01-12 13:01:07 [RateCDR] => 1 ) [2026-01-12 13:01:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-12 10:01:07' and `end` < '2026-01-12 13:01:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-12 13:01:22] Production.INFO: count ==6290 [2026-01-12 13:01:25] Production.ERROR: pbx CDR StartTime 2026-01-12 10:01:07 - End Time 2026-01-12 13:01:07 [2026-01-12 13:01:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 13:01:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550082', 'tblTempUsageDetail_20' ) start [2026-01-12 13:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550082', 'tblTempUsageDetail_20' ) end [2026-01-12 13:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550082', 'tblTempVendorCDR_20' ) start [2026-01-12 13:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550082', 'tblTempVendorCDR_20' ) end [2026-01-12 13:01:26] Production.INFO: ProcessCDR(1,16550082,1,1,2) [2026-01-12 13:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16550082,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 13:04:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16550082,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 13:04:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16550082,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 13:08:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16550082,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 13:08:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550082', 'tblTempUsageDetail_20' ) start [2026-01-12 13:08:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550082', 'tblTempUsageDetail_20' ) end [2026-01-12 13:08:37] Production.ERROR: pbx prc_insertCDR start [2026-01-12 13:08:39] Production.ERROR: pbx prc_insertCDR end [2026-01-12 13:08:39] Production.INFO: ==1622== Releasing lock... [2026-01-12 13:08:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 13:08:39] Production.INFO: 75.25 MB #Memory Used# [2026-01-12 14:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 11:01:06 [end_date_ymd] => 2026-01-12 14:01:06 [RateCDR] => 1 ) [2026-01-12 14: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-12 11:01:06' and `end` < '2026-01-12 14: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-12 14:01:22] Production.INFO: count ==6851 [2026-01-12 14:01:26] Production.ERROR: pbx CDR StartTime 2026-01-12 11:01:06 - End Time 2026-01-12 14:01:06 [2026-01-12 14:01:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 14:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550329', 'tblTempUsageDetail_20' ) start [2026-01-12 14:01:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550329', 'tblTempUsageDetail_20' ) end [2026-01-12 14:01:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550329', 'tblTempVendorCDR_20' ) start [2026-01-12 14:01:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550329', 'tblTempVendorCDR_20' ) end [2026-01-12 14:01:27] Production.INFO: ProcessCDR(1,16550329,1,1,2) [2026-01-12 14:01:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16550329,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 14:04:46] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16550329,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 14:04:46] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16550329,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 14:08:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16550329,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 14:08:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550329', 'tblTempUsageDetail_20' ) start [2026-01-12 14:08:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550329', 'tblTempUsageDetail_20' ) end [2026-01-12 14:08:47] Production.ERROR: pbx prc_insertCDR start [2026-01-12 14:08:50] Production.ERROR: pbx prc_insertCDR end [2026-01-12 14:08:50] Production.INFO: ==6950== Releasing lock... [2026-01-12 14:08:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 14:08:50] Production.INFO: 79.5 MB #Memory Used# [2026-01-12 15:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 12:01:06 [end_date_ymd] => 2026-01-12 15:01:06 [RateCDR] => 1 ) [2026-01-12 15: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-12 12:01:06' and `end` < '2026-01-12 15: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-12 15:01:21] Production.INFO: count ==7780 [2026-01-12 15:01:25] Production.ERROR: pbx CDR StartTime 2026-01-12 12:01:06 - End Time 2026-01-12 15:01:06 [2026-01-12 15:01:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 15:01:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550576', 'tblTempUsageDetail_20' ) start [2026-01-12 15:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550576', 'tblTempUsageDetail_20' ) end [2026-01-12 15:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550576', 'tblTempVendorCDR_20' ) start [2026-01-12 15:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550576', 'tblTempVendorCDR_20' ) end [2026-01-12 15:01:26] Production.INFO: ProcessCDR(1,16550576,1,1,2) [2026-01-12 15:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16550576,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 15:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16550576,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 15:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16550576,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 15:08:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16550576,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 15:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550576', 'tblTempUsageDetail_20' ) start [2026-01-12 15:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550576', 'tblTempUsageDetail_20' ) end [2026-01-12 15:08:21] Production.ERROR: pbx prc_insertCDR start [2026-01-12 15:08:24] Production.ERROR: pbx prc_insertCDR end [2026-01-12 15:08:24] Production.INFO: ==11799== Releasing lock... [2026-01-12 15:08:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 15:08:24] Production.INFO: 87 MB #Memory Used# [2026-01-12 16:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 13:01:07 [end_date_ymd] => 2026-01-12 16:01:07 [RateCDR] => 1 ) [2026-01-12 16:01:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-12 13:01:07' and `end` < '2026-01-12 16:01:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-12 16:01:24] Production.INFO: count ==7913 [2026-01-12 16:01:28] Production.ERROR: pbx CDR StartTime 2026-01-12 13:01:07 - End Time 2026-01-12 16:01:07 [2026-01-12 16:01:28] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 16:01:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550823', 'tblTempUsageDetail_20' ) start [2026-01-12 16:01:29] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16550823', 'tblTempUsageDetail_20' ) end [2026-01-12 16:01:29] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550823', 'tblTempVendorCDR_20' ) start [2026-01-12 16:01:29] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16550823', 'tblTempVendorCDR_20' ) end [2026-01-12 16:01:29] Production.INFO: ProcessCDR(1,16550823,1,1,2) [2026-01-12 16:01:29] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16550823,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 16:04:49] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16550823,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 16:04:49] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16550823,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 16:08:52] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16550823,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 16:08:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550823', 'tblTempUsageDetail_20' ) start [2026-01-12 16:08:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16550823', 'tblTempUsageDetail_20' ) end [2026-01-12 16:08:52] Production.ERROR: pbx prc_insertCDR start [2026-01-12 16:08:55] Production.ERROR: pbx prc_insertCDR end [2026-01-12 16:08:55] Production.INFO: ==16380== Releasing lock... [2026-01-12 16:08:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 16:08:55] Production.INFO: 88 MB #Memory Used# [2026-01-12 17:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 14:01:07 [end_date_ymd] => 2026-01-12 17:01:07 [RateCDR] => 1 ) [2026-01-12 17:01:07] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-12 14:01:07' and `end` < '2026-01-12 17:01:07' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-12 17:01:21] Production.INFO: count ==7037 [2026-01-12 17:01:25] Production.ERROR: pbx CDR StartTime 2026-01-12 14:01:07 - End Time 2026-01-12 17:01:07 [2026-01-12 17:01:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 17:01:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551070', 'tblTempUsageDetail_20' ) start [2026-01-12 17:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551070', 'tblTempUsageDetail_20' ) end [2026-01-12 17:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551070', 'tblTempVendorCDR_20' ) start [2026-01-12 17:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551070', 'tblTempVendorCDR_20' ) end [2026-01-12 17:01:26] Production.INFO: ProcessCDR(1,16551070,1,1,2) [2026-01-12 17:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16551070,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 17:04:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16551070,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 17:04:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16551070,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 17:08:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16551070,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 17:08:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551070', 'tblTempUsageDetail_20' ) start [2026-01-12 17:08:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551070', 'tblTempUsageDetail_20' ) end [2026-01-12 17:08:41] Production.ERROR: pbx prc_insertCDR start [2026-01-12 17:08:43] Production.ERROR: pbx prc_insertCDR end [2026-01-12 17:08:43] Production.INFO: ==21142== Releasing lock... [2026-01-12 17:08:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 17:08:43] Production.INFO: 81 MB #Memory Used# [2026-01-12 18:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 15:01:06 [end_date_ymd] => 2026-01-12 18:01:06 [RateCDR] => 1 ) [2026-01-12 18: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-12 15:01:06' and `end` < '2026-01-12 18: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-12 18:01:19] Production.INFO: count ==4779 [2026-01-12 18:01:21] Production.ERROR: pbx CDR StartTime 2026-01-12 15:01:06 - End Time 2026-01-12 18:01:06 [2026-01-12 18:01:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 18:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551315', 'tblTempUsageDetail_20' ) start [2026-01-12 18:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551315', 'tblTempUsageDetail_20' ) end [2026-01-12 18:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551315', 'tblTempVendorCDR_20' ) start [2026-01-12 18:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551315', 'tblTempVendorCDR_20' ) end [2026-01-12 18:01:22] Production.INFO: ProcessCDR(1,16551315,1,1,2) [2026-01-12 18:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16551315,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 18:04:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16551315,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 18:04:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16551315,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 18:08:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16551315,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 18:08:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551315', 'tblTempUsageDetail_20' ) start [2026-01-12 18:08:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551315', 'tblTempUsageDetail_20' ) end [2026-01-12 18:08:47] Production.ERROR: pbx prc_insertCDR start [2026-01-12 18:08:49] Production.ERROR: pbx prc_insertCDR end [2026-01-12 18:08:49] Production.INFO: ==25754== Releasing lock... [2026-01-12 18:08:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 18:08:49] Production.INFO: 64 MB #Memory Used# [2026-01-12 19:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 16:01:06 [end_date_ymd] => 2026-01-12 19:01:06 [RateCDR] => 1 ) [2026-01-12 19: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-12 16:01:06' and `end` < '2026-01-12 19: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-12 19:01:21] Production.INFO: count ==3700 [2026-01-12 19:01:23] Production.ERROR: pbx CDR StartTime 2026-01-12 16:01:06 - End Time 2026-01-12 19:01:06 [2026-01-12 19:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 19:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551562', 'tblTempUsageDetail_20' ) start [2026-01-12 19:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551562', 'tblTempUsageDetail_20' ) end [2026-01-12 19:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551562', 'tblTempVendorCDR_20' ) start [2026-01-12 19:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551562', 'tblTempVendorCDR_20' ) end [2026-01-12 19:01:23] Production.INFO: ProcessCDR(1,16551562,1,1,2) [2026-01-12 19:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16551562,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 19:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16551562,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 19:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16551562,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 19:08:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16551562,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 19:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551562', 'tblTempUsageDetail_20' ) start [2026-01-12 19:08:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551562', 'tblTempUsageDetail_20' ) end [2026-01-12 19:08:27] Production.ERROR: pbx prc_insertCDR start [2026-01-12 19:08:28] Production.ERROR: pbx prc_insertCDR end [2026-01-12 19:08:28] Production.INFO: ==30336== Releasing lock... [2026-01-12 19:08:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 19:08:28] Production.INFO: 56 MB #Memory Used# [2026-01-12 20:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 17:01:06 [end_date_ymd] => 2026-01-12 20:01:06 [RateCDR] => 1 ) [2026-01-12 20: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-12 17:01:06' and `end` < '2026-01-12 20: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-12 20:01:19] Production.INFO: count ==2568 [2026-01-12 20:01:20] Production.ERROR: pbx CDR StartTime 2026-01-12 17:01:06 - End Time 2026-01-12 20:01:06 [2026-01-12 20:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551809', 'tblTempUsageDetail_20' ) start [2026-01-12 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16551809', 'tblTempUsageDetail_20' ) end [2026-01-12 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551809', 'tblTempVendorCDR_20' ) start [2026-01-12 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16551809', 'tblTempVendorCDR_20' ) end [2026-01-12 20:01:20] Production.INFO: ProcessCDR(1,16551809,1,1,2) [2026-01-12 20:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16551809,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 20:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16551809,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 20:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16551809,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 20:08:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16551809,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 20:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551809', 'tblTempUsageDetail_20' ) start [2026-01-12 20:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16551809', 'tblTempUsageDetail_20' ) end [2026-01-12 20:08:25] Production.ERROR: pbx prc_insertCDR start [2026-01-12 20:08:26] Production.ERROR: pbx prc_insertCDR end [2026-01-12 20:08:26] Production.INFO: ==2606== Releasing lock... [2026-01-12 20:08:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 20:08:26] Production.INFO: 47.75 MB #Memory Used# [2026-01-12 21:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 18:01:05 [end_date_ymd] => 2026-01-12 21:01:05 [RateCDR] => 1 ) [2026-01-12 21:01: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-12 18:01:05' and `end` < '2026-01-12 21:01: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-12 21:01:18] Production.INFO: count ==1746 [2026-01-12 21:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 18:01:05 - End Time 2026-01-12 21:01:05 [2026-01-12 21:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 21:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552055', 'tblTempUsageDetail_20' ) start [2026-01-12 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552055', 'tblTempUsageDetail_20' ) end [2026-01-12 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552055', 'tblTempVendorCDR_20' ) start [2026-01-12 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552055', 'tblTempVendorCDR_20' ) end [2026-01-12 21:01:19] Production.INFO: ProcessCDR(1,16552055,1,1,2) [2026-01-12 21:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16552055,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 21:04:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16552055,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 21:04:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16552055,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 21:08:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16552055,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 21:08:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552055', 'tblTempUsageDetail_20' ) start [2026-01-12 21:08:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552055', 'tblTempUsageDetail_20' ) end [2026-01-12 21:08:14] Production.ERROR: pbx prc_insertCDR start [2026-01-12 21:08:15] Production.ERROR: pbx prc_insertCDR end [2026-01-12 21:08:15] Production.INFO: ==7147== Releasing lock... [2026-01-12 21:08:15] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 21:08:15] Production.INFO: 41.25 MB #Memory Used# [2026-01-12 22:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 19:01:06 [end_date_ymd] => 2026-01-12 22:01:06 [RateCDR] => 1 ) [2026-01-12 22: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-12 19:01:06' and `end` < '2026-01-12 22: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-12 22:01:18] Production.INFO: count ==1164 [2026-01-12 22:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 19:01:06 - End Time 2026-01-12 22:01:06 [2026-01-12 22:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552303', 'tblTempUsageDetail_20' ) start [2026-01-12 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552303', 'tblTempUsageDetail_20' ) end [2026-01-12 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552303', 'tblTempVendorCDR_20' ) start [2026-01-12 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552303', 'tblTempVendorCDR_20' ) end [2026-01-12 22:01:18] Production.INFO: ProcessCDR(1,16552303,1,1,2) [2026-01-12 22:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16552303,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 22:04:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16552303,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 22:04:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16552303,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 22:08:11] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16552303,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 22:08:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552303', 'tblTempUsageDetail_20' ) start [2026-01-12 22:08:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552303', 'tblTempUsageDetail_20' ) end [2026-01-12 22:08:12] Production.ERROR: pbx prc_insertCDR start [2026-01-12 22:08:12] Production.ERROR: pbx prc_insertCDR end [2026-01-12 22:08:12] Production.INFO: ==11721== Releasing lock... [2026-01-12 22:08:12] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 22:08:12] Production.INFO: 37 MB #Memory Used# [2026-01-12 23:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-12 20:01:06 [end_date_ymd] => 2026-01-12 23:01:06 [RateCDR] => 1 ) [2026-01-12 23: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-12 20:01:06' and `end` < '2026-01-12 23: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-12 23:01:18] Production.INFO: count ==775 [2026-01-12 23:01:18] Production.ERROR: pbx CDR StartTime 2026-01-12 20:01:06 - End Time 2026-01-12 23:01:06 [2026-01-12 23:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-12 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552550', 'tblTempUsageDetail_20' ) start [2026-01-12 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16552550', 'tblTempUsageDetail_20' ) end [2026-01-12 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552550', 'tblTempVendorCDR_20' ) start [2026-01-12 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16552550', 'tblTempVendorCDR_20' ) end [2026-01-12 23:01:18] Production.INFO: ProcessCDR(1,16552550,1,1,2) [2026-01-12 23:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16552550,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 23:04:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16552550,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-12 23:04:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16552550,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 23:08:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16552550,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-12 23:08:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552550', 'tblTempUsageDetail_20' ) start [2026-01-12 23:08:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16552550', 'tblTempUsageDetail_20' ) end [2026-01-12 23:08:33] Production.ERROR: pbx prc_insertCDR start [2026-01-12 23:08:33] Production.ERROR: pbx prc_insertCDR end [2026-01-12 23:08:33] Production.INFO: ==16423== Releasing lock... [2026-01-12 23:08:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-12 23:08:33] Production.INFO: 34.5 MB #Memory Used#