[2025-07-22 00:25:04] Production.INFO: next invoice date [2025-07-22 00:25:04] Production.INFO: 2025-08-22 [2025-07-22 00:25:04] Production.INFO: getdaysdiff [2025-07-22 00:25:04] Production.INFO: +31 [2025-07-22 00:25:04] Production.INFO: call prc_setAccountDiscountPlan (253,16,1,31,31,'RMScheduler',2025-07-22 00:25:04,1,0,,,0) [2025-07-22 00:25:05] Production.INFO: next invoice date [2025-07-22 00:25:05] Production.INFO: 2025-08-22 [2025-07-22 00:25:05] Production.INFO: getdaysdiff [2025-07-22 00:25:05] Production.INFO: +31 [2025-07-22 00:25:05] Production.INFO: call prc_setAccountDiscountPlan (253,13,2,31,31,'RMScheduler',2025-07-22 00:25:04,1,0,,,0) [2025-07-22 00:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-07-21 21:25:06 [end_date_ymd] => 2025-07-22 00:25:06 [RateCDR] => 1 ) [2025-07-22 00:25: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` >= '2025-07-21 21:25:06' and `end` < '2025-07-22 00:25: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 ,'') [2025-07-22 00:25:19] Production.INFO: count ==421 [2025-07-22 00:25:19] Production.ERROR: pbx CDR StartTime 2025-07-21 21:25:06 - End Time 2025-07-22 00:25:06 [2025-07-22 00:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515316', 'tblTempUsageDetail_20' ) start [2025-07-22 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515316', 'tblTempUsageDetail_20' ) end [2025-07-22 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515316', 'tblTempVendorCDR_20' ) start [2025-07-22 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515316', 'tblTempVendorCDR_20' ) end [2025-07-22 00:25:19] Production.INFO: ProcessCDR(1,15515316,1,1,2) [2025-07-22 00:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15515316,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 00:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15515316,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 00:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15515316,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 00:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15515316,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 00:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515316', 'tblTempUsageDetail_20' ) start [2025-07-22 00:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515316', 'tblTempUsageDetail_20' ) end [2025-07-22 00:25:25] Production.ERROR: pbx prc_insertCDR start [2025-07-22 00:25:26] Production.ERROR: pbx prc_insertCDR end [2025-07-22 00:25:27] Production.INFO: ==20500== Releasing lock... [2025-07-22 00:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 00:25:27] Production.INFO: 35.75 MB #Memory Used# [2025-07-22 01:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-21 22:25:05 [end_date_ymd] => 2025-07-22 01:25:05 [RateCDR] => 1 ) [2025-07-22 01:25: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` >= '2025-07-21 22:25:05' and `end` < '2025-07-22 01:25: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 ,'') [2025-07-22 01:25:17] Production.INFO: count ==342 [2025-07-22 01:25:17] Production.ERROR: pbx CDR StartTime 2025-07-21 22:25:05 - End Time 2025-07-22 01:25:05 [2025-07-22 01:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 01:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515563', 'tblTempUsageDetail_20' ) start [2025-07-22 01:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515563', 'tblTempUsageDetail_20' ) end [2025-07-22 01:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515563', 'tblTempVendorCDR_20' ) start [2025-07-22 01:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515563', 'tblTempVendorCDR_20' ) end [2025-07-22 01:25:17] Production.INFO: ProcessCDR(1,15515563,1,1,2) [2025-07-22 01:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15515563,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 01:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15515563,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 01:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15515563,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 01:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15515563,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 01:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515563', 'tblTempUsageDetail_20' ) start [2025-07-22 01:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515563', 'tblTempUsageDetail_20' ) end [2025-07-22 01:25:24] Production.ERROR: pbx prc_insertCDR start [2025-07-22 01:25:24] Production.ERROR: pbx prc_insertCDR end [2025-07-22 01:25:24] Production.INFO: ==25541== Releasing lock... [2025-07-22 01:25:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 01:25:24] Production.INFO: 31.5 MB #Memory Used# [2025-07-22 02:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-21 23:25:05 [end_date_ymd] => 2025-07-22 02:25:05 [RateCDR] => 1 ) [2025-07-22 02:25: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` >= '2025-07-21 23:25:05' and `end` < '2025-07-22 02:25: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 ,'') [2025-07-22 02:25:18] Production.INFO: count ==320 [2025-07-22 02:25:18] Production.ERROR: pbx CDR StartTime 2025-07-21 23:25:05 - End Time 2025-07-22 02:25:05 [2025-07-22 02:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 02:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515810', 'tblTempUsageDetail_20' ) start [2025-07-22 02:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15515810', 'tblTempUsageDetail_20' ) end [2025-07-22 02:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515810', 'tblTempVendorCDR_20' ) start [2025-07-22 02:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15515810', 'tblTempVendorCDR_20' ) end [2025-07-22 02:25:18] Production.INFO: ProcessCDR(1,15515810,1,1,2) [2025-07-22 02:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15515810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 02:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15515810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 02:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15515810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 02:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15515810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 02:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515810', 'tblTempUsageDetail_20' ) start [2025-07-22 02:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15515810', 'tblTempUsageDetail_20' ) end [2025-07-22 02:25:24] Production.ERROR: pbx prc_insertCDR start [2025-07-22 02:25:24] Production.ERROR: pbx prc_insertCDR end [2025-07-22 02:25:24] Production.INFO: ==30500== Releasing lock... [2025-07-22 02:25:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 02:25:24] Production.INFO: 31 MB #Memory Used# [2025-07-22 03:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 00:25:06 [end_date_ymd] => 2025-07-22 03:25:06 [RateCDR] => 1 ) [2025-07-22 03:25: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` >= '2025-07-22 00:25:06' and `end` < '2025-07-22 03:25: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 ,'') [2025-07-22 03:25:18] Production.INFO: count ==263 [2025-07-22 03:25:18] Production.ERROR: pbx CDR StartTime 2025-07-22 00:25:06 - End Time 2025-07-22 03:25:06 [2025-07-22 03:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516057', 'tblTempUsageDetail_20' ) start [2025-07-22 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516057', 'tblTempUsageDetail_20' ) end [2025-07-22 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516057', 'tblTempVendorCDR_20' ) start [2025-07-22 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516057', 'tblTempVendorCDR_20' ) end [2025-07-22 03:25:18] Production.INFO: ProcessCDR(1,15516057,1,1,2) [2025-07-22 03:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15516057,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 03:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15516057,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 03:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15516057,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 03:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15516057,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 03:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516057', 'tblTempUsageDetail_20' ) start [2025-07-22 03:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516057', 'tblTempUsageDetail_20' ) end [2025-07-22 03:25:25] Production.ERROR: pbx prc_insertCDR start [2025-07-22 03:25:25] Production.ERROR: pbx prc_insertCDR end [2025-07-22 03:25:25] Production.INFO: ==2610== Releasing lock... [2025-07-22 03:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 03:25:25] Production.INFO: 30.5 MB #Memory Used# [2025-07-22 04:25:04] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 01:25:04 [end_date_ymd] => 2025-07-22 04:25:04 [RateCDR] => 1 ) [2025-07-22 04:25:04] 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` >= '2025-07-22 01:25:04' and `end` < '2025-07-22 04:25:04' 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 ,'') [2025-07-22 04:25:16] Production.INFO: count ==183 [2025-07-22 04:25:17] Production.ERROR: pbx CDR StartTime 2025-07-22 01:25:04 - End Time 2025-07-22 04:25:04 [2025-07-22 04:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 04:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516305', 'tblTempUsageDetail_20' ) start [2025-07-22 04:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516305', 'tblTempUsageDetail_20' ) end [2025-07-22 04:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516305', 'tblTempVendorCDR_20' ) start [2025-07-22 04:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516305', 'tblTempVendorCDR_20' ) end [2025-07-22 04:25:17] Production.INFO: ProcessCDR(1,15516305,1,1,2) [2025-07-22 04:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15516305,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 04:25:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15516305,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 04:25:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15516305,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 04:25:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15516305,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 04:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516305', 'tblTempUsageDetail_20' ) start [2025-07-22 04:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516305', 'tblTempUsageDetail_20' ) end [2025-07-22 04:25:23] Production.ERROR: pbx prc_insertCDR start [2025-07-22 04:25:23] Production.ERROR: pbx prc_insertCDR end [2025-07-22 04:25:23] Production.INFO: ==7090== Releasing lock... [2025-07-22 04:25:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 04:25:23] Production.INFO: 29.5 MB #Memory Used# [2025-07-22 05:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 02:25:05 [end_date_ymd] => 2025-07-22 05:25:05 [RateCDR] => 1 ) [2025-07-22 05:25: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` >= '2025-07-22 02:25:05' and `end` < '2025-07-22 05:25: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 ,'') [2025-07-22 05:25:17] Production.INFO: count ==104 [2025-07-22 05:25:17] Production.ERROR: pbx CDR StartTime 2025-07-22 02:25:05 - End Time 2025-07-22 05:25:05 [2025-07-22 05:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 05:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516553', 'tblTempUsageDetail_20' ) start [2025-07-22 05:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516553', 'tblTempUsageDetail_20' ) end [2025-07-22 05:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516553', 'tblTempVendorCDR_20' ) start [2025-07-22 05:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516553', 'tblTempVendorCDR_20' ) end [2025-07-22 05:25:17] Production.INFO: ProcessCDR(1,15516553,1,1,2) [2025-07-22 05:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15516553,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 05:25:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15516553,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 05:25:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15516553,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 05:25:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15516553,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 05:25:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516553', 'tblTempUsageDetail_20' ) start [2025-07-22 05:25:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516553', 'tblTempUsageDetail_20' ) end [2025-07-22 05:25:21] Production.ERROR: pbx prc_insertCDR start [2025-07-22 05:25:21] Production.ERROR: pbx prc_insertCDR end [2025-07-22 05:25:21] Production.INFO: ==12009== Releasing lock... [2025-07-22 05:25:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 05:25:21] Production.INFO: 28.75 MB #Memory Used# [2025-07-22 06:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 03:25:05 [end_date_ymd] => 2025-07-22 06:25:05 [RateCDR] => 1 ) [2025-07-22 06:25: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` >= '2025-07-22 03:25:05' and `end` < '2025-07-22 06:25: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 ,'') [2025-07-22 06:25:17] Production.INFO: count ==84 [2025-07-22 06:25:17] Production.ERROR: pbx CDR StartTime 2025-07-22 03:25:05 - End Time 2025-07-22 06:25:05 [2025-07-22 06:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516800', 'tblTempUsageDetail_20' ) start [2025-07-22 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15516800', 'tblTempUsageDetail_20' ) end [2025-07-22 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516800', 'tblTempVendorCDR_20' ) start [2025-07-22 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15516800', 'tblTempVendorCDR_20' ) end [2025-07-22 06:25:17] Production.INFO: ProcessCDR(1,15516800,1,1,2) [2025-07-22 06:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15516800,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 06:25:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15516800,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 06:25:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15516800,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 06:25:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15516800,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 06:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516800', 'tblTempUsageDetail_20' ) start [2025-07-22 06:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15516800', 'tblTempUsageDetail_20' ) end [2025-07-22 06:25:23] Production.ERROR: pbx prc_insertCDR start [2025-07-22 06:25:23] Production.ERROR: pbx prc_insertCDR end [2025-07-22 06:25:23] Production.INFO: ==17879== Releasing lock... [2025-07-22 06:25:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 06:25:23] Production.INFO: 28.5 MB #Memory Used# [2025-07-22 07:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 04:25:05 [end_date_ymd] => 2025-07-22 07:25:05 [RateCDR] => 1 ) [2025-07-22 07:25: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` >= '2025-07-22 04:25:05' and `end` < '2025-07-22 07:25: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 ,'') [2025-07-22 07:25:17] Production.INFO: count ==113 [2025-07-22 07:25:17] Production.ERROR: pbx CDR StartTime 2025-07-22 04:25:05 - End Time 2025-07-22 07:25:05 [2025-07-22 07:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517047', 'tblTempUsageDetail_20' ) start [2025-07-22 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517047', 'tblTempUsageDetail_20' ) end [2025-07-22 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517047', 'tblTempVendorCDR_20' ) start [2025-07-22 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517047', 'tblTempVendorCDR_20' ) end [2025-07-22 07:25:17] Production.INFO: ProcessCDR(1,15517047,1,1,2) [2025-07-22 07:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15517047,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 07:25:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15517047,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 07:25:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15517047,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 07:25:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15517047,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 07:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517047', 'tblTempUsageDetail_20' ) start [2025-07-22 07:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517047', 'tblTempUsageDetail_20' ) end [2025-07-22 07:25:23] Production.ERROR: pbx prc_insertCDR start [2025-07-22 07:25:23] Production.ERROR: pbx prc_insertCDR end [2025-07-22 07:25:23] Production.INFO: ==22649== Releasing lock... [2025-07-22 07:25:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 07:25:23] Production.INFO: 29 MB #Memory Used# [2025-07-22 08:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 05:25:05 [end_date_ymd] => 2025-07-22 08:25:05 [RateCDR] => 1 ) [2025-07-22 08:25: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` >= '2025-07-22 05:25:05' and `end` < '2025-07-22 08:25: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 ,'') [2025-07-22 08:25:17] Production.INFO: count ==324 [2025-07-22 08:25:17] Production.ERROR: pbx CDR StartTime 2025-07-22 05:25:05 - End Time 2025-07-22 08:25:05 [2025-07-22 08:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517294', 'tblTempUsageDetail_20' ) start [2025-07-22 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517294', 'tblTempUsageDetail_20' ) end [2025-07-22 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517294', 'tblTempVendorCDR_20' ) start [2025-07-22 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517294', 'tblTempVendorCDR_20' ) end [2025-07-22 08:25:17] Production.INFO: ProcessCDR(1,15517294,1,1,2) [2025-07-22 08:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15517294,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 08:25:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15517294,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 08:25:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15517294,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 08:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15517294,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 08:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517294', 'tblTempUsageDetail_20' ) start [2025-07-22 08:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517294', 'tblTempUsageDetail_20' ) end [2025-07-22 08:25:24] Production.ERROR: pbx prc_insertCDR start [2025-07-22 08:25:24] Production.ERROR: pbx prc_insertCDR end [2025-07-22 08:25:24] Production.INFO: ==26991== Releasing lock... [2025-07-22 08:25:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 08:25:24] Production.INFO: 31 MB #Memory Used# [2025-07-22 09:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 06:25:06 [end_date_ymd] => 2025-07-22 09:25:06 [RateCDR] => 1 ) [2025-07-22 09:25: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` >= '2025-07-22 06:25:06' and `end` < '2025-07-22 09:25: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 ,'') [2025-07-22 09:25:18] Production.INFO: count ==1174 [2025-07-22 09:25:19] Production.ERROR: pbx CDR StartTime 2025-07-22 06:25:06 - End Time 2025-07-22 09:25:06 [2025-07-22 09:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 09:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517541', 'tblTempUsageDetail_20' ) start [2025-07-22 09:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517541', 'tblTempUsageDetail_20' ) end [2025-07-22 09:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517541', 'tblTempVendorCDR_20' ) start [2025-07-22 09:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517541', 'tblTempVendorCDR_20' ) end [2025-07-22 09:25:19] Production.INFO: ProcessCDR(1,15517541,1,1,2) [2025-07-22 09:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15517541,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 09:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15517541,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 09:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15517541,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 09:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15517541,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 09:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517541', 'tblTempUsageDetail_20' ) start [2025-07-22 09:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517541', 'tblTempUsageDetail_20' ) end [2025-07-22 09:25:27] Production.ERROR: pbx prc_insertCDR start [2025-07-22 09:25:28] Production.ERROR: pbx prc_insertCDR end [2025-07-22 09:25:28] Production.INFO: ==31736== Releasing lock... [2025-07-22 09:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 09:25:28] Production.INFO: 37.5 MB #Memory Used# [2025-07-22 10:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 07:25:05 [end_date_ymd] => 2025-07-22 10:25:05 [RateCDR] => 1 ) [2025-07-22 10:25: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` >= '2025-07-22 07:25:05' and `end` < '2025-07-22 10:25: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 ,'') [2025-07-22 10:25:20] Production.INFO: count ==2672 [2025-07-22 10:25:21] Production.ERROR: pbx CDR StartTime 2025-07-22 07:25:05 - End Time 2025-07-22 10:25:05 [2025-07-22 10:25:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 10:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517788', 'tblTempUsageDetail_20' ) start [2025-07-22 10:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15517788', 'tblTempUsageDetail_20' ) end [2025-07-22 10:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517788', 'tblTempVendorCDR_20' ) start [2025-07-22 10:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15517788', 'tblTempVendorCDR_20' ) end [2025-07-22 10:25:21] Production.INFO: ProcessCDR(1,15517788,1,1,2) [2025-07-22 10:25:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15517788,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 10:25:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15517788,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 10:25:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15517788,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 10:25:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15517788,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 10:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517788', 'tblTempUsageDetail_20' ) start [2025-07-22 10:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15517788', 'tblTempUsageDetail_20' ) end [2025-07-22 10:25:29] Production.ERROR: pbx prc_insertCDR start [2025-07-22 10:25:31] Production.ERROR: pbx prc_insertCDR end [2025-07-22 10:25:31] Production.INFO: ==3725== Releasing lock... [2025-07-22 10:25:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 10:25:31] Production.INFO: 48.5 MB #Memory Used# [2025-07-22 11:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 08:25:05 [end_date_ymd] => 2025-07-22 11:25:05 [RateCDR] => 1 ) [2025-07-22 11:25: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` >= '2025-07-22 08:25:05' and `end` < '2025-07-22 11:25: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 ,'') [2025-07-22 11:25:20] Production.INFO: count ==4523 [2025-07-22 11:25:22] Production.ERROR: pbx CDR StartTime 2025-07-22 08:25:05 - End Time 2025-07-22 11:25:05 [2025-07-22 11:25:22] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 11:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518035', 'tblTempUsageDetail_20' ) start [2025-07-22 11:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518035', 'tblTempUsageDetail_20' ) end [2025-07-22 11:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518035', 'tblTempVendorCDR_20' ) start [2025-07-22 11:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518035', 'tblTempVendorCDR_20' ) end [2025-07-22 11:25:22] Production.INFO: ProcessCDR(1,15518035,1,1,2) [2025-07-22 11:25:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15518035,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 11:25:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15518035,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 11:25:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15518035,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 11:25:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15518035,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 11:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518035', 'tblTempUsageDetail_20' ) start [2025-07-22 11:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518035', 'tblTempUsageDetail_20' ) end [2025-07-22 11:25:31] Production.ERROR: pbx prc_insertCDR start [2025-07-22 11:25:33] Production.ERROR: pbx prc_insertCDR end [2025-07-22 11:25:33] Production.INFO: ==8473== Releasing lock... [2025-07-22 11:25:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 11:25:33] Production.INFO: 62 MB #Memory Used# [2025-07-22 12:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 09:25:05 [end_date_ymd] => 2025-07-22 12:25:05 [RateCDR] => 1 ) [2025-07-22 12:25: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` >= '2025-07-22 09:25:05' and `end` < '2025-07-22 12:25: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 ,'') [2025-07-22 12:25:22] Production.INFO: count ==5416 [2025-07-22 12:25:25] Production.ERROR: pbx CDR StartTime 2025-07-22 09:25:05 - End Time 2025-07-22 12:25:05 [2025-07-22 12:25:25] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 12:25:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518282', 'tblTempUsageDetail_20' ) start [2025-07-22 12:25:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518282', 'tblTempUsageDetail_20' ) end [2025-07-22 12:25:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518282', 'tblTempVendorCDR_20' ) start [2025-07-22 12:25:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518282', 'tblTempVendorCDR_20' ) end [2025-07-22 12:25:25] Production.INFO: ProcessCDR(1,15518282,1,1,2) [2025-07-22 12:25:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15518282,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 12:25:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15518282,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 12:25:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15518282,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 12:25:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15518282,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 12:25:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518282', 'tblTempUsageDetail_20' ) start [2025-07-22 12:25:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518282', 'tblTempUsageDetail_20' ) end [2025-07-22 12:25:34] Production.ERROR: pbx prc_insertCDR start [2025-07-22 12:25:37] Production.ERROR: pbx prc_insertCDR end [2025-07-22 12:25:37] Production.INFO: ==12980== Releasing lock... [2025-07-22 12:25:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 12:25:37] Production.INFO: 68.75 MB #Memory Used# [2025-07-22 13:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 10:25:06 [end_date_ymd] => 2025-07-22 13:25:06 [RateCDR] => 1 ) [2025-07-22 13:25: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` >= '2025-07-22 10:25:06' and `end` < '2025-07-22 13:25: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 ,'') [2025-07-22 13:25:19] Production.INFO: count ==5607 [2025-07-22 13:25:22] Production.ERROR: pbx CDR StartTime 2025-07-22 10:25:06 - End Time 2025-07-22 13:25:06 [2025-07-22 13:25:22] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 13:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518529', 'tblTempUsageDetail_20' ) start [2025-07-22 13:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518529', 'tblTempUsageDetail_20' ) end [2025-07-22 13:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518529', 'tblTempVendorCDR_20' ) start [2025-07-22 13:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518529', 'tblTempVendorCDR_20' ) end [2025-07-22 13:25:22] Production.INFO: ProcessCDR(1,15518529,1,1,2) [2025-07-22 13:25:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15518529,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 13:25:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15518529,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 13:25:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15518529,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 13:25:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15518529,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 13:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518529', 'tblTempUsageDetail_20' ) start [2025-07-22 13:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518529', 'tblTempUsageDetail_20' ) end [2025-07-22 13:25:31] Production.ERROR: pbx prc_insertCDR start [2025-07-22 13:25:33] Production.ERROR: pbx prc_insertCDR end [2025-07-22 13:25:33] Production.INFO: ==17414== Releasing lock... [2025-07-22 13:25:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 13:25:33] Production.INFO: 70.25 MB #Memory Used# [2025-07-22 14:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 11:25:05 [end_date_ymd] => 2025-07-22 14:25:05 [RateCDR] => 1 ) [2025-07-22 14:25: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` >= '2025-07-22 11:25:05' and `end` < '2025-07-22 14:25: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 ,'') [2025-07-22 14:25:20] Production.INFO: count ==5275 [2025-07-22 14:25:23] Production.ERROR: pbx CDR StartTime 2025-07-22 11:25:05 - End Time 2025-07-22 14:25:05 [2025-07-22 14:25:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 14:25:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518776', 'tblTempUsageDetail_20' ) start [2025-07-22 14:25:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15518776', 'tblTempUsageDetail_20' ) end [2025-07-22 14:25:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518776', 'tblTempVendorCDR_20' ) start [2025-07-22 14:25:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15518776', 'tblTempVendorCDR_20' ) end [2025-07-22 14:25:23] Production.INFO: ProcessCDR(1,15518776,1,1,2) [2025-07-22 14:25:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15518776,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 14:25:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15518776,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 14:25:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15518776,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 14:25:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15518776,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 14:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518776', 'tblTempUsageDetail_20' ) start [2025-07-22 14:25:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15518776', 'tblTempUsageDetail_20' ) end [2025-07-22 14:25:32] Production.ERROR: pbx prc_insertCDR start [2025-07-22 14:25:34] Production.ERROR: pbx prc_insertCDR end [2025-07-22 14:25:34] Production.INFO: ==21804== Releasing lock... [2025-07-22 14:25:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 14:25:34] Production.INFO: 67.75 MB #Memory Used# [2025-07-22 15:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 12:25:05 [end_date_ymd] => 2025-07-22 15:25:05 [RateCDR] => 1 ) [2025-07-22 15:25: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` >= '2025-07-22 12:25:05' and `end` < '2025-07-22 15:25: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 ,'') [2025-07-22 15:25:19] Production.INFO: count ==5384 [2025-07-22 15:25:22] Production.ERROR: pbx CDR StartTime 2025-07-22 12:25:05 - End Time 2025-07-22 15:25:05 [2025-07-22 15:25:22] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 15:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519023', 'tblTempUsageDetail_20' ) start [2025-07-22 15:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519023', 'tblTempUsageDetail_20' ) end [2025-07-22 15:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519023', 'tblTempVendorCDR_20' ) start [2025-07-22 15:25:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519023', 'tblTempVendorCDR_20' ) end [2025-07-22 15:25:22] Production.INFO: ProcessCDR(1,15519023,1,1,2) [2025-07-22 15:25:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15519023,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 15:25:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15519023,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 15:25:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15519023,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 15:25:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15519023,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 15:25:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519023', 'tblTempUsageDetail_20' ) start [2025-07-22 15:25:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519023', 'tblTempUsageDetail_20' ) end [2025-07-22 15:25:31] Production.ERROR: pbx prc_insertCDR start [2025-07-22 15:25:33] Production.ERROR: pbx prc_insertCDR end [2025-07-22 15:25:33] Production.INFO: ==26209== Releasing lock... [2025-07-22 15:25:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 15:25:33] Production.INFO: 68.5 MB #Memory Used# [2025-07-22 16:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 13:25:05 [end_date_ymd] => 2025-07-22 16:25:05 [RateCDR] => 1 ) [2025-07-22 16:25: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` >= '2025-07-22 13:25:05' and `end` < '2025-07-22 16:25: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 ,'') [2025-07-22 16:25:21] Production.INFO: count ==5343 [2025-07-22 16:25:24] Production.ERROR: pbx CDR StartTime 2025-07-22 13:25:05 - End Time 2025-07-22 16:25:05 [2025-07-22 16:25:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 16:25:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519270', 'tblTempUsageDetail_20' ) start [2025-07-22 16:25:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519270', 'tblTempUsageDetail_20' ) end [2025-07-22 16:25:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519270', 'tblTempVendorCDR_20' ) start [2025-07-22 16:25:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519270', 'tblTempVendorCDR_20' ) end [2025-07-22 16:25:24] Production.INFO: ProcessCDR(1,15519270,1,1,2) [2025-07-22 16:25:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15519270,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 16:25:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15519270,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 16:25:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15519270,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 16:25:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15519270,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 16:25:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519270', 'tblTempUsageDetail_20' ) start [2025-07-22 16:25:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519270', 'tblTempUsageDetail_20' ) end [2025-07-22 16:25:33] Production.ERROR: pbx prc_insertCDR start [2025-07-22 16:25:35] Production.ERROR: pbx prc_insertCDR end [2025-07-22 16:25:35] Production.INFO: ==30748== Releasing lock... [2025-07-22 16:25:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 16:25:35] Production.INFO: 68.25 MB #Memory Used# [2025-07-22 17:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 14:25:05 [end_date_ymd] => 2025-07-22 17:25:05 [RateCDR] => 1 ) [2025-07-22 17:25: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` >= '2025-07-22 14:25:05' and `end` < '2025-07-22 17:25: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 ,'') [2025-07-22 17:25:18] Production.INFO: count ==5174 [2025-07-22 17:25:21] Production.ERROR: pbx CDR StartTime 2025-07-22 14:25:05 - End Time 2025-07-22 17:25:05 [2025-07-22 17:25:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 17:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519517', 'tblTempUsageDetail_20' ) start [2025-07-22 17:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519517', 'tblTempUsageDetail_20' ) end [2025-07-22 17:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519517', 'tblTempVendorCDR_20' ) start [2025-07-22 17:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519517', 'tblTempVendorCDR_20' ) end [2025-07-22 17:25:21] Production.INFO: ProcessCDR(1,15519517,1,1,2) [2025-07-22 17:25:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15519517,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 17:25:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15519517,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 17:25:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15519517,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 17:25:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15519517,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 17:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519517', 'tblTempUsageDetail_20' ) start [2025-07-22 17:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519517', 'tblTempUsageDetail_20' ) end [2025-07-22 17:25:29] Production.ERROR: pbx prc_insertCDR start [2025-07-22 17:25:31] Production.ERROR: pbx prc_insertCDR end [2025-07-22 17:25:31] Production.INFO: ==3058== Releasing lock... [2025-07-22 17:25:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 17:25:31] Production.INFO: 67 MB #Memory Used# [2025-07-22 18:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 15:25:05 [end_date_ymd] => 2025-07-22 18:25:05 [RateCDR] => 1 ) [2025-07-22 18:25: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` >= '2025-07-22 15:25:05' and `end` < '2025-07-22 18:25: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 ,'') [2025-07-22 18:25:18] Production.INFO: count ==4237 [2025-07-22 18:25:20] Production.ERROR: pbx CDR StartTime 2025-07-22 15:25:05 - End Time 2025-07-22 18:25:05 [2025-07-22 18:25:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 18:25:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519764', 'tblTempUsageDetail_20' ) start [2025-07-22 18:25:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15519764', 'tblTempUsageDetail_20' ) end [2025-07-22 18:25:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519764', 'tblTempVendorCDR_20' ) start [2025-07-22 18:25:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15519764', 'tblTempVendorCDR_20' ) end [2025-07-22 18:25:20] Production.INFO: ProcessCDR(1,15519764,1,1,2) [2025-07-22 18:25:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15519764,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 18:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15519764,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 18:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15519764,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 18:25:58] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15519764,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 18:25:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519764', 'tblTempUsageDetail_20' ) start [2025-07-22 18:26:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15519764', 'tblTempUsageDetail_20' ) end [2025-07-22 18:26:00] Production.ERROR: pbx prc_insertCDR start [2025-07-22 18:26:01] Production.ERROR: pbx prc_insertCDR end [2025-07-22 18:26:06] Production.INFO: ==7784== Releasing lock... [2025-07-22 18:26:06] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 18:26:06] Production.INFO: 60 MB #Memory Used# [2025-07-22 19:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 16:25:05 [end_date_ymd] => 2025-07-22 19:25:05 [RateCDR] => 1 ) [2025-07-22 19:25: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` >= '2025-07-22 16:25:05' and `end` < '2025-07-22 19:25: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 ,'') [2025-07-22 19:25:19] Production.INFO: count ==3307 [2025-07-22 19:25:20] Production.ERROR: pbx CDR StartTime 2025-07-22 16:25:05 - End Time 2025-07-22 19:25:05 [2025-07-22 19:25:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 19:25:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520008', 'tblTempUsageDetail_20' ) start [2025-07-22 19:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520008', 'tblTempUsageDetail_20' ) end [2025-07-22 19:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520008', 'tblTempVendorCDR_20' ) start [2025-07-22 19:25:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520008', 'tblTempVendorCDR_20' ) end [2025-07-22 19:25:21] Production.INFO: ProcessCDR(1,15520008,1,1,2) [2025-07-22 19:25:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15520008,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 19:25:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15520008,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 19:25:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15520008,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 19:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15520008,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 19:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520008', 'tblTempUsageDetail_20' ) start [2025-07-22 19:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520008', 'tblTempUsageDetail_20' ) end [2025-07-22 19:25:28] Production.ERROR: pbx prc_insertCDR start [2025-07-22 19:25:28] Production.ERROR: pbx prc_insertCDR end [2025-07-22 19:25:29] Production.INFO: ==12637== Releasing lock... [2025-07-22 19:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 19:25:29] Production.INFO: 52.75 MB #Memory Used# [2025-07-22 20:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 17:25:05 [end_date_ymd] => 2025-07-22 20:25:05 [RateCDR] => 1 ) [2025-07-22 20:25: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` >= '2025-07-22 17:25:05' and `end` < '2025-07-22 20:25: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 ,'') [2025-07-22 20:25:17] Production.INFO: count ==2243 [2025-07-22 20:25:18] Production.ERROR: pbx CDR StartTime 2025-07-22 17:25:05 - End Time 2025-07-22 20:25:05 [2025-07-22 20:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520255', 'tblTempUsageDetail_20' ) start [2025-07-22 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520255', 'tblTempUsageDetail_20' ) end [2025-07-22 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520255', 'tblTempVendorCDR_20' ) start [2025-07-22 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520255', 'tblTempVendorCDR_20' ) end [2025-07-22 20:25:18] Production.INFO: ProcessCDR(1,15520255,1,1,2) [2025-07-22 20:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15520255,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 20:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15520255,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 20:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15520255,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 20:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15520255,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 20:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520255', 'tblTempUsageDetail_20' ) start [2025-07-22 20:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520255', 'tblTempUsageDetail_20' ) end [2025-07-22 20:25:25] Production.ERROR: pbx prc_insertCDR start [2025-07-22 20:25:25] Production.ERROR: pbx prc_insertCDR end [2025-07-22 20:25:25] Production.INFO: ==17055== Releasing lock... [2025-07-22 20:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 20:25:25] Production.INFO: 45 MB #Memory Used# [2025-07-22 21:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 18:25:05 [end_date_ymd] => 2025-07-22 21:25:05 [RateCDR] => 1 ) [2025-07-22 21:25: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` >= '2025-07-22 18:25:05' and `end` < '2025-07-22 21:25: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 ,'') [2025-07-22 21:25:17] Production.INFO: count ==1602 [2025-07-22 21:25:18] Production.ERROR: pbx CDR StartTime 2025-07-22 18:25:05 - End Time 2025-07-22 21:25:05 [2025-07-22 21:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520502', 'tblTempUsageDetail_20' ) start [2025-07-22 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520502', 'tblTempUsageDetail_20' ) end [2025-07-22 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520502', 'tblTempVendorCDR_20' ) start [2025-07-22 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520502', 'tblTempVendorCDR_20' ) end [2025-07-22 21:25:18] Production.INFO: ProcessCDR(1,15520502,1,1,2) [2025-07-22 21:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15520502,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 21:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15520502,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 21:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15520502,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 21:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15520502,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 21:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520502', 'tblTempUsageDetail_20' ) start [2025-07-22 21:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520502', 'tblTempUsageDetail_20' ) end [2025-07-22 21:25:24] Production.ERROR: pbx prc_insertCDR start [2025-07-22 21:25:24] Production.ERROR: pbx prc_insertCDR end [2025-07-22 21:25:24] Production.INFO: ==21363== Releasing lock... [2025-07-22 21:25:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 21:25:24] Production.INFO: 40.25 MB #Memory Used# [2025-07-22 22:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 19:25:05 [end_date_ymd] => 2025-07-22 22:25:05 [RateCDR] => 1 ) [2025-07-22 22:25: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` >= '2025-07-22 19:25:05' and `end` < '2025-07-22 22:25: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 ,'') [2025-07-22 22:25:18] Production.INFO: count ==1105 [2025-07-22 22:25:18] Production.ERROR: pbx CDR StartTime 2025-07-22 19:25:05 - End Time 2025-07-22 22:25:05 [2025-07-22 22:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520749', 'tblTempUsageDetail_20' ) start [2025-07-22 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520749', 'tblTempUsageDetail_20' ) end [2025-07-22 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520749', 'tblTempVendorCDR_20' ) start [2025-07-22 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520749', 'tblTempVendorCDR_20' ) end [2025-07-22 22:25:18] Production.INFO: ProcessCDR(1,15520749,1,1,2) [2025-07-22 22:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15520749,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 22:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15520749,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 22:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15520749,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 22:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15520749,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 22:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520749', 'tblTempUsageDetail_20' ) start [2025-07-22 22:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520749', 'tblTempUsageDetail_20' ) end [2025-07-22 22:25:25] Production.ERROR: pbx prc_insertCDR start [2025-07-22 22:25:25] Production.ERROR: pbx prc_insertCDR end [2025-07-22 22:25:25] Production.INFO: ==26573== Releasing lock... [2025-07-22 22:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 22:25:25] Production.INFO: 36.5 MB #Memory Used# [2025-07-22 23:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-07-22 20:25:05 [end_date_ymd] => 2025-07-22 23:25:05 [RateCDR] => 1 ) [2025-07-22 23:25: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` >= '2025-07-22 20:25:05' and `end` < '2025-07-22 23:25: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 ,'') [2025-07-22 23:25:18] Production.INFO: count ==866 [2025-07-22 23:25:18] Production.ERROR: pbx CDR StartTime 2025-07-22 20:25:05 - End Time 2025-07-22 23:25:05 [2025-07-22 23:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-07-22 23:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520996', 'tblTempUsageDetail_20' ) start [2025-07-22 23:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15520996', 'tblTempUsageDetail_20' ) end [2025-07-22 23:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520996', 'tblTempVendorCDR_20' ) start [2025-07-22 23:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15520996', 'tblTempVendorCDR_20' ) end [2025-07-22 23:25:18] Production.INFO: ProcessCDR(1,15520996,1,1,2) [2025-07-22 23:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15520996,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 23:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15520996,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-07-22 23:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15520996,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 23:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15520996,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-07-22 23:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520996', 'tblTempUsageDetail_20' ) start [2025-07-22 23:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15520996', 'tblTempUsageDetail_20' ) end [2025-07-22 23:25:25] Production.ERROR: pbx prc_insertCDR start [2025-07-22 23:25:25] Production.ERROR: pbx prc_insertCDR end [2025-07-22 23:25:25] Production.INFO: ==30959== Releasing lock... [2025-07-22 23:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-07-22 23:25:25] Production.INFO: 34.75 MB #Memory Used#