[2026-03-17 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-16 21:02:05 [end_date_ymd] => 2026-03-17 00:02:05 [RateCDR] => 1 ) [2026-03-17 00:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-16 21:02:05' and `end` < '2026-03-17 00:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-17 00:02:17] Production.INFO: count ==579 [2026-03-17 00:02:17] Production.ERROR: pbx CDR StartTime 2026-03-16 21:02:05 - End Time 2026-03-17 00:02:05 [2026-03-17 00:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 00:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926013', 'tblTempUsageDetail_20' ) start [2026-03-17 00:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926013', 'tblTempUsageDetail_20' ) end [2026-03-17 00:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926013', 'tblTempVendorCDR_20' ) start [2026-03-17 00:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926013', 'tblTempVendorCDR_20' ) end [2026-03-17 00:02:17] Production.INFO: ProcessCDR(1,16926013,1,1,2) [2026-03-17 00:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16926013,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 00:06:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16926013,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 00:06:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16926013,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 00:06:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16926013,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 00:06:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926013', 'tblTempUsageDetail_20' ) start [2026-03-17 00:06:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926013', 'tblTempUsageDetail_20' ) end [2026-03-17 00:06:18] Production.ERROR: pbx prc_insertCDR start [2026-03-17 00:06:18] Production.ERROR: pbx prc_insertCDR end [2026-03-17 00:06:20] Production.INFO: ==30875== Releasing lock... [2026-03-17 00:06:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 00:06:20] Production.INFO: 36.75 MB #Memory Used# [2026-03-17 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-16 22:02:06 [end_date_ymd] => 2026-03-17 01:02:06 [RateCDR] => 1 ) [2026-03-17 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-16 22:02:06' and `end` < '2026-03-17 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-17 01:02:17] Production.INFO: count ==545 [2026-03-17 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-16 22:02:06 - End Time 2026-03-17 01:02:06 [2026-03-17 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926260', 'tblTempUsageDetail_20' ) start [2026-03-17 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926260', 'tblTempUsageDetail_20' ) end [2026-03-17 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926260', 'tblTempVendorCDR_20' ) start [2026-03-17 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926260', 'tblTempVendorCDR_20' ) end [2026-03-17 01:02:17] Production.INFO: ProcessCDR(1,16926260,1,1,2) [2026-03-17 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16926260,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 01:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16926260,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 01:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16926260,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 01:06:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16926260,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 01:06:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926260', 'tblTempUsageDetail_20' ) start [2026-03-17 01:06:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926260', 'tblTempUsageDetail_20' ) end [2026-03-17 01:06:23] Production.ERROR: pbx prc_insertCDR start [2026-03-17 01:06:23] Production.ERROR: pbx prc_insertCDR end [2026-03-17 01:06:23] Production.INFO: ==3548== Releasing lock... [2026-03-17 01:06:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 01:06:23] Production.INFO: 32.25 MB #Memory Used# [2026-03-17 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-16 23:02:06 [end_date_ymd] => 2026-03-17 02:02:06 [RateCDR] => 1 ) [2026-03-17 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-16 23:02:06' and `end` < '2026-03-17 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-17 02:02:17] Production.INFO: count ==504 [2026-03-17 02:02:17] Production.ERROR: pbx CDR StartTime 2026-03-16 23:02:06 - End Time 2026-03-17 02:02:06 [2026-03-17 02:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926507', 'tblTempUsageDetail_20' ) start [2026-03-17 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926507', 'tblTempUsageDetail_20' ) end [2026-03-17 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926507', 'tblTempVendorCDR_20' ) start [2026-03-17 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926507', 'tblTempVendorCDR_20' ) end [2026-03-17 02:02:17] Production.INFO: ProcessCDR(1,16926507,1,1,2) [2026-03-17 02:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16926507,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 02:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16926507,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 02:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16926507,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 02:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16926507,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 02:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926507', 'tblTempUsageDetail_20' ) start [2026-03-17 02:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926507', 'tblTempUsageDetail_20' ) end [2026-03-17 02:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-17 02:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-17 02:02:37] Production.INFO: ==8580== Releasing lock... [2026-03-17 02:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 02:02:37] Production.INFO: 32.5 MB #Memory Used# [2026-03-17 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 00:02:05 [end_date_ymd] => 2026-03-17 03:02:05 [RateCDR] => 1 ) [2026-03-17 03:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-17 00:02:05' and `end` < '2026-03-17 03:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-17 03:02:17] Production.INFO: count ==552 [2026-03-17 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 00:02:05 - End Time 2026-03-17 03:02:05 [2026-03-17 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926754', 'tblTempUsageDetail_20' ) start [2026-03-17 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16926754', 'tblTempUsageDetail_20' ) end [2026-03-17 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926754', 'tblTempVendorCDR_20' ) start [2026-03-17 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16926754', 'tblTempVendorCDR_20' ) end [2026-03-17 03:02:17] Production.INFO: ProcessCDR(1,16926754,1,1,2) [2026-03-17 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16926754,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 03:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16926754,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 03:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16926754,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 03:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16926754,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 03:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926754', 'tblTempUsageDetail_20' ) start [2026-03-17 03:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16926754', 'tblTempUsageDetail_20' ) end [2026-03-17 03:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-17 03:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-17 03:02:37] Production.INFO: ==13352== Releasing lock... [2026-03-17 03:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 03:02:37] Production.INFO: 32.75 MB #Memory Used# [2026-03-17 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 01:02:06 [end_date_ymd] => 2026-03-17 04:02:06 [RateCDR] => 1 ) [2026-03-17 04:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-17 01:02:06' and `end` < '2026-03-17 04:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-17 04:02:17] Production.INFO: count ==445 [2026-03-17 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 01:02:06 - End Time 2026-03-17 04:02:06 [2026-03-17 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927002', 'tblTempUsageDetail_20' ) start [2026-03-17 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927002', 'tblTempUsageDetail_20' ) end [2026-03-17 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927002', 'tblTempVendorCDR_20' ) start [2026-03-17 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927002', 'tblTempVendorCDR_20' ) end [2026-03-17 04:02:17] Production.INFO: ProcessCDR(1,16927002,1,1,2) [2026-03-17 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16927002,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 04:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16927002,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 04:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16927002,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 04:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16927002,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927002', 'tblTempUsageDetail_20' ) start [2026-03-17 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927002', 'tblTempUsageDetail_20' ) end [2026-03-17 04:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-17 04:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-17 04:02:36] Production.INFO: ==17767== Releasing lock... [2026-03-17 04:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 04:02:36] Production.INFO: 32 MB #Memory Used# [2026-03-17 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 02:02:05 [end_date_ymd] => 2026-03-17 05:02:05 [RateCDR] => 1 ) [2026-03-17 05:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-17 02:02:05' and `end` < '2026-03-17 05:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-17 05:02:17] Production.INFO: count ==344 [2026-03-17 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 02:02:05 - End Time 2026-03-17 05:02:05 [2026-03-17 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927250', 'tblTempUsageDetail_20' ) start [2026-03-17 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927250', 'tblTempUsageDetail_20' ) end [2026-03-17 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927250', 'tblTempVendorCDR_20' ) start [2026-03-17 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927250', 'tblTempVendorCDR_20' ) end [2026-03-17 05:02:17] Production.INFO: ProcessCDR(1,16927250,1,1,2) [2026-03-17 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16927250,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 05:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16927250,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 05:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16927250,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 05:02:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16927250,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 05:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927250', 'tblTempUsageDetail_20' ) start [2026-03-17 05:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927250', 'tblTempUsageDetail_20' ) end [2026-03-17 05:02:35] Production.ERROR: pbx prc_insertCDR start [2026-03-17 05:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-17 05:02:36] Production.INFO: ==22330== Releasing lock... [2026-03-17 05:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 05:02:36] Production.INFO: 30.5 MB #Memory Used# [2026-03-17 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 03:02:05 [end_date_ymd] => 2026-03-17 06:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 03:02:05' and `end` < '2026-03-17 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-17 06:02:16] Production.INFO: count ==156 [2026-03-17 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 03:02:05 - End Time 2026-03-17 06:02:05 [2026-03-17 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927497', 'tblTempUsageDetail_20' ) start [2026-03-17 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927497', 'tblTempUsageDetail_20' ) end [2026-03-17 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927497', 'tblTempVendorCDR_20' ) start [2026-03-17 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927497', 'tblTempVendorCDR_20' ) end [2026-03-17 06:02:17] Production.INFO: ProcessCDR(1,16927497,1,1,2) [2026-03-17 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16927497,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 06:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16927497,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 06:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16927497,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 06:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16927497,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 06:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927497', 'tblTempUsageDetail_20' ) start [2026-03-17 06:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927497', 'tblTempUsageDetail_20' ) end [2026-03-17 06:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-17 06:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-17 06:02:36] Production.INFO: ==26817== Releasing lock... [2026-03-17 06:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 06:02:36] Production.INFO: 29.25 MB #Memory Used# [2026-03-17 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 04:02:06 [end_date_ymd] => 2026-03-17 07:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 04:02:06' and `end` < '2026-03-17 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-17 07:02:17] Production.INFO: count ==85 [2026-03-17 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 04:02:06 - End Time 2026-03-17 07:02:06 [2026-03-17 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927744', 'tblTempUsageDetail_20' ) start [2026-03-17 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927744', 'tblTempUsageDetail_20' ) end [2026-03-17 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927744', 'tblTempVendorCDR_20' ) start [2026-03-17 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927744', 'tblTempVendorCDR_20' ) end [2026-03-17 07:02:17] Production.INFO: ProcessCDR(1,16927744,1,1,2) [2026-03-17 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16927744,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 07:02:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16927744,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 07:02:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16927744,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 07:02:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16927744,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 07:02:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927744', 'tblTempUsageDetail_20' ) start [2026-03-17 07:02:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927744', 'tblTempUsageDetail_20' ) end [2026-03-17 07:02:31] Production.ERROR: pbx prc_insertCDR start [2026-03-17 07:02:31] Production.ERROR: pbx prc_insertCDR end [2026-03-17 07:02:31] Production.INFO: ==31592== Releasing lock... [2026-03-17 07:02:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 07:02:31] Production.INFO: 28.25 MB #Memory Used# [2026-03-17 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 05:02:05 [end_date_ymd] => 2026-03-17 08:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 05:02:05' and `end` < '2026-03-17 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-17 08:02:16] Production.INFO: count ==203 [2026-03-17 08:02:16] Production.ERROR: pbx CDR StartTime 2026-03-17 05:02:05 - End Time 2026-03-17 08:02:05 [2026-03-17 08:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927991', 'tblTempUsageDetail_20' ) start [2026-03-17 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16927991', 'tblTempUsageDetail_20' ) end [2026-03-17 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927991', 'tblTempVendorCDR_20' ) start [2026-03-17 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16927991', 'tblTempVendorCDR_20' ) end [2026-03-17 08:02:16] Production.INFO: ProcessCDR(1,16927991,1,1,2) [2026-03-17 08:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16927991,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 08:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16927991,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 08:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16927991,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 08:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16927991,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 08:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927991', 'tblTempUsageDetail_20' ) start [2026-03-17 08:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16927991', 'tblTempUsageDetail_20' ) end [2026-03-17 08:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-17 08:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-17 08:02:37] Production.INFO: ==4213== Releasing lock... [2026-03-17 08:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 08:02:37] Production.INFO: 29.75 MB #Memory Used# [2026-03-17 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 06:02:06 [end_date_ymd] => 2026-03-17 09:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 06:02:06' and `end` < '2026-03-17 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-17 09:02:17] Production.INFO: count ==758 [2026-03-17 09:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 06:02:06 - End Time 2026-03-17 09:02:06 [2026-03-17 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928238', 'tblTempUsageDetail_20' ) start [2026-03-17 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928238', 'tblTempUsageDetail_20' ) end [2026-03-17 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928238', 'tblTempVendorCDR_20' ) start [2026-03-17 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928238', 'tblTempVendorCDR_20' ) end [2026-03-17 09:02:17] Production.INFO: ProcessCDR(1,16928238,1,1,2) [2026-03-17 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16928238,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 09:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16928238,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 09:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16928238,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 09:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16928238,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 09:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928238', 'tblTempUsageDetail_20' ) start [2026-03-17 09:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928238', 'tblTempUsageDetail_20' ) end [2026-03-17 09:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-17 09:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-17 09:02:38] Production.INFO: ==9265== Releasing lock... [2026-03-17 09:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 09:02:38] Production.INFO: 33.5 MB #Memory Used# [2026-03-17 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 07:02:05 [end_date_ymd] => 2026-03-17 10:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 07:02:05' and `end` < '2026-03-17 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-17 10:02:19] Production.INFO: count ==2435 [2026-03-17 10:02:20] Production.ERROR: pbx CDR StartTime 2026-03-17 07:02:05 - End Time 2026-03-17 10:02:05 [2026-03-17 10:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 10:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928485', 'tblTempUsageDetail_20' ) start [2026-03-17 10:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928485', 'tblTempUsageDetail_20' ) end [2026-03-17 10:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928485', 'tblTempVendorCDR_20' ) start [2026-03-17 10:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928485', 'tblTempVendorCDR_20' ) end [2026-03-17 10:02:20] Production.INFO: ProcessCDR(1,16928485,1,1,2) [2026-03-17 10:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16928485,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 10:02:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16928485,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 10:02:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16928485,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 10:02:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16928485,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 10:02:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928485', 'tblTempUsageDetail_20' ) start [2026-03-17 10:02:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928485', 'tblTempUsageDetail_20' ) end [2026-03-17 10:02:41] Production.ERROR: pbx prc_insertCDR start [2026-03-17 10:02:43] Production.ERROR: pbx prc_insertCDR end [2026-03-17 10:02:43] Production.INFO: ==13632== Releasing lock... [2026-03-17 10:02:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 10:02:43] Production.INFO: 47 MB #Memory Used# [2026-03-17 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 08:02:05 [end_date_ymd] => 2026-03-17 11:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 08:02:05' and `end` < '2026-03-17 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-17 11:02:20] Production.INFO: count ==4228 [2026-03-17 11:02:22] Production.ERROR: pbx CDR StartTime 2026-03-17 08:02:05 - End Time 2026-03-17 11:02:05 [2026-03-17 11:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928732', 'tblTempUsageDetail_20' ) start [2026-03-17 11:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928732', 'tblTempUsageDetail_20' ) end [2026-03-17 11:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928732', 'tblTempVendorCDR_20' ) start [2026-03-17 11:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928732', 'tblTempVendorCDR_20' ) end [2026-03-17 11:02:23] Production.INFO: ProcessCDR(1,16928732,1,1,2) [2026-03-17 11:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16928732,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 11:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16928732,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 11:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16928732,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 11:02:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16928732,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 11:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928732', 'tblTempUsageDetail_20' ) start [2026-03-17 11:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928732', 'tblTempUsageDetail_20' ) end [2026-03-17 11:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-17 11:02:48] Production.ERROR: pbx prc_insertCDR end [2026-03-17 11:02:48] Production.INFO: ==18086== Releasing lock... [2026-03-17 11:02:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 11:02:48] Production.INFO: 59.75 MB #Memory Used# [2026-03-17 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 09:02:05 [end_date_ymd] => 2026-03-17 12:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 09:02:05' and `end` < '2026-03-17 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-17 12:02:18] Production.INFO: count ==5541 [2026-03-17 12:02:20] Production.ERROR: pbx CDR StartTime 2026-03-17 09:02:05 - End Time 2026-03-17 12:02:05 [2026-03-17 12:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 12:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928979', 'tblTempUsageDetail_20' ) start [2026-03-17 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16928979', 'tblTempUsageDetail_20' ) end [2026-03-17 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928979', 'tblTempVendorCDR_20' ) start [2026-03-17 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16928979', 'tblTempVendorCDR_20' ) end [2026-03-17 12:02:21] Production.INFO: ProcessCDR(1,16928979,1,1,2) [2026-03-17 12:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16928979,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 12:02:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16928979,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 12:02:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16928979,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 12:02:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16928979,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 12:02:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928979', 'tblTempUsageDetail_20' ) start [2026-03-17 12:02:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16928979', 'tblTempUsageDetail_20' ) end [2026-03-17 12:02:43] Production.ERROR: pbx prc_insertCDR start [2026-03-17 12:02:46] Production.ERROR: pbx prc_insertCDR end [2026-03-17 12:02:46] Production.INFO: ==22921== Releasing lock... [2026-03-17 12:02:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 12:02:46] Production.INFO: 69.75 MB #Memory Used# [2026-03-17 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 10:02:05 [end_date_ymd] => 2026-03-17 13:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 10:02:05' and `end` < '2026-03-17 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-17 13:02:19] Production.INFO: count ==5770 [2026-03-17 13:02:22] Production.ERROR: pbx CDR StartTime 2026-03-17 10:02:05 - End Time 2026-03-17 13:02:05 [2026-03-17 13:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929226', 'tblTempUsageDetail_20' ) start [2026-03-17 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929226', 'tblTempUsageDetail_20' ) end [2026-03-17 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929226', 'tblTempVendorCDR_20' ) start [2026-03-17 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929226', 'tblTempVendorCDR_20' ) end [2026-03-17 13:02:23] Production.INFO: ProcessCDR(1,16929226,1,1,2) [2026-03-17 13:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16929226,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 13:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16929226,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 13:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16929226,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 13:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16929226,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 13:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929226', 'tblTempUsageDetail_20' ) start [2026-03-17 13:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929226', 'tblTempUsageDetail_20' ) end [2026-03-17 13:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-17 13:02:47] Production.ERROR: pbx prc_insertCDR end [2026-03-17 13:02:47] Production.INFO: ==27952== Releasing lock... [2026-03-17 13:02:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 13:02:47] Production.INFO: 71.5 MB #Memory Used# [2026-03-17 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 11:02:05 [end_date_ymd] => 2026-03-17 14:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 11:02:05' and `end` < '2026-03-17 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-17 14:02:23] Production.INFO: count ==5677 [2026-03-17 14:02:26] Production.ERROR: pbx CDR StartTime 2026-03-17 11:02:05 - End Time 2026-03-17 14:02:05 [2026-03-17 14:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 14:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929473', 'tblTempUsageDetail_20' ) start [2026-03-17 14:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929473', 'tblTempUsageDetail_20' ) end [2026-03-17 14:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929473', 'tblTempVendorCDR_20' ) start [2026-03-17 14:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929473', 'tblTempVendorCDR_20' ) end [2026-03-17 14:02:27] Production.INFO: ProcessCDR(1,16929473,1,1,2) [2026-03-17 14:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16929473,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 14:02:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16929473,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 14:02:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16929473,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 14:02:51] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16929473,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 14:02:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929473', 'tblTempUsageDetail_20' ) start [2026-03-17 14:02:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929473', 'tblTempUsageDetail_20' ) end [2026-03-17 14:02:51] Production.ERROR: pbx prc_insertCDR start [2026-03-17 14:02:54] Production.ERROR: pbx prc_insertCDR end [2026-03-17 14:02:54] Production.INFO: ==1328== Releasing lock... [2026-03-17 14:02:54] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 14:02:54] Production.INFO: 70.75 MB #Memory Used# [2026-03-17 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 12:02:05 [end_date_ymd] => 2026-03-17 15:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 12:02:05' and `end` < '2026-03-17 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-17 15:02:19] Production.INFO: count ==5703 [2026-03-17 15:02:22] Production.ERROR: pbx CDR StartTime 2026-03-17 12:02:05 - End Time 2026-03-17 15:02:05 [2026-03-17 15:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929720', 'tblTempUsageDetail_20' ) start [2026-03-17 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929720', 'tblTempUsageDetail_20' ) end [2026-03-17 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929720', 'tblTempVendorCDR_20' ) start [2026-03-17 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929720', 'tblTempVendorCDR_20' ) end [2026-03-17 15:02:23] Production.INFO: ProcessCDR(1,16929720,1,1,2) [2026-03-17 15:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16929720,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 15:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16929720,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 15:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16929720,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 15:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16929720,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 15:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929720', 'tblTempUsageDetail_20' ) start [2026-03-17 15:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929720', 'tblTempUsageDetail_20' ) end [2026-03-17 15:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-17 15:02:47] Production.ERROR: pbx prc_insertCDR end [2026-03-17 15:02:47] Production.INFO: ==6839== Releasing lock... [2026-03-17 15:02:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 15:02:47] Production.INFO: 71 MB #Memory Used# [2026-03-17 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 13:02:05 [end_date_ymd] => 2026-03-17 16:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 13:02:05' and `end` < '2026-03-17 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-17 16:02:20] Production.INFO: count ==5739 [2026-03-17 16:02:23] Production.ERROR: pbx CDR StartTime 2026-03-17 13:02:05 - End Time 2026-03-17 16:02:05 [2026-03-17 16:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 16:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929967', 'tblTempUsageDetail_20' ) start [2026-03-17 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16929967', 'tblTempUsageDetail_20' ) end [2026-03-17 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929967', 'tblTempVendorCDR_20' ) start [2026-03-17 16:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16929967', 'tblTempVendorCDR_20' ) end [2026-03-17 16:02:24] Production.INFO: ProcessCDR(1,16929967,1,1,2) [2026-03-17 16:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16929967,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 16:02:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16929967,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 16:02:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16929967,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 16:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16929967,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 16:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929967', 'tblTempUsageDetail_20' ) start [2026-03-17 16:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16929967', 'tblTempUsageDetail_20' ) end [2026-03-17 16:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-17 16:02:47] Production.ERROR: pbx prc_insertCDR end [2026-03-17 16:02:47] Production.INFO: ==12478== Releasing lock... [2026-03-17 16:02:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 16:02:47] Production.INFO: 71.25 MB #Memory Used# [2026-03-17 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 14:02:05 [end_date_ymd] => 2026-03-17 17:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 14:02:05' and `end` < '2026-03-17 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-17 17:02:19] Production.INFO: count ==5959 [2026-03-17 17:02:21] Production.ERROR: pbx CDR StartTime 2026-03-17 14:02:05 - End Time 2026-03-17 17:02:05 [2026-03-17 17:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 17:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930214', 'tblTempUsageDetail_20' ) start [2026-03-17 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930214', 'tblTempUsageDetail_20' ) end [2026-03-17 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930214', 'tblTempVendorCDR_20' ) start [2026-03-17 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930214', 'tblTempVendorCDR_20' ) end [2026-03-17 17:02:22] Production.INFO: ProcessCDR(1,16930214,1,1,2) [2026-03-17 17:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16930214,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 17:02:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16930214,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 17:02:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16930214,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 17:02:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16930214,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 17:02:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930214', 'tblTempUsageDetail_20' ) start [2026-03-17 17:02:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930214', 'tblTempUsageDetail_20' ) end [2026-03-17 17:02:46] Production.ERROR: pbx prc_insertCDR start [2026-03-17 17:02:50] Production.ERROR: pbx prc_insertCDR end [2026-03-17 17:02:50] Production.INFO: ==18144== Releasing lock... [2026-03-17 17:02:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 17:02:50] Production.INFO: 72.75 MB #Memory Used# [2026-03-17 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 15:02:06 [end_date_ymd] => 2026-03-17 18:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 15:02:06' and `end` < '2026-03-17 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-17 18:02:20] Production.INFO: count ==5187 [2026-03-17 18:02:22] Production.ERROR: pbx CDR StartTime 2026-03-17 15:02:06 - End Time 2026-03-17 18:02:06 [2026-03-17 18:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930461', 'tblTempUsageDetail_20' ) start [2026-03-17 18:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930461', 'tblTempUsageDetail_20' ) end [2026-03-17 18:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930461', 'tblTempVendorCDR_20' ) start [2026-03-17 18:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930461', 'tblTempVendorCDR_20' ) end [2026-03-17 18:02:23] Production.INFO: ProcessCDR(1,16930461,1,1,2) [2026-03-17 18:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16930461,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 18:02:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16930461,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 18:02:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16930461,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 18:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16930461,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 18:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930461', 'tblTempUsageDetail_20' ) start [2026-03-17 18:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930461', 'tblTempUsageDetail_20' ) end [2026-03-17 18:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-17 18:02:46] Production.ERROR: pbx prc_insertCDR end [2026-03-17 18:02:46] Production.INFO: ==23803== Releasing lock... [2026-03-17 18:02:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 18:02:46] Production.INFO: 67 MB #Memory Used# [2026-03-17 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 16:02:05 [end_date_ymd] => 2026-03-17 19:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 16:02:05' and `end` < '2026-03-17 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-17 19:02:17] Production.INFO: count ==4035 [2026-03-17 19:02:19] Production.ERROR: pbx CDR StartTime 2026-03-17 16:02:05 - End Time 2026-03-17 19:02:05 [2026-03-17 19:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930707', 'tblTempUsageDetail_20' ) start [2026-03-17 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930707', 'tblTempUsageDetail_20' ) end [2026-03-17 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930707', 'tblTempVendorCDR_20' ) start [2026-03-17 19:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930707', 'tblTempVendorCDR_20' ) end [2026-03-17 19:02:19] Production.INFO: ProcessCDR(1,16930707,1,1,2) [2026-03-17 19:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16930707,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 19:02:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16930707,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 19:02:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16930707,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 19:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16930707,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 19:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930707', 'tblTempUsageDetail_20' ) start [2026-03-17 19:02:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930707', 'tblTempUsageDetail_20' ) end [2026-03-17 19:02:40] Production.ERROR: pbx prc_insertCDR start [2026-03-17 19:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-17 19:02:40] Production.INFO: ==29742== Releasing lock... [2026-03-17 19:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 19:02:40] Production.INFO: 58.25 MB #Memory Used# [2026-03-17 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 17:02:05 [end_date_ymd] => 2026-03-17 20:02:05 [RateCDR] => 1 ) [2026-03-17 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-17 17:02:05' and `end` < '2026-03-17 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-17 20:02:17] Production.INFO: count ==2621 [2026-03-17 20:02:18] Production.ERROR: pbx CDR StartTime 2026-03-17 17:02:05 - End Time 2026-03-17 20:02:05 [2026-03-17 20:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930954', 'tblTempUsageDetail_20' ) start [2026-03-17 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16930954', 'tblTempUsageDetail_20' ) end [2026-03-17 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930954', 'tblTempVendorCDR_20' ) start [2026-03-17 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16930954', 'tblTempVendorCDR_20' ) end [2026-03-17 20:02:18] Production.INFO: ProcessCDR(1,16930954,1,1,2) [2026-03-17 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16930954,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 20:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16930954,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 20:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16930954,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 20:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16930954,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 20:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930954', 'tblTempUsageDetail_20' ) start [2026-03-17 20:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16930954', 'tblTempUsageDetail_20' ) end [2026-03-17 20:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-17 20:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-17 20:02:40] Production.INFO: ==3117== Releasing lock... [2026-03-17 20:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 20:02:40] Production.INFO: 47.75 MB #Memory Used# [2026-03-17 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 18:02:06 [end_date_ymd] => 2026-03-17 21:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 18:02:06' and `end` < '2026-03-17 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-17 21:02:17] Production.INFO: count ==1898 [2026-03-17 21:02:18] Production.ERROR: pbx CDR StartTime 2026-03-17 18:02:06 - End Time 2026-03-17 21:02:06 [2026-03-17 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931201', 'tblTempUsageDetail_20' ) start [2026-03-17 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931201', 'tblTempUsageDetail_20' ) end [2026-03-17 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931201', 'tblTempVendorCDR_20' ) start [2026-03-17 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931201', 'tblTempVendorCDR_20' ) end [2026-03-17 21:02:18] Production.INFO: ProcessCDR(1,16931201,1,1,2) [2026-03-17 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16931201,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 21:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16931201,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 21:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16931201,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 21:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16931201,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 21:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931201', 'tblTempUsageDetail_20' ) start [2026-03-17 21:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931201', 'tblTempUsageDetail_20' ) end [2026-03-17 21:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-17 21:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-17 21:02:39] Production.INFO: ==9154== Releasing lock... [2026-03-17 21:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 21:02:39] Production.INFO: 42.25 MB #Memory Used# [2026-03-17 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 19:02:06 [end_date_ymd] => 2026-03-17 22:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 19:02:06' and `end` < '2026-03-17 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-17 22:02:17] Production.INFO: count ==1315 [2026-03-17 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 19:02:06 - End Time 2026-03-17 22:02:06 [2026-03-17 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931448', 'tblTempUsageDetail_20' ) start [2026-03-17 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931448', 'tblTempUsageDetail_20' ) end [2026-03-17 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931448', 'tblTempVendorCDR_20' ) start [2026-03-17 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931448', 'tblTempVendorCDR_20' ) end [2026-03-17 22:02:18] Production.INFO: ProcessCDR(1,16931448,1,1,2) [2026-03-17 22:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16931448,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 22:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16931448,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 22:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16931448,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 22:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16931448,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931448', 'tblTempUsageDetail_20' ) start [2026-03-17 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931448', 'tblTempUsageDetail_20' ) end [2026-03-17 22:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-17 22:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-17 22:02:38] Production.INFO: ==14369== Releasing lock... [2026-03-17 22:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 22:02:38] Production.INFO: 38.25 MB #Memory Used# [2026-03-17 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-17 20:02:06 [end_date_ymd] => 2026-03-17 23:02:06 [RateCDR] => 1 ) [2026-03-17 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-17 20:02:06' and `end` < '2026-03-17 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-17 23:02:17] Production.INFO: count ==930 [2026-03-17 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-17 20:02:06 - End Time 2026-03-17 23:02:06 [2026-03-17 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-17 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931695', 'tblTempUsageDetail_20' ) start [2026-03-17 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16931695', 'tblTempUsageDetail_20' ) end [2026-03-17 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931695', 'tblTempVendorCDR_20' ) start [2026-03-17 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16931695', 'tblTempVendorCDR_20' ) end [2026-03-17 23:02:17] Production.INFO: ProcessCDR(1,16931695,1,1,2) [2026-03-17 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16931695,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 23:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16931695,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-17 23:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16931695,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 23:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16931695,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-17 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931695', 'tblTempUsageDetail_20' ) start [2026-03-17 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16931695', 'tblTempUsageDetail_20' ) end [2026-03-17 23:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-17 23:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-17 23:02:37] Production.INFO: ==18835== Releasing lock... [2026-03-17 23:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-17 23:02:37] Production.INFO: 35 MB #Memory Used#