[2026-03-23 00:02:05] Production.INFO: next invoice date [2026-03-23 00:02:05] Production.INFO: 2026-04-23 [2026-03-23 00:02:05] Production.INFO: getdaysdiff [2026-03-23 00:02:05] Production.INFO: +31 [2026-03-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (226,11,1,31,31,'RMScheduler',2026-03-23 00:02:05,1,0,,,0) [2026-03-23 00:02:05] Production.INFO: next invoice date [2026-03-23 00:02:05] Production.INFO: 2026-04-23 [2026-03-23 00:02:05] Production.INFO: getdaysdiff [2026-03-23 00:02:05] Production.INFO: +31 [2026-03-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (226,13,2,31,31,'RMScheduler',2026-03-23 00:02:05,1,0,,,0) [2026-03-23 00:02:05] Production.INFO: next invoice date [2026-03-23 00:02:05] Production.INFO: 2026-04-23 [2026-03-23 00:02:05] Production.INFO: getdaysdiff [2026-03-23 00:02:05] Production.INFO: +31 [2026-03-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (252,16,1,31,31,'RMScheduler',2026-03-23 00:02:05,1,0,,,0) [2026-03-23 00:02:05] Production.INFO: next invoice date [2026-03-23 00:02:05] Production.INFO: 2026-04-23 [2026-03-23 00:02:05] Production.INFO: getdaysdiff [2026-03-23 00:02:05] Production.INFO: +31 [2026-03-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (252,13,2,31,31,'RMScheduler',2026-03-23 00:02:05,1,0,,,0) [2026-03-23 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 21:02:06 [end_date_ymd] => 2026-03-23 00:02:06 [RateCDR] => 1 ) [2026-03-23 00:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-22 21:02:06' and `end` < '2026-03-23 00:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 00:02:18] Production.INFO: count ==629 [2026-03-23 00:02:19] Production.ERROR: pbx CDR StartTime 2026-03-22 21:02:06 - End Time 2026-03-23 00:02:06 [2026-03-23 00:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961585', 'tblTempUsageDetail_20' ) start [2026-03-23 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961585', 'tblTempUsageDetail_20' ) end [2026-03-23 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961585', 'tblTempVendorCDR_20' ) start [2026-03-23 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961585', 'tblTempVendorCDR_20' ) end [2026-03-23 00:02:19] Production.INFO: ProcessCDR(1,16961585,1,1,2) [2026-03-23 00:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16961585,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 00:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16961585,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 00:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16961585,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 00:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16961585,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 00:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961585', 'tblTempUsageDetail_20' ) start [2026-03-23 00:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961585', 'tblTempUsageDetail_20' ) end [2026-03-23 00:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-23 00:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-23 00:02:39] Production.INFO: ==7022== Releasing lock... [2026-03-23 00:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 00:02:39] Production.INFO: 37.5 MB #Memory Used# [2026-03-23 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 22:02:05 [end_date_ymd] => 2026-03-23 01:02:05 [RateCDR] => 1 ) [2026-03-23 01:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-22 22:02:05' and `end` < '2026-03-23 01:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 01:02:27] Production.INFO: count ==547 [2026-03-23 01:02:27] Production.ERROR: pbx CDR StartTime 2026-03-22 22:02:05 - End Time 2026-03-23 01:02:05 [2026-03-23 01:02:27] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 01:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961832', 'tblTempUsageDetail_20' ) start [2026-03-23 01:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961832', 'tblTempUsageDetail_20' ) end [2026-03-23 01:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961832', 'tblTempVendorCDR_20' ) start [2026-03-23 01:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961832', 'tblTempVendorCDR_20' ) end [2026-03-23 01:02:27] Production.INFO: ProcessCDR(1,16961832,1,1,2) [2026-03-23 01:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16961832,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 01:02:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16961832,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 01:02:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16961832,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 01:02:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16961832,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 01:02:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961832', 'tblTempUsageDetail_20' ) start [2026-03-23 01:02:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961832', 'tblTempUsageDetail_20' ) end [2026-03-23 01:02:49] Production.ERROR: pbx prc_insertCDR start [2026-03-23 01:02:49] Production.ERROR: pbx prc_insertCDR end [2026-03-23 01:02:49] Production.INFO: ==11464== Releasing lock... [2026-03-23 01:02:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 01:02:49] Production.INFO: 32.5 MB #Memory Used# [2026-03-23 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 23:02:06 [end_date_ymd] => 2026-03-23 02:02:06 [RateCDR] => 1 ) [2026-03-23 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-03-22 23:02:06' and `end` < '2026-03-23 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-03-23 02:02:23] Production.INFO: count ==509 [2026-03-23 02:02:23] Production.ERROR: pbx CDR StartTime 2026-03-22 23:02:06 - End Time 2026-03-23 02:02:06 [2026-03-23 02:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 02:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962079', 'tblTempUsageDetail_20' ) start [2026-03-23 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962079', 'tblTempUsageDetail_20' ) end [2026-03-23 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962079', 'tblTempVendorCDR_20' ) start [2026-03-23 02:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962079', 'tblTempVendorCDR_20' ) end [2026-03-23 02:02:24] Production.INFO: ProcessCDR(1,16962079,1,1,2) [2026-03-23 02:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16962079,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 02:02:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16962079,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 02:02:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16962079,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 02:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16962079,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 02:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962079', 'tblTempUsageDetail_20' ) start [2026-03-23 02:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962079', 'tblTempUsageDetail_20' ) end [2026-03-23 02:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-23 02:02:44] Production.ERROR: pbx prc_insertCDR end [2026-03-23 02:02:44] Production.INFO: ==15892== Releasing lock... [2026-03-23 02:02:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 02:02:44] Production.INFO: 32.5 MB #Memory Used# [2026-03-23 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 00:02:06 [end_date_ymd] => 2026-03-23 03:02:06 [RateCDR] => 1 ) [2026-03-23 03:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 00:02:06' and `end` < '2026-03-23 03:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 03:02:17] Production.INFO: count ==454 [2026-03-23 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 00:02:06 - End Time 2026-03-23 03:02:06 [2026-03-23 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962326', 'tblTempUsageDetail_20' ) start [2026-03-23 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962326', 'tblTempUsageDetail_20' ) end [2026-03-23 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962326', 'tblTempVendorCDR_20' ) start [2026-03-23 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962326', 'tblTempVendorCDR_20' ) end [2026-03-23 03:02:18] Production.INFO: ProcessCDR(1,16962326,1,1,2) [2026-03-23 03:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16962326,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 03:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16962326,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 03:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16962326,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 03:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16962326,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 03:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962326', 'tblTempUsageDetail_20' ) start [2026-03-23 03:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962326', 'tblTempUsageDetail_20' ) end [2026-03-23 03:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-23 03:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-23 03:02:38] Production.INFO: ==20458== Releasing lock... [2026-03-23 03:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 03:02:38] Production.INFO: 32.25 MB #Memory Used# [2026-03-23 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 01:02:05 [end_date_ymd] => 2026-03-23 04:02:05 [RateCDR] => 1 ) [2026-03-23 04:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 01:02:05' and `end` < '2026-03-23 04:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 04:02:17] Production.INFO: count ==281 [2026-03-23 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 01:02:05 - End Time 2026-03-23 04:02:05 [2026-03-23 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962574', 'tblTempUsageDetail_20' ) start [2026-03-23 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962574', 'tblTempUsageDetail_20' ) end [2026-03-23 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962574', 'tblTempVendorCDR_20' ) start [2026-03-23 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962574', 'tblTempVendorCDR_20' ) end [2026-03-23 04:02:17] Production.INFO: ProcessCDR(1,16962574,1,1,2) [2026-03-23 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16962574,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 04:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16962574,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 04:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16962574,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 04:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16962574,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 04:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962574', 'tblTempUsageDetail_20' ) start [2026-03-23 04:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962574', 'tblTempUsageDetail_20' ) end [2026-03-23 04:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-23 04:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-23 04:02:37] Production.INFO: ==25863== Releasing lock... [2026-03-23 04:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 04:02:37] Production.INFO: 30.5 MB #Memory Used# [2026-03-23 05:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 02:02:06 [end_date_ymd] => 2026-03-23 05:02:06 [RateCDR] => 1 ) [2026-03-23 05:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 02:02:06' and `end` < '2026-03-23 05:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 05:02:18] Production.INFO: count ==155 [2026-03-23 05:02:18] Production.ERROR: pbx CDR StartTime 2026-03-23 02:02:06 - End Time 2026-03-23 05:02:06 [2026-03-23 05:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962822', 'tblTempUsageDetail_20' ) start [2026-03-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16962822', 'tblTempUsageDetail_20' ) end [2026-03-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962822', 'tblTempVendorCDR_20' ) start [2026-03-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16962822', 'tblTempVendorCDR_20' ) end [2026-03-23 05:02:18] Production.INFO: ProcessCDR(1,16962822,1,1,2) [2026-03-23 05:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16962822,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 05:02:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16962822,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 05:02:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16962822,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 05:02:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16962822,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 05:02:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962822', 'tblTempUsageDetail_20' ) start [2026-03-23 05:02:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16962822', 'tblTempUsageDetail_20' ) end [2026-03-23 05:02:32] Production.ERROR: pbx prc_insertCDR start [2026-03-23 05:02:32] Production.ERROR: pbx prc_insertCDR end [2026-03-23 05:02:32] Production.INFO: ==30781== Releasing lock... [2026-03-23 05:02:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 05:02:32] Production.INFO: 29.25 MB #Memory Used# [2026-03-23 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 03:02:06 [end_date_ymd] => 2026-03-23 06:02:06 [RateCDR] => 1 ) [2026-03-23 06:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 03:02:06' and `end` < '2026-03-23 06:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 06:02:17] Production.INFO: count ==79 [2026-03-23 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 03:02:06 - End Time 2026-03-23 06:02:06 [2026-03-23 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963069', 'tblTempUsageDetail_20' ) start [2026-03-23 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963069', 'tblTempUsageDetail_20' ) end [2026-03-23 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963069', 'tblTempVendorCDR_20' ) start [2026-03-23 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963069', 'tblTempVendorCDR_20' ) end [2026-03-23 06:02:17] Production.INFO: ProcessCDR(1,16963069,1,1,2) [2026-03-23 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16963069,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 06:02:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16963069,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 06:02:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16963069,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 06:02:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16963069,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 06:02:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963069', 'tblTempUsageDetail_20' ) start [2026-03-23 06:02:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963069', 'tblTempUsageDetail_20' ) end [2026-03-23 06:02:31] Production.ERROR: pbx prc_insertCDR start [2026-03-23 06:02:31] Production.ERROR: pbx prc_insertCDR end [2026-03-23 06:02:31] Production.INFO: ==2946== Releasing lock... [2026-03-23 06:02:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 06:02:31] Production.INFO: 28.25 MB #Memory Used# [2026-03-23 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 04:02:06 [end_date_ymd] => 2026-03-23 07:02:06 [RateCDR] => 1 ) [2026-03-23 07:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 04:02:06' and `end` < '2026-03-23 07:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 07:02:17] Production.INFO: count ==86 [2026-03-23 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 04:02:06 - End Time 2026-03-23 07:02:06 [2026-03-23 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963316', 'tblTempUsageDetail_20' ) start [2026-03-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963316', 'tblTempUsageDetail_20' ) end [2026-03-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963316', 'tblTempVendorCDR_20' ) start [2026-03-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963316', 'tblTempVendorCDR_20' ) end [2026-03-23 07:02:17] Production.INFO: ProcessCDR(1,16963316,1,1,2) [2026-03-23 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16963316,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 07:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16963316,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 07:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16963316,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 07:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16963316,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 07:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963316', 'tblTempUsageDetail_20' ) start [2026-03-23 07:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963316', 'tblTempUsageDetail_20' ) end [2026-03-23 07:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-23 07:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-23 07:02:37] Production.INFO: ==7451== Releasing lock... [2026-03-23 07:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 07:02:37] Production.INFO: 28.25 MB #Memory Used# [2026-03-23 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 05:02:06 [end_date_ymd] => 2026-03-23 08:02:06 [RateCDR] => 1 ) [2026-03-23 08:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 05:02:06' and `end` < '2026-03-23 08:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 08:02:17] Production.INFO: count ==188 [2026-03-23 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 05:02:06 - End Time 2026-03-23 08:02:06 [2026-03-23 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963563', 'tblTempUsageDetail_20' ) start [2026-03-23 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963563', 'tblTempUsageDetail_20' ) end [2026-03-23 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963563', 'tblTempVendorCDR_20' ) start [2026-03-23 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963563', 'tblTempVendorCDR_20' ) end [2026-03-23 08:02:17] Production.INFO: ProcessCDR(1,16963563,1,1,2) [2026-03-23 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16963563,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 08:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16963563,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 08:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16963563,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 08:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16963563,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963563', 'tblTempUsageDetail_20' ) start [2026-03-23 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963563', 'tblTempUsageDetail_20' ) end [2026-03-23 08:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-23 08:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-23 08:02:37] Production.INFO: ==12080== Releasing lock... [2026-03-23 08:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 08:02:37] Production.INFO: 29.5 MB #Memory Used# [2026-03-23 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 06:02:06 [end_date_ymd] => 2026-03-23 09:02:06 [RateCDR] => 1 ) [2026-03-23 09:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 06:02:06' and `end` < '2026-03-23 09:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 09:02:18] Production.INFO: count ==929 [2026-03-23 09:02:18] Production.ERROR: pbx CDR StartTime 2026-03-23 06:02:06 - End Time 2026-03-23 09:02:06 [2026-03-23 09:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963810', 'tblTempUsageDetail_20' ) start [2026-03-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16963810', 'tblTempUsageDetail_20' ) end [2026-03-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963810', 'tblTempVendorCDR_20' ) start [2026-03-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16963810', 'tblTempVendorCDR_20' ) end [2026-03-23 09:02:18] Production.INFO: ProcessCDR(1,16963810,1,1,2) [2026-03-23 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16963810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 09:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16963810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 09:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16963810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 09:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16963810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 09:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963810', 'tblTempUsageDetail_20' ) start [2026-03-23 09:02:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16963810', 'tblTempUsageDetail_20' ) end [2026-03-23 09:02:40] Production.ERROR: pbx prc_insertCDR start [2026-03-23 09:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-23 09:02:40] Production.INFO: ==16538== Releasing lock... [2026-03-23 09:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 09:02:40] Production.INFO: 35 MB #Memory Used# [2026-03-23 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 07:02:05 [end_date_ymd] => 2026-03-23 10:02:05 [RateCDR] => 1 ) [2026-03-23 10:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 07:02:05' and `end` < '2026-03-23 10:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 10:02:20] Production.INFO: count ==2893 [2026-03-23 10:02:21] Production.ERROR: pbx CDR StartTime 2026-03-23 07:02:05 - End Time 2026-03-23 10:02:05 [2026-03-23 10:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964057', 'tblTempUsageDetail_20' ) start [2026-03-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964057', 'tblTempUsageDetail_20' ) end [2026-03-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964057', 'tblTempVendorCDR_20' ) start [2026-03-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964057', 'tblTempVendorCDR_20' ) end [2026-03-23 10:02:21] Production.INFO: ProcessCDR(1,16964057,1,1,2) [2026-03-23 10:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16964057,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 10:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16964057,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 10:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16964057,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 10:07:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16964057,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 10:07:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964057', 'tblTempUsageDetail_20' ) start [2026-03-23 10:07:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964057', 'tblTempUsageDetail_20' ) end [2026-03-23 10:07:26] Production.ERROR: pbx prc_insertCDR start [2026-03-23 10:07:29] Production.ERROR: pbx prc_insertCDR end [2026-03-23 10:07:29] Production.INFO: ==21095== Releasing lock... [2026-03-23 10:07:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 10:07:29] Production.INFO: 49.75 MB #Memory Used# [2026-03-23 11:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 08:02:06 [end_date_ymd] => 2026-03-23 11:02:06 [RateCDR] => 1 ) [2026-03-23 11:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 08:02:06' and `end` < '2026-03-23 11:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 11:02:20] Production.INFO: count ==5195 [2026-03-23 11:02:23] Production.ERROR: pbx CDR StartTime 2026-03-23 08:02:06 - End Time 2026-03-23 11:02:06 [2026-03-23 11:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 11:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964304', 'tblTempUsageDetail_20' ) start [2026-03-23 11:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964304', 'tblTempUsageDetail_20' ) end [2026-03-23 11:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964304', 'tblTempVendorCDR_20' ) start [2026-03-23 11:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964304', 'tblTempVendorCDR_20' ) end [2026-03-23 11:02:24] Production.INFO: ProcessCDR(1,16964304,1,1,2) [2026-03-23 11:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16964304,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 11:07:17] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16964304,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 11:07:17] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16964304,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 11:12:13] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16964304,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 11:12:13] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964304', 'tblTempUsageDetail_20' ) start [2026-03-23 11:12:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964304', 'tblTempUsageDetail_20' ) end [2026-03-23 11:12:14] Production.ERROR: pbx prc_insertCDR start [2026-03-23 11:12:18] Production.ERROR: pbx prc_insertCDR end [2026-03-23 11:12:18] Production.INFO: ==25695== Releasing lock... [2026-03-23 11:12:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 11:12:18] Production.INFO: 67 MB #Memory Used# [2026-03-23 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 09:02:06 [end_date_ymd] => 2026-03-23 12:02:06 [RateCDR] => 1 ) [2026-03-23 12:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 09:02:06' and `end` < '2026-03-23 12:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 12:02:23] Production.INFO: count ==7062 [2026-03-23 12:02:27] Production.ERROR: pbx CDR StartTime 2026-03-23 09:02:06 - End Time 2026-03-23 12:02:06 [2026-03-23 12:02:27] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 12:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964551', 'tblTempUsageDetail_20' ) start [2026-03-23 12:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964551', 'tblTempUsageDetail_20' ) end [2026-03-23 12:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964551', 'tblTempVendorCDR_20' ) start [2026-03-23 12:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964551', 'tblTempVendorCDR_20' ) end [2026-03-23 12:02:28] Production.INFO: ProcessCDR(1,16964551,1,1,2) [2026-03-23 12:02:28] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16964551,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 12:06:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16964551,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 12:06:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16964551,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 12:11:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16964551,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 12:11:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964551', 'tblTempUsageDetail_20' ) start [2026-03-23 12:11:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964551', 'tblTempUsageDetail_20' ) end [2026-03-23 12:11:25] Production.ERROR: pbx prc_insertCDR start [2026-03-23 12:11:28] Production.ERROR: pbx prc_insertCDR end [2026-03-23 12:11:28] Production.INFO: ==30158== Releasing lock... [2026-03-23 12:11:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 12:11:28] Production.INFO: 81.25 MB #Memory Used# [2026-03-23 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 10:02:06 [end_date_ymd] => 2026-03-23 13:02:06 [RateCDR] => 1 ) [2026-03-23 13:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 10:02:06' and `end` < '2026-03-23 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-03-23 13:02:20] Production.INFO: count ==7154 [2026-03-23 13:02:23] Production.ERROR: pbx CDR StartTime 2026-03-23 10:02:06 - End Time 2026-03-23 13:02:06 [2026-03-23 13:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964798', 'tblTempUsageDetail_20' ) start [2026-03-23 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16964798', 'tblTempUsageDetail_20' ) end [2026-03-23 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964798', 'tblTempVendorCDR_20' ) start [2026-03-23 13:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16964798', 'tblTempVendorCDR_20' ) end [2026-03-23 13:02:25] Production.INFO: ProcessCDR(1,16964798,1,1,2) [2026-03-23 13:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16964798,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 13:07:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16964798,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 13:07:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16964798,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 13:11:51] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16964798,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 13:11:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964798', 'tblTempUsageDetail_20' ) start [2026-03-23 13:11:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16964798', 'tblTempUsageDetail_20' ) end [2026-03-23 13:11:51] Production.ERROR: pbx prc_insertCDR start [2026-03-23 13:11:55] Production.ERROR: pbx prc_insertCDR end [2026-03-23 13:11:55] Production.INFO: ==2206== Releasing lock... [2026-03-23 13:11:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 13:11:55] Production.INFO: 82.5 MB #Memory Used# [2026-03-23 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 11:02:05 [end_date_ymd] => 2026-03-23 14:02:05 [RateCDR] => 1 ) [2026-03-23 14:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 11:02:05' and `end` < '2026-03-23 14:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 14:02:18] Production.INFO: count ==6757 [2026-03-23 14:02:22] Production.ERROR: pbx CDR StartTime 2026-03-23 11:02:05 - End Time 2026-03-23 14:02:05 [2026-03-23 14:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965045', 'tblTempUsageDetail_20' ) start [2026-03-23 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965045', 'tblTempUsageDetail_20' ) end [2026-03-23 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965045', 'tblTempVendorCDR_20' ) start [2026-03-23 14:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965045', 'tblTempVendorCDR_20' ) end [2026-03-23 14:02:23] Production.INFO: ProcessCDR(1,16965045,1,1,2) [2026-03-23 14:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16965045,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 14:06:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16965045,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 14:06:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16965045,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 14:11:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16965045,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 14:11:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965045', 'tblTempUsageDetail_20' ) start [2026-03-23 14:11:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965045', 'tblTempUsageDetail_20' ) end [2026-03-23 14:11:20] Production.ERROR: pbx prc_insertCDR start [2026-03-23 14:11:23] Production.ERROR: pbx prc_insertCDR end [2026-03-23 14:11:24] Production.INFO: ==6735== Releasing lock... [2026-03-23 14:11:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 14:11:24] Production.INFO: 79 MB #Memory Used# [2026-03-23 15:02:07] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 12:02:07 [end_date_ymd] => 2026-03-23 15:02:07 [RateCDR] => 1 ) [2026-03-23 15: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-03-23 12:02:07' and `end` < '2026-03-23 15: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-03-23 15:02:20] Production.INFO: count ==6199 [2026-03-23 15:02:24] Production.ERROR: pbx CDR StartTime 2026-03-23 12:02:07 - End Time 2026-03-23 15:02:07 [2026-03-23 15:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965292', 'tblTempUsageDetail_20' ) start [2026-03-23 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965292', 'tblTempUsageDetail_20' ) end [2026-03-23 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965292', 'tblTempVendorCDR_20' ) start [2026-03-23 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965292', 'tblTempVendorCDR_20' ) end [2026-03-23 15:02:25] Production.INFO: ProcessCDR(1,16965292,1,1,2) [2026-03-23 15:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16965292,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 15:07:03] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16965292,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 15:07:03] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16965292,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 15:12:12] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16965292,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 15:12:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965292', 'tblTempUsageDetail_20' ) start [2026-03-23 15:12:13] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965292', 'tblTempUsageDetail_20' ) end [2026-03-23 15:12:13] Production.ERROR: pbx prc_insertCDR start [2026-03-23 15:12:18] Production.ERROR: pbx prc_insertCDR end [2026-03-23 15:12:18] Production.INFO: ==11389== Releasing lock... [2026-03-23 15:12:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 15:12:18] Production.INFO: 74.75 MB #Memory Used# [2026-03-23 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 13:02:05 [end_date_ymd] => 2026-03-23 16:02:05 [RateCDR] => 1 ) [2026-03-23 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-03-23 13:02:05' and `end` < '2026-03-23 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-03-23 16:02:19] Production.INFO: count ==6258 [2026-03-23 16:02:23] Production.ERROR: pbx CDR StartTime 2026-03-23 13:02:05 - End Time 2026-03-23 16:02:05 [2026-03-23 16:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965539', 'tblTempUsageDetail_20' ) start [2026-03-23 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965539', 'tblTempUsageDetail_20' ) end [2026-03-23 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965539', 'tblTempVendorCDR_20' ) start [2026-03-23 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965539', 'tblTempVendorCDR_20' ) end [2026-03-23 16:02:23] Production.INFO: ProcessCDR(1,16965539,1,1,2) [2026-03-23 16:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16965539,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 16:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16965539,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 16:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16965539,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 16:10:52] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16965539,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 16:10:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965539', 'tblTempUsageDetail_20' ) start [2026-03-23 16:10:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965539', 'tblTempUsageDetail_20' ) end [2026-03-23 16:10:52] Production.ERROR: pbx prc_insertCDR start [2026-03-23 16:10:56] Production.ERROR: pbx prc_insertCDR end [2026-03-23 16:10:56] Production.INFO: ==16638== Releasing lock... [2026-03-23 16:10:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 16:10:56] Production.INFO: 75 MB #Memory Used# [2026-03-23 17:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 14:02:06 [end_date_ymd] => 2026-03-23 17:02:06 [RateCDR] => 1 ) [2026-03-23 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-03-23 14:02:06' and `end` < '2026-03-23 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-03-23 17:02:20] Production.INFO: count ==6287 [2026-03-23 17:02:23] Production.ERROR: pbx CDR StartTime 2026-03-23 14:02:06 - End Time 2026-03-23 17:02:06 [2026-03-23 17:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965786', 'tblTempUsageDetail_20' ) start [2026-03-23 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16965786', 'tblTempUsageDetail_20' ) end [2026-03-23 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965786', 'tblTempVendorCDR_20' ) start [2026-03-23 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16965786', 'tblTempVendorCDR_20' ) end [2026-03-23 17:02:23] Production.INFO: ProcessCDR(1,16965786,1,1,2) [2026-03-23 17:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16965786,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 17:06:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16965786,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 17:06:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16965786,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 17:11:01] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16965786,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 17:11:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965786', 'tblTempUsageDetail_20' ) start [2026-03-23 17:11:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16965786', 'tblTempUsageDetail_20' ) end [2026-03-23 17:11:01] Production.ERROR: pbx prc_insertCDR start [2026-03-23 17:11:12] Production.ERROR: pbx prc_insertCDR end [2026-03-23 17:11:12] Production.INFO: ==21378== Releasing lock... [2026-03-23 17:11:12] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 17:11:12] Production.INFO: 75.25 MB #Memory Used# [2026-03-23 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 15:02:05 [end_date_ymd] => 2026-03-23 18:02:05 [RateCDR] => 1 ) [2026-03-23 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-03-23 15:02:05' and `end` < '2026-03-23 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-03-23 18:02:18] Production.INFO: count ==5285 [2026-03-23 18:02:20] Production.ERROR: pbx CDR StartTime 2026-03-23 15:02:05 - End Time 2026-03-23 18:02:05 [2026-03-23 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966033', 'tblTempUsageDetail_20' ) start [2026-03-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966033', 'tblTempUsageDetail_20' ) end [2026-03-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966033', 'tblTempVendorCDR_20' ) start [2026-03-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966033', 'tblTempVendorCDR_20' ) end [2026-03-23 18:02:21] Production.INFO: ProcessCDR(1,16966033,1,1,2) [2026-03-23 18:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16966033,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 18:06:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16966033,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 18:06:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16966033,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 18:11:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16966033,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 18:11:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966033', 'tblTempUsageDetail_20' ) start [2026-03-23 18:11:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966033', 'tblTempUsageDetail_20' ) end [2026-03-23 18:11:32] Production.ERROR: pbx prc_insertCDR start [2026-03-23 18:11:34] Production.ERROR: pbx prc_insertCDR end [2026-03-23 18:11:34] Production.INFO: ==26047== Releasing lock... [2026-03-23 18:11:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 18:11:34] Production.INFO: 67.75 MB #Memory Used# [2026-03-23 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 16:02:06 [end_date_ymd] => 2026-03-23 19:02:06 [RateCDR] => 1 ) [2026-03-23 19:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 16:02:06' and `end` < '2026-03-23 19:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 19:02:18] Production.INFO: count ==4015 [2026-03-23 19:02:20] Production.ERROR: pbx CDR StartTime 2026-03-23 16:02:06 - End Time 2026-03-23 19:02:06 [2026-03-23 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966277', 'tblTempUsageDetail_20' ) start [2026-03-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966277', 'tblTempUsageDetail_20' ) end [2026-03-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966277', 'tblTempVendorCDR_20' ) start [2026-03-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966277', 'tblTempVendorCDR_20' ) end [2026-03-23 19:02:20] Production.INFO: ProcessCDR(1,16966277,1,1,2) [2026-03-23 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16966277,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 19:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16966277,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 19:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16966277,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 19:10:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16966277,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 19:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966277', 'tblTempUsageDetail_20' ) start [2026-03-23 19:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966277', 'tblTempUsageDetail_20' ) end [2026-03-23 19:10:45] Production.ERROR: pbx prc_insertCDR start [2026-03-23 19:10:46] Production.ERROR: pbx prc_insertCDR end [2026-03-23 19:10:46] Production.INFO: ==30727== Releasing lock... [2026-03-23 19:10:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 19:10:46] Production.INFO: 58.25 MB #Memory Used# [2026-03-23 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 17:02:05 [end_date_ymd] => 2026-03-23 20:02:05 [RateCDR] => 1 ) [2026-03-23 20:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 17:02:05' and `end` < '2026-03-23 20:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 20:02:16] Production.INFO: count ==2471 [2026-03-23 20:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 17:02:05 - End Time 2026-03-23 20:02:05 [2026-03-23 20:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966524', 'tblTempUsageDetail_20' ) start [2026-03-23 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966524', 'tblTempUsageDetail_20' ) end [2026-03-23 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966524', 'tblTempVendorCDR_20' ) start [2026-03-23 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966524', 'tblTempVendorCDR_20' ) end [2026-03-23 20:02:18] Production.INFO: ProcessCDR(1,16966524,1,1,2) [2026-03-23 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16966524,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 20:06:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16966524,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 20:06:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16966524,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 20:10:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16966524,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 20:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966524', 'tblTempUsageDetail_20' ) start [2026-03-23 20:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966524', 'tblTempUsageDetail_20' ) end [2026-03-23 20:10:43] Production.ERROR: pbx prc_insertCDR start [2026-03-23 20:10:44] Production.ERROR: pbx prc_insertCDR end [2026-03-23 20:10:44] Production.INFO: ==2967== Releasing lock... [2026-03-23 20:10:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 20:10:44] Production.INFO: 47 MB #Memory Used# [2026-03-23 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 18:02:06 [end_date_ymd] => 2026-03-23 21:02:06 [RateCDR] => 1 ) [2026-03-23 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-03-23 18:02:06' and `end` < '2026-03-23 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-03-23 21:02:17] Production.INFO: count ==1749 [2026-03-23 21:02:18] Production.ERROR: pbx CDR StartTime 2026-03-23 18:02:06 - End Time 2026-03-23 21:02:06 [2026-03-23 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966771', 'tblTempUsageDetail_20' ) start [2026-03-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16966771', 'tblTempUsageDetail_20' ) end [2026-03-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966771', 'tblTempVendorCDR_20' ) start [2026-03-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16966771', 'tblTempVendorCDR_20' ) end [2026-03-23 21:02:18] Production.INFO: ProcessCDR(1,16966771,1,1,2) [2026-03-23 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16966771,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 21:06:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16966771,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 21:06:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16966771,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 21:10:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16966771,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 21:10:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966771', 'tblTempUsageDetail_20' ) start [2026-03-23 21:10:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16966771', 'tblTempUsageDetail_20' ) end [2026-03-23 21:10:46] Production.ERROR: pbx prc_insertCDR start [2026-03-23 21:10:47] Production.ERROR: pbx prc_insertCDR end [2026-03-23 21:10:47] Production.INFO: ==7583== Releasing lock... [2026-03-23 21:10:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 21:10:47] Production.INFO: 41.25 MB #Memory Used# [2026-03-23 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 19:02:06 [end_date_ymd] => 2026-03-23 22:02:06 [RateCDR] => 1 ) [2026-03-23 22:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-23 19:02:06' and `end` < '2026-03-23 22:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-23 22:02:17] Production.INFO: count ==1185 [2026-03-23 22:02:18] Production.ERROR: pbx CDR StartTime 2026-03-23 19:02:06 - End Time 2026-03-23 22:02:06 [2026-03-23 22:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967018', 'tblTempUsageDetail_20' ) start [2026-03-23 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967018', 'tblTempUsageDetail_20' ) end [2026-03-23 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967018', 'tblTempVendorCDR_20' ) start [2026-03-23 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967018', 'tblTempVendorCDR_20' ) end [2026-03-23 22:02:18] Production.INFO: ProcessCDR(1,16967018,1,1,2) [2026-03-23 22:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16967018,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 22:06:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16967018,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 22:06:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16967018,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 22:10:58] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16967018,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 22:10:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967018', 'tblTempUsageDetail_20' ) start [2026-03-23 22:10:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967018', 'tblTempUsageDetail_20' ) end [2026-03-23 22:10:59] Production.ERROR: pbx prc_insertCDR start [2026-03-23 22:10:59] Production.ERROR: pbx prc_insertCDR end [2026-03-23 22:10:59] Production.INFO: ==12040== Releasing lock... [2026-03-23 22:10:59] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 22:10:59] Production.INFO: 37.5 MB #Memory Used# [2026-03-23 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-23 20:02:05 [end_date_ymd] => 2026-03-23 23:02:05 [RateCDR] => 1 ) [2026-03-23 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-03-23 20:02:05' and `end` < '2026-03-23 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-03-23 23:02:17] Production.INFO: count ==1005 [2026-03-23 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-23 20:02:05 - End Time 2026-03-23 23:02:05 [2026-03-23 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-23 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967265', 'tblTempUsageDetail_20' ) start [2026-03-23 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16967265', 'tblTempUsageDetail_20' ) end [2026-03-23 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967265', 'tblTempVendorCDR_20' ) start [2026-03-23 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16967265', 'tblTempVendorCDR_20' ) end [2026-03-23 23:02:17] Production.INFO: ProcessCDR(1,16967265,1,1,2) [2026-03-23 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16967265,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 23:06:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16967265,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-23 23:06:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16967265,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 23:10:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16967265,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-23 23:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967265', 'tblTempUsageDetail_20' ) start [2026-03-23 23:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16967265', 'tblTempUsageDetail_20' ) end [2026-03-23 23:10:43] Production.ERROR: pbx prc_insertCDR start [2026-03-23 23:10:43] Production.ERROR: pbx prc_insertCDR end [2026-03-23 23:10:43] Production.INFO: ==16415== Releasing lock... [2026-03-23 23:10:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-23 23:10:43] Production.INFO: 36 MB #Memory Used#