[2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-25 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +31 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (111,11,1,31,31,'RMScheduler',2026-03-25 00:02:04,1,0,,,0) [2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-25 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +31 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (110,11,1,31,31,'RMScheduler',2026-03-25 00:02:04,1,0,,,0) [2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-08 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +14 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (241,16,1,31,14,'RMScheduler',2026-03-25 00:02:04,1,0,,,0) [2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-08 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +14 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (241,13,2,31,14,'RMScheduler',2026-03-25 00:02:04,1,0,,,0) [2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-08 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +14 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (241,16,1,31,14,'RMScheduler',2026-03-25 00:02:04,0,0,,,0) [2026-03-25 00:02:04] Production.INFO: next invoice date [2026-03-25 00:02:04] Production.INFO: 2026-04-08 [2026-03-25 00:02:04] Production.INFO: getdaysdiff [2026-03-25 00:02:04] Production.INFO: +14 [2026-03-25 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (241,13,2,31,14,'RMScheduler',2026-03-25 00:02:04,0,0,,,0) [2026-03-25 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 21:02:06 [end_date_ymd] => 2026-03-25 00:02:06 [RateCDR] => 1 ) [2026-03-25 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-24 21:02:06' and `end` < '2026-03-25 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-25 00:02:21] Production.INFO: count ==638 [2026-03-25 00:02:22] Production.ERROR: pbx CDR StartTime 2026-03-24 21:02:06 - End Time 2026-03-25 00:02:06 [2026-03-25 00:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 00:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973441', 'tblTempUsageDetail_20' ) start [2026-03-25 00:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973441', 'tblTempUsageDetail_20' ) end [2026-03-25 00:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973441', 'tblTempVendorCDR_20' ) start [2026-03-25 00:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973441', 'tblTempVendorCDR_20' ) end [2026-03-25 00:02:22] Production.INFO: ProcessCDR(1,16973441,1,1,2) [2026-03-25 00:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16973441,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 00:06:06] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16973441,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 00:06:06] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16973441,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 00:10:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16973441,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 00:10:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973441', 'tblTempUsageDetail_20' ) start [2026-03-25 00:10:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973441', 'tblTempUsageDetail_20' ) end [2026-03-25 00:10:35] Production.ERROR: pbx prc_insertCDR start [2026-03-25 00:10:35] Production.ERROR: pbx prc_insertCDR end [2026-03-25 00:10:38] Production.INFO: ==1710== Releasing lock... [2026-03-25 00:10:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 00:10:38] Production.INFO: 37.75 MB #Memory Used# [2026-03-25 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 22:02:06 [end_date_ymd] => 2026-03-25 01:02:06 [RateCDR] => 1 ) [2026-03-25 01:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-24 22:02:06' and `end` < '2026-03-25 01:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 01:02:17] Production.INFO: count ==551 [2026-03-25 01:02:18] Production.ERROR: pbx CDR StartTime 2026-03-24 22:02:06 - End Time 2026-03-25 01:02:06 [2026-03-25 01:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973688', 'tblTempUsageDetail_20' ) start [2026-03-25 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973688', 'tblTempUsageDetail_20' ) end [2026-03-25 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973688', 'tblTempVendorCDR_20' ) start [2026-03-25 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973688', 'tblTempVendorCDR_20' ) end [2026-03-25 01:02:18] Production.INFO: ProcessCDR(1,16973688,1,1,2) [2026-03-25 01:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16973688,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 01:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16973688,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 01:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16973688,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 01:10:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16973688,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 01:10:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973688', 'tblTempUsageDetail_20' ) start [2026-03-25 01:10:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973688', 'tblTempUsageDetail_20' ) end [2026-03-25 01:10:33] Production.ERROR: pbx prc_insertCDR start [2026-03-25 01:10:34] Production.ERROR: pbx prc_insertCDR end [2026-03-25 01:10:34] Production.INFO: ==6057== Releasing lock... [2026-03-25 01:10:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 01:10:34] Production.INFO: 32.75 MB #Memory Used# [2026-03-25 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-24 23:02:05 [end_date_ymd] => 2026-03-25 02:02:05 [RateCDR] => 1 ) [2026-03-25 02:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-24 23:02:05' and `end` < '2026-03-25 02:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 02:02:17] Production.INFO: count ==554 [2026-03-25 02:02:17] Production.ERROR: pbx CDR StartTime 2026-03-24 23:02:05 - End Time 2026-03-25 02:02:05 [2026-03-25 02:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973935', 'tblTempUsageDetail_20' ) start [2026-03-25 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16973935', 'tblTempUsageDetail_20' ) end [2026-03-25 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973935', 'tblTempVendorCDR_20' ) start [2026-03-25 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16973935', 'tblTempVendorCDR_20' ) end [2026-03-25 02:02:17] Production.INFO: ProcessCDR(1,16973935,1,1,2) [2026-03-25 02:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16973935,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 02:06:08] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16973935,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 02:06:08] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16973935,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 02:10:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16973935,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 02:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973935', 'tblTempUsageDetail_20' ) start [2026-03-25 02:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16973935', 'tblTempUsageDetail_20' ) end [2026-03-25 02:10:44] Production.ERROR: pbx prc_insertCDR start [2026-03-25 02:10:44] Production.ERROR: pbx prc_insertCDR end [2026-03-25 02:10:44] Production.INFO: ==10516== Releasing lock... [2026-03-25 02:10:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 02:10:44] Production.INFO: 32.5 MB #Memory Used# [2026-03-25 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 00:02:06 [end_date_ymd] => 2026-03-25 03:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 00:02:06' and `end` < '2026-03-25 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-25 03:02:17] Production.INFO: count ==500 [2026-03-25 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 00:02:06 - End Time 2026-03-25 03:02:06 [2026-03-25 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974182', 'tblTempUsageDetail_20' ) start [2026-03-25 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974182', 'tblTempUsageDetail_20' ) end [2026-03-25 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974182', 'tblTempVendorCDR_20' ) start [2026-03-25 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974182', 'tblTempVendorCDR_20' ) end [2026-03-25 03:02:17] Production.INFO: ProcessCDR(1,16974182,1,1,2) [2026-03-25 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16974182,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 03:05:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16974182,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 03:05:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16974182,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 03:10:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16974182,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 03:10:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974182', 'tblTempUsageDetail_20' ) start [2026-03-25 03:10:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974182', 'tblTempUsageDetail_20' ) end [2026-03-25 03:10:28] Production.ERROR: pbx prc_insertCDR start [2026-03-25 03:10:28] Production.ERROR: pbx prc_insertCDR end [2026-03-25 03:10:28] Production.INFO: ==14899== Releasing lock... [2026-03-25 03:10:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 03:10:28] Production.INFO: 32.5 MB #Memory Used# [2026-03-25 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 01:02:05 [end_date_ymd] => 2026-03-25 04:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 01:02:05' and `end` < '2026-03-25 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-25 04:02:16] Production.INFO: count ==382 [2026-03-25 04:02:16] Production.ERROR: pbx CDR StartTime 2026-03-25 01:02:05 - End Time 2026-03-25 04:02:05 [2026-03-25 04:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974430', 'tblTempUsageDetail_20' ) start [2026-03-25 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974430', 'tblTempUsageDetail_20' ) end [2026-03-25 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974430', 'tblTempVendorCDR_20' ) start [2026-03-25 04:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974430', 'tblTempVendorCDR_20' ) end [2026-03-25 04:02:16] Production.INFO: ProcessCDR(1,16974430,1,1,2) [2026-03-25 04:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16974430,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 04:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16974430,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 04:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16974430,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 04:10:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16974430,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 04:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974430', 'tblTempUsageDetail_20' ) start [2026-03-25 04:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974430', 'tblTempUsageDetail_20' ) end [2026-03-25 04:10:37] Production.ERROR: pbx prc_insertCDR start [2026-03-25 04:10:37] Production.ERROR: pbx prc_insertCDR end [2026-03-25 04:10:37] Production.INFO: ==19340== Releasing lock... [2026-03-25 04:10:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 04:10:37] Production.INFO: 31.75 MB #Memory Used# [2026-03-25 05:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 02:02:06 [end_date_ymd] => 2026-03-25 05:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 02:02:06' and `end` < '2026-03-25 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-25 05:02:17] Production.INFO: count ==211 [2026-03-25 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 02:02:06 - End Time 2026-03-25 05:02:06 [2026-03-25 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974678', 'tblTempUsageDetail_20' ) start [2026-03-25 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974678', 'tblTempUsageDetail_20' ) end [2026-03-25 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974678', 'tblTempVendorCDR_20' ) start [2026-03-25 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974678', 'tblTempVendorCDR_20' ) end [2026-03-25 05:02:17] Production.INFO: ProcessCDR(1,16974678,1,1,2) [2026-03-25 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16974678,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 05:06:03] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16974678,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 05:06:03] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16974678,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 05:10:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16974678,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 05:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974678', 'tblTempUsageDetail_20' ) start [2026-03-25 05:10:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974678', 'tblTempUsageDetail_20' ) end [2026-03-25 05:10:36] Production.ERROR: pbx prc_insertCDR start [2026-03-25 05:10:36] Production.ERROR: pbx prc_insertCDR end [2026-03-25 05:10:36] Production.INFO: ==24289== Releasing lock... [2026-03-25 05:10:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 05:10:36] Production.INFO: 30 MB #Memory Used# [2026-03-25 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 03:02:05 [end_date_ymd] => 2026-03-25 06:02:05 [RateCDR] => 1 ) [2026-03-25 06:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-25 03:02:05' and `end` < '2026-03-25 06:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 06:02:16] Production.INFO: count ==97 [2026-03-25 06:02:16] Production.ERROR: pbx CDR StartTime 2026-03-25 03:02:05 - End Time 2026-03-25 06:02:05 [2026-03-25 06:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974925', 'tblTempUsageDetail_20' ) start [2026-03-25 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16974925', 'tblTempUsageDetail_20' ) end [2026-03-25 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974925', 'tblTempVendorCDR_20' ) start [2026-03-25 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16974925', 'tblTempVendorCDR_20' ) end [2026-03-25 06:02:16] Production.INFO: ProcessCDR(1,16974925,1,1,2) [2026-03-25 06:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16974925,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 06:06:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16974925,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 06:06:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16974925,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 06:11:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16974925,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 06:11:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974925', 'tblTempUsageDetail_20' ) start [2026-03-25 06:11:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16974925', 'tblTempUsageDetail_20' ) end [2026-03-25 06:11:34] Production.ERROR: pbx prc_insertCDR start [2026-03-25 06:11:35] Production.ERROR: pbx prc_insertCDR end [2026-03-25 06:11:35] Production.INFO: ==28730== Releasing lock... [2026-03-25 06:11:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 06:11:35] Production.INFO: 28.75 MB #Memory Used# [2026-03-25 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 04:02:06 [end_date_ymd] => 2026-03-25 07:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 04:02:06' and `end` < '2026-03-25 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-25 07:02:17] Production.INFO: count ==100 [2026-03-25 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 04:02:06 - End Time 2026-03-25 07:02:06 [2026-03-25 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975172', 'tblTempUsageDetail_20' ) start [2026-03-25 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975172', 'tblTempUsageDetail_20' ) end [2026-03-25 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975172', 'tblTempVendorCDR_20' ) start [2026-03-25 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975172', 'tblTempVendorCDR_20' ) end [2026-03-25 07:02:17] Production.INFO: ProcessCDR(1,16975172,1,1,2) [2026-03-25 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16975172,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 07:06:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16975172,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 07:06:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16975172,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 07:10:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16975172,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 07:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975172', 'tblTempUsageDetail_20' ) start [2026-03-25 07:10:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975172', 'tblTempUsageDetail_20' ) end [2026-03-25 07:10:37] Production.ERROR: pbx prc_insertCDR start [2026-03-25 07:10:37] Production.ERROR: pbx prc_insertCDR end [2026-03-25 07:10:37] Production.INFO: ==2861== Releasing lock... [2026-03-25 07:10:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 07:10:37] Production.INFO: 28.75 MB #Memory Used# [2026-03-25 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 05:02:05 [end_date_ymd] => 2026-03-25 08:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 05:02:05' and `end` < '2026-03-25 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-25 08:02:17] Production.INFO: count ==194 [2026-03-25 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 05:02:05 - End Time 2026-03-25 08:02:05 [2026-03-25 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975419', 'tblTempUsageDetail_20' ) start [2026-03-25 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975419', 'tblTempUsageDetail_20' ) end [2026-03-25 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975419', 'tblTempVendorCDR_20' ) start [2026-03-25 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975419', 'tblTempVendorCDR_20' ) end [2026-03-25 08:02:17] Production.INFO: ProcessCDR(1,16975419,1,1,2) [2026-03-25 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16975419,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 08:06:06] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16975419,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 08:06:06] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16975419,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 08:10:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16975419,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 08:10:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975419', 'tblTempUsageDetail_20' ) start [2026-03-25 08:10:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975419', 'tblTempUsageDetail_20' ) end [2026-03-25 08:10:32] Production.ERROR: pbx prc_insertCDR start [2026-03-25 08:10:32] Production.ERROR: pbx prc_insertCDR end [2026-03-25 08:10:32] Production.INFO: ==7947== Releasing lock... [2026-03-25 08:10:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 08:10:32] Production.INFO: 30 MB #Memory Used# [2026-03-25 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 06:02:05 [end_date_ymd] => 2026-03-25 09:02:05 [RateCDR] => 1 ) [2026-03-25 09:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-25 06:02:05' and `end` < '2026-03-25 09:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 09:02:16] Production.INFO: count ==712 [2026-03-25 09:02:16] Production.ERROR: pbx CDR StartTime 2026-03-25 06:02:05 - End Time 2026-03-25 09:02:05 [2026-03-25 09:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975666', 'tblTempUsageDetail_20' ) start [2026-03-25 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975666', 'tblTempUsageDetail_20' ) end [2026-03-25 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975666', 'tblTempVendorCDR_20' ) start [2026-03-25 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975666', 'tblTempVendorCDR_20' ) end [2026-03-25 09:02:16] Production.INFO: ProcessCDR(1,16975666,1,1,2) [2026-03-25 09:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16975666,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 09:06:48] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16975666,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 09:06:48] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16975666,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 09:11:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16975666,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 09:11:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975666', 'tblTempUsageDetail_20' ) start [2026-03-25 09:11:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975666', 'tblTempUsageDetail_20' ) end [2026-03-25 09:11:31] Production.ERROR: pbx prc_insertCDR start [2026-03-25 09:11:31] Production.ERROR: pbx prc_insertCDR end [2026-03-25 09:11:31] Production.INFO: ==12297== Releasing lock... [2026-03-25 09:11:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 09:11:31] Production.INFO: 33.75 MB #Memory Used# [2026-03-25 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 07:02:06 [end_date_ymd] => 2026-03-25 10:02:06 [RateCDR] => 1 ) [2026-03-25 10:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-25 07:02:06' and `end` < '2026-03-25 10:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 10:02:18] Production.INFO: count ==2330 [2026-03-25 10:02:19] Production.ERROR: pbx CDR StartTime 2026-03-25 07:02:06 - End Time 2026-03-25 10:02:06 [2026-03-25 10:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975913', 'tblTempUsageDetail_20' ) start [2026-03-25 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16975913', 'tblTempUsageDetail_20' ) end [2026-03-25 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975913', 'tblTempVendorCDR_20' ) start [2026-03-25 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16975913', 'tblTempVendorCDR_20' ) end [2026-03-25 10:02:19] Production.INFO: ProcessCDR(1,16975913,1,1,2) [2026-03-25 10:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16975913,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 10:06:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16975913,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 10:06:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16975913,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 10:11:04] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16975913,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 10:11:04] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975913', 'tblTempUsageDetail_20' ) start [2026-03-25 10:11:05] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16975913', 'tblTempUsageDetail_20' ) end [2026-03-25 10:11:05] Production.ERROR: pbx prc_insertCDR start [2026-03-25 10:11:11] Production.ERROR: pbx prc_insertCDR end [2026-03-25 10:11:11] Production.INFO: ==17354== Releasing lock... [2026-03-25 10:11:11] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 10:11:11] Production.INFO: 46.25 MB #Memory Used# [2026-03-25 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 08:02:05 [end_date_ymd] => 2026-03-25 11:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 08:02:05' and `end` < '2026-03-25 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-25 11:02:19] Production.INFO: count ==3942 [2026-03-25 11:02:21] Production.ERROR: pbx CDR StartTime 2026-03-25 08:02:05 - End Time 2026-03-25 11:02:05 [2026-03-25 11:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976160', 'tblTempUsageDetail_20' ) start [2026-03-25 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976160', 'tblTempUsageDetail_20' ) end [2026-03-25 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976160', 'tblTempVendorCDR_20' ) start [2026-03-25 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976160', 'tblTempVendorCDR_20' ) end [2026-03-25 11:02:21] Production.INFO: ProcessCDR(1,16976160,1,1,2) [2026-03-25 11:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16976160,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 11:06:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16976160,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 11:06:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16976160,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 11:06:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16976160,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 11:06:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976160', 'tblTempUsageDetail_20' ) start [2026-03-25 11:06:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976160', 'tblTempUsageDetail_20' ) end [2026-03-25 11:06:32] Production.ERROR: pbx prc_insertCDR start [2026-03-25 11:06:34] Production.ERROR: pbx prc_insertCDR end [2026-03-25 11:06:34] Production.INFO: ==22110== Releasing lock... [2026-03-25 11:06:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 11:06:34] Production.INFO: 57.5 MB #Memory Used# [2026-03-25 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 09:02:06 [end_date_ymd] => 2026-03-25 12:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 09:02:06' and `end` < '2026-03-25 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-25 12:02:18] Production.INFO: count ==5344 [2026-03-25 12:02:21] Production.ERROR: pbx CDR StartTime 2026-03-25 09:02:06 - End Time 2026-03-25 12:02:06 [2026-03-25 12:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976407', 'tblTempUsageDetail_20' ) start [2026-03-25 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976407', 'tblTempUsageDetail_20' ) end [2026-03-25 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976407', 'tblTempVendorCDR_20' ) start [2026-03-25 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976407', 'tblTempVendorCDR_20' ) end [2026-03-25 12:02:21] Production.INFO: ProcessCDR(1,16976407,1,1,2) [2026-03-25 12:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16976407,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 12:06:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16976407,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 12:06:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16976407,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 12:07:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16976407,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 12:07:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976407', 'tblTempUsageDetail_20' ) start [2026-03-25 12:07:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976407', 'tblTempUsageDetail_20' ) end [2026-03-25 12:07:18] Production.ERROR: pbx prc_insertCDR start [2026-03-25 12:07:21] Production.ERROR: pbx prc_insertCDR end [2026-03-25 12:07:21] Production.INFO: ==26447== Releasing lock... [2026-03-25 12:07:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 12:07:21] Production.INFO: 68.25 MB #Memory Used# [2026-03-25 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 10:02:05 [end_date_ymd] => 2026-03-25 13:02:05 [RateCDR] => 1 ) [2026-03-25 13:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-25 10:02:05' and `end` < '2026-03-25 13:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 13:02:19] Production.INFO: count ==5615 [2026-03-25 13:02:22] Production.ERROR: pbx CDR StartTime 2026-03-25 10:02:05 - End Time 2026-03-25 13:02:05 [2026-03-25 13:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976654', 'tblTempUsageDetail_20' ) start [2026-03-25 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976654', 'tblTempUsageDetail_20' ) end [2026-03-25 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976654', 'tblTempVendorCDR_20' ) start [2026-03-25 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976654', 'tblTempVendorCDR_20' ) end [2026-03-25 13:02:23] Production.INFO: ProcessCDR(1,16976654,1,1,2) [2026-03-25 13:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16976654,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 13:06:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16976654,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 13:06:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16976654,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 13:07:16] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16976654,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 13:07:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976654', 'tblTempUsageDetail_20' ) start [2026-03-25 13:07:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976654', 'tblTempUsageDetail_20' ) end [2026-03-25 13:07:17] Production.ERROR: pbx prc_insertCDR start [2026-03-25 13:07:20] Production.ERROR: pbx prc_insertCDR end [2026-03-25 13:07:20] Production.INFO: ==30836== Releasing lock... [2026-03-25 13:07:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 13:07:20] Production.INFO: 70.25 MB #Memory Used# [2026-03-25 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 11:02:05 [end_date_ymd] => 2026-03-25 14:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 11:02:05' and `end` < '2026-03-25 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-25 14:02:19] Production.INFO: count ==5682 [2026-03-25 14:02:22] Production.ERROR: pbx CDR StartTime 2026-03-25 11:02:05 - End Time 2026-03-25 14:02:05 [2026-03-25 14:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976901', 'tblTempUsageDetail_20' ) start [2026-03-25 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16976901', 'tblTempUsageDetail_20' ) end [2026-03-25 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976901', 'tblTempVendorCDR_20' ) start [2026-03-25 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16976901', 'tblTempVendorCDR_20' ) end [2026-03-25 14:02:22] Production.INFO: ProcessCDR(1,16976901,1,1,2) [2026-03-25 14:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16976901,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 14:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16976901,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 14:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16976901,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 14:02:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16976901,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 14:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976901', 'tblTempUsageDetail_20' ) start [2026-03-25 14:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16976901', 'tblTempUsageDetail_20' ) end [2026-03-25 14:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-25 14:02:48] Production.ERROR: pbx prc_insertCDR end [2026-03-25 14:02:48] Production.INFO: ==2927== Releasing lock... [2026-03-25 14:02:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 14:02:48] Production.INFO: 70.75 MB #Memory Used# [2026-03-25 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 12:02:05 [end_date_ymd] => 2026-03-25 15:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 12:02:05' and `end` < '2026-03-25 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-25 15:02:20] Production.INFO: count ==5619 [2026-03-25 15:02:23] Production.ERROR: pbx CDR StartTime 2026-03-25 12:02:05 - End Time 2026-03-25 15:02:05 [2026-03-25 15:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977148', 'tblTempUsageDetail_20' ) start [2026-03-25 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977148', 'tblTempUsageDetail_20' ) end [2026-03-25 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977148', 'tblTempVendorCDR_20' ) start [2026-03-25 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977148', 'tblTempVendorCDR_20' ) end [2026-03-25 15:02:24] Production.INFO: ProcessCDR(1,16977148,1,1,2) [2026-03-25 15:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16977148,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 15:02:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16977148,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 15:02:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16977148,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 15:02:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16977148,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 15:02:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977148', 'tblTempUsageDetail_20' ) start [2026-03-25 15:02:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977148', 'tblTempUsageDetail_20' ) end [2026-03-25 15:02:47] Production.ERROR: pbx prc_insertCDR start [2026-03-25 15:02:50] Production.ERROR: pbx prc_insertCDR end [2026-03-25 15:02:50] Production.INFO: ==7602== Releasing lock... [2026-03-25 15:02:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 15:02:50] Production.INFO: 70.25 MB #Memory Used# [2026-03-25 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 13:02:05 [end_date_ymd] => 2026-03-25 16:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 13:02:05' and `end` < '2026-03-25 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-25 16:02:18] Production.INFO: count ==5570 [2026-03-25 16:02:21] Production.ERROR: pbx CDR StartTime 2026-03-25 13:02:05 - End Time 2026-03-25 16:02:05 [2026-03-25 16:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977395', 'tblTempUsageDetail_20' ) start [2026-03-25 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977395', 'tblTempUsageDetail_20' ) end [2026-03-25 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977395', 'tblTempVendorCDR_20' ) start [2026-03-25 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977395', 'tblTempVendorCDR_20' ) end [2026-03-25 16:02:22] Production.INFO: ProcessCDR(1,16977395,1,1,2) [2026-03-25 16:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16977395,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 16:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16977395,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 16:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16977395,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 16:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16977395,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 16:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977395', 'tblTempUsageDetail_20' ) start [2026-03-25 16:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977395', 'tblTempUsageDetail_20' ) end [2026-03-25 16:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-25 16:02:47] Production.ERROR: pbx prc_insertCDR end [2026-03-25 16:02:47] Production.INFO: ==12253== Releasing lock... [2026-03-25 16:02:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 16:02:47] Production.INFO: 70 MB #Memory Used# [2026-03-25 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 14:02:05 [end_date_ymd] => 2026-03-25 17:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 14:02:05' and `end` < '2026-03-25 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-25 17:02:19] Production.INFO: count ==5162 [2026-03-25 17:02:22] Production.ERROR: pbx CDR StartTime 2026-03-25 14:02:05 - End Time 2026-03-25 17:02:05 [2026-03-25 17:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977642', 'tblTempUsageDetail_20' ) start [2026-03-25 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977642', 'tblTempUsageDetail_20' ) end [2026-03-25 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977642', 'tblTempVendorCDR_20' ) start [2026-03-25 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977642', 'tblTempVendorCDR_20' ) end [2026-03-25 17:02:22] Production.INFO: ProcessCDR(1,16977642,1,1,2) [2026-03-25 17:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16977642,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 17:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16977642,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 17:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16977642,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 17:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16977642,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 17:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977642', 'tblTempUsageDetail_20' ) start [2026-03-25 17:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977642', 'tblTempUsageDetail_20' ) end [2026-03-25 17:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-25 17:02:48] Production.ERROR: pbx prc_insertCDR end [2026-03-25 17:02:49] Production.INFO: ==16646== Releasing lock... [2026-03-25 17:02:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 17:02:49] Production.INFO: 67 MB #Memory Used# [2026-03-25 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 15:02:05 [end_date_ymd] => 2026-03-25 18:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 15:02:05' and `end` < '2026-03-25 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-25 18:02:17] Production.INFO: count ==4571 [2026-03-25 18:02:20] Production.ERROR: pbx CDR StartTime 2026-03-25 15:02:05 - End Time 2026-03-25 18:02:05 [2026-03-25 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977889', 'tblTempUsageDetail_20' ) start [2026-03-25 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16977889', 'tblTempUsageDetail_20' ) end [2026-03-25 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977889', 'tblTempVendorCDR_20' ) start [2026-03-25 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16977889', 'tblTempVendorCDR_20' ) end [2026-03-25 18:02:20] Production.INFO: ProcessCDR(1,16977889,1,1,2) [2026-03-25 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16977889,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 18:02:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16977889,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 18:02:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16977889,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 18:02:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16977889,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 18:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977889', 'tblTempUsageDetail_20' ) start [2026-03-25 18:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16977889', 'tblTempUsageDetail_20' ) end [2026-03-25 18:02:42] Production.ERROR: pbx prc_insertCDR start [2026-03-25 18:02:44] Production.ERROR: pbx prc_insertCDR end [2026-03-25 18:02:44] Production.INFO: ==21213== Releasing lock... [2026-03-25 18:02:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 18:02:44] Production.INFO: 62.5 MB #Memory Used# [2026-03-25 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 16:02:06 [end_date_ymd] => 2026-03-25 19:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 16:02:06' and `end` < '2026-03-25 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-25 19:02:18] Production.INFO: count ==3425 [2026-03-25 19:02:20] Production.ERROR: pbx CDR StartTime 2026-03-25 16:02:06 - End Time 2026-03-25 19:02:06 [2026-03-25 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978135', 'tblTempUsageDetail_20' ) start [2026-03-25 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978135', 'tblTempUsageDetail_20' ) end [2026-03-25 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978135', 'tblTempVendorCDR_20' ) start [2026-03-25 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978135', 'tblTempVendorCDR_20' ) end [2026-03-25 19:02:20] Production.INFO: ProcessCDR(1,16978135,1,1,2) [2026-03-25 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16978135,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 19:02:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16978135,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 19:02:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16978135,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 19:02:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16978135,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 19:02:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978135', 'tblTempUsageDetail_20' ) start [2026-03-25 19:02:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978135', 'tblTempUsageDetail_20' ) end [2026-03-25 19:02:41] Production.ERROR: pbx prc_insertCDR start [2026-03-25 19:02:41] Production.ERROR: pbx prc_insertCDR end [2026-03-25 19:02:41] Production.INFO: ==25796== Releasing lock... [2026-03-25 19:02:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 19:02:41] Production.INFO: 53.75 MB #Memory Used# [2026-03-25 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 17:02:05 [end_date_ymd] => 2026-03-25 20:02:05 [RateCDR] => 1 ) [2026-03-25 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-25 17:02:05' and `end` < '2026-03-25 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-25 20:02:17] Production.INFO: count ==2644 [2026-03-25 20:02:18] Production.ERROR: pbx CDR StartTime 2026-03-25 17:02:05 - End Time 2026-03-25 20:02:05 [2026-03-25 20:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978382', 'tblTempUsageDetail_20' ) start [2026-03-25 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978382', 'tblTempUsageDetail_20' ) end [2026-03-25 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978382', 'tblTempVendorCDR_20' ) start [2026-03-25 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978382', 'tblTempVendorCDR_20' ) end [2026-03-25 20:02:18] Production.INFO: ProcessCDR(1,16978382,1,1,2) [2026-03-25 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16978382,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 20:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16978382,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 20:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16978382,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 20:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16978382,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 20:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978382', 'tblTempUsageDetail_20' ) start [2026-03-25 20:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978382', 'tblTempUsageDetail_20' ) end [2026-03-25 20:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-25 20:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-25 20:02:40] Production.INFO: ==30713== Releasing lock... [2026-03-25 20:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 20:02:40] Production.INFO: 48.25 MB #Memory Used# [2026-03-25 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 18:02:05 [end_date_ymd] => 2026-03-25 21:02:05 [RateCDR] => 1 ) [2026-03-25 21:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-25 18:02:05' and `end` < '2026-03-25 21:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-25 21:02:16] Production.INFO: count ==1782 [2026-03-25 21:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 18:02:05 - End Time 2026-03-25 21:02:05 [2026-03-25 21:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978629', 'tblTempUsageDetail_20' ) start [2026-03-25 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978629', 'tblTempUsageDetail_20' ) end [2026-03-25 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978629', 'tblTempVendorCDR_20' ) start [2026-03-25 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978629', 'tblTempVendorCDR_20' ) end [2026-03-25 21:02:17] Production.INFO: ProcessCDR(1,16978629,1,1,2) [2026-03-25 21:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16978629,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 21:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16978629,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 21:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16978629,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 21:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16978629,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 21:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978629', 'tblTempUsageDetail_20' ) start [2026-03-25 21:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978629', 'tblTempUsageDetail_20' ) end [2026-03-25 21:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-25 21:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-25 21:02:37] Production.INFO: ==2882== Releasing lock... [2026-03-25 21:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 21:02:37] Production.INFO: 41.5 MB #Memory Used# [2026-03-25 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 19:02:06 [end_date_ymd] => 2026-03-25 22:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 19:02:06' and `end` < '2026-03-25 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-25 22:02:17] Production.INFO: count ==1479 [2026-03-25 22:02:18] Production.ERROR: pbx CDR StartTime 2026-03-25 19:02:06 - End Time 2026-03-25 22:02:06 [2026-03-25 22:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978876', 'tblTempUsageDetail_20' ) start [2026-03-25 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16978876', 'tblTempUsageDetail_20' ) end [2026-03-25 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978876', 'tblTempVendorCDR_20' ) start [2026-03-25 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16978876', 'tblTempVendorCDR_20' ) end [2026-03-25 22:02:18] Production.INFO: ProcessCDR(1,16978876,1,1,2) [2026-03-25 22:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16978876,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 22:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16978876,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 22:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16978876,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 22:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16978876,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 22:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978876', 'tblTempUsageDetail_20' ) start [2026-03-25 22:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16978876', 'tblTempUsageDetail_20' ) end [2026-03-25 22:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-25 22:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-25 22:02:39] Production.INFO: ==7713== Releasing lock... [2026-03-25 22:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 22:02:39] Production.INFO: 39.25 MB #Memory Used# [2026-03-25 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-25 20:02:06 [end_date_ymd] => 2026-03-25 23:02:06 [RateCDR] => 1 ) [2026-03-25 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-25 20:02:06' and `end` < '2026-03-25 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-25 23:02:17] Production.INFO: count ==1116 [2026-03-25 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-25 20:02:06 - End Time 2026-03-25 23:02:06 [2026-03-25 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-25 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16979123', 'tblTempUsageDetail_20' ) start [2026-03-25 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16979123', 'tblTempUsageDetail_20' ) end [2026-03-25 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16979123', 'tblTempVendorCDR_20' ) start [2026-03-25 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16979123', 'tblTempVendorCDR_20' ) end [2026-03-25 23:02:17] Production.INFO: ProcessCDR(1,16979123,1,1,2) [2026-03-25 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16979123,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 23:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16979123,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-25 23:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16979123,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 23:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16979123,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-25 23:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16979123', 'tblTempUsageDetail_20' ) start [2026-03-25 23:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16979123', 'tblTempUsageDetail_20' ) end [2026-03-25 23:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-25 23:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-25 23:02:39] Production.INFO: ==12266== Releasing lock... [2026-03-25 23:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-25 23:02:39] Production.INFO: 36.5 MB #Memory Used#