[2025-08-31 00:25:05] Production.INFO: next invoice date [2025-08-31 00:25:05] Production.INFO: 2025-10-01 [2025-08-31 00:25:05] Production.INFO: getdaysdiff [2025-08-31 00:25:05] Production.INFO: +31 [2025-08-31 00:25:05] Production.INFO: call prc_setAccountDiscountPlan (208,11,1,31,31,'RMScheduler',2025-08-31 00:25:05,0,0,,,0) [2025-08-31 00:25:05] Production.INFO: next invoice date [2025-08-31 00:25:05] Production.INFO: 2025-10-01 [2025-08-31 00:25:05] Production.INFO: getdaysdiff [2025-08-31 00:25:05] Production.INFO: +31 [2025-08-31 00:25:05] Production.INFO: call prc_setAccountDiscountPlan (208,13,2,31,31,'RMScheduler',2025-08-31 00:25:05,0,0,,,0) [2025-08-31 00:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-30 21:25:06 [end_date_ymd] => 2025-08-31 00:25:06 [RateCDR] => 1 ) [2025-08-31 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-08-30 21:25:06' and `end` < '2025-08-31 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-08-31 00:25:19] Production.INFO: count ==680 [2025-08-31 00:25:19] Production.ERROR: pbx CDR StartTime 2025-08-30 21:25:06 - End Time 2025-08-31 00:25:06 [2025-08-31 00:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752403', 'tblTempUsageDetail_20' ) start [2025-08-31 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752403', 'tblTempUsageDetail_20' ) end [2025-08-31 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752403', 'tblTempVendorCDR_20' ) start [2025-08-31 00:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752403', 'tblTempVendorCDR_20' ) end [2025-08-31 00:25:19] Production.INFO: ProcessCDR(1,15752403,1,1,2) [2025-08-31 00:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15752403,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 00:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15752403,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 00:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15752403,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 00:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15752403,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 00:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752403', 'tblTempUsageDetail_20' ) start [2025-08-31 00:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752403', 'tblTempUsageDetail_20' ) end [2025-08-31 00:25:27] Production.ERROR: pbx prc_insertCDR start [2025-08-31 00:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 00:25:28] Production.INFO: ==6432== Releasing lock... [2025-08-31 00:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 00:25:28] Production.INFO: 37 MB #Memory Used# [2025-08-31 01:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-30 22:25:06 [end_date_ymd] => 2025-08-31 01:25:06 [RateCDR] => 1 ) [2025-08-31 01: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-08-30 22:25:06' and `end` < '2025-08-31 01: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-08-31 01:25:18] Production.INFO: count ==1071 [2025-08-31 01:25:19] Production.ERROR: pbx CDR StartTime 2025-08-30 22:25:06 - End Time 2025-08-31 01:25:06 [2025-08-31 01:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 01:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752650', 'tblTempUsageDetail_20' ) start [2025-08-31 01:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752650', 'tblTempUsageDetail_20' ) end [2025-08-31 01:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752650', 'tblTempVendorCDR_20' ) start [2025-08-31 01:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752650', 'tblTempVendorCDR_20' ) end [2025-08-31 01:25:19] Production.INFO: ProcessCDR(1,15752650,1,1,2) [2025-08-31 01:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15752650,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 01:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15752650,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 01:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15752650,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 01:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15752650,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 01:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752650', 'tblTempUsageDetail_20' ) start [2025-08-31 01:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752650', 'tblTempUsageDetail_20' ) end [2025-08-31 01:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 01:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 01:25:27] Production.INFO: ==11096== Releasing lock... [2025-08-31 01:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 01:25:27] Production.INFO: 38 MB #Memory Used# [2025-08-31 02:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-30 23:25:06 [end_date_ymd] => 2025-08-31 02:25:06 [RateCDR] => 1 ) [2025-08-31 02: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-08-30 23:25:06' and `end` < '2025-08-31 02: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-08-31 02:25:18] Production.INFO: count ==1009 [2025-08-31 02:25:19] Production.ERROR: pbx CDR StartTime 2025-08-30 23:25:06 - End Time 2025-08-31 02:25:06 [2025-08-31 02:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 02:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752897', 'tblTempUsageDetail_20' ) start [2025-08-31 02:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15752897', 'tblTempUsageDetail_20' ) end [2025-08-31 02:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752897', 'tblTempVendorCDR_20' ) start [2025-08-31 02:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15752897', 'tblTempVendorCDR_20' ) end [2025-08-31 02:25:19] Production.INFO: ProcessCDR(1,15752897,1,1,2) [2025-08-31 02:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15752897,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 02:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15752897,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 02:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15752897,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 02:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15752897,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 02:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752897', 'tblTempUsageDetail_20' ) start [2025-08-31 02:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15752897', 'tblTempUsageDetail_20' ) end [2025-08-31 02:25:27] Production.ERROR: pbx prc_insertCDR start [2025-08-31 02:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 02:25:27] Production.INFO: ==15878== Releasing lock... [2025-08-31 02:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 02:25:27] Production.INFO: 36.25 MB #Memory Used# [2025-08-31 03:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 00:25:05 [end_date_ymd] => 2025-08-31 03:25:05 [RateCDR] => 1 ) [2025-08-31 03: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-08-31 00:25:05' and `end` < '2025-08-31 03: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-08-31 03:25:17] Production.INFO: count ==850 [2025-08-31 03:25:17] Production.ERROR: pbx CDR StartTime 2025-08-31 00:25:05 - End Time 2025-08-31 03:25:05 [2025-08-31 03:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 03:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753144', 'tblTempUsageDetail_20' ) start [2025-08-31 03:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753144', 'tblTempUsageDetail_20' ) end [2025-08-31 03:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753144', 'tblTempVendorCDR_20' ) start [2025-08-31 03:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753144', 'tblTempVendorCDR_20' ) end [2025-08-31 03:25:17] Production.INFO: ProcessCDR(1,15753144,1,1,2) [2025-08-31 03:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15753144,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 03:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15753144,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 03:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15753144,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 03:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15753144,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 03:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753144', 'tblTempUsageDetail_20' ) start [2025-08-31 03:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753144', 'tblTempUsageDetail_20' ) end [2025-08-31 03:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 03:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 03:25:25] Production.INFO: ==20220== Releasing lock... [2025-08-31 03:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 03:25:25] Production.INFO: 34.25 MB #Memory Used# [2025-08-31 04:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 01:25:05 [end_date_ymd] => 2025-08-31 04:25:05 [RateCDR] => 1 ) [2025-08-31 04: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-08-31 01:25:05' and `end` < '2025-08-31 04: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-08-31 04:25:18] Production.INFO: count ==292 [2025-08-31 04:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 01:25:05 - End Time 2025-08-31 04:25:05 [2025-08-31 04:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753392', 'tblTempUsageDetail_20' ) start [2025-08-31 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753392', 'tblTempUsageDetail_20' ) end [2025-08-31 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753392', 'tblTempVendorCDR_20' ) start [2025-08-31 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753392', 'tblTempVendorCDR_20' ) end [2025-08-31 04:25:18] Production.INFO: ProcessCDR(1,15753392,1,1,2) [2025-08-31 04:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15753392,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 04:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15753392,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 04:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15753392,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 04:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15753392,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 04:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753392', 'tblTempUsageDetail_20' ) start [2025-08-31 04:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753392', 'tblTempUsageDetail_20' ) end [2025-08-31 04:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 04:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 04:25:25] Production.INFO: ==24834== Releasing lock... [2025-08-31 04:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 04:25:25] Production.INFO: 30.5 MB #Memory Used# [2025-08-31 05:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 02:25:06 [end_date_ymd] => 2025-08-31 05:25:06 [RateCDR] => 1 ) [2025-08-31 05: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-08-31 02:25:06' and `end` < '2025-08-31 05: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-08-31 05:25:18] Production.INFO: count ==226 [2025-08-31 05:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 02:25:06 - End Time 2025-08-31 05:25:06 [2025-08-31 05:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753640', 'tblTempUsageDetail_20' ) start [2025-08-31 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753640', 'tblTempUsageDetail_20' ) end [2025-08-31 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753640', 'tblTempVendorCDR_20' ) start [2025-08-31 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753640', 'tblTempVendorCDR_20' ) end [2025-08-31 05:25:18] Production.INFO: ProcessCDR(1,15753640,1,1,2) [2025-08-31 05:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15753640,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 05:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15753640,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 05:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15753640,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 05:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15753640,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 05:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753640', 'tblTempUsageDetail_20' ) start [2025-08-31 05:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753640', 'tblTempUsageDetail_20' ) end [2025-08-31 05:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 05:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 05:25:26] Production.INFO: ==29237== Releasing lock... [2025-08-31 05:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 05:25:26] Production.INFO: 30.25 MB #Memory Used# [2025-08-31 06:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 03:25:06 [end_date_ymd] => 2025-08-31 06:25:06 [RateCDR] => 1 ) [2025-08-31 06: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-08-31 03:25:06' and `end` < '2025-08-31 06: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-08-31 06:25:18] Production.INFO: count ==165 [2025-08-31 06:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 03:25:06 - End Time 2025-08-31 06:25:06 [2025-08-31 06:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 06:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753887', 'tblTempUsageDetail_20' ) start [2025-08-31 06:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15753887', 'tblTempUsageDetail_20' ) end [2025-08-31 06:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753887', 'tblTempVendorCDR_20' ) start [2025-08-31 06:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15753887', 'tblTempVendorCDR_20' ) end [2025-08-31 06:25:18] Production.INFO: ProcessCDR(1,15753887,1,1,2) [2025-08-31 06:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15753887,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 06:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15753887,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 06:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15753887,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 06:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15753887,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 06:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753887', 'tblTempUsageDetail_20' ) start [2025-08-31 06:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15753887', 'tblTempUsageDetail_20' ) end [2025-08-31 06:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 06:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 06:25:25] Production.INFO: ==1254== Releasing lock... [2025-08-31 06:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 06:25:25] Production.INFO: 29.25 MB #Memory Used# [2025-08-31 07:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 04:25:06 [end_date_ymd] => 2025-08-31 07:25:06 [RateCDR] => 1 ) [2025-08-31 07: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-08-31 04:25:06' and `end` < '2025-08-31 07: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-08-31 07:25:18] Production.INFO: count ==170 [2025-08-31 07:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 04:25:06 - End Time 2025-08-31 07:25:06 [2025-08-31 07:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 07:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754134', 'tblTempUsageDetail_20' ) start [2025-08-31 07:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754134', 'tblTempUsageDetail_20' ) end [2025-08-31 07:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754134', 'tblTempVendorCDR_20' ) start [2025-08-31 07:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754134', 'tblTempVendorCDR_20' ) end [2025-08-31 07:25:18] Production.INFO: ProcessCDR(1,15754134,1,1,2) [2025-08-31 07:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15754134,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 07:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15754134,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 07:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15754134,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 07:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15754134,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 07:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754134', 'tblTempUsageDetail_20' ) start [2025-08-31 07:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754134', 'tblTempUsageDetail_20' ) end [2025-08-31 07:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 07:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 07:25:25] Production.INFO: ==5869== Releasing lock... [2025-08-31 07:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 07:25:25] Production.INFO: 29.5 MB #Memory Used# [2025-08-31 08:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 05:25:05 [end_date_ymd] => 2025-08-31 08:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 05:25:05' and `end` < '2025-08-31 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-08-31 08:25:17] Production.INFO: count ==153 [2025-08-31 08:25:17] Production.ERROR: pbx CDR StartTime 2025-08-31 05:25:05 - End Time 2025-08-31 08:25:05 [2025-08-31 08:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754381', 'tblTempUsageDetail_20' ) start [2025-08-31 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754381', 'tblTempUsageDetail_20' ) end [2025-08-31 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754381', 'tblTempVendorCDR_20' ) start [2025-08-31 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754381', 'tblTempVendorCDR_20' ) end [2025-08-31 08:25:17] Production.INFO: ProcessCDR(1,15754381,1,1,2) [2025-08-31 08:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15754381,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 08:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15754381,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 08:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15754381,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 08:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15754381,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 08:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754381', 'tblTempUsageDetail_20' ) start [2025-08-31 08:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754381', 'tblTempUsageDetail_20' ) end [2025-08-31 08:25:24] Production.ERROR: pbx prc_insertCDR start [2025-08-31 08:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 08:25:25] Production.INFO: ==10160== Releasing lock... [2025-08-31 08:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 08:25:25] Production.INFO: 29.5 MB #Memory Used# [2025-08-31 09:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 06:25:05 [end_date_ymd] => 2025-08-31 09:25:05 [RateCDR] => 1 ) [2025-08-31 09: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-08-31 06:25:05' and `end` < '2025-08-31 09: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-08-31 09:25:18] Production.INFO: count ==195 [2025-08-31 09:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 06:25:05 - End Time 2025-08-31 09:25:05 [2025-08-31 09:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754628', 'tblTempUsageDetail_20' ) start [2025-08-31 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754628', 'tblTempUsageDetail_20' ) end [2025-08-31 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754628', 'tblTempVendorCDR_20' ) start [2025-08-31 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754628', 'tblTempVendorCDR_20' ) end [2025-08-31 09:25:18] Production.INFO: ProcessCDR(1,15754628,1,1,2) [2025-08-31 09:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15754628,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 09:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15754628,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 09:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15754628,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 09:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15754628,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 09:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754628', 'tblTempUsageDetail_20' ) start [2025-08-31 09:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754628', 'tblTempUsageDetail_20' ) end [2025-08-31 09:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 09:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 09:25:25] Production.INFO: ==14426== Releasing lock... [2025-08-31 09:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 09:25:25] Production.INFO: 30 MB #Memory Used# [2025-08-31 10:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 07:25:05 [end_date_ymd] => 2025-08-31 10:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 07:25:05' and `end` < '2025-08-31 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-08-31 10:25:17] Production.INFO: count ==237 [2025-08-31 10:25:17] Production.ERROR: pbx CDR StartTime 2025-08-31 07:25:05 - End Time 2025-08-31 10:25:05 [2025-08-31 10:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 10:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754875', 'tblTempUsageDetail_20' ) start [2025-08-31 10:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15754875', 'tblTempUsageDetail_20' ) end [2025-08-31 10:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754875', 'tblTempVendorCDR_20' ) start [2025-08-31 10:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15754875', 'tblTempVendorCDR_20' ) end [2025-08-31 10:25:17] Production.INFO: ProcessCDR(1,15754875,1,1,2) [2025-08-31 10:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15754875,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 10:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15754875,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 10:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15754875,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 10:25:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15754875,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 10:25:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754875', 'tblTempUsageDetail_20' ) start [2025-08-31 10:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15754875', 'tblTempUsageDetail_20' ) end [2025-08-31 10:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 10:25:25] Production.ERROR: pbx prc_insertCDR end [2025-08-31 10:25:25] Production.INFO: ==18963== Releasing lock... [2025-08-31 10:25:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 10:25:25] Production.INFO: 30.75 MB #Memory Used# [2025-08-31 11:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 08:25:06 [end_date_ymd] => 2025-08-31 11:25:06 [RateCDR] => 1 ) [2025-08-31 11: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-08-31 08:25:06' and `end` < '2025-08-31 11: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-08-31 11:25:18] Production.INFO: count ==420 [2025-08-31 11:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 08:25:06 - End Time 2025-08-31 11:25:06 [2025-08-31 11:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 11:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755122', 'tblTempUsageDetail_20' ) start [2025-08-31 11:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755122', 'tblTempUsageDetail_20' ) end [2025-08-31 11:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755122', 'tblTempVendorCDR_20' ) start [2025-08-31 11:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755122', 'tblTempVendorCDR_20' ) end [2025-08-31 11:25:18] Production.INFO: ProcessCDR(1,15755122,1,1,2) [2025-08-31 11:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15755122,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 11:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15755122,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 11:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15755122,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 11:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15755122,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 11:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755122', 'tblTempUsageDetail_20' ) start [2025-08-31 11:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755122', 'tblTempUsageDetail_20' ) end [2025-08-31 11:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 11:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 11:25:26] Production.INFO: ==23370== Releasing lock... [2025-08-31 11:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 11:25:26] Production.INFO: 32 MB #Memory Used# [2025-08-31 12:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 09:25:06 [end_date_ymd] => 2025-08-31 12:25:06 [RateCDR] => 1 ) [2025-08-31 12: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-08-31 09:25:06' and `end` < '2025-08-31 12: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-08-31 12:25:18] Production.INFO: count ==601 [2025-08-31 12:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 09:25:06 - End Time 2025-08-31 12:25:06 [2025-08-31 12:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 12:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755369', 'tblTempUsageDetail_20' ) start [2025-08-31 12:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755369', 'tblTempUsageDetail_20' ) end [2025-08-31 12:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755369', 'tblTempVendorCDR_20' ) start [2025-08-31 12:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755369', 'tblTempVendorCDR_20' ) end [2025-08-31 12:25:18] Production.INFO: ProcessCDR(1,15755369,1,1,2) [2025-08-31 12:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15755369,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 12:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15755369,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 12:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15755369,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 12:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15755369,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 12:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755369', 'tblTempUsageDetail_20' ) start [2025-08-31 12:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755369', 'tblTempUsageDetail_20' ) end [2025-08-31 12:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 12:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 12:25:26] Production.INFO: ==28039== Releasing lock... [2025-08-31 12:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 12:25:26] Production.INFO: 33.25 MB #Memory Used# [2025-08-31 13:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 10:25:05 [end_date_ymd] => 2025-08-31 13:25:05 [RateCDR] => 1 ) [2025-08-31 13: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-08-31 10:25:05' and `end` < '2025-08-31 13: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-08-31 13:25:17] Production.INFO: count ==805 [2025-08-31 13:25:17] Production.ERROR: pbx CDR StartTime 2025-08-31 10:25:05 - End Time 2025-08-31 13:25:05 [2025-08-31 13:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 13:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755616', 'tblTempUsageDetail_20' ) start [2025-08-31 13:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755616', 'tblTempUsageDetail_20' ) end [2025-08-31 13:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755616', 'tblTempVendorCDR_20' ) start [2025-08-31 13:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755616', 'tblTempVendorCDR_20' ) end [2025-08-31 13:25:17] Production.INFO: ProcessCDR(1,15755616,1,1,2) [2025-08-31 13:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15755616,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 13:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15755616,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 13:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15755616,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 13:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15755616,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 13:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755616', 'tblTempUsageDetail_20' ) start [2025-08-31 13:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755616', 'tblTempUsageDetail_20' ) end [2025-08-31 13:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 13:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 13:25:26] Production.INFO: ==32597== Releasing lock... [2025-08-31 13:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 13:25:26] Production.INFO: 34.5 MB #Memory Used# [2025-08-31 14:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 11:25:05 [end_date_ymd] => 2025-08-31 14:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 11:25:05' and `end` < '2025-08-31 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-08-31 14:25:17] Production.INFO: count ==838 [2025-08-31 14:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 11:25:05 - End Time 2025-08-31 14:25:05 [2025-08-31 14:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 14:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755863', 'tblTempUsageDetail_20' ) start [2025-08-31 14:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15755863', 'tblTempUsageDetail_20' ) end [2025-08-31 14:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755863', 'tblTempVendorCDR_20' ) start [2025-08-31 14:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15755863', 'tblTempVendorCDR_20' ) end [2025-08-31 14:25:18] Production.INFO: ProcessCDR(1,15755863,1,1,2) [2025-08-31 14:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15755863,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 14:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15755863,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 14:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15755863,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 14:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15755863,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 14:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755863', 'tblTempUsageDetail_20' ) start [2025-08-31 14:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15755863', 'tblTempUsageDetail_20' ) end [2025-08-31 14:25:25] Production.ERROR: pbx prc_insertCDR start [2025-08-31 14:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 14:25:26] Production.INFO: ==5047== Releasing lock... [2025-08-31 14:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 14:25:26] Production.INFO: 34.5 MB #Memory Used# [2025-08-31 15:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 12:25:05 [end_date_ymd] => 2025-08-31 15:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 12:25:05' and `end` < '2025-08-31 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-08-31 15:25:17] Production.INFO: count ==910 [2025-08-31 15:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 12:25:05 - End Time 2025-08-31 15:25:05 [2025-08-31 15:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 15:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756110', 'tblTempUsageDetail_20' ) start [2025-08-31 15:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756110', 'tblTempUsageDetail_20' ) end [2025-08-31 15:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756110', 'tblTempVendorCDR_20' ) start [2025-08-31 15:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756110', 'tblTempVendorCDR_20' ) end [2025-08-31 15:25:18] Production.INFO: ProcessCDR(1,15756110,1,1,2) [2025-08-31 15:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15756110,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 15:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15756110,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 15:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15756110,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 15:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15756110,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 15:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756110', 'tblTempUsageDetail_20' ) start [2025-08-31 15:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756110', 'tblTempUsageDetail_20' ) end [2025-08-31 15:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 15:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 15:25:27] Production.INFO: ==9457== Releasing lock... [2025-08-31 15:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 15:25:27] Production.INFO: 35 MB #Memory Used# [2025-08-31 16:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 13:25:06 [end_date_ymd] => 2025-08-31 16:25:06 [RateCDR] => 1 ) [2025-08-31 16: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-08-31 13:25:06' and `end` < '2025-08-31 16: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-08-31 16:25:18] Production.INFO: count ==1033 [2025-08-31 16:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 13:25:06 - End Time 2025-08-31 16:25:06 [2025-08-31 16:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 16:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756357', 'tblTempUsageDetail_20' ) start [2025-08-31 16:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756357', 'tblTempUsageDetail_20' ) end [2025-08-31 16:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756357', 'tblTempVendorCDR_20' ) start [2025-08-31 16:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756357', 'tblTempVendorCDR_20' ) end [2025-08-31 16:25:18] Production.INFO: ProcessCDR(1,15756357,1,1,2) [2025-08-31 16:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15756357,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 16:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15756357,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 16:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15756357,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 16:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15756357,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 16:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756357', 'tblTempUsageDetail_20' ) start [2025-08-31 16:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756357', 'tblTempUsageDetail_20' ) end [2025-08-31 16:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 16:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 16:25:26] Production.INFO: ==13768== Releasing lock... [2025-08-31 16:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 16:25:26] Production.INFO: 36.5 MB #Memory Used# [2025-08-31 17:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 14:25:05 [end_date_ymd] => 2025-08-31 17:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 14:25:05' and `end` < '2025-08-31 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-08-31 17:25:17] Production.INFO: count ==1280 [2025-08-31 17:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 14:25:05 - End Time 2025-08-31 17:25:05 [2025-08-31 17:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756604', 'tblTempUsageDetail_20' ) start [2025-08-31 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756604', 'tblTempUsageDetail_20' ) end [2025-08-31 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756604', 'tblTempVendorCDR_20' ) start [2025-08-31 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756604', 'tblTempVendorCDR_20' ) end [2025-08-31 17:25:18] Production.INFO: ProcessCDR(1,15756604,1,1,2) [2025-08-31 17:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15756604,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 17:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15756604,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 17:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15756604,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 17:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15756604,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 17:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756604', 'tblTempUsageDetail_20' ) start [2025-08-31 17:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756604', 'tblTempUsageDetail_20' ) end [2025-08-31 17:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 17:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 17:25:27] Production.INFO: ==18259== Releasing lock... [2025-08-31 17:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 17:25:27] Production.INFO: 38.5 MB #Memory Used# [2025-08-31 18:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 15:25:05 [end_date_ymd] => 2025-08-31 18:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 15:25:05' and `end` < '2025-08-31 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-08-31 18:25:18] Production.INFO: count ==1463 [2025-08-31 18:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 15:25:05 - End Time 2025-08-31 18:25:05 [2025-08-31 18:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756851', 'tblTempUsageDetail_20' ) start [2025-08-31 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15756851', 'tblTempUsageDetail_20' ) end [2025-08-31 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756851', 'tblTempVendorCDR_20' ) start [2025-08-31 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15756851', 'tblTempVendorCDR_20' ) end [2025-08-31 18:25:18] Production.INFO: ProcessCDR(1,15756851,1,1,2) [2025-08-31 18:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15756851,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 18:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15756851,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 18:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15756851,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 18:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15756851,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 18:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756851', 'tblTempUsageDetail_20' ) start [2025-08-31 18:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15756851', 'tblTempUsageDetail_20' ) end [2025-08-31 18:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 18:25:28] Production.ERROR: pbx prc_insertCDR end [2025-08-31 18:25:28] Production.INFO: ==22669== Releasing lock... [2025-08-31 18:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 18:25:28] Production.INFO: 39 MB #Memory Used# [2025-08-31 19:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 16:25:05 [end_date_ymd] => 2025-08-31 19:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 16:25:05' and `end` < '2025-08-31 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-08-31 19:25:18] Production.INFO: count ==1482 [2025-08-31 19:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 16:25:05 - End Time 2025-08-31 19:25:05 [2025-08-31 19:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 19:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757095', 'tblTempUsageDetail_20' ) start [2025-08-31 19:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757095', 'tblTempUsageDetail_20' ) end [2025-08-31 19:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757095', 'tblTempVendorCDR_20' ) start [2025-08-31 19:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757095', 'tblTempVendorCDR_20' ) end [2025-08-31 19:25:18] Production.INFO: ProcessCDR(1,15757095,1,1,2) [2025-08-31 19:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15757095,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 19:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15757095,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 19:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15757095,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 19:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15757095,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 19:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757095', 'tblTempUsageDetail_20' ) start [2025-08-31 19:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757095', 'tblTempUsageDetail_20' ) end [2025-08-31 19:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 19:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 19:25:27] Production.INFO: ==27067== Releasing lock... [2025-08-31 19:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 19:25:27] Production.INFO: 39.25 MB #Memory Used# [2025-08-31 20:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 17:25:06 [end_date_ymd] => 2025-08-31 20:25:06 [RateCDR] => 1 ) [2025-08-31 20: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-08-31 17:25:06' and `end` < '2025-08-31 20: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-08-31 20:25:18] Production.INFO: count ==1391 [2025-08-31 20:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 17:25:06 - End Time 2025-08-31 20:25:06 [2025-08-31 20:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757342', 'tblTempUsageDetail_20' ) start [2025-08-31 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757342', 'tblTempUsageDetail_20' ) end [2025-08-31 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757342', 'tblTempVendorCDR_20' ) start [2025-08-31 20:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757342', 'tblTempVendorCDR_20' ) end [2025-08-31 20:25:19] Production.INFO: ProcessCDR(1,15757342,1,1,2) [2025-08-31 20:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15757342,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 20:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15757342,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 20:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15757342,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 20:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15757342,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 20:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757342', 'tblTempUsageDetail_20' ) start [2025-08-31 20:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757342', 'tblTempUsageDetail_20' ) end [2025-08-31 20:25:27] Production.ERROR: pbx prc_insertCDR start [2025-08-31 20:25:27] Production.ERROR: pbx prc_insertCDR end [2025-08-31 20:25:27] Production.INFO: ==31393== Releasing lock... [2025-08-31 20:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 20:25:27] Production.INFO: 38.75 MB #Memory Used# [2025-08-31 21:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 18:25:05 [end_date_ymd] => 2025-08-31 21:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 18:25:05' and `end` < '2025-08-31 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-08-31 21:25:18] Production.INFO: count ==1322 [2025-08-31 21:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 18:25:05 - End Time 2025-08-31 21:25:05 [2025-08-31 21:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757589', 'tblTempUsageDetail_20' ) start [2025-08-31 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757589', 'tblTempUsageDetail_20' ) end [2025-08-31 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757589', 'tblTempVendorCDR_20' ) start [2025-08-31 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757589', 'tblTempVendorCDR_20' ) end [2025-08-31 21:25:18] Production.INFO: ProcessCDR(1,15757589,1,1,2) [2025-08-31 21:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15757589,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 21:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15757589,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 21:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15757589,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 21:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15757589,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 21:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757589', 'tblTempUsageDetail_20' ) start [2025-08-31 21:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757589', 'tblTempUsageDetail_20' ) end [2025-08-31 21:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 21:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 21:25:26] Production.INFO: ==3299== Releasing lock... [2025-08-31 21:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 21:25:26] Production.INFO: 38.5 MB #Memory Used# [2025-08-31 22:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 19:25:05 [end_date_ymd] => 2025-08-31 22:25:05 [RateCDR] => 1 ) [2025-08-31 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-08-31 19:25:05' and `end` < '2025-08-31 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-08-31 22:25:17] Production.INFO: count ==1269 [2025-08-31 22:25:18] Production.ERROR: pbx CDR StartTime 2025-08-31 19:25:05 - End Time 2025-08-31 22:25:05 [2025-08-31 22:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757836', 'tblTempUsageDetail_20' ) start [2025-08-31 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15757836', 'tblTempUsageDetail_20' ) end [2025-08-31 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757836', 'tblTempVendorCDR_20' ) start [2025-08-31 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15757836', 'tblTempVendorCDR_20' ) end [2025-08-31 22:25:18] Production.INFO: ProcessCDR(1,15757836,1,1,2) [2025-08-31 22:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15757836,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 22:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15757836,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 22:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15757836,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 22:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15757836,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 22:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757836', 'tblTempUsageDetail_20' ) start [2025-08-31 22:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15757836', 'tblTempUsageDetail_20' ) end [2025-08-31 22:25:26] Production.ERROR: pbx prc_insertCDR start [2025-08-31 22:25:26] Production.ERROR: pbx prc_insertCDR end [2025-08-31 22:25:26] Production.INFO: ==7918== Releasing lock... [2025-08-31 22:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 22:25:26] Production.INFO: 38.5 MB #Memory Used# [2025-08-31 23:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-08-31 20:25:06 [end_date_ymd] => 2025-08-31 23:25:06 [RateCDR] => 1 ) [2025-08-31 23: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-08-31 20:25:06' and `end` < '2025-08-31 23: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-08-31 23:25:18] Production.INFO: count ==1223 [2025-08-31 23:25:19] Production.ERROR: pbx CDR StartTime 2025-08-31 20:25:06 - End Time 2025-08-31 23:25:06 [2025-08-31 23:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-08-31 23:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15758083', 'tblTempUsageDetail_20' ) start [2025-08-31 23:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15758083', 'tblTempUsageDetail_20' ) end [2025-08-31 23:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15758083', 'tblTempVendorCDR_20' ) start [2025-08-31 23:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15758083', 'tblTempVendorCDR_20' ) end [2025-08-31 23:25:19] Production.INFO: ProcessCDR(1,15758083,1,1,2) [2025-08-31 23:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15758083,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 23:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15758083,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-08-31 23:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15758083,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 23:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15758083,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-08-31 23:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15758083', 'tblTempUsageDetail_20' ) start [2025-08-31 23:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15758083', 'tblTempUsageDetail_20' ) end [2025-08-31 23:25:27] Production.ERROR: pbx prc_insertCDR start [2025-08-31 23:25:28] Production.ERROR: pbx prc_insertCDR end [2025-08-31 23:25:28] Production.INFO: ==12375== Releasing lock... [2025-08-31 23:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-08-31 23:25:28] Production.INFO: 37.5 MB #Memory Used#