[2026-03-19 00:02:05] Production.INFO: next invoice date [2026-03-19 00:02:05] Production.INFO: 2026-04-19 [2026-03-19 00:02:05] Production.INFO: getdaysdiff [2026-03-19 00:02:05] Production.INFO: +31 [2026-03-19 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (108,15,1,31,31,'RMScheduler',2026-03-19 00:02:05,1,0,,,0) [2026-03-19 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-18 21:02:06 [end_date_ymd] => 2026-03-19 00:02:06 [RateCDR] => 1 ) [2026-03-19 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-18 21:02:06' and `end` < '2026-03-19 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-19 00:02:31] Production.INFO: count ==730 [2026-03-19 00:02:31] Production.ERROR: pbx CDR StartTime 2026-03-18 21:02:06 - End Time 2026-03-19 00:02:06 [2026-03-19 00:02:31] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 00:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16937871', 'tblTempUsageDetail_20' ) start [2026-03-19 00:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16937871', 'tblTempUsageDetail_20' ) end [2026-03-19 00:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16937871', 'tblTempVendorCDR_20' ) start [2026-03-19 00:02:31] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16937871', 'tblTempVendorCDR_20' ) end [2026-03-19 00:02:31] Production.INFO: ProcessCDR(1,16937871,1,1,2) [2026-03-19 00:02:31] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16937871,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 00:06:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16937871,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 00:06:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16937871,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 00:10:59] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16937871,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 00:10:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16937871', 'tblTempUsageDetail_20' ) start [2026-03-19 00:10:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16937871', 'tblTempUsageDetail_20' ) end [2026-03-19 00:10:59] Production.ERROR: pbx prc_insertCDR start [2026-03-19 00:11:00] Production.ERROR: pbx prc_insertCDR end [2026-03-19 00:11:01] Production.INFO: ==9611== Releasing lock... [2026-03-19 00:11:01] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 00:11:01] Production.INFO: 38.25 MB #Memory Used# [2026-03-19 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-18 22:02:05 [end_date_ymd] => 2026-03-19 01:02:05 [RateCDR] => 1 ) [2026-03-19 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-18 22:02:05' and `end` < '2026-03-19 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-19 01:02:17] Production.INFO: count ==646 [2026-03-19 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-18 22:02:05 - End Time 2026-03-19 01:02:05 [2026-03-19 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938118', 'tblTempUsageDetail_20' ) start [2026-03-19 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938118', 'tblTempUsageDetail_20' ) end [2026-03-19 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938118', 'tblTempVendorCDR_20' ) start [2026-03-19 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938118', 'tblTempVendorCDR_20' ) end [2026-03-19 01:02:17] Production.INFO: ProcessCDR(1,16938118,1,1,2) [2026-03-19 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16938118,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 01:05:56] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16938118,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 01:05:56] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16938118,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 01:10:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16938118,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 01:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938118', 'tblTempUsageDetail_20' ) start [2026-03-19 01:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938118', 'tblTempUsageDetail_20' ) end [2026-03-19 01:10:27] Production.ERROR: pbx prc_insertCDR start [2026-03-19 01:10:27] Production.ERROR: pbx prc_insertCDR end [2026-03-19 01:10:27] Production.INFO: ==14569== Releasing lock... [2026-03-19 01:10:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 01:10:27] Production.INFO: 33.5 MB #Memory Used# [2026-03-19 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-18 23:02:06 [end_date_ymd] => 2026-03-19 02:02:06 [RateCDR] => 1 ) [2026-03-19 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-18 23:02:06' and `end` < '2026-03-19 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-19 02:02:17] Production.INFO: count ==584 [2026-03-19 02:02:17] Production.ERROR: pbx CDR StartTime 2026-03-18 23:02:06 - End Time 2026-03-19 02:02:06 [2026-03-19 02:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938365', 'tblTempUsageDetail_20' ) start [2026-03-19 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938365', 'tblTempUsageDetail_20' ) end [2026-03-19 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938365', 'tblTempVendorCDR_20' ) start [2026-03-19 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938365', 'tblTempVendorCDR_20' ) end [2026-03-19 02:02:17] Production.INFO: ProcessCDR(1,16938365,1,1,2) [2026-03-19 02:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16938365,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 02:06:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16938365,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 02:06:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16938365,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 02:10:53] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16938365,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 02:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938365', 'tblTempUsageDetail_20' ) start [2026-03-19 02:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938365', 'tblTempUsageDetail_20' ) end [2026-03-19 02:10:53] Production.ERROR: pbx prc_insertCDR start [2026-03-19 02:10:53] Production.ERROR: pbx prc_insertCDR end [2026-03-19 02:10:53] Production.INFO: ==19270== Releasing lock... [2026-03-19 02:10:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 02:10:53] Production.INFO: 32.5 MB #Memory Used# [2026-03-19 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 00:02:06 [end_date_ymd] => 2026-03-19 03:02:06 [RateCDR] => 1 ) [2026-03-19 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-19 00:02:06' and `end` < '2026-03-19 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-19 03:02:17] Production.INFO: count ==523 [2026-03-19 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 00:02:06 - End Time 2026-03-19 03:02:06 [2026-03-19 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938612', 'tblTempUsageDetail_20' ) start [2026-03-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938612', 'tblTempUsageDetail_20' ) end [2026-03-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938612', 'tblTempVendorCDR_20' ) start [2026-03-19 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938612', 'tblTempVendorCDR_20' ) end [2026-03-19 03:02:17] Production.INFO: ProcessCDR(1,16938612,1,1,2) [2026-03-19 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16938612,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 03:06:15] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16938612,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 03:06:15] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16938612,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 03:10:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16938612,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 03:10:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938612', 'tblTempUsageDetail_20' ) start [2026-03-19 03:10:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938612', 'tblTempUsageDetail_20' ) end [2026-03-19 03:10:56] Production.ERROR: pbx prc_insertCDR start [2026-03-19 03:10:56] Production.ERROR: pbx prc_insertCDR end [2026-03-19 03:10:56] Production.INFO: ==24077== Releasing lock... [2026-03-19 03:10:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 03:10:56] Production.INFO: 32.5 MB #Memory Used# [2026-03-19 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 01:02:05 [end_date_ymd] => 2026-03-19 04:02:05 [RateCDR] => 1 ) [2026-03-19 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-19 01:02:05' and `end` < '2026-03-19 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-19 04:02:16] Production.INFO: count ==323 [2026-03-19 04:02:16] Production.ERROR: pbx CDR StartTime 2026-03-19 01:02:05 - End Time 2026-03-19 04:02:05 [2026-03-19 04:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938860', 'tblTempUsageDetail_20' ) start [2026-03-19 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16938860', 'tblTempUsageDetail_20' ) end [2026-03-19 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938860', 'tblTempVendorCDR_20' ) start [2026-03-19 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16938860', 'tblTempVendorCDR_20' ) end [2026-03-19 04:02:16] Production.INFO: ProcessCDR(1,16938860,1,1,2) [2026-03-19 04:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16938860,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 04:06:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16938860,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 04:06:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16938860,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 04:10:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16938860,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 04:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938860', 'tblTempUsageDetail_20' ) start [2026-03-19 04:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16938860', 'tblTempUsageDetail_20' ) end [2026-03-19 04:10:27] Production.ERROR: pbx prc_insertCDR start [2026-03-19 04:10:27] Production.ERROR: pbx prc_insertCDR end [2026-03-19 04:10:27] Production.INFO: ==28687== Releasing lock... [2026-03-19 04:10:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 04:10:27] Production.INFO: 31.25 MB #Memory Used# [2026-03-19 05:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 02:02:06 [end_date_ymd] => 2026-03-19 05:02:06 [RateCDR] => 1 ) [2026-03-19 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-19 02:02:06' and `end` < '2026-03-19 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-19 05:02:17] Production.INFO: count ==184 [2026-03-19 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 02:02:06 - End Time 2026-03-19 05:02:06 [2026-03-19 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939108', 'tblTempUsageDetail_20' ) start [2026-03-19 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939108', 'tblTempUsageDetail_20' ) end [2026-03-19 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939108', 'tblTempVendorCDR_20' ) start [2026-03-19 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939108', 'tblTempVendorCDR_20' ) end [2026-03-19 05:02:17] Production.INFO: ProcessCDR(1,16939108,1,1,2) [2026-03-19 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16939108,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 05:06:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16939108,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 05:06:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16939108,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 05:10:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16939108,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 05:10:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939108', 'tblTempUsageDetail_20' ) start [2026-03-19 05:10:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939108', 'tblTempUsageDetail_20' ) end [2026-03-19 05:10:33] Production.ERROR: pbx prc_insertCDR start [2026-03-19 05:10:33] Production.ERROR: pbx prc_insertCDR end [2026-03-19 05:10:33] Production.INFO: ==1025== Releasing lock... [2026-03-19 05:10:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 05:10:33] Production.INFO: 29.75 MB #Memory Used# [2026-03-19 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 03:02:06 [end_date_ymd] => 2026-03-19 06:02:06 [RateCDR] => 1 ) [2026-03-19 06:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 03:02:06' and `end` < '2026-03-19 06:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 06:02:17] Production.INFO: count ==115 [2026-03-19 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 03:02:06 - End Time 2026-03-19 06:02:06 [2026-03-19 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939355', 'tblTempUsageDetail_20' ) start [2026-03-19 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939355', 'tblTempUsageDetail_20' ) end [2026-03-19 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939355', 'tblTempVendorCDR_20' ) start [2026-03-19 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939355', 'tblTempVendorCDR_20' ) end [2026-03-19 06:02:17] Production.INFO: ProcessCDR(1,16939355,1,1,2) [2026-03-19 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16939355,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 06:05:56] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16939355,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 06:05:56] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16939355,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 06:10:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16939355,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 06:10:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939355', 'tblTempUsageDetail_20' ) start [2026-03-19 06:10:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939355', 'tblTempUsageDetail_20' ) end [2026-03-19 06:10:21] Production.ERROR: pbx prc_insertCDR start [2026-03-19 06:10:21] Production.ERROR: pbx prc_insertCDR end [2026-03-19 06:10:21] Production.INFO: ==5551== Releasing lock... [2026-03-19 06:10:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 06:10:21] Production.INFO: 29 MB #Memory Used# [2026-03-19 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 04:02:05 [end_date_ymd] => 2026-03-19 07:02:05 [RateCDR] => 1 ) [2026-03-19 07:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 04:02:05' and `end` < '2026-03-19 07:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 07:02:16] Production.INFO: count ==111 [2026-03-19 07:02:16] Production.ERROR: pbx CDR StartTime 2026-03-19 04:02:05 - End Time 2026-03-19 07:02:05 [2026-03-19 07:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939602', 'tblTempUsageDetail_20' ) start [2026-03-19 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939602', 'tblTempUsageDetail_20' ) end [2026-03-19 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939602', 'tblTempVendorCDR_20' ) start [2026-03-19 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939602', 'tblTempVendorCDR_20' ) end [2026-03-19 07:02:16] Production.INFO: ProcessCDR(1,16939602,1,1,2) [2026-03-19 07:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16939602,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 07:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16939602,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 07:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16939602,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 07:10:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16939602,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 07:10:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939602', 'tblTempUsageDetail_20' ) start [2026-03-19 07:10:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939602', 'tblTempUsageDetail_20' ) end [2026-03-19 07:10:34] Production.ERROR: pbx prc_insertCDR start [2026-03-19 07:10:34] Production.ERROR: pbx prc_insertCDR end [2026-03-19 07:10:34] Production.INFO: ==10030== Releasing lock... [2026-03-19 07:10:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 07:10:34] Production.INFO: 28.75 MB #Memory Used# [2026-03-19 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 05:02:05 [end_date_ymd] => 2026-03-19 08:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 05:02:05' and `end` < '2026-03-19 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-03-19 08:02:17] Production.INFO: count ==208 [2026-03-19 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 05:02:05 - End Time 2026-03-19 08:02:05 [2026-03-19 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939849', 'tblTempUsageDetail_20' ) start [2026-03-19 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16939849', 'tblTempUsageDetail_20' ) end [2026-03-19 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939849', 'tblTempVendorCDR_20' ) start [2026-03-19 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16939849', 'tblTempVendorCDR_20' ) end [2026-03-19 08:02:17] Production.INFO: ProcessCDR(1,16939849,1,1,2) [2026-03-19 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16939849,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 08:06:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16939849,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 08:06:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16939849,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 08:10:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16939849,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 08:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939849', 'tblTempUsageDetail_20' ) start [2026-03-19 08:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16939849', 'tblTempUsageDetail_20' ) end [2026-03-19 08:10:38] Production.ERROR: pbx prc_insertCDR start [2026-03-19 08:10:38] Production.ERROR: pbx prc_insertCDR end [2026-03-19 08:10:38] Production.INFO: ==14811== Releasing lock... [2026-03-19 08:10:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 08:10:38] Production.INFO: 30 MB #Memory Used# [2026-03-19 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 06:02:06 [end_date_ymd] => 2026-03-19 09:02:06 [RateCDR] => 1 ) [2026-03-19 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-19 06:02:06' and `end` < '2026-03-19 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-19 09:02:17] Production.INFO: count ==718 [2026-03-19 09:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 06:02:06 - End Time 2026-03-19 09:02:06 [2026-03-19 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940096', 'tblTempUsageDetail_20' ) start [2026-03-19 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940096', 'tblTempUsageDetail_20' ) end [2026-03-19 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940096', 'tblTempVendorCDR_20' ) start [2026-03-19 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940096', 'tblTempVendorCDR_20' ) end [2026-03-19 09:02:17] Production.INFO: ProcessCDR(1,16940096,1,1,2) [2026-03-19 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16940096,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 09:05:52] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16940096,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 09:05:52] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16940096,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 09:10:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16940096,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 09:10:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940096', 'tblTempUsageDetail_20' ) start [2026-03-19 09:10:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940096', 'tblTempUsageDetail_20' ) end [2026-03-19 09:10:23] Production.ERROR: pbx prc_insertCDR start [2026-03-19 09:10:23] Production.ERROR: pbx prc_insertCDR end [2026-03-19 09:10:23] Production.INFO: ==19359== Releasing lock... [2026-03-19 09:10:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 09:10:23] Production.INFO: 33.75 MB #Memory Used# [2026-03-19 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 07:02:05 [end_date_ymd] => 2026-03-19 10:02:05 [RateCDR] => 1 ) [2026-03-19 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-19 07:02:05' and `end` < '2026-03-19 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-19 10:02:18] Production.INFO: count ==2229 [2026-03-19 10:02:19] Production.ERROR: pbx CDR StartTime 2026-03-19 07:02:05 - End Time 2026-03-19 10:02:05 [2026-03-19 10:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940343', 'tblTempUsageDetail_20' ) start [2026-03-19 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940343', 'tblTempUsageDetail_20' ) end [2026-03-19 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940343', 'tblTempVendorCDR_20' ) start [2026-03-19 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940343', 'tblTempVendorCDR_20' ) end [2026-03-19 10:02:19] Production.INFO: ProcessCDR(1,16940343,1,1,2) [2026-03-19 10:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16940343,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 10:05:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16940343,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 10:05:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16940343,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 10:10:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16940343,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 10:10:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940343', 'tblTempUsageDetail_20' ) start [2026-03-19 10:10:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940343', 'tblTempUsageDetail_20' ) end [2026-03-19 10:10:26] Production.ERROR: pbx prc_insertCDR start [2026-03-19 10:10:28] Production.ERROR: pbx prc_insertCDR end [2026-03-19 10:10:28] Production.INFO: ==24350== Releasing lock... [2026-03-19 10:10:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 10:10:28] Production.INFO: 45 MB #Memory Used# [2026-03-19 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 08:02:05 [end_date_ymd] => 2026-03-19 11:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 08:02:05' and `end` < '2026-03-19 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-03-19 11:02:19] Production.INFO: count ==3796 [2026-03-19 11:02:21] Production.ERROR: pbx CDR StartTime 2026-03-19 08:02:05 - End Time 2026-03-19 11:02:05 [2026-03-19 11:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940590', 'tblTempUsageDetail_20' ) start [2026-03-19 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940590', 'tblTempUsageDetail_20' ) end [2026-03-19 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940590', 'tblTempVendorCDR_20' ) start [2026-03-19 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940590', 'tblTempVendorCDR_20' ) end [2026-03-19 11:02:21] Production.INFO: ProcessCDR(1,16940590,1,1,2) [2026-03-19 11:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16940590,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 11:06:08] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16940590,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 11:06:08] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16940590,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 11:10:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16940590,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 11:10:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940590', 'tblTempUsageDetail_20' ) start [2026-03-19 11:10:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940590', 'tblTempUsageDetail_20' ) end [2026-03-19 11:10:41] Production.ERROR: pbx prc_insertCDR start [2026-03-19 11:10:43] Production.ERROR: pbx prc_insertCDR end [2026-03-19 11:10:43] Production.INFO: ==28984== Releasing lock... [2026-03-19 11:10:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 11:10:43] Production.INFO: 56.5 MB #Memory Used# [2026-03-19 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 09:02:05 [end_date_ymd] => 2026-03-19 12:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 09:02:05' and `end` < '2026-03-19 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-03-19 12:02:23] Production.INFO: count ==5254 [2026-03-19 12:02:26] Production.ERROR: pbx CDR StartTime 2026-03-19 09:02:05 - End Time 2026-03-19 12:02:05 [2026-03-19 12:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 12:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940837', 'tblTempUsageDetail_20' ) start [2026-03-19 12:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16940837', 'tblTempUsageDetail_20' ) end [2026-03-19 12:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940837', 'tblTempVendorCDR_20' ) start [2026-03-19 12:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16940837', 'tblTempVendorCDR_20' ) end [2026-03-19 12:02:27] Production.INFO: ProcessCDR(1,16940837,1,1,2) [2026-03-19 12:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16940837,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 12:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16940837,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 12:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16940837,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 12:10:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16940837,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 12:10:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940837', 'tblTempUsageDetail_20' ) start [2026-03-19 12:10:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16940837', 'tblTempUsageDetail_20' ) end [2026-03-19 12:10:29] Production.ERROR: pbx prc_insertCDR start [2026-03-19 12:10:32] Production.ERROR: pbx prc_insertCDR end [2026-03-19 12:10:32] Production.INFO: ==1186== Releasing lock... [2026-03-19 12:10:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 12:10:32] Production.INFO: 67.5 MB #Memory Used# [2026-03-19 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 10:02:06 [end_date_ymd] => 2026-03-19 13:02:06 [RateCDR] => 1 ) [2026-03-19 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-19 10:02:06' and `end` < '2026-03-19 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-19 13:02:18] Production.INFO: count ==5506 [2026-03-19 13:02:21] Production.ERROR: pbx CDR StartTime 2026-03-19 10:02:06 - End Time 2026-03-19 13:02:06 [2026-03-19 13:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941084', 'tblTempUsageDetail_20' ) start [2026-03-19 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941084', 'tblTempUsageDetail_20' ) end [2026-03-19 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941084', 'tblTempVendorCDR_20' ) start [2026-03-19 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941084', 'tblTempVendorCDR_20' ) end [2026-03-19 13:02:22] Production.INFO: ProcessCDR(1,16941084,1,1,2) [2026-03-19 13:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16941084,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 13:05:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16941084,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 13:05:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16941084,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 13:10:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16941084,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 13:10:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941084', 'tblTempUsageDetail_20' ) start [2026-03-19 13:10:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941084', 'tblTempUsageDetail_20' ) end [2026-03-19 13:10:28] Production.ERROR: pbx prc_insertCDR start [2026-03-19 13:10:30] Production.ERROR: pbx prc_insertCDR end [2026-03-19 13:10:30] Production.INFO: ==6753== Releasing lock... [2026-03-19 13:10:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 13:10:30] Production.INFO: 69.5 MB #Memory Used# [2026-03-19 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 11:02:05 [end_date_ymd] => 2026-03-19 14:02:05 [RateCDR] => 1 ) [2026-03-19 14:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 11:02:05' and `end` < '2026-03-19 14:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 14:02:18] Production.INFO: count ==5512 [2026-03-19 14:02:21] Production.ERROR: pbx CDR StartTime 2026-03-19 11:02:05 - End Time 2026-03-19 14:02:05 [2026-03-19 14:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941331', 'tblTempUsageDetail_20' ) start [2026-03-19 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941331', 'tblTempUsageDetail_20' ) end [2026-03-19 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941331', 'tblTempVendorCDR_20' ) start [2026-03-19 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941331', 'tblTempVendorCDR_20' ) end [2026-03-19 14:02:22] Production.INFO: ProcessCDR(1,16941331,1,1,2) [2026-03-19 14:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16941331,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 14:06:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16941331,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 14:06:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16941331,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 14:10:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16941331,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 14:10:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941331', 'tblTempUsageDetail_20' ) start [2026-03-19 14:10:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941331', 'tblTempUsageDetail_20' ) end [2026-03-19 14:10:30] Production.ERROR: pbx prc_insertCDR start [2026-03-19 14:10:32] Production.ERROR: pbx prc_insertCDR end [2026-03-19 14:10:32] Production.INFO: ==11374== Releasing lock... [2026-03-19 14:10:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 14:10:32] Production.INFO: 69.5 MB #Memory Used# [2026-03-19 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 12:02:05 [end_date_ymd] => 2026-03-19 15:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 12:02:05' and `end` < '2026-03-19 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-03-19 15:02:23] Production.INFO: count ==5412 [2026-03-19 15:02:26] Production.ERROR: pbx CDR StartTime 2026-03-19 12:02:05 - End Time 2026-03-19 15:02:05 [2026-03-19 15:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 15:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941578', 'tblTempUsageDetail_20' ) start [2026-03-19 15:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941578', 'tblTempUsageDetail_20' ) end [2026-03-19 15:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941578', 'tblTempVendorCDR_20' ) start [2026-03-19 15:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941578', 'tblTempVendorCDR_20' ) end [2026-03-19 15:02:27] Production.INFO: ProcessCDR(1,16941578,1,1,2) [2026-03-19 15:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16941578,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 15:06:16] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16941578,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 15:06:16] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16941578,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 15:10:53] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16941578,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 15:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941578', 'tblTempUsageDetail_20' ) start [2026-03-19 15:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941578', 'tblTempUsageDetail_20' ) end [2026-03-19 15:10:54] Production.ERROR: pbx prc_insertCDR start [2026-03-19 15:10:56] Production.ERROR: pbx prc_insertCDR end [2026-03-19 15:10:56] Production.INFO: ==15862== Releasing lock... [2026-03-19 15:10:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 15:10:56] Production.INFO: 68.75 MB #Memory Used# [2026-03-19 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 13:02:05 [end_date_ymd] => 2026-03-19 16:02:05 [RateCDR] => 1 ) [2026-03-19 16:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 13:02:05' and `end` < '2026-03-19 16:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 16:02:19] Production.INFO: count ==5445 [2026-03-19 16:02:21] Production.ERROR: pbx CDR StartTime 2026-03-19 13:02:05 - End Time 2026-03-19 16:02:05 [2026-03-19 16:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941825', 'tblTempUsageDetail_20' ) start [2026-03-19 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16941825', 'tblTempUsageDetail_20' ) end [2026-03-19 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941825', 'tblTempVendorCDR_20' ) start [2026-03-19 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16941825', 'tblTempVendorCDR_20' ) end [2026-03-19 16:02:22] Production.INFO: ProcessCDR(1,16941825,1,1,2) [2026-03-19 16:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16941825,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 16:06:49] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16941825,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 16:06:49] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16941825,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 16:11:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16941825,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 16:11:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941825', 'tblTempUsageDetail_20' ) start [2026-03-19 16:11:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16941825', 'tblTempUsageDetail_20' ) end [2026-03-19 16:11:21] Production.ERROR: pbx prc_insertCDR start [2026-03-19 16:11:24] Production.ERROR: pbx prc_insertCDR end [2026-03-19 16:11:24] Production.INFO: ==20340== Releasing lock... [2026-03-19 16:11:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 16:11:24] Production.INFO: 69 MB #Memory Used# [2026-03-19 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 14:02:05 [end_date_ymd] => 2026-03-19 17:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 14:02:05' and `end` < '2026-03-19 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-03-19 17:02:21] Production.INFO: count ==5511 [2026-03-19 17:02:24] Production.ERROR: pbx CDR StartTime 2026-03-19 14:02:05 - End Time 2026-03-19 17:02:05 [2026-03-19 17:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942072', 'tblTempUsageDetail_20' ) start [2026-03-19 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942072', 'tblTempUsageDetail_20' ) end [2026-03-19 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942072', 'tblTempVendorCDR_20' ) start [2026-03-19 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942072', 'tblTempVendorCDR_20' ) end [2026-03-19 17:02:24] Production.INFO: ProcessCDR(1,16942072,1,1,2) [2026-03-19 17:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16942072,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 17:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16942072,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 17:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16942072,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 17:10:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16942072,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 17:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942072', 'tblTempUsageDetail_20' ) start [2026-03-19 17:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942072', 'tblTempUsageDetail_20' ) end [2026-03-19 17:10:44] Production.ERROR: pbx prc_insertCDR start [2026-03-19 17:10:46] Production.ERROR: pbx prc_insertCDR end [2026-03-19 17:10:46] Production.INFO: ==24977== Releasing lock... [2026-03-19 17:10:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 17:10:46] Production.INFO: 69.5 MB #Memory Used# [2026-03-19 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 15:02:06 [end_date_ymd] => 2026-03-19 18:02:06 [RateCDR] => 1 ) [2026-03-19 18:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 15:02:06' and `end` < '2026-03-19 18:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 18:02:18] Production.INFO: count ==4521 [2026-03-19 18:02:20] Production.ERROR: pbx CDR StartTime 2026-03-19 15:02:06 - End Time 2026-03-19 18:02:06 [2026-03-19 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942319', 'tblTempUsageDetail_20' ) start [2026-03-19 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942319', 'tblTempUsageDetail_20' ) end [2026-03-19 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942319', 'tblTempVendorCDR_20' ) start [2026-03-19 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942319', 'tblTempVendorCDR_20' ) end [2026-03-19 18:02:20] Production.INFO: ProcessCDR(1,16942319,1,1,2) [2026-03-19 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16942319,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 18:06:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16942319,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 18:06:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16942319,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 18:10:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16942319,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 18:10:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942319', 'tblTempUsageDetail_20' ) start [2026-03-19 18:10:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942319', 'tblTempUsageDetail_20' ) end [2026-03-19 18:10:30] Production.ERROR: pbx prc_insertCDR start [2026-03-19 18:10:31] Production.ERROR: pbx prc_insertCDR end [2026-03-19 18:10:31] Production.INFO: ==29495== Releasing lock... [2026-03-19 18:10:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 18:10:31] Production.INFO: 62 MB #Memory Used# [2026-03-19 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 16:02:05 [end_date_ymd] => 2026-03-19 19:02:05 [RateCDR] => 1 ) [2026-03-19 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-03-19 16:02:05' and `end` < '2026-03-19 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-03-19 19:02:17] Production.INFO: count ==3628 [2026-03-19 19:02:19] Production.ERROR: pbx CDR StartTime 2026-03-19 16:02:05 - End Time 2026-03-19 19:02:05 [2026-03-19 19:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942564', 'tblTempUsageDetail_20' ) start [2026-03-19 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942564', 'tblTempUsageDetail_20' ) end [2026-03-19 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942564', 'tblTempVendorCDR_20' ) start [2026-03-19 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942564', 'tblTempVendorCDR_20' ) end [2026-03-19 19:02:19] Production.INFO: ProcessCDR(1,16942564,1,1,2) [2026-03-19 19:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16942564,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 19:06:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16942564,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 19:06:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16942564,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 19:10:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16942564,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 19:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942564', 'tblTempUsageDetail_20' ) start [2026-03-19 19:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942564', 'tblTempUsageDetail_20' ) end [2026-03-19 19:10:38] Production.ERROR: pbx prc_insertCDR start [2026-03-19 19:10:39] Production.ERROR: pbx prc_insertCDR end [2026-03-19 19:10:39] Production.INFO: ==1697== Releasing lock... [2026-03-19 19:10:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 19:10:39] Production.INFO: 55.25 MB #Memory Used# [2026-03-19 20:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 17:02:06 [end_date_ymd] => 2026-03-19 20:02:06 [RateCDR] => 1 ) [2026-03-19 20:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 17:02:06' and `end` < '2026-03-19 20:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 20:02:18] Production.INFO: count ==2599 [2026-03-19 20:02:19] Production.ERROR: pbx CDR StartTime 2026-03-19 17:02:06 - End Time 2026-03-19 20:02:06 [2026-03-19 20:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942811', 'tblTempUsageDetail_20' ) start [2026-03-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16942811', 'tblTempUsageDetail_20' ) end [2026-03-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942811', 'tblTempVendorCDR_20' ) start [2026-03-19 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16942811', 'tblTempVendorCDR_20' ) end [2026-03-19 20:02:19] Production.INFO: ProcessCDR(1,16942811,1,1,2) [2026-03-19 20:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16942811,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 20:06:17] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16942811,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 20:06:17] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16942811,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 20:10:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16942811,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 20:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942811', 'tblTempUsageDetail_20' ) start [2026-03-19 20:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16942811', 'tblTempUsageDetail_20' ) end [2026-03-19 20:10:48] Production.ERROR: pbx prc_insertCDR start [2026-03-19 20:10:49] Production.ERROR: pbx prc_insertCDR end [2026-03-19 20:10:49] Production.INFO: ==6916== Releasing lock... [2026-03-19 20:10:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 20:10:49] Production.INFO: 47.75 MB #Memory Used# [2026-03-19 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 18:02:06 [end_date_ymd] => 2026-03-19 21:02:06 [RateCDR] => 1 ) [2026-03-19 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-19 18:02:06' and `end` < '2026-03-19 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-19 21:02:18] Production.INFO: count ==2141 [2026-03-19 21:02:19] Production.ERROR: pbx CDR StartTime 2026-03-19 18:02:06 - End Time 2026-03-19 21:02:06 [2026-03-19 21:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943058', 'tblTempUsageDetail_20' ) start [2026-03-19 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943058', 'tblTempUsageDetail_20' ) end [2026-03-19 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943058', 'tblTempVendorCDR_20' ) start [2026-03-19 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943058', 'tblTempVendorCDR_20' ) end [2026-03-19 21:02:19] Production.INFO: ProcessCDR(1,16943058,1,1,2) [2026-03-19 21:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16943058,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 21:06:05] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16943058,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 21:06:05] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16943058,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 21:10:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16943058,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 21:10:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943058', 'tblTempUsageDetail_20' ) start [2026-03-19 21:10:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943058', 'tblTempUsageDetail_20' ) end [2026-03-19 21:10:40] Production.ERROR: pbx prc_insertCDR start [2026-03-19 21:10:40] Production.ERROR: pbx prc_insertCDR end [2026-03-19 21:10:40] Production.INFO: ==11503== Releasing lock... [2026-03-19 21:10:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 21:10:40] Production.INFO: 44.25 MB #Memory Used# [2026-03-19 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 19:02:05 [end_date_ymd] => 2026-03-19 22:02:05 [RateCDR] => 1 ) [2026-03-19 22:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-19 19:02:05' and `end` < '2026-03-19 22:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-19 22:02:17] Production.INFO: count ==1616 [2026-03-19 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-19 19:02:05 - End Time 2026-03-19 22:02:05 [2026-03-19 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943305', 'tblTempUsageDetail_20' ) start [2026-03-19 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943305', 'tblTempUsageDetail_20' ) end [2026-03-19 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943305', 'tblTempVendorCDR_20' ) start [2026-03-19 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943305', 'tblTempVendorCDR_20' ) end [2026-03-19 22:02:17] Production.INFO: ProcessCDR(1,16943305,1,1,2) [2026-03-19 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16943305,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 22:06:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16943305,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 22:06:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16943305,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 22:10:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16943305,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 22:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943305', 'tblTempUsageDetail_20' ) start [2026-03-19 22:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943305', 'tblTempUsageDetail_20' ) end [2026-03-19 22:10:54] Production.ERROR: pbx prc_insertCDR start [2026-03-19 22:10:55] Production.ERROR: pbx prc_insertCDR end [2026-03-19 22:10:55] Production.INFO: ==16417== Releasing lock... [2026-03-19 22:10:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 22:10:55] Production.INFO: 40.5 MB #Memory Used# [2026-03-19 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-19 20:02:06 [end_date_ymd] => 2026-03-19 23:02:06 [RateCDR] => 1 ) [2026-03-19 23: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-19 20:02:06' and `end` < '2026-03-19 23: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-19 23:02:18] Production.INFO: count ==1235 [2026-03-19 23:02:18] Production.ERROR: pbx CDR StartTime 2026-03-19 20:02:06 - End Time 2026-03-19 23:02:06 [2026-03-19 23:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943552', 'tblTempUsageDetail_20' ) start [2026-03-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16943552', 'tblTempUsageDetail_20' ) end [2026-03-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943552', 'tblTempVendorCDR_20' ) start [2026-03-19 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16943552', 'tblTempVendorCDR_20' ) end [2026-03-19 23:02:18] Production.INFO: ProcessCDR(1,16943552,1,1,2) [2026-03-19 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16943552,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 23:06:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16943552,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-19 23:06:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16943552,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 23:11:00] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16943552,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-19 23:11:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943552', 'tblTempUsageDetail_20' ) start [2026-03-19 23:11:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16943552', 'tblTempUsageDetail_20' ) end [2026-03-19 23:11:00] Production.ERROR: pbx prc_insertCDR start [2026-03-19 23:11:00] Production.ERROR: pbx prc_insertCDR end [2026-03-19 23:11:00] Production.INFO: ==21386== Releasing lock... [2026-03-19 23:11:00] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-19 23:11:00] Production.INFO: 37.25 MB #Memory Used#