[2026-01-26 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-25 21:02:05 [end_date_ymd] => 2026-01-26 00:02:05 [RateCDR] => 1 ) [2026-01-26 00: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-25 21:02:05' and `end` < '2026-01-26 00: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-26 00:02:18] Production.INFO: count ==706 [2026-01-26 00:02:18] Production.ERROR: pbx CDR StartTime 2026-01-25 21:02:05 - End Time 2026-01-26 00:02:05 [2026-01-26 00:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16629867', 'tblTempUsageDetail_20' ) start [2026-01-26 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16629867', 'tblTempUsageDetail_20' ) end [2026-01-26 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16629867', 'tblTempVendorCDR_20' ) start [2026-01-26 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16629867', 'tblTempVendorCDR_20' ) end [2026-01-26 00:02:18] Production.INFO: ProcessCDR(1,16629867,1,1,2) [2026-01-26 00:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16629867,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 00:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16629867,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 00:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16629867,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 00:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16629867,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 00:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16629867', 'tblTempUsageDetail_20' ) start [2026-01-26 00:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16629867', 'tblTempUsageDetail_20' ) end [2026-01-26 00:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-26 00:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-26 00:09:36] Production.INFO: ==2090== Releasing lock... [2026-01-26 00:09:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 00:09:36] Production.INFO: 38 MB #Memory Used# [2026-01-26 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-25 22:02:06 [end_date_ymd] => 2026-01-26 01:02:06 [RateCDR] => 1 ) [2026-01-26 01: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-25 22:02:06' and `end` < '2026-01-26 01: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-26 01:02:23] Production.INFO: count ==550 [2026-01-26 01:02:23] Production.ERROR: pbx CDR StartTime 2026-01-25 22:02:06 - End Time 2026-01-26 01:02:06 [2026-01-26 01:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 01:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630114', 'tblTempUsageDetail_20' ) start [2026-01-26 01:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630114', 'tblTempUsageDetail_20' ) end [2026-01-26 01:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630114', 'tblTempVendorCDR_20' ) start [2026-01-26 01:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630114', 'tblTempVendorCDR_20' ) end [2026-01-26 01:02:23] Production.INFO: ProcessCDR(1,16630114,1,1,2) [2026-01-26 01:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16630114,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 01:05:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16630114,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 01:05:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16630114,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 01:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16630114,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 01:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630114', 'tblTempUsageDetail_20' ) start [2026-01-26 01:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630114', 'tblTempUsageDetail_20' ) end [2026-01-26 01:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-26 01:09:35] Production.ERROR: pbx prc_insertCDR end [2026-01-26 01:09:35] Production.INFO: ==7045== Releasing lock... [2026-01-26 01:09:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 01:09:35] Production.INFO: 32.75 MB #Memory Used# [2026-01-26 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-25 23:02:05 [end_date_ymd] => 2026-01-26 02:02:05 [RateCDR] => 1 ) [2026-01-26 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-25 23:02:05' and `end` < '2026-01-26 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-26 02:02:20] Production.INFO: count ==526 [2026-01-26 02:02:20] Production.ERROR: pbx CDR StartTime 2026-01-25 23:02:05 - End Time 2026-01-26 02:02:05 [2026-01-26 02:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 02:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630361', 'tblTempUsageDetail_20' ) start [2026-01-26 02:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630361', 'tblTempUsageDetail_20' ) end [2026-01-26 02:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630361', 'tblTempVendorCDR_20' ) start [2026-01-26 02:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630361', 'tblTempVendorCDR_20' ) end [2026-01-26 02:02:20] Production.INFO: ProcessCDR(1,16630361,1,1,2) [2026-01-26 02:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16630361,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 02:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16630361,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 02:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16630361,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 02:09:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16630361,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 02:09:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630361', 'tblTempUsageDetail_20' ) start [2026-01-26 02:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630361', 'tblTempUsageDetail_20' ) end [2026-01-26 02:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-26 02:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-26 02:09:26] Production.INFO: ==11845== Releasing lock... [2026-01-26 02:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 02:09:26] Production.INFO: 33 MB #Memory Used# [2026-01-26 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 00:02:05 [end_date_ymd] => 2026-01-26 03:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 00:02:05' and `end` < '2026-01-26 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-26 03:02:17] Production.INFO: count ==397 [2026-01-26 03:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 00:02:05 - End Time 2026-01-26 03:02:05 [2026-01-26 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630608', 'tblTempUsageDetail_20' ) start [2026-01-26 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630608', 'tblTempUsageDetail_20' ) end [2026-01-26 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630608', 'tblTempVendorCDR_20' ) start [2026-01-26 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630608', 'tblTempVendorCDR_20' ) end [2026-01-26 03:02:17] Production.INFO: ProcessCDR(1,16630608,1,1,2) [2026-01-26 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16630608,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 03:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16630608,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 03:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16630608,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 03:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16630608,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 03:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630608', 'tblTempUsageDetail_20' ) start [2026-01-26 03:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630608', 'tblTempUsageDetail_20' ) end [2026-01-26 03:09:29] Production.ERROR: pbx prc_insertCDR start [2026-01-26 03:09:29] Production.ERROR: pbx prc_insertCDR end [2026-01-26 03:09:29] Production.INFO: ==16233== Releasing lock... [2026-01-26 03:09:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 03:09:29] Production.INFO: 32.25 MB #Memory Used# [2026-01-26 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 01:02:05 [end_date_ymd] => 2026-01-26 04:02:05 [RateCDR] => 1 ) [2026-01-26 04:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 01:02:05' and `end` < '2026-01-26 04:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 04:02:17] Production.INFO: count ==296 [2026-01-26 04:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 01:02:05 - End Time 2026-01-26 04:02:05 [2026-01-26 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630856', 'tblTempUsageDetail_20' ) start [2026-01-26 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16630856', 'tblTempUsageDetail_20' ) end [2026-01-26 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630856', 'tblTempVendorCDR_20' ) start [2026-01-26 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16630856', 'tblTempVendorCDR_20' ) end [2026-01-26 04:02:17] Production.INFO: ProcessCDR(1,16630856,1,1,2) [2026-01-26 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16630856,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 04:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16630856,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 04:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16630856,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 04:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16630856,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 04:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630856', 'tblTempUsageDetail_20' ) start [2026-01-26 04:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16630856', 'tblTempUsageDetail_20' ) end [2026-01-26 04:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-26 04:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-26 04:09:33] Production.INFO: ==20636== Releasing lock... [2026-01-26 04:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 04:09:33] Production.INFO: 31 MB #Memory Used# [2026-01-26 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 02:02:05 [end_date_ymd] => 2026-01-26 05:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 02:02:05' and `end` < '2026-01-26 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-26 05:02:17] Production.INFO: count ==172 [2026-01-26 05:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 02:02:05 - End Time 2026-01-26 05:02:05 [2026-01-26 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631104', 'tblTempUsageDetail_20' ) start [2026-01-26 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631104', 'tblTempUsageDetail_20' ) end [2026-01-26 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631104', 'tblTempVendorCDR_20' ) start [2026-01-26 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631104', 'tblTempVendorCDR_20' ) end [2026-01-26 05:02:17] Production.INFO: ProcessCDR(1,16631104,1,1,2) [2026-01-26 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16631104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 05:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16631104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 05:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16631104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 05:09:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16631104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 05:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631104', 'tblTempUsageDetail_20' ) start [2026-01-26 05:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631104', 'tblTempUsageDetail_20' ) end [2026-01-26 05:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-26 05:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-26 05:09:33] Production.INFO: ==27628== Releasing lock... [2026-01-26 05:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 05:09:33] Production.INFO: 29.25 MB #Memory Used# [2026-01-26 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 03:02:05 [end_date_ymd] => 2026-01-26 06:02:05 [RateCDR] => 1 ) [2026-01-26 06:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 03:02:05' and `end` < '2026-01-26 06:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 06:02:17] Production.INFO: count ==146 [2026-01-26 06:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 03:02:05 - End Time 2026-01-26 06:02:05 [2026-01-26 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631351', 'tblTempUsageDetail_20' ) start [2026-01-26 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631351', 'tblTempUsageDetail_20' ) end [2026-01-26 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631351', 'tblTempVendorCDR_20' ) start [2026-01-26 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631351', 'tblTempVendorCDR_20' ) end [2026-01-26 06:02:17] Production.INFO: ProcessCDR(1,16631351,1,1,2) [2026-01-26 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16631351,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 06:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16631351,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 06:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16631351,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 06:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16631351,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 06:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631351', 'tblTempUsageDetail_20' ) start [2026-01-26 06:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631351', 'tblTempUsageDetail_20' ) end [2026-01-26 06:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-26 06:09:35] Production.ERROR: pbx prc_insertCDR end [2026-01-26 06:09:35] Production.INFO: ==32687== Releasing lock... [2026-01-26 06:09:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 06:09:35] Production.INFO: 29.25 MB #Memory Used# [2026-01-26 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 04:02:05 [end_date_ymd] => 2026-01-26 07:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 04:02:05' and `end` < '2026-01-26 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-26 07:02:17] Production.INFO: count ==137 [2026-01-26 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 04:02:05 - End Time 2026-01-26 07:02:05 [2026-01-26 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631598', 'tblTempUsageDetail_20' ) start [2026-01-26 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631598', 'tblTempUsageDetail_20' ) end [2026-01-26 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631598', 'tblTempVendorCDR_20' ) start [2026-01-26 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631598', 'tblTempVendorCDR_20' ) end [2026-01-26 07:02:17] Production.INFO: ProcessCDR(1,16631598,1,1,2) [2026-01-26 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16631598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 07:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16631598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 07:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16631598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 07:09:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16631598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 07:09:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631598', 'tblTempUsageDetail_20' ) start [2026-01-26 07:09:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631598', 'tblTempUsageDetail_20' ) end [2026-01-26 07:09:20] Production.ERROR: pbx prc_insertCDR start [2026-01-26 07:09:20] Production.ERROR: pbx prc_insertCDR end [2026-01-26 07:09:20] Production.INFO: ==4821== Releasing lock... [2026-01-26 07:09:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 07:09:20] Production.INFO: 29.25 MB #Memory Used# [2026-01-26 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 05:02:06 [end_date_ymd] => 2026-01-26 08:02:06 [RateCDR] => 1 ) [2026-01-26 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-26 05:02:06' and `end` < '2026-01-26 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-26 08:02:18] Production.INFO: count ==292 [2026-01-26 08:02:18] Production.ERROR: pbx CDR StartTime 2026-01-26 05:02:06 - End Time 2026-01-26 08:02:06 [2026-01-26 08:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631845', 'tblTempUsageDetail_20' ) start [2026-01-26 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16631845', 'tblTempUsageDetail_20' ) end [2026-01-26 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631845', 'tblTempVendorCDR_20' ) start [2026-01-26 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16631845', 'tblTempVendorCDR_20' ) end [2026-01-26 08:02:18] Production.INFO: ProcessCDR(1,16631845,1,1,2) [2026-01-26 08:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16631845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 08:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16631845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 08:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16631845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 08:09:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16631845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 08:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631845', 'tblTempUsageDetail_20' ) start [2026-01-26 08:09:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16631845', 'tblTempUsageDetail_20' ) end [2026-01-26 08:09:36] Production.ERROR: pbx prc_insertCDR start [2026-01-26 08:09:37] Production.ERROR: pbx prc_insertCDR end [2026-01-26 08:09:37] Production.INFO: ==9412== Releasing lock... [2026-01-26 08:09:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 08:09:37] Production.INFO: 31 MB #Memory Used# [2026-01-26 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 06:02:06 [end_date_ymd] => 2026-01-26 09:02:06 [RateCDR] => 1 ) [2026-01-26 09:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 06:02:06' and `end` < '2026-01-26 09:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 09:02:18] Production.INFO: count ==915 [2026-01-26 09:02:19] Production.ERROR: pbx CDR StartTime 2026-01-26 06:02:06 - End Time 2026-01-26 09:02:06 [2026-01-26 09:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 09:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632092', 'tblTempUsageDetail_20' ) start [2026-01-26 09:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632092', 'tblTempUsageDetail_20' ) end [2026-01-26 09:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632092', 'tblTempVendorCDR_20' ) start [2026-01-26 09:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632092', 'tblTempVendorCDR_20' ) end [2026-01-26 09:02:19] Production.INFO: ProcessCDR(1,16632092,1,1,2) [2026-01-26 09:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16632092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 09:05:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16632092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 09:05:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16632092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 09:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16632092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 09:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632092', 'tblTempUsageDetail_20' ) start [2026-01-26 09:09:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632092', 'tblTempUsageDetail_20' ) end [2026-01-26 09:09:34] Production.ERROR: pbx prc_insertCDR start [2026-01-26 09:09:34] Production.ERROR: pbx prc_insertCDR end [2026-01-26 09:09:34] Production.INFO: ==14453== Releasing lock... [2026-01-26 09:09:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 09:09:34] Production.INFO: 35.75 MB #Memory Used# [2026-01-26 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 07:02:06 [end_date_ymd] => 2026-01-26 10:02:06 [RateCDR] => 1 ) [2026-01-26 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-26 07:02:06' and `end` < '2026-01-26 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-26 10:02:20] Production.INFO: count ==2929 [2026-01-26 10:02:21] Production.ERROR: pbx CDR StartTime 2026-01-26 07:02:06 - End Time 2026-01-26 10:02:06 [2026-01-26 10:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632339', 'tblTempUsageDetail_20' ) start [2026-01-26 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632339', 'tblTempUsageDetail_20' ) end [2026-01-26 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632339', 'tblTempVendorCDR_20' ) start [2026-01-26 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632339', 'tblTempVendorCDR_20' ) end [2026-01-26 10:02:21] Production.INFO: ProcessCDR(1,16632339,1,1,2) [2026-01-26 10:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16632339,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 10:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16632339,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 10:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16632339,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 10:09:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16632339,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 10:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632339', 'tblTempUsageDetail_20' ) start [2026-01-26 10:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632339', 'tblTempUsageDetail_20' ) end [2026-01-26 10:09:38] Production.ERROR: pbx prc_insertCDR start [2026-01-26 10:09:41] Production.ERROR: pbx prc_insertCDR end [2026-01-26 10:09:41] Production.INFO: ==19284== Releasing lock... [2026-01-26 10:09:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 10:09:41] Production.INFO: 50 MB #Memory Used# [2026-01-26 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 08:02:05 [end_date_ymd] => 2026-01-26 11:02:05 [RateCDR] => 1 ) [2026-01-26 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 08:02:05' and `end` < '2026-01-26 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 11:02:19] Production.INFO: count ==4775 [2026-01-26 11:02:21] Production.ERROR: pbx CDR StartTime 2026-01-26 08:02:05 - End Time 2026-01-26 11:02:05 [2026-01-26 11:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632586', 'tblTempUsageDetail_20' ) start [2026-01-26 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632586', 'tblTempUsageDetail_20' ) end [2026-01-26 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632586', 'tblTempVendorCDR_20' ) start [2026-01-26 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632586', 'tblTempVendorCDR_20' ) end [2026-01-26 11:02:22] Production.INFO: ProcessCDR(1,16632586,1,1,2) [2026-01-26 11:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16632586,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 11:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16632586,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 11:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16632586,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 11:09:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16632586,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 11:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632586', 'tblTempUsageDetail_20' ) start [2026-01-26 11:09:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632586', 'tblTempUsageDetail_20' ) end [2026-01-26 11:09:46] Production.ERROR: pbx prc_insertCDR start [2026-01-26 11:09:49] Production.ERROR: pbx prc_insertCDR end [2026-01-26 11:09:49] Production.INFO: ==24120== Releasing lock... [2026-01-26 11:09:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 11:09:49] Production.INFO: 64 MB #Memory Used# [2026-01-26 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 09:02:05 [end_date_ymd] => 2026-01-26 12:02:05 [RateCDR] => 1 ) [2026-01-26 12:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 09:02:05' and `end` < '2026-01-26 12:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 12:02:22] Production.INFO: count ==6462 [2026-01-26 12:02:25] Production.ERROR: pbx CDR StartTime 2026-01-26 09:02:05 - End Time 2026-01-26 12:02:05 [2026-01-26 12:02:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632833', 'tblTempUsageDetail_20' ) start [2026-01-26 12:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16632833', 'tblTempUsageDetail_20' ) end [2026-01-26 12:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632833', 'tblTempVendorCDR_20' ) start [2026-01-26 12:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16632833', 'tblTempVendorCDR_20' ) end [2026-01-26 12:02:26] Production.INFO: ProcessCDR(1,16632833,1,1,2) [2026-01-26 12:02:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16632833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 12:05:50] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16632833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 12:05:50] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16632833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 12:09:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16632833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 12:09:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632833', 'tblTempUsageDetail_20' ) start [2026-01-26 12:09:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16632833', 'tblTempUsageDetail_20' ) end [2026-01-26 12:09:55] Production.ERROR: pbx prc_insertCDR start [2026-01-26 12:09:57] Production.ERROR: pbx prc_insertCDR end [2026-01-26 12:09:57] Production.INFO: ==28743== Releasing lock... [2026-01-26 12:09:57] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 12:09:57] Production.INFO: 76.5 MB #Memory Used# [2026-01-26 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 10:02:06 [end_date_ymd] => 2026-01-26 13:02:06 [RateCDR] => 1 ) [2026-01-26 13:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 10:02:06' and `end` < '2026-01-26 13: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-26 13:02:21] Production.INFO: count ==6163 [2026-01-26 13:02:24] Production.ERROR: pbx CDR StartTime 2026-01-26 10:02:06 - End Time 2026-01-26 13:02:06 [2026-01-26 13:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633080', 'tblTempUsageDetail_20' ) start [2026-01-26 13:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633080', 'tblTempUsageDetail_20' ) end [2026-01-26 13:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633080', 'tblTempVendorCDR_20' ) start [2026-01-26 13:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633080', 'tblTempVendorCDR_20' ) end [2026-01-26 13:02:25] Production.INFO: ProcessCDR(1,16633080,1,1,2) [2026-01-26 13:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16633080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 13:05:49] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16633080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 13:05:49] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16633080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 13:09:52] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16633080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 13:09:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633080', 'tblTempUsageDetail_20' ) start [2026-01-26 13:09:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633080', 'tblTempUsageDetail_20' ) end [2026-01-26 13:09:53] Production.ERROR: pbx prc_insertCDR start [2026-01-26 13:09:55] Production.ERROR: pbx prc_insertCDR end [2026-01-26 13:09:55] Production.INFO: ==858== Releasing lock... [2026-01-26 13:09:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 13:09:55] Production.INFO: 74.5 MB #Memory Used# [2026-01-26 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 11:02:06 [end_date_ymd] => 2026-01-26 14:02:06 [RateCDR] => 1 ) [2026-01-26 14:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 11:02:06' and `end` < '2026-01-26 14:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 14:02:19] Production.INFO: count ==5983 [2026-01-26 14:02:22] Production.ERROR: pbx CDR StartTime 2026-01-26 11:02:06 - End Time 2026-01-26 14:02:06 [2026-01-26 14:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633327', 'tblTempUsageDetail_20' ) start [2026-01-26 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633327', 'tblTempUsageDetail_20' ) end [2026-01-26 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633327', 'tblTempVendorCDR_20' ) start [2026-01-26 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633327', 'tblTempVendorCDR_20' ) end [2026-01-26 14:02:23] Production.INFO: ProcessCDR(1,16633327,1,1,2) [2026-01-26 14:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16633327,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 14:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16633327,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 14:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16633327,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 14:09:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16633327,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 14:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633327', 'tblTempUsageDetail_20' ) start [2026-01-26 14:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633327', 'tblTempUsageDetail_20' ) end [2026-01-26 14:09:39] Production.ERROR: pbx prc_insertCDR start [2026-01-26 14:09:42] Production.ERROR: pbx prc_insertCDR end [2026-01-26 14:09:42] Production.INFO: ==5449== Releasing lock... [2026-01-26 14:09:42] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 14:09:42] Production.INFO: 73 MB #Memory Used# [2026-01-26 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 12:02:05 [end_date_ymd] => 2026-01-26 15:02:05 [RateCDR] => 1 ) [2026-01-26 15: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-26 12:02:05' and `end` < '2026-01-26 15: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-26 15:02:19] Production.INFO: count ==5327 [2026-01-26 15:02:21] Production.ERROR: pbx CDR StartTime 2026-01-26 12:02:05 - End Time 2026-01-26 15:02:05 [2026-01-26 15:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 15:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633574', 'tblTempUsageDetail_20' ) start [2026-01-26 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633574', 'tblTempUsageDetail_20' ) end [2026-01-26 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633574', 'tblTempVendorCDR_20' ) start [2026-01-26 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633574', 'tblTempVendorCDR_20' ) end [2026-01-26 15:02:22] Production.INFO: ProcessCDR(1,16633574,1,1,2) [2026-01-26 15:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16633574,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 15:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16633574,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 15:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16633574,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 15:09:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16633574,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 15:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633574', 'tblTempUsageDetail_20' ) start [2026-01-26 15:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633574', 'tblTempUsageDetail_20' ) end [2026-01-26 15:09:37] Production.ERROR: pbx prc_insertCDR start [2026-01-26 15:09:40] Production.ERROR: pbx prc_insertCDR end [2026-01-26 15:09:40] Production.INFO: ==9944== Releasing lock... [2026-01-26 15:09:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 15:09:40] Production.INFO: 68 MB #Memory Used# [2026-01-26 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 13:02:05 [end_date_ymd] => 2026-01-26 16:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 13:02:05' and `end` < '2026-01-26 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-26 16:02:19] Production.INFO: count ==5353 [2026-01-26 16:02:22] Production.ERROR: pbx CDR StartTime 2026-01-26 13:02:05 - End Time 2026-01-26 16:02:05 [2026-01-26 16:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633821', 'tblTempUsageDetail_20' ) start [2026-01-26 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16633821', 'tblTempUsageDetail_20' ) end [2026-01-26 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633821', 'tblTempVendorCDR_20' ) start [2026-01-26 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16633821', 'tblTempVendorCDR_20' ) end [2026-01-26 16:02:22] Production.INFO: ProcessCDR(1,16633821,1,1,2) [2026-01-26 16:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16633821,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 16:05:48] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16633821,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 16:05:48] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16633821,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 16:09:59] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16633821,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 16:09:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633821', 'tblTempUsageDetail_20' ) start [2026-01-26 16:10:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16633821', 'tblTempUsageDetail_20' ) end [2026-01-26 16:10:00] Production.ERROR: pbx prc_insertCDR start [2026-01-26 16:10:02] Production.ERROR: pbx prc_insertCDR end [2026-01-26 16:10:02] Production.INFO: ==15936== Releasing lock... [2026-01-26 16:10:02] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 16:10:02] Production.INFO: 68.25 MB #Memory Used# [2026-01-26 17:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 14:02:06 [end_date_ymd] => 2026-01-26 17:02:06 [RateCDR] => 1 ) [2026-01-26 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-26 14:02:06' and `end` < '2026-01-26 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-26 17:02:19] Production.INFO: count ==5277 [2026-01-26 17:02:22] Production.ERROR: pbx CDR StartTime 2026-01-26 14:02:06 - End Time 2026-01-26 17:02:06 [2026-01-26 17:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634068', 'tblTempUsageDetail_20' ) start [2026-01-26 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634068', 'tblTempUsageDetail_20' ) end [2026-01-26 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634068', 'tblTempVendorCDR_20' ) start [2026-01-26 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634068', 'tblTempVendorCDR_20' ) end [2026-01-26 17:02:22] Production.INFO: ProcessCDR(1,16634068,1,1,2) [2026-01-26 17:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16634068,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 17:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16634068,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 17:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16634068,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 17:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16634068,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 17:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634068', 'tblTempUsageDetail_20' ) start [2026-01-26 17:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634068', 'tblTempUsageDetail_20' ) end [2026-01-26 17:09:45] Production.ERROR: pbx prc_insertCDR start [2026-01-26 17:09:47] Production.ERROR: pbx prc_insertCDR end [2026-01-26 17:09:47] Production.INFO: ==20761== Releasing lock... [2026-01-26 17:09:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 17:09:47] Production.INFO: 67.75 MB #Memory Used# [2026-01-26 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 15:02:06 [end_date_ymd] => 2026-01-26 18:02:06 [RateCDR] => 1 ) [2026-01-26 18:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 15:02:06' and `end` < '2026-01-26 18:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 18:02:19] Production.INFO: count ==4700 [2026-01-26 18:02:21] Production.ERROR: pbx CDR StartTime 2026-01-26 15:02:06 - End Time 2026-01-26 18:02:06 [2026-01-26 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634312', 'tblTempUsageDetail_20' ) start [2026-01-26 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634312', 'tblTempUsageDetail_20' ) end [2026-01-26 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634312', 'tblTempVendorCDR_20' ) start [2026-01-26 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634312', 'tblTempVendorCDR_20' ) end [2026-01-26 18:02:21] Production.INFO: ProcessCDR(1,16634312,1,1,2) [2026-01-26 18:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16634312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 18:05:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16634312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 18:05:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16634312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 18:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16634312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 18:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634312', 'tblTempUsageDetail_20' ) start [2026-01-26 18:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634312', 'tblTempUsageDetail_20' ) end [2026-01-26 18:09:44] Production.ERROR: pbx prc_insertCDR start [2026-01-26 18:09:46] Production.ERROR: pbx prc_insertCDR end [2026-01-26 18:09:46] Production.INFO: ==25456== Releasing lock... [2026-01-26 18:09:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 18:09:46] Production.INFO: 63.75 MB #Memory Used# [2026-01-26 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 16:02:05 [end_date_ymd] => 2026-01-26 19:02:05 [RateCDR] => 1 ) [2026-01-26 19:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-26 16:02:05' and `end` < '2026-01-26 19:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-26 19:02:17] Production.INFO: count ==3608 [2026-01-26 19:02:19] Production.ERROR: pbx CDR StartTime 2026-01-26 16:02:05 - End Time 2026-01-26 19:02:05 [2026-01-26 19:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634559', 'tblTempUsageDetail_20' ) start [2026-01-26 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634559', 'tblTempUsageDetail_20' ) end [2026-01-26 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634559', 'tblTempVendorCDR_20' ) start [2026-01-26 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634559', 'tblTempVendorCDR_20' ) end [2026-01-26 19:02:19] Production.INFO: ProcessCDR(1,16634559,1,1,2) [2026-01-26 19:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16634559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 19:05:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16634559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 19:05:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16634559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 19:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16634559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 19:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634559', 'tblTempUsageDetail_20' ) start [2026-01-26 19:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634559', 'tblTempUsageDetail_20' ) end [2026-01-26 19:09:44] Production.ERROR: pbx prc_insertCDR start [2026-01-26 19:09:45] Production.ERROR: pbx prc_insertCDR end [2026-01-26 19:09:45] Production.INFO: ==29973== Releasing lock... [2026-01-26 19:09:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 19:09:45] Production.INFO: 55.75 MB #Memory Used# [2026-01-26 20:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 17:02:06 [end_date_ymd] => 2026-01-26 20:02:06 [RateCDR] => 1 ) [2026-01-26 20: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-26 17:02:06' and `end` < '2026-01-26 20: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-26 20:02:18] Production.INFO: count ==2376 [2026-01-26 20:02:19] Production.ERROR: pbx CDR StartTime 2026-01-26 17:02:06 - End Time 2026-01-26 20:02:06 [2026-01-26 20:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634806', 'tblTempUsageDetail_20' ) start [2026-01-26 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16634806', 'tblTempUsageDetail_20' ) end [2026-01-26 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634806', 'tblTempVendorCDR_20' ) start [2026-01-26 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16634806', 'tblTempVendorCDR_20' ) end [2026-01-26 20:02:19] Production.INFO: ProcessCDR(1,16634806,1,1,2) [2026-01-26 20:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16634806,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 20:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16634806,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 20:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16634806,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 20:09:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16634806,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 20:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634806', 'tblTempUsageDetail_20' ) start [2026-01-26 20:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16634806', 'tblTempUsageDetail_20' ) end [2026-01-26 20:09:39] Production.ERROR: pbx prc_insertCDR start [2026-01-26 20:09:40] Production.ERROR: pbx prc_insertCDR end [2026-01-26 20:09:40] Production.INFO: ==1987== Releasing lock... [2026-01-26 20:09:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 20:09:40] Production.INFO: 46.25 MB #Memory Used# [2026-01-26 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 18:02:05 [end_date_ymd] => 2026-01-26 21:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 18:02:05' and `end` < '2026-01-26 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-26 21:02:17] Production.INFO: count ==1604 [2026-01-26 21:02:18] Production.ERROR: pbx CDR StartTime 2026-01-26 18:02:05 - End Time 2026-01-26 21:02:05 [2026-01-26 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635053', 'tblTempUsageDetail_20' ) start [2026-01-26 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635053', 'tblTempUsageDetail_20' ) end [2026-01-26 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635053', 'tblTempVendorCDR_20' ) start [2026-01-26 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635053', 'tblTempVendorCDR_20' ) end [2026-01-26 21:02:18] Production.INFO: ProcessCDR(1,16635053,1,1,2) [2026-01-26 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16635053,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 21:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16635053,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 21:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16635053,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 21:09:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16635053,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 21:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635053', 'tblTempUsageDetail_20' ) start [2026-01-26 21:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635053', 'tblTempUsageDetail_20' ) end [2026-01-26 21:09:27] Production.ERROR: pbx prc_insertCDR start [2026-01-26 21:09:28] Production.ERROR: pbx prc_insertCDR end [2026-01-26 21:09:28] Production.INFO: ==6330== Releasing lock... [2026-01-26 21:09:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 21:09:28] Production.INFO: 40.25 MB #Memory Used# [2026-01-26 22:02:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 19:02:07 [end_date_ymd] => 2026-01-26 22:02:07 [RateCDR] => 1 ) [2026-01-26 22:02: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-26 19:02:07' and `end` < '2026-01-26 22:02: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-26 22:02:19] Production.INFO: count ==1211 [2026-01-26 22:02:19] Production.ERROR: pbx CDR StartTime 2026-01-26 19:02:07 - End Time 2026-01-26 22:02:07 [2026-01-26 22:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635300', 'tblTempUsageDetail_20' ) start [2026-01-26 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635300', 'tblTempUsageDetail_20' ) end [2026-01-26 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635300', 'tblTempVendorCDR_20' ) start [2026-01-26 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635300', 'tblTempVendorCDR_20' ) end [2026-01-26 22:02:19] Production.INFO: ProcessCDR(1,16635300,1,1,2) [2026-01-26 22:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16635300,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 22:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16635300,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 22:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16635300,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 22:09:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16635300,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 22:09:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635300', 'tblTempUsageDetail_20' ) start [2026-01-26 22:09:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635300', 'tblTempUsageDetail_20' ) end [2026-01-26 22:09:21] Production.ERROR: pbx prc_insertCDR start [2026-01-26 22:09:22] Production.ERROR: pbx prc_insertCDR end [2026-01-26 22:09:22] Production.INFO: ==11421== Releasing lock... [2026-01-26 22:09:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 22:09:22] Production.INFO: 37.5 MB #Memory Used# [2026-01-26 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-26 20:02:05 [end_date_ymd] => 2026-01-26 23:02:05 [RateCDR] => 1 ) [2026-01-26 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-26 20:02:05' and `end` < '2026-01-26 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-26 23:02:17] Production.INFO: count ==917 [2026-01-26 23:02:17] Production.ERROR: pbx CDR StartTime 2026-01-26 20:02:05 - End Time 2026-01-26 23:02:05 [2026-01-26 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-26 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635547', 'tblTempUsageDetail_20' ) start [2026-01-26 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16635547', 'tblTempUsageDetail_20' ) end [2026-01-26 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635547', 'tblTempVendorCDR_20' ) start [2026-01-26 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16635547', 'tblTempVendorCDR_20' ) end [2026-01-26 23:02:18] Production.INFO: ProcessCDR(1,16635547,1,1,2) [2026-01-26 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16635547,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 23:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16635547,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-26 23:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16635547,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 23:09:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16635547,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-26 23:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635547', 'tblTempUsageDetail_20' ) start [2026-01-26 23:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16635547', 'tblTempUsageDetail_20' ) end [2026-01-26 23:09:32] Production.ERROR: pbx prc_insertCDR start [2026-01-26 23:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-26 23:09:33] Production.INFO: ==15825== Releasing lock... [2026-01-26 23:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-26 23:09:33] Production.INFO: 34.75 MB #Memory Used#