[2026-03-27 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-26 21:02:06 [end_date_ymd] => 2026-03-27 00:02:06 [RateCDR] => 1 ) [2026-03-27 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-26 21:02:06' and `end` < '2026-03-27 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-27 00:02:29] Production.INFO: count ==752 [2026-03-27 00:02:30] Production.ERROR: pbx CDR StartTime 2026-03-26 21:02:06 - End Time 2026-03-27 00:02:06 [2026-03-27 00:02:30] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985297', 'tblTempUsageDetail_20' ) start [2026-03-27 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985297', 'tblTempUsageDetail_20' ) end [2026-03-27 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985297', 'tblTempVendorCDR_20' ) start [2026-03-27 00:02:30] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985297', 'tblTempVendorCDR_20' ) end [2026-03-27 00:02:30] Production.INFO: ProcessCDR(1,16985297,1,1,2) [2026-03-27 00:02:30] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16985297,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 00:02:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16985297,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 00:02:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16985297,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 00:02:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16985297,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 00:02:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985297', 'tblTempUsageDetail_20' ) start [2026-03-27 00:02:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985297', 'tblTempUsageDetail_20' ) end [2026-03-27 00:02:50] Production.ERROR: pbx prc_insertCDR start [2026-03-27 00:02:50] Production.ERROR: pbx prc_insertCDR end [2026-03-27 00:02:52] Production.INFO: ==31104== Releasing lock... [2026-03-27 00:02:52] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 00:02:52] Production.INFO: 38.25 MB #Memory Used# [2026-03-27 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-26 22:02:05 [end_date_ymd] => 2026-03-27 01:02:05 [RateCDR] => 1 ) [2026-03-27 01:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-26 22:02:05' and `end` < '2026-03-27 01:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 01:02:16] Production.INFO: count ==779 [2026-03-27 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-26 22:02:05 - End Time 2026-03-27 01:02:05 [2026-03-27 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985544', 'tblTempUsageDetail_20' ) start [2026-03-27 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985544', 'tblTempUsageDetail_20' ) end [2026-03-27 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985544', 'tblTempVendorCDR_20' ) start [2026-03-27 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985544', 'tblTempVendorCDR_20' ) end [2026-03-27 01:02:17] Production.INFO: ProcessCDR(1,16985544,1,1,2) [2026-03-27 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16985544,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 01:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16985544,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 01:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16985544,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 01:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16985544,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 01:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985544', 'tblTempUsageDetail_20' ) start [2026-03-27 01:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985544', 'tblTempUsageDetail_20' ) end [2026-03-27 01:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-27 01:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-27 01:02:37] Production.INFO: ==3242== Releasing lock... [2026-03-27 01:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 01:02:37] Production.INFO: 34.5 MB #Memory Used# [2026-03-27 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-26 23:02:06 [end_date_ymd] => 2026-03-27 02:02:06 [RateCDR] => 1 ) [2026-03-27 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-26 23:02:06' and `end` < '2026-03-27 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-27 02:02:25] Production.INFO: count ==747 [2026-03-27 02:02:26] Production.ERROR: pbx CDR StartTime 2026-03-26 23:02:06 - End Time 2026-03-27 02:02:06 [2026-03-27 02:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 02:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985791', 'tblTempUsageDetail_20' ) start [2026-03-27 02:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16985791', 'tblTempUsageDetail_20' ) end [2026-03-27 02:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985791', 'tblTempVendorCDR_20' ) start [2026-03-27 02:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16985791', 'tblTempVendorCDR_20' ) end [2026-03-27 02:02:26] Production.INFO: ProcessCDR(1,16985791,1,1,2) [2026-03-27 02:02:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16985791,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 02:02:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16985791,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 02:02:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16985791,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 02:02:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16985791,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 02:02:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985791', 'tblTempUsageDetail_20' ) start [2026-03-27 02:02:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16985791', 'tblTempUsageDetail_20' ) end [2026-03-27 02:02:46] Production.ERROR: pbx prc_insertCDR start [2026-03-27 02:02:46] Production.ERROR: pbx prc_insertCDR end [2026-03-27 02:02:46] Production.INFO: ==7901== Releasing lock... [2026-03-27 02:02:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 02:02:46] Production.INFO: 34 MB #Memory Used# [2026-03-27 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 00:02:05 [end_date_ymd] => 2026-03-27 03:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 00:02:05' and `end` < '2026-03-27 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-27 03:02:16] Production.INFO: count ==804 [2026-03-27 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 00:02:05 - End Time 2026-03-27 03:02:05 [2026-03-27 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986038', 'tblTempUsageDetail_20' ) start [2026-03-27 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986038', 'tblTempUsageDetail_20' ) end [2026-03-27 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986038', 'tblTempVendorCDR_20' ) start [2026-03-27 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986038', 'tblTempVendorCDR_20' ) end [2026-03-27 03:02:17] Production.INFO: ProcessCDR(1,16986038,1,1,2) [2026-03-27 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16986038,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 03:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16986038,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 03:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16986038,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 03:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16986038,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 03:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986038', 'tblTempUsageDetail_20' ) start [2026-03-27 03:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986038', 'tblTempUsageDetail_20' ) end [2026-03-27 03:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-27 03:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 03:02:38] Production.INFO: ==12445== Releasing lock... [2026-03-27 03:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 03:02:38] Production.INFO: 34.25 MB #Memory Used# [2026-03-27 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 01:02:05 [end_date_ymd] => 2026-03-27 04:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 01:02:05' and `end` < '2026-03-27 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-27 04:02:16] Production.INFO: count ==629 [2026-03-27 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 01:02:05 - End Time 2026-03-27 04:02:05 [2026-03-27 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986286', 'tblTempUsageDetail_20' ) start [2026-03-27 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986286', 'tblTempUsageDetail_20' ) end [2026-03-27 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986286', 'tblTempVendorCDR_20' ) start [2026-03-27 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986286', 'tblTempVendorCDR_20' ) end [2026-03-27 04:02:17] Production.INFO: ProcessCDR(1,16986286,1,1,2) [2026-03-27 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16986286,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 04:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16986286,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 04:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16986286,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 04:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16986286,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986286', 'tblTempUsageDetail_20' ) start [2026-03-27 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986286', 'tblTempUsageDetail_20' ) end [2026-03-27 04:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-27 04:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-27 04:02:36] Production.INFO: ==17127== Releasing lock... [2026-03-27 04:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 04:02:36] Production.INFO: 33.5 MB #Memory Used# [2026-03-27 05:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 02:02:06 [end_date_ymd] => 2026-03-27 05:02:06 [RateCDR] => 1 ) [2026-03-27 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-27 02:02:06' and `end` < '2026-03-27 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-27 05:02:17] Production.INFO: count ==402 [2026-03-27 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 02:02:06 - End Time 2026-03-27 05:02:06 [2026-03-27 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986534', 'tblTempUsageDetail_20' ) start [2026-03-27 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986534', 'tblTempUsageDetail_20' ) end [2026-03-27 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986534', 'tblTempVendorCDR_20' ) start [2026-03-27 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986534', 'tblTempVendorCDR_20' ) end [2026-03-27 05:02:17] Production.INFO: ProcessCDR(1,16986534,1,1,2) [2026-03-27 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16986534,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 05:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16986534,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 05:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16986534,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 05:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16986534,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 05:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986534', 'tblTempUsageDetail_20' ) start [2026-03-27 05:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986534', 'tblTempUsageDetail_20' ) end [2026-03-27 05:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-27 05:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-27 05:02:37] Production.INFO: ==21861== Releasing lock... [2026-03-27 05:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 05:02:37] Production.INFO: 32 MB #Memory Used# [2026-03-27 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 03:02:06 [end_date_ymd] => 2026-03-27 06:02:06 [RateCDR] => 1 ) [2026-03-27 06:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 03:02:06' and `end` < '2026-03-27 06:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 06:02:17] Production.INFO: count ==129 [2026-03-27 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 03:02:06 - End Time 2026-03-27 06:02:06 [2026-03-27 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986781', 'tblTempUsageDetail_20' ) start [2026-03-27 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16986781', 'tblTempUsageDetail_20' ) end [2026-03-27 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986781', 'tblTempVendorCDR_20' ) start [2026-03-27 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16986781', 'tblTempVendorCDR_20' ) end [2026-03-27 06:02:17] Production.INFO: ProcessCDR(1,16986781,1,1,2) [2026-03-27 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16986781,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 06:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16986781,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 06:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16986781,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 06:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16986781,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 06:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986781', 'tblTempUsageDetail_20' ) start [2026-03-27 06:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16986781', 'tblTempUsageDetail_20' ) end [2026-03-27 06:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-27 06:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 06:02:38] Production.INFO: ==26479== Releasing lock... [2026-03-27 06:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 06:02:38] Production.INFO: 29.5 MB #Memory Used# [2026-03-27 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 04:02:06 [end_date_ymd] => 2026-03-27 07:02:06 [RateCDR] => 1 ) [2026-03-27 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-27 04:02:06' and `end` < '2026-03-27 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-27 07:02:17] Production.INFO: count ==55 [2026-03-27 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 04:02:06 - End Time 2026-03-27 07:02:06 [2026-03-27 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987028', 'tblTempUsageDetail_20' ) start [2026-03-27 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987028', 'tblTempUsageDetail_20' ) end [2026-03-27 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987028', 'tblTempVendorCDR_20' ) start [2026-03-27 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987028', 'tblTempVendorCDR_20' ) end [2026-03-27 07:02:17] Production.INFO: ProcessCDR(1,16987028,1,1,2) [2026-03-27 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16987028,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 07:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16987028,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 07:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16987028,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 07:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16987028,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 07:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987028', 'tblTempUsageDetail_20' ) start [2026-03-27 07:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987028', 'tblTempUsageDetail_20' ) end [2026-03-27 07:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-27 07:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 07:02:38] Production.INFO: ==30998== Releasing lock... [2026-03-27 07:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 07:02:38] Production.INFO: 28.25 MB #Memory Used# [2026-03-27 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 05:02:06 [end_date_ymd] => 2026-03-27 08:02:06 [RateCDR] => 1 ) [2026-03-27 08:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 05:02:06' and `end` < '2026-03-27 08:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 08:02:17] Production.INFO: count ==148 [2026-03-27 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 05:02:06 - End Time 2026-03-27 08:02:06 [2026-03-27 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987275', 'tblTempUsageDetail_20' ) start [2026-03-27 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987275', 'tblTempUsageDetail_20' ) end [2026-03-27 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987275', 'tblTempVendorCDR_20' ) start [2026-03-27 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987275', 'tblTempVendorCDR_20' ) end [2026-03-27 08:02:17] Production.INFO: ProcessCDR(1,16987275,1,1,2) [2026-03-27 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16987275,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 08:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16987275,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 08:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16987275,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 08:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16987275,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 08:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987275', 'tblTempUsageDetail_20' ) start [2026-03-27 08:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987275', 'tblTempUsageDetail_20' ) end [2026-03-27 08:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-27 08:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 08:02:38] Production.INFO: ==3174== Releasing lock... [2026-03-27 08:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 08:02:38] Production.INFO: 29.75 MB #Memory Used# [2026-03-27 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 06:02:05 [end_date_ymd] => 2026-03-27 09:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 06:02:05' and `end` < '2026-03-27 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-27 09:02:17] Production.INFO: count ==714 [2026-03-27 09:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 06:02:05 - End Time 2026-03-27 09:02:05 [2026-03-27 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987522', 'tblTempUsageDetail_20' ) start [2026-03-27 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987522', 'tblTempUsageDetail_20' ) end [2026-03-27 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987522', 'tblTempVendorCDR_20' ) start [2026-03-27 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987522', 'tblTempVendorCDR_20' ) end [2026-03-27 09:02:17] Production.INFO: ProcessCDR(1,16987522,1,1,2) [2026-03-27 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16987522,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 09:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16987522,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 09:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16987522,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 09:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16987522,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 09:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987522', 'tblTempUsageDetail_20' ) start [2026-03-27 09:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987522', 'tblTempUsageDetail_20' ) end [2026-03-27 09:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-27 09:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 09:02:38] Production.INFO: ==7579== Releasing lock... [2026-03-27 09:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 09:02:38] Production.INFO: 34.5 MB #Memory Used# [2026-03-27 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 07:02:05 [end_date_ymd] => 2026-03-27 10:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 07:02:05' and `end` < '2026-03-27 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-27 10:02:17] Production.INFO: count ==1835 [2026-03-27 10:02:18] Production.ERROR: pbx CDR StartTime 2026-03-27 07:02:05 - End Time 2026-03-27 10:02:05 [2026-03-27 10:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987769', 'tblTempUsageDetail_20' ) start [2026-03-27 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16987769', 'tblTempUsageDetail_20' ) end [2026-03-27 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987769', 'tblTempVendorCDR_20' ) start [2026-03-27 10:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16987769', 'tblTempVendorCDR_20' ) end [2026-03-27 10:02:18] Production.INFO: ProcessCDR(1,16987769,1,1,2) [2026-03-27 10:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16987769,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 10:02:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16987769,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 10:02:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16987769,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 10:02:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16987769,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 10:02:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987769', 'tblTempUsageDetail_20' ) start [2026-03-27 10:02:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16987769', 'tblTempUsageDetail_20' ) end [2026-03-27 10:02:41] Production.ERROR: pbx prc_insertCDR start [2026-03-27 10:02:43] Production.ERROR: pbx prc_insertCDR end [2026-03-27 10:02:43] Production.INFO: ==12275== Releasing lock... [2026-03-27 10:02:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 10:02:43] Production.INFO: 42.5 MB #Memory Used# [2026-03-27 11:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 08:02:06 [end_date_ymd] => 2026-03-27 11:02:06 [RateCDR] => 1 ) [2026-03-27 11:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 08:02:06' and `end` < '2026-03-27 11:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 11:02:22] Production.INFO: count ==3148 [2026-03-27 11:02:24] Production.ERROR: pbx CDR StartTime 2026-03-27 08:02:06 - End Time 2026-03-27 11:02:06 [2026-03-27 11:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 11:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988016', 'tblTempUsageDetail_20' ) start [2026-03-27 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988016', 'tblTempUsageDetail_20' ) end [2026-03-27 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988016', 'tblTempVendorCDR_20' ) start [2026-03-27 11:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988016', 'tblTempVendorCDR_20' ) end [2026-03-27 11:02:25] Production.INFO: ProcessCDR(1,16988016,1,1,2) [2026-03-27 11:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16988016,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 11:02:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16988016,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 11:02:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16988016,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 11:02:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16988016,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 11:02:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988016', 'tblTempUsageDetail_20' ) start [2026-03-27 11:02:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988016', 'tblTempUsageDetail_20' ) end [2026-03-27 11:02:47] Production.ERROR: pbx prc_insertCDR start [2026-03-27 11:02:49] Production.ERROR: pbx prc_insertCDR end [2026-03-27 11:02:49] Production.INFO: ==16759== Releasing lock... [2026-03-27 11:02:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 11:02:49] Production.INFO: 52.25 MB #Memory Used# [2026-03-27 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 09:02:05 [end_date_ymd] => 2026-03-27 12:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 09:02:05' and `end` < '2026-03-27 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-27 12:02:18] Production.INFO: count ==4195 [2026-03-27 12:02:21] Production.ERROR: pbx CDR StartTime 2026-03-27 09:02:05 - End Time 2026-03-27 12:02:05 [2026-03-27 12:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988263', 'tblTempUsageDetail_20' ) start [2026-03-27 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988263', 'tblTempUsageDetail_20' ) end [2026-03-27 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988263', 'tblTempVendorCDR_20' ) start [2026-03-27 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988263', 'tblTempVendorCDR_20' ) end [2026-03-27 12:02:21] Production.INFO: ProcessCDR(1,16988263,1,1,2) [2026-03-27 12:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16988263,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 12:02:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16988263,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 12:02:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16988263,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 12:07:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16988263,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 12:07:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988263', 'tblTempUsageDetail_20' ) start [2026-03-27 12:07:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988263', 'tblTempUsageDetail_20' ) end [2026-03-27 12:07:16] Production.ERROR: pbx prc_insertCDR start [2026-03-27 12:07:19] Production.ERROR: pbx prc_insertCDR end [2026-03-27 12:07:19] Production.INFO: ==21143== Releasing lock... [2026-03-27 12:07:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 12:07:19] Production.INFO: 59.75 MB #Memory Used# [2026-03-27 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 10:02:06 [end_date_ymd] => 2026-03-27 13:02:06 [RateCDR] => 1 ) [2026-03-27 13:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 10:02:06' and `end` < '2026-03-27 13:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 13:02:18] Production.INFO: count ==4509 [2026-03-27 13:02:21] Production.ERROR: pbx CDR StartTime 2026-03-27 10:02:06 - End Time 2026-03-27 13:02:06 [2026-03-27 13:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988510', 'tblTempUsageDetail_20' ) start [2026-03-27 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988510', 'tblTempUsageDetail_20' ) end [2026-03-27 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988510', 'tblTempVendorCDR_20' ) start [2026-03-27 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988510', 'tblTempVendorCDR_20' ) end [2026-03-27 13:02:22] Production.INFO: ProcessCDR(1,16988510,1,1,2) [2026-03-27 13:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16988510,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 13:06:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16988510,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 13:06:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16988510,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 13:11:16] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16988510,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 13:11:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988510', 'tblTempUsageDetail_20' ) start [2026-03-27 13:11:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988510', 'tblTempUsageDetail_20' ) end [2026-03-27 13:11:17] Production.ERROR: pbx prc_insertCDR start [2026-03-27 13:11:20] Production.ERROR: pbx prc_insertCDR end [2026-03-27 13:11:20] Production.INFO: ==25486== Releasing lock... [2026-03-27 13:11:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 13:11:20] Production.INFO: 62 MB #Memory Used# [2026-03-27 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 11:02:05 [end_date_ymd] => 2026-03-27 14:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 11:02:05' and `end` < '2026-03-27 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-27 14:02:18] Production.INFO: count ==4475 [2026-03-27 14:02:20] Production.ERROR: pbx CDR StartTime 2026-03-27 11:02:05 - End Time 2026-03-27 14:02:05 [2026-03-27 14:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 14:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988757', 'tblTempUsageDetail_20' ) start [2026-03-27 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16988757', 'tblTempUsageDetail_20' ) end [2026-03-27 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988757', 'tblTempVendorCDR_20' ) start [2026-03-27 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16988757', 'tblTempVendorCDR_20' ) end [2026-03-27 14:02:21] Production.INFO: ProcessCDR(1,16988757,1,1,2) [2026-03-27 14:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16988757,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 14:06:14] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16988757,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 14:06:14] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16988757,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 14:10:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16988757,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 14:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988757', 'tblTempUsageDetail_20' ) start [2026-03-27 14:10:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16988757', 'tblTempUsageDetail_20' ) end [2026-03-27 14:10:46] Production.ERROR: pbx prc_insertCDR start [2026-03-27 14:10:48] Production.ERROR: pbx prc_insertCDR end [2026-03-27 14:10:48] Production.INFO: ==30057== Releasing lock... [2026-03-27 14:10:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 14:10:48] Production.INFO: 61.75 MB #Memory Used# [2026-03-27 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 12:02:05 [end_date_ymd] => 2026-03-27 15:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 12:02:05' and `end` < '2026-03-27 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-27 15:02:21] Production.INFO: count ==4713 [2026-03-27 15:02:24] Production.ERROR: pbx CDR StartTime 2026-03-27 12:02:05 - End Time 2026-03-27 15:02:05 [2026-03-27 15:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 15:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989004', 'tblTempUsageDetail_20' ) start [2026-03-27 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989004', 'tblTempUsageDetail_20' ) end [2026-03-27 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989004', 'tblTempVendorCDR_20' ) start [2026-03-27 15:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989004', 'tblTempVendorCDR_20' ) end [2026-03-27 15:02:25] Production.INFO: ProcessCDR(1,16989004,1,1,2) [2026-03-27 15:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16989004,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 15:06:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16989004,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 15:06:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16989004,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 15:11:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16989004,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 15:11:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989004', 'tblTempUsageDetail_20' ) start [2026-03-27 15:11:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989004', 'tblTempUsageDetail_20' ) end [2026-03-27 15:11:35] Production.ERROR: pbx prc_insertCDR start [2026-03-27 15:11:38] Production.ERROR: pbx prc_insertCDR end [2026-03-27 15:11:38] Production.INFO: ==2273== Releasing lock... [2026-03-27 15:11:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 15:11:38] Production.INFO: 63.5 MB #Memory Used# [2026-03-27 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 13:02:05 [end_date_ymd] => 2026-03-27 16:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 13:02:05' and `end` < '2026-03-27 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-27 16:02:18] Production.INFO: count ==5106 [2026-03-27 16:02:21] Production.ERROR: pbx CDR StartTime 2026-03-27 13:02:05 - End Time 2026-03-27 16:02:05 [2026-03-27 16:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989251', 'tblTempUsageDetail_20' ) start [2026-03-27 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989251', 'tblTempUsageDetail_20' ) end [2026-03-27 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989251', 'tblTempVendorCDR_20' ) start [2026-03-27 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989251', 'tblTempVendorCDR_20' ) end [2026-03-27 16:02:22] Production.INFO: ProcessCDR(1,16989251,1,1,2) [2026-03-27 16:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16989251,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 16:06:17] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16989251,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 16:06:17] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16989251,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 16:10:55] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16989251,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 16:10:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989251', 'tblTempUsageDetail_20' ) start [2026-03-27 16:10:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989251', 'tblTempUsageDetail_20' ) end [2026-03-27 16:10:55] Production.ERROR: pbx prc_insertCDR start [2026-03-27 16:10:58] Production.ERROR: pbx prc_insertCDR end [2026-03-27 16:10:58] Production.INFO: ==6779== Releasing lock... [2026-03-27 16:10:58] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 16:10:58] Production.INFO: 66.5 MB #Memory Used# [2026-03-27 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 14:02:05 [end_date_ymd] => 2026-03-27 17:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 14:02:05' and `end` < '2026-03-27 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-27 17:02:19] Production.INFO: count ==5632 [2026-03-27 17:02:23] Production.ERROR: pbx CDR StartTime 2026-03-27 14:02:05 - End Time 2026-03-27 17:02:05 [2026-03-27 17:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989498', 'tblTempUsageDetail_20' ) start [2026-03-27 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989498', 'tblTempUsageDetail_20' ) end [2026-03-27 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989498', 'tblTempVendorCDR_20' ) start [2026-03-27 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989498', 'tblTempVendorCDR_20' ) end [2026-03-27 17:02:23] Production.INFO: ProcessCDR(1,16989498,1,1,2) [2026-03-27 17:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16989498,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 17:06:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16989498,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 17:06:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16989498,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 17:10:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16989498,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 17:10:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989498', 'tblTempUsageDetail_20' ) start [2026-03-27 17:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989498', 'tblTempUsageDetail_20' ) end [2026-03-27 17:10:57] Production.ERROR: pbx prc_insertCDR start [2026-03-27 17:11:00] Production.ERROR: pbx prc_insertCDR end [2026-03-27 17:11:00] Production.INFO: ==12000== Releasing lock... [2026-03-27 17:11:00] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 17:11:00] Production.INFO: 70.75 MB #Memory Used# [2026-03-27 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 15:02:05 [end_date_ymd] => 2026-03-27 18:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 15:02:05' and `end` < '2026-03-27 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-27 18:02:17] Production.INFO: count ==4764 [2026-03-27 18:02:20] Production.ERROR: pbx CDR StartTime 2026-03-27 15:02:05 - End Time 2026-03-27 18:02:05 [2026-03-27 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989745', 'tblTempUsageDetail_20' ) start [2026-03-27 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989745', 'tblTempUsageDetail_20' ) end [2026-03-27 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989745', 'tblTempVendorCDR_20' ) start [2026-03-27 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989745', 'tblTempVendorCDR_20' ) end [2026-03-27 18:02:20] Production.INFO: ProcessCDR(1,16989745,1,1,2) [2026-03-27 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16989745,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 18:06:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16989745,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 18:06:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16989745,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 18:10:56] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16989745,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 18:10:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989745', 'tblTempUsageDetail_20' ) start [2026-03-27 18:10:56] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989745', 'tblTempUsageDetail_20' ) end [2026-03-27 18:10:56] Production.ERROR: pbx prc_insertCDR start [2026-03-27 18:10:58] Production.ERROR: pbx prc_insertCDR end [2026-03-27 18:10:58] Production.INFO: ==17435== Releasing lock... [2026-03-27 18:10:58] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 18:10:58] Production.INFO: 64.25 MB #Memory Used# [2026-03-27 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 16:02:06 [end_date_ymd] => 2026-03-27 19:02:06 [RateCDR] => 1 ) [2026-03-27 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-27 16:02:06' and `end` < '2026-03-27 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-27 19:02:18] Production.INFO: count ==3669 [2026-03-27 19:02:20] Production.ERROR: pbx CDR StartTime 2026-03-27 16:02:06 - End Time 2026-03-27 19:02:06 [2026-03-27 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989992', 'tblTempUsageDetail_20' ) start [2026-03-27 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16989992', 'tblTempUsageDetail_20' ) end [2026-03-27 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989992', 'tblTempVendorCDR_20' ) start [2026-03-27 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16989992', 'tblTempVendorCDR_20' ) end [2026-03-27 19:02:20] Production.INFO: ProcessCDR(1,16989992,1,1,2) [2026-03-27 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16989992,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 19:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16989992,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 19:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16989992,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 19:10:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16989992,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 19:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989992', 'tblTempUsageDetail_20' ) start [2026-03-27 19:10:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16989992', 'tblTempUsageDetail_20' ) end [2026-03-27 19:10:39] Production.ERROR: pbx prc_insertCDR start [2026-03-27 19:10:40] Production.ERROR: pbx prc_insertCDR end [2026-03-27 19:10:40] Production.INFO: ==22122== Releasing lock... [2026-03-27 19:10:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 19:10:40] Production.INFO: 56.75 MB #Memory Used# [2026-03-27 20:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 17:02:06 [end_date_ymd] => 2026-03-27 20:02:06 [RateCDR] => 1 ) [2026-03-27 20:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 17:02:06' and `end` < '2026-03-27 20:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 20:02:19] Production.INFO: count ==2440 [2026-03-27 20:02:20] Production.ERROR: pbx CDR StartTime 2026-03-27 17:02:06 - End Time 2026-03-27 20:02:06 [2026-03-27 20:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 20:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990239', 'tblTempUsageDetail_20' ) start [2026-03-27 20:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990239', 'tblTempUsageDetail_20' ) end [2026-03-27 20:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990239', 'tblTempVendorCDR_20' ) start [2026-03-27 20:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990239', 'tblTempVendorCDR_20' ) end [2026-03-27 20:02:20] Production.INFO: ProcessCDR(1,16990239,1,1,2) [2026-03-27 20:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16990239,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 20:06:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16990239,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 20:06:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16990239,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 20:10:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16990239,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 20:10:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990239', 'tblTempUsageDetail_20' ) start [2026-03-27 20:10:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990239', 'tblTempUsageDetail_20' ) end [2026-03-27 20:10:47] Production.ERROR: pbx prc_insertCDR start [2026-03-27 20:10:47] Production.ERROR: pbx prc_insertCDR end [2026-03-27 20:10:47] Production.INFO: ==26740== Releasing lock... [2026-03-27 20:10:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 20:10:47] Production.INFO: 47.5 MB #Memory Used# [2026-03-27 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 18:02:05 [end_date_ymd] => 2026-03-27 21:02:05 [RateCDR] => 1 ) [2026-03-27 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-27 18:02:05' and `end` < '2026-03-27 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-27 21:02:16] Production.INFO: count ==1888 [2026-03-27 21:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 18:02:05 - End Time 2026-03-27 21:02:05 [2026-03-27 21:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990486', 'tblTempUsageDetail_20' ) start [2026-03-27 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990486', 'tblTempUsageDetail_20' ) end [2026-03-27 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990486', 'tblTempVendorCDR_20' ) start [2026-03-27 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990486', 'tblTempVendorCDR_20' ) end [2026-03-27 21:02:17] Production.INFO: ProcessCDR(1,16990486,1,1,2) [2026-03-27 21:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16990486,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 21:06:08] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16990486,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 21:06:08] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16990486,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 21:10:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16990486,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 21:10:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990486', 'tblTempUsageDetail_20' ) start [2026-03-27 21:10:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990486', 'tblTempUsageDetail_20' ) end [2026-03-27 21:10:51] Production.ERROR: pbx prc_insertCDR start [2026-03-27 21:10:51] Production.ERROR: pbx prc_insertCDR end [2026-03-27 21:10:51] Production.INFO: ==31299== Releasing lock... [2026-03-27 21:10:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 21:10:51] Production.INFO: 42.75 MB #Memory Used# [2026-03-27 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 19:02:05 [end_date_ymd] => 2026-03-27 22:02:05 [RateCDR] => 1 ) [2026-03-27 22:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 19:02:05' and `end` < '2026-03-27 22:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-27 22:02:17] Production.INFO: count ==1533 [2026-03-27 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 19:02:05 - End Time 2026-03-27 22:02:05 [2026-03-27 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990733', 'tblTempUsageDetail_20' ) start [2026-03-27 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990733', 'tblTempUsageDetail_20' ) end [2026-03-27 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990733', 'tblTempVendorCDR_20' ) start [2026-03-27 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990733', 'tblTempVendorCDR_20' ) end [2026-03-27 22:02:17] Production.INFO: ProcessCDR(1,16990733,1,1,2) [2026-03-27 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16990733,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 22:06:19] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16990733,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 22:06:19] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16990733,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 22:11:09] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16990733,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 22:11:09] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990733', 'tblTempUsageDetail_20' ) start [2026-03-27 22:11:10] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990733', 'tblTempUsageDetail_20' ) end [2026-03-27 22:11:10] Production.ERROR: pbx prc_insertCDR start [2026-03-27 22:11:11] Production.ERROR: pbx prc_insertCDR end [2026-03-27 22:11:11] Production.INFO: ==3387== Releasing lock... [2026-03-27 22:11:11] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 22:11:11] Production.INFO: 39.75 MB #Memory Used# [2026-03-27 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 20:02:06 [end_date_ymd] => 2026-03-27 23:02:06 [RateCDR] => 1 ) [2026-03-27 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-27 20:02:06' and `end` < '2026-03-27 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-27 23:02:18] Production.INFO: count ==1310 [2026-03-27 23:02:18] Production.ERROR: pbx CDR StartTime 2026-03-27 20:02:06 - End Time 2026-03-27 23:02:06 [2026-03-27 23:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-27 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990980', 'tblTempUsageDetail_20' ) start [2026-03-27 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16990980', 'tblTempUsageDetail_20' ) end [2026-03-27 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990980', 'tblTempVendorCDR_20' ) start [2026-03-27 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16990980', 'tblTempVendorCDR_20' ) end [2026-03-27 23:02:18] Production.INFO: ProcessCDR(1,16990980,1,1,2) [2026-03-27 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16990980,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 23:06:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16990980,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-27 23:06:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16990980,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 23:11:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16990980,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-27 23:11:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990980', 'tblTempUsageDetail_20' ) start [2026-03-27 23:11:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16990980', 'tblTempUsageDetail_20' ) end [2026-03-27 23:11:20] Production.ERROR: pbx prc_insertCDR start [2026-03-27 23:11:21] Production.ERROR: pbx prc_insertCDR end [2026-03-27 23:11:21] Production.INFO: ==8107== Releasing lock... [2026-03-27 23:11:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-27 23:11:21] Production.INFO: 38.25 MB #Memory Used#