[2026-01-24 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 21:02:06 [end_date_ymd] => 2026-01-24 00:02:06 [RateCDR] => 1 ) [2026-01-24 00:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-23 21:02:06' and `end` < '2026-01-24 00:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 00:02:35] Production.INFO: count ==945 [2026-01-24 00:02:36] Production.ERROR: pbx CDR StartTime 2026-01-23 21:02:06 - End Time 2026-01-24 00:02:06 [2026-01-24 00:02:36] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618014', 'tblTempUsageDetail_20' ) start [2026-01-24 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618014', 'tblTempUsageDetail_20' ) end [2026-01-24 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618014', 'tblTempVendorCDR_20' ) start [2026-01-24 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618014', 'tblTempVendorCDR_20' ) end [2026-01-24 00:02:36] Production.INFO: ProcessCDR(1,16618014,1,1,2) [2026-01-24 00:02:36] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16618014,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 00:05:56] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16618014,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 00:05:56] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16618014,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 00:09:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16618014,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 00:09:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618014', 'tblTempUsageDetail_20' ) start [2026-01-24 00:09:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618014', 'tblTempUsageDetail_20' ) end [2026-01-24 00:09:57] Production.ERROR: pbx prc_insertCDR start [2026-01-24 00:09:57] Production.ERROR: pbx prc_insertCDR end [2026-01-24 00:10:05] Production.INFO: ==21274== Releasing lock... [2026-01-24 00:10:05] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 00:10:05] Production.INFO: 39.75 MB #Memory Used# [2026-01-24 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 22:02:06 [end_date_ymd] => 2026-01-24 01:02:06 [RateCDR] => 1 ) [2026-01-24 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-23 22:02:06' and `end` < '2026-01-24 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-24 01:02:18] Production.INFO: count ==942 [2026-01-24 01:02:19] Production.ERROR: pbx CDR StartTime 2026-01-23 22:02:06 - End Time 2026-01-24 01:02:06 [2026-01-24 01:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 01:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618261', 'tblTempUsageDetail_20' ) start [2026-01-24 01:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618261', 'tblTempUsageDetail_20' ) end [2026-01-24 01:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618261', 'tblTempVendorCDR_20' ) start [2026-01-24 01:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618261', 'tblTempVendorCDR_20' ) end [2026-01-24 01:02:19] Production.INFO: ProcessCDR(1,16618261,1,1,2) [2026-01-24 01:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16618261,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 01:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16618261,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 01:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16618261,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 01:09:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16618261,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 01:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618261', 'tblTempUsageDetail_20' ) start [2026-01-24 01:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618261', 'tblTempUsageDetail_20' ) end [2026-01-24 01:09:49] Production.ERROR: pbx prc_insertCDR start [2026-01-24 01:09:50] Production.ERROR: pbx prc_insertCDR end [2026-01-24 01:09:50] Production.INFO: ==26456== Releasing lock... [2026-01-24 01:09:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 01:09:50] Production.INFO: 36.25 MB #Memory Used# [2026-01-24 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 23:02:06 [end_date_ymd] => 2026-01-24 02:02:06 [RateCDR] => 1 ) [2026-01-24 02: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-23 23:02:06' and `end` < '2026-01-24 02: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-24 02:02:23] Production.INFO: count ==841 [2026-01-24 02:02:24] Production.ERROR: pbx CDR StartTime 2026-01-23 23:02:06 - End Time 2026-01-24 02:02:06 [2026-01-24 02:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618508', 'tblTempUsageDetail_20' ) start [2026-01-24 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618508', 'tblTempUsageDetail_20' ) end [2026-01-24 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618508', 'tblTempVendorCDR_20' ) start [2026-01-24 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618508', 'tblTempVendorCDR_20' ) end [2026-01-24 02:02:24] Production.INFO: ProcessCDR(1,16618508,1,1,2) [2026-01-24 02:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16618508,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 02:05:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16618508,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 02:05:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16618508,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 02:09:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16618508,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 02:09:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618508', 'tblTempUsageDetail_20' ) start [2026-01-24 02:09:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618508', 'tblTempUsageDetail_20' ) end [2026-01-24 02:09:46] Production.ERROR: pbx prc_insertCDR start [2026-01-24 02:09:46] Production.ERROR: pbx prc_insertCDR end [2026-01-24 02:09:46] Production.INFO: ==31464== Releasing lock... [2026-01-24 02:09:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 02:09:46] Production.INFO: 34.5 MB #Memory Used# [2026-01-24 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 00:02:05 [end_date_ymd] => 2026-01-24 03:02:05 [RateCDR] => 1 ) [2026-01-24 03:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 00:02:05' and `end` < '2026-01-24 03:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 03:02:17] Production.INFO: count ==817 [2026-01-24 03:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 00:02:05 - End Time 2026-01-24 03:02:05 [2026-01-24 03:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618755', 'tblTempUsageDetail_20' ) start [2026-01-24 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16618755', 'tblTempUsageDetail_20' ) end [2026-01-24 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618755', 'tblTempVendorCDR_20' ) start [2026-01-24 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16618755', 'tblTempVendorCDR_20' ) end [2026-01-24 03:02:18] Production.INFO: ProcessCDR(1,16618755,1,1,2) [2026-01-24 03:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16618755,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 03:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16618755,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 03:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16618755,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 03:09:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16618755,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 03:09:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618755', 'tblTempUsageDetail_20' ) start [2026-01-24 03:09:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16618755', 'tblTempUsageDetail_20' ) end [2026-01-24 03:09:34] Production.ERROR: pbx prc_insertCDR start [2026-01-24 03:09:35] Production.ERROR: pbx prc_insertCDR end [2026-01-24 03:09:35] Production.INFO: ==3585== Releasing lock... [2026-01-24 03:09:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 03:09:35] Production.INFO: 34 MB #Memory Used# [2026-01-24 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 01:02:06 [end_date_ymd] => 2026-01-24 04:02:06 [RateCDR] => 1 ) [2026-01-24 04:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 01:02:06' and `end` < '2026-01-24 04:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 04:02:18] Production.INFO: count ==593 [2026-01-24 04:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 01:02:06 - End Time 2026-01-24 04:02:06 [2026-01-24 04:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619003', 'tblTempUsageDetail_20' ) start [2026-01-24 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619003', 'tblTempUsageDetail_20' ) end [2026-01-24 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619003', 'tblTempVendorCDR_20' ) start [2026-01-24 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619003', 'tblTempVendorCDR_20' ) end [2026-01-24 04:02:18] Production.INFO: ProcessCDR(1,16619003,1,1,2) [2026-01-24 04:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16619003,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 04:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16619003,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 04:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16619003,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 04:09:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16619003,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 04:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619003', 'tblTempUsageDetail_20' ) start [2026-01-24 04:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619003', 'tblTempUsageDetail_20' ) end [2026-01-24 04:09:27] Production.ERROR: pbx prc_insertCDR start [2026-01-24 04:09:27] Production.ERROR: pbx prc_insertCDR end [2026-01-24 04:09:27] Production.INFO: ==7899== Releasing lock... [2026-01-24 04:09:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 04:09:27] Production.INFO: 33.5 MB #Memory Used# [2026-01-24 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 02:02:05 [end_date_ymd] => 2026-01-24 05:02:05 [RateCDR] => 1 ) [2026-01-24 05:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 02:02:05' and `end` < '2026-01-24 05:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 05:02:17] Production.INFO: count ==389 [2026-01-24 05:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 02:02:05 - End Time 2026-01-24 05:02:05 [2026-01-24 05:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619251', 'tblTempUsageDetail_20' ) start [2026-01-24 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619251', 'tblTempUsageDetail_20' ) end [2026-01-24 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619251', 'tblTempVendorCDR_20' ) start [2026-01-24 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619251', 'tblTempVendorCDR_20' ) end [2026-01-24 05:02:18] Production.INFO: ProcessCDR(1,16619251,1,1,2) [2026-01-24 05:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16619251,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 05:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16619251,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 05:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16619251,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 05:09:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16619251,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 05:09:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619251', 'tblTempUsageDetail_20' ) start [2026-01-24 05:09:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619251', 'tblTempUsageDetail_20' ) end [2026-01-24 05:09:34] Production.ERROR: pbx prc_insertCDR start [2026-01-24 05:09:34] Production.ERROR: pbx prc_insertCDR end [2026-01-24 05:09:34] Production.INFO: ==12366== Releasing lock... [2026-01-24 05:09:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 05:09:34] Production.INFO: 31.5 MB #Memory Used# [2026-01-24 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 03:02:05 [end_date_ymd] => 2026-01-24 06:02:05 [RateCDR] => 1 ) [2026-01-24 06:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 03:02:05' and `end` < '2026-01-24 06:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 06:02:17] Production.INFO: count ==225 [2026-01-24 06:02:17] Production.ERROR: pbx CDR StartTime 2026-01-24 03:02:05 - End Time 2026-01-24 06:02:05 [2026-01-24 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619498', 'tblTempUsageDetail_20' ) start [2026-01-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619498', 'tblTempUsageDetail_20' ) end [2026-01-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619498', 'tblTempVendorCDR_20' ) start [2026-01-24 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619498', 'tblTempVendorCDR_20' ) end [2026-01-24 06:02:17] Production.INFO: ProcessCDR(1,16619498,1,1,2) [2026-01-24 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16619498,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 06:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16619498,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 06:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16619498,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 06:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16619498,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 06:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619498', 'tblTempUsageDetail_20' ) start [2026-01-24 06:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619498', 'tblTempUsageDetail_20' ) end [2026-01-24 06:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-24 06:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-24 06:09:33] Production.INFO: ==17033== Releasing lock... [2026-01-24 06:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 06:09:33] Production.INFO: 30.25 MB #Memory Used# [2026-01-24 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 04:02:05 [end_date_ymd] => 2026-01-24 07:02:05 [RateCDR] => 1 ) [2026-01-24 07:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 04:02:05' and `end` < '2026-01-24 07:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 07:02:17] Production.INFO: count ==102 [2026-01-24 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-24 04:02:05 - End Time 2026-01-24 07:02:05 [2026-01-24 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619745', 'tblTempUsageDetail_20' ) start [2026-01-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619745', 'tblTempUsageDetail_20' ) end [2026-01-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619745', 'tblTempVendorCDR_20' ) start [2026-01-24 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619745', 'tblTempVendorCDR_20' ) end [2026-01-24 07:02:17] Production.INFO: ProcessCDR(1,16619745,1,1,2) [2026-01-24 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16619745,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 07:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16619745,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 07:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16619745,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 07:09:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16619745,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 07:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619745', 'tblTempUsageDetail_20' ) start [2026-01-24 07:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619745', 'tblTempUsageDetail_20' ) end [2026-01-24 07:09:39] Production.ERROR: pbx prc_insertCDR start [2026-01-24 07:09:39] Production.ERROR: pbx prc_insertCDR end [2026-01-24 07:09:39] Production.INFO: ==21653== Releasing lock... [2026-01-24 07:09:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 07:09:39] Production.INFO: 28.75 MB #Memory Used# [2026-01-24 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 05:02:05 [end_date_ymd] => 2026-01-24 08:02:05 [RateCDR] => 1 ) [2026-01-24 08: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-24 05:02:05' and `end` < '2026-01-24 08: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-24 08:02:17] Production.INFO: count ==150 [2026-01-24 08:02:17] Production.ERROR: pbx CDR StartTime 2026-01-24 05:02:05 - End Time 2026-01-24 08:02:05 [2026-01-24 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619992', 'tblTempUsageDetail_20' ) start [2026-01-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16619992', 'tblTempUsageDetail_20' ) end [2026-01-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619992', 'tblTempVendorCDR_20' ) start [2026-01-24 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16619992', 'tblTempVendorCDR_20' ) end [2026-01-24 08:02:17] Production.INFO: ProcessCDR(1,16619992,1,1,2) [2026-01-24 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16619992,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 08:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16619992,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 08:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16619992,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 08:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16619992,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 08:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619992', 'tblTempUsageDetail_20' ) start [2026-01-24 08:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16619992', 'tblTempUsageDetail_20' ) end [2026-01-24 08:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-24 08:09:35] Production.ERROR: pbx prc_insertCDR end [2026-01-24 08:09:35] Production.INFO: ==26368== Releasing lock... [2026-01-24 08:09:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 08:09:35] Production.INFO: 29.5 MB #Memory Used# [2026-01-24 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 06:02:05 [end_date_ymd] => 2026-01-24 09:02:05 [RateCDR] => 1 ) [2026-01-24 09:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 06:02:05' and `end` < '2026-01-24 09:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 09:02:17] Production.INFO: count ==308 [2026-01-24 09:02:17] Production.ERROR: pbx CDR StartTime 2026-01-24 06:02:05 - End Time 2026-01-24 09:02:05 [2026-01-24 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620239', 'tblTempUsageDetail_20' ) start [2026-01-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620239', 'tblTempUsageDetail_20' ) end [2026-01-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620239', 'tblTempVendorCDR_20' ) start [2026-01-24 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620239', 'tblTempVendorCDR_20' ) end [2026-01-24 09:02:17] Production.INFO: ProcessCDR(1,16620239,1,1,2) [2026-01-24 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16620239,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 09:05:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16620239,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 09:05:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16620239,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 09:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16620239,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 09:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620239', 'tblTempUsageDetail_20' ) start [2026-01-24 09:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620239', 'tblTempUsageDetail_20' ) end [2026-01-24 09:09:45] Production.ERROR: pbx prc_insertCDR start [2026-01-24 09:09:45] Production.ERROR: pbx prc_insertCDR end [2026-01-24 09:09:45] Production.INFO: ==30731== Releasing lock... [2026-01-24 09:09:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 09:09:45] Production.INFO: 30.75 MB #Memory Used# [2026-01-24 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 07:02:06 [end_date_ymd] => 2026-01-24 10:02:06 [RateCDR] => 1 ) [2026-01-24 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-24 07:02:06' and `end` < '2026-01-24 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-24 10:02:18] Production.INFO: count ==753 [2026-01-24 10:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 07:02:06 - End Time 2026-01-24 10:02:06 [2026-01-24 10:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620486', 'tblTempUsageDetail_20' ) start [2026-01-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620486', 'tblTempUsageDetail_20' ) end [2026-01-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620486', 'tblTempVendorCDR_20' ) start [2026-01-24 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620486', 'tblTempVendorCDR_20' ) end [2026-01-24 10:02:18] Production.INFO: ProcessCDR(1,16620486,1,1,2) [2026-01-24 10:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16620486,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 10:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16620486,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 10:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16620486,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 10:09:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16620486,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 10:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620486', 'tblTempUsageDetail_20' ) start [2026-01-24 10:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620486', 'tblTempUsageDetail_20' ) end [2026-01-24 10:09:23] Production.ERROR: pbx prc_insertCDR start [2026-01-24 10:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-24 10:09:23] Production.INFO: ==2740== Releasing lock... [2026-01-24 10:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 10:09:23] Production.INFO: 33.75 MB #Memory Used# [2026-01-24 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 08:02:05 [end_date_ymd] => 2026-01-24 11:02:05 [RateCDR] => 1 ) [2026-01-24 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 08:02:05' and `end` < '2026-01-24 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 11:02:17] Production.INFO: count ==1317 [2026-01-24 11:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 08:02:05 - End Time 2026-01-24 11:02:05 [2026-01-24 11:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 11:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620733', 'tblTempUsageDetail_20' ) start [2026-01-24 11:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620733', 'tblTempUsageDetail_20' ) end [2026-01-24 11:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620733', 'tblTempVendorCDR_20' ) start [2026-01-24 11:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620733', 'tblTempVendorCDR_20' ) end [2026-01-24 11:02:18] Production.INFO: ProcessCDR(1,16620733,1,1,2) [2026-01-24 11:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16620733,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 11:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16620733,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 11:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16620733,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 11:09:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16620733,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 11:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620733', 'tblTempUsageDetail_20' ) start [2026-01-24 11:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620733', 'tblTempUsageDetail_20' ) end [2026-01-24 11:09:42] Production.ERROR: pbx prc_insertCDR start [2026-01-24 11:09:43] Production.ERROR: pbx prc_insertCDR end [2026-01-24 11:09:43] Production.INFO: ==7166== Releasing lock... [2026-01-24 11:09:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 11:09:43] Production.INFO: 38 MB #Memory Used# [2026-01-24 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 09:02:05 [end_date_ymd] => 2026-01-24 12:02:05 [RateCDR] => 1 ) [2026-01-24 12:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 09:02:05' and `end` < '2026-01-24 12:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 12:02:18] Production.INFO: count ==1819 [2026-01-24 12:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 09:02:05 - End Time 2026-01-24 12:02:05 [2026-01-24 12:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 12:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620980', 'tblTempUsageDetail_20' ) start [2026-01-24 12:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16620980', 'tblTempUsageDetail_20' ) end [2026-01-24 12:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620980', 'tblTempVendorCDR_20' ) start [2026-01-24 12:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16620980', 'tblTempVendorCDR_20' ) end [2026-01-24 12:02:19] Production.INFO: ProcessCDR(1,16620980,1,1,2) [2026-01-24 12:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16620980,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 12:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16620980,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 12:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16620980,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 12:09:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16620980,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 12:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620980', 'tblTempUsageDetail_20' ) start [2026-01-24 12:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16620980', 'tblTempUsageDetail_20' ) end [2026-01-24 12:09:38] Production.ERROR: pbx prc_insertCDR start [2026-01-24 12:09:38] Production.ERROR: pbx prc_insertCDR end [2026-01-24 12:09:38] Production.INFO: ==13430== Releasing lock... [2026-01-24 12:09:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 12:09:39] Production.INFO: 41.75 MB #Memory Used# [2026-01-24 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 10:02:05 [end_date_ymd] => 2026-01-24 13:02:05 [RateCDR] => 1 ) [2026-01-24 13:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 10:02:05' and `end` < '2026-01-24 13:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 13:02:17] Production.INFO: count ==2007 [2026-01-24 13:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 10:02:05 - End Time 2026-01-24 13:02:05 [2026-01-24 13:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 13:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621227', 'tblTempUsageDetail_20' ) start [2026-01-24 13:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621227', 'tblTempUsageDetail_20' ) end [2026-01-24 13:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621227', 'tblTempVendorCDR_20' ) start [2026-01-24 13:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621227', 'tblTempVendorCDR_20' ) end [2026-01-24 13:02:18] Production.INFO: ProcessCDR(1,16621227,1,1,2) [2026-01-24 13:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16621227,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 13:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16621227,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 13:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16621227,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 13:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16621227,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 13:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621227', 'tblTempUsageDetail_20' ) start [2026-01-24 13:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621227', 'tblTempUsageDetail_20' ) end [2026-01-24 13:09:44] Production.ERROR: pbx prc_insertCDR start [2026-01-24 13:09:45] Production.ERROR: pbx prc_insertCDR end [2026-01-24 13:09:45] Production.INFO: ==20516== Releasing lock... [2026-01-24 13:09:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 13:09:45] Production.INFO: 43.25 MB #Memory Used# [2026-01-24 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 11:02:06 [end_date_ymd] => 2026-01-24 14:02:06 [RateCDR] => 1 ) [2026-01-24 14:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 11:02:06' and `end` < '2026-01-24 14:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 14:02:18] Production.INFO: count ==2001 [2026-01-24 14:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 11:02:06 - End Time 2026-01-24 14:02:06 [2026-01-24 14:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 14:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621474', 'tblTempUsageDetail_20' ) start [2026-01-24 14:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621474', 'tblTempUsageDetail_20' ) end [2026-01-24 14:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621474', 'tblTempVendorCDR_20' ) start [2026-01-24 14:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621474', 'tblTempVendorCDR_20' ) end [2026-01-24 14:02:19] Production.INFO: ProcessCDR(1,16621474,1,1,2) [2026-01-24 14:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16621474,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 14:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16621474,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 14:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16621474,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 14:09:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16621474,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 14:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621474', 'tblTempUsageDetail_20' ) start [2026-01-24 14:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621474', 'tblTempUsageDetail_20' ) end [2026-01-24 14:09:49] Production.ERROR: pbx prc_insertCDR start [2026-01-24 14:09:50] Production.ERROR: pbx prc_insertCDR end [2026-01-24 14:09:50] Production.INFO: ==27460== Releasing lock... [2026-01-24 14:09:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 14:09:50] Production.INFO: 43.25 MB #Memory Used# [2026-01-24 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 12:02:05 [end_date_ymd] => 2026-01-24 15:02:05 [RateCDR] => 1 ) [2026-01-24 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-24 12:02:05' and `end` < '2026-01-24 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-24 15:02:17] Production.INFO: count ==2025 [2026-01-24 15:02:18] Production.ERROR: pbx CDR StartTime 2026-01-24 12:02:05 - End Time 2026-01-24 15:02:05 [2026-01-24 15:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 15:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621721', 'tblTempUsageDetail_20' ) start [2026-01-24 15:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621721', 'tblTempUsageDetail_20' ) end [2026-01-24 15:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621721', 'tblTempVendorCDR_20' ) start [2026-01-24 15:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621721', 'tblTempVendorCDR_20' ) end [2026-01-24 15:02:18] Production.INFO: ProcessCDR(1,16621721,1,1,2) [2026-01-24 15:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16621721,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 15:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16621721,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 15:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16621721,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 15:09:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16621721,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 15:09:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621721', 'tblTempUsageDetail_20' ) start [2026-01-24 15:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621721', 'tblTempUsageDetail_20' ) end [2026-01-24 15:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-24 15:09:27] Production.ERROR: pbx prc_insertCDR end [2026-01-24 15:09:27] Production.INFO: ==32403== Releasing lock... [2026-01-24 15:09:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 15:09:27] Production.INFO: 43.5 MB #Memory Used# [2026-01-24 16:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 13:02:06 [end_date_ymd] => 2026-01-24 16:02:06 [RateCDR] => 1 ) [2026-01-24 16:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 13:02:06' and `end` < '2026-01-24 16:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 16:02:18] Production.INFO: count ==2081 [2026-01-24 16:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 13:02:06 - End Time 2026-01-24 16:02:06 [2026-01-24 16:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 16:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621968', 'tblTempUsageDetail_20' ) start [2026-01-24 16:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16621968', 'tblTempUsageDetail_20' ) end [2026-01-24 16:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621968', 'tblTempVendorCDR_20' ) start [2026-01-24 16:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16621968', 'tblTempVendorCDR_20' ) end [2026-01-24 16:02:19] Production.INFO: ProcessCDR(1,16621968,1,1,2) [2026-01-24 16:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16621968,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 16:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16621968,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 16:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16621968,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 16:09:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16621968,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 16:09:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621968', 'tblTempUsageDetail_20' ) start [2026-01-24 16:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16621968', 'tblTempUsageDetail_20' ) end [2026-01-24 16:09:22] Production.ERROR: pbx prc_insertCDR start [2026-01-24 16:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-24 16:09:23] Production.INFO: ==5344== Releasing lock... [2026-01-24 16:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 16:09:23] Production.INFO: 44 MB #Memory Used# [2026-01-24 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 14:02:05 [end_date_ymd] => 2026-01-24 17:02:05 [RateCDR] => 1 ) [2026-01-24 17:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 14:02:05' and `end` < '2026-01-24 17:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 17:02:18] Production.INFO: count ==2352 [2026-01-24 17:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 14:02:05 - End Time 2026-01-24 17:02:05 [2026-01-24 17:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 17:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622215', 'tblTempUsageDetail_20' ) start [2026-01-24 17:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622215', 'tblTempUsageDetail_20' ) end [2026-01-24 17:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622215', 'tblTempVendorCDR_20' ) start [2026-01-24 17:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622215', 'tblTempVendorCDR_20' ) end [2026-01-24 17:02:19] Production.INFO: ProcessCDR(1,16622215,1,1,2) [2026-01-24 17:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16622215,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 17:05:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16622215,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 17:05:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16622215,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 17:10:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16622215,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 17:10:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622215', 'tblTempUsageDetail_20' ) start [2026-01-24 17:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622215', 'tblTempUsageDetail_20' ) end [2026-01-24 17:10:27] Production.ERROR: pbx prc_insertCDR start [2026-01-24 17:10:29] Production.ERROR: pbx prc_insertCDR end [2026-01-24 17:10:29] Production.INFO: ==10496== Releasing lock... [2026-01-24 17:10:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 17:10:29] Production.INFO: 45.75 MB #Memory Used# [2026-01-24 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 15:02:05 [end_date_ymd] => 2026-01-24 18:02:05 [RateCDR] => 1 ) [2026-01-24 18:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 15:02:05' and `end` < '2026-01-24 18:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 18:02:19] Production.INFO: count ==2807 [2026-01-24 18:02:20] Production.ERROR: pbx CDR StartTime 2026-01-24 15:02:05 - End Time 2026-01-24 18:02:05 [2026-01-24 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622459', 'tblTempUsageDetail_20' ) start [2026-01-24 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622459', 'tblTempUsageDetail_20' ) end [2026-01-24 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622459', 'tblTempVendorCDR_20' ) start [2026-01-24 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622459', 'tblTempVendorCDR_20' ) end [2026-01-24 18:02:20] Production.INFO: ProcessCDR(1,16622459,1,1,2) [2026-01-24 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16622459,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 18:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16622459,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 18:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16622459,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 18:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16622459,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 18:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622459', 'tblTempUsageDetail_20' ) start [2026-01-24 18:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622459', 'tblTempUsageDetail_20' ) end [2026-01-24 18:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-24 18:09:36] Production.ERROR: pbx prc_insertCDR end [2026-01-24 18:09:36] Production.INFO: ==14900== Releasing lock... [2026-01-24 18:09:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 18:09:36] Production.INFO: 49.5 MB #Memory Used# [2026-01-24 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 16:02:05 [end_date_ymd] => 2026-01-24 19:02:05 [RateCDR] => 1 ) [2026-01-24 19:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 16:02:05' and `end` < '2026-01-24 19:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 19:02:18] Production.INFO: count ==3129 [2026-01-24 19:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 16:02:05 - End Time 2026-01-24 19:02:05 [2026-01-24 19:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622706', 'tblTempUsageDetail_20' ) start [2026-01-24 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622706', 'tblTempUsageDetail_20' ) end [2026-01-24 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622706', 'tblTempVendorCDR_20' ) start [2026-01-24 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622706', 'tblTempVendorCDR_20' ) end [2026-01-24 19:02:19] Production.INFO: ProcessCDR(1,16622706,1,1,2) [2026-01-24 19:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16622706,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 19:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16622706,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 19:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16622706,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 19:09:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16622706,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 19:09:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622706', 'tblTempUsageDetail_20' ) start [2026-01-24 19:09:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622706', 'tblTempUsageDetail_20' ) end [2026-01-24 19:09:48] Production.ERROR: pbx prc_insertCDR start [2026-01-24 19:09:50] Production.ERROR: pbx prc_insertCDR end [2026-01-24 19:09:50] Production.INFO: ==19442== Releasing lock... [2026-01-24 19:09:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 19:09:50] Production.INFO: 52.25 MB #Memory Used# [2026-01-24 20:02:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 17:02:07 [end_date_ymd] => 2026-01-24 20:02:07 [RateCDR] => 1 ) [2026-01-24 20: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-24 17:02:07' and `end` < '2026-01-24 20: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-24 20:02:19] Production.INFO: count ==3087 [2026-01-24 20:02:20] Production.ERROR: pbx CDR StartTime 2026-01-24 17:02:07 - End Time 2026-01-24 20:02:07 [2026-01-24 20:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 20:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622953', 'tblTempUsageDetail_20' ) start [2026-01-24 20:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16622953', 'tblTempUsageDetail_20' ) end [2026-01-24 20:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622953', 'tblTempVendorCDR_20' ) start [2026-01-24 20:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16622953', 'tblTempVendorCDR_20' ) end [2026-01-24 20:02:21] Production.INFO: ProcessCDR(1,16622953,1,1,2) [2026-01-24 20:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16622953,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 20:05:46] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16622953,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 20:05:46] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16622953,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 20:09:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16622953,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 20:09:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622953', 'tblTempUsageDetail_20' ) start [2026-01-24 20:09:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16622953', 'tblTempUsageDetail_20' ) end [2026-01-24 20:09:56] Production.ERROR: pbx prc_insertCDR start [2026-01-24 20:09:57] Production.ERROR: pbx prc_insertCDR end [2026-01-24 20:09:57] Production.INFO: ==24091== Releasing lock... [2026-01-24 20:09:57] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 20:09:57] Production.INFO: 51.5 MB #Memory Used# [2026-01-24 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 18:02:06 [end_date_ymd] => 2026-01-24 21:02:06 [RateCDR] => 1 ) [2026-01-24 21: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-24 18:02:06' and `end` < '2026-01-24 21: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-24 21:02:19] Production.INFO: count ==2571 [2026-01-24 21:02:20] Production.ERROR: pbx CDR StartTime 2026-01-24 18:02:06 - End Time 2026-01-24 21:02:06 [2026-01-24 21:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 21:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623200', 'tblTempUsageDetail_20' ) start [2026-01-24 21:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623200', 'tblTempUsageDetail_20' ) end [2026-01-24 21:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623200', 'tblTempVendorCDR_20' ) start [2026-01-24 21:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623200', 'tblTempVendorCDR_20' ) end [2026-01-24 21:02:20] Production.INFO: ProcessCDR(1,16623200,1,1,2) [2026-01-24 21:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16623200,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 21:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16623200,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 21:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16623200,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 21:09:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16623200,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 21:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623200', 'tblTempUsageDetail_20' ) start [2026-01-24 21:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623200', 'tblTempUsageDetail_20' ) end [2026-01-24 21:09:41] Production.ERROR: pbx prc_insertCDR start [2026-01-24 21:09:42] Production.ERROR: pbx prc_insertCDR end [2026-01-24 21:09:42] Production.INFO: ==28830== Releasing lock... [2026-01-24 21:09:42] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 21:09:42] Production.INFO: 47.5 MB #Memory Used# [2026-01-24 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 19:02:06 [end_date_ymd] => 2026-01-24 22:02:06 [RateCDR] => 1 ) [2026-01-24 22:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-24 19:02:06' and `end` < '2026-01-24 22:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-24 22:02:19] Production.INFO: count ==2111 [2026-01-24 22:02:19] Production.ERROR: pbx CDR StartTime 2026-01-24 19:02:06 - End Time 2026-01-24 22:02:06 [2026-01-24 22:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623447', 'tblTempUsageDetail_20' ) start [2026-01-24 22:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623447', 'tblTempUsageDetail_20' ) end [2026-01-24 22:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623447', 'tblTempVendorCDR_20' ) start [2026-01-24 22:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623447', 'tblTempVendorCDR_20' ) end [2026-01-24 22:02:20] Production.INFO: ProcessCDR(1,16623447,1,1,2) [2026-01-24 22:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16623447,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 22:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16623447,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 22:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16623447,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 22:09:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16623447,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 22:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623447', 'tblTempUsageDetail_20' ) start [2026-01-24 22:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623447', 'tblTempUsageDetail_20' ) end [2026-01-24 22:09:49] Production.ERROR: pbx prc_insertCDR start [2026-01-24 22:09:50] Production.ERROR: pbx prc_insertCDR end [2026-01-24 22:09:50] Production.INFO: ==1191== Releasing lock... [2026-01-24 22:09:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 22:09:50] Production.INFO: 44 MB #Memory Used# [2026-01-24 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-24 20:02:05 [end_date_ymd] => 2026-01-24 23:02:05 [RateCDR] => 1 ) [2026-01-24 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-24 20:02:05' and `end` < '2026-01-24 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-24 23:02:17] Production.INFO: count ==1722 [2026-01-24 23:02:17] Production.ERROR: pbx CDR StartTime 2026-01-24 20:02:05 - End Time 2026-01-24 23:02:05 [2026-01-24 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-24 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623694', 'tblTempUsageDetail_20' ) start [2026-01-24 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16623694', 'tblTempUsageDetail_20' ) end [2026-01-24 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623694', 'tblTempVendorCDR_20' ) start [2026-01-24 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16623694', 'tblTempVendorCDR_20' ) end [2026-01-24 23:02:18] Production.INFO: ProcessCDR(1,16623694,1,1,2) [2026-01-24 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16623694,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 23:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16623694,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-24 23:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16623694,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 23:09:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16623694,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-24 23:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623694', 'tblTempUsageDetail_20' ) start [2026-01-24 23:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16623694', 'tblTempUsageDetail_20' ) end [2026-01-24 23:09:42] Production.ERROR: pbx prc_insertCDR start [2026-01-24 23:09:43] Production.ERROR: pbx prc_insertCDR end [2026-01-24 23:09:43] Production.INFO: ==6376== Releasing lock... [2026-01-24 23:09:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-24 23:09:43] Production.INFO: 41.5 MB #Memory Used#