[2025-11-28 00:00:06] Production.INFO: next invoice date [2025-11-28 00:00:06] Production.INFO: 2025-12-28 [2025-11-28 00:00:06] Production.INFO: getdaysdiff [2025-11-28 00:00:06] Production.INFO: +30 [2025-11-28 00:00:06] Production.INFO: call prc_setAccountDiscountPlan (103,10,2,30,30,'RMScheduler',2025-11-28 00:00:06,1,0,,,0) [2025-11-28 00:00:06] Production.INFO: next invoice date [2025-11-28 00:00:06] Production.INFO: 2025-12-28 [2025-11-28 00:00:06] Production.INFO: getdaysdiff [2025-11-28 00:00:06] Production.INFO: +30 [2025-11-28 00:00:06] Production.INFO: call prc_setAccountDiscountPlan (103,16,1,30,30,'RMScheduler',2025-11-28 00:00:06,1,0,,,0) [2025-11-28 00:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-27 21:00:07 [end_date_ymd] => 2025-11-28 00:00:07 [RateCDR] => 1 ) [2025-11-28 00:00:07] 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-11-27 21:00:07' and `end` < '2025-11-28 00:00:07' 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-11-28 00:00:20] Production.INFO: count ==915 [2025-11-28 00:00:21] Production.ERROR: pbx CDR StartTime 2025-11-27 21:00:07 - End Time 2025-11-28 00:00:07 [2025-11-28 00:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280126', 'tblTempUsageDetail_20' ) start [2025-11-28 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280126', 'tblTempUsageDetail_20' ) end [2025-11-28 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280126', 'tblTempVendorCDR_20' ) start [2025-11-28 00:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280126', 'tblTempVendorCDR_20' ) end [2025-11-28 00:00:21] Production.INFO: ProcessCDR(1,16280126,1,1,2) [2025-11-28 00:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16280126,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 00:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16280126,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 00:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16280126,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 00:00:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16280126,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 00:00:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280126', 'tblTempUsageDetail_20' ) start [2025-11-28 00:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280126', 'tblTempUsageDetail_20' ) end [2025-11-28 00:00:35] Production.ERROR: pbx prc_insertCDR start [2025-11-28 00:00:35] Production.ERROR: pbx prc_insertCDR end [2025-11-28 00:00:37] Production.INFO: ==4551== Releasing lock... [2025-11-28 00:00:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 00:00:37] Production.INFO: 38.75 MB #Memory Used# [2025-11-28 01:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-27 22:00:06 [end_date_ymd] => 2025-11-28 01:00:06 [RateCDR] => 1 ) [2025-11-28 01:00: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-11-27 22:00:06' and `end` < '2025-11-28 01:00: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-11-28 01:00:19] Production.INFO: count ==692 [2025-11-28 01:00:20] Production.ERROR: pbx CDR StartTime 2025-11-27 22:00:06 - End Time 2025-11-28 01:00:06 [2025-11-28 01:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 01:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280373', 'tblTempUsageDetail_20' ) start [2025-11-28 01:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280373', 'tblTempUsageDetail_20' ) end [2025-11-28 01:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280373', 'tblTempVendorCDR_20' ) start [2025-11-28 01:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280373', 'tblTempVendorCDR_20' ) end [2025-11-28 01:00:20] Production.INFO: ProcessCDR(1,16280373,1,1,2) [2025-11-28 01:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16280373,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 01:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16280373,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 01:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16280373,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 01:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16280373,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 01:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280373', 'tblTempUsageDetail_20' ) start [2025-11-28 01:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280373', 'tblTempUsageDetail_20' ) end [2025-11-28 01:00:31] Production.ERROR: pbx prc_insertCDR start [2025-11-28 01:00:31] Production.ERROR: pbx prc_insertCDR end [2025-11-28 01:00:31] Production.INFO: ==9136== Releasing lock... [2025-11-28 01:00:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 01:00:31] Production.INFO: 33.75 MB #Memory Used# [2025-11-28 02:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-27 23:00:07 [end_date_ymd] => 2025-11-28 02:00:07 [RateCDR] => 1 ) [2025-11-28 02:00:07] 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-11-27 23:00:07' and `end` < '2025-11-28 02:00:07' 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-11-28 02:00:19] Production.INFO: count ==648 [2025-11-28 02:00:19] Production.ERROR: pbx CDR StartTime 2025-11-27 23:00:07 - End Time 2025-11-28 02:00:07 [2025-11-28 02:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280620', 'tblTempUsageDetail_20' ) start [2025-11-28 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280620', 'tblTempUsageDetail_20' ) end [2025-11-28 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280620', 'tblTempVendorCDR_20' ) start [2025-11-28 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280620', 'tblTempVendorCDR_20' ) end [2025-11-28 02:00:19] Production.INFO: ProcessCDR(1,16280620,1,1,2) [2025-11-28 02:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16280620,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 02:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16280620,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 02:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16280620,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 02:00:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16280620,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 02:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280620', 'tblTempUsageDetail_20' ) start [2025-11-28 02:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280620', 'tblTempUsageDetail_20' ) end [2025-11-28 02:00:31] Production.ERROR: pbx prc_insertCDR start [2025-11-28 02:00:32] Production.ERROR: pbx prc_insertCDR end [2025-11-28 02:00:32] Production.INFO: ==13930== Releasing lock... [2025-11-28 02:00:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 02:00:32] Production.INFO: 33.25 MB #Memory Used# [2025-11-28 03:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 00:00:06 [end_date_ymd] => 2025-11-28 03:00:06 [RateCDR] => 1 ) [2025-11-28 03:00: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-11-28 00:00:06' and `end` < '2025-11-28 03:00: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-11-28 03:00:18] Production.INFO: count ==958 [2025-11-28 03:00:19] Production.ERROR: pbx CDR StartTime 2025-11-28 00:00:06 - End Time 2025-11-28 03:00:06 [2025-11-28 03:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 03:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280866', 'tblTempUsageDetail_20' ) start [2025-11-28 03:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16280866', 'tblTempUsageDetail_20' ) end [2025-11-28 03:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280866', 'tblTempVendorCDR_20' ) start [2025-11-28 03:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16280866', 'tblTempVendorCDR_20' ) end [2025-11-28 03:00:19] Production.INFO: ProcessCDR(1,16280866,1,1,2) [2025-11-28 03:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16280866,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 03:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16280866,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 03:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16280866,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 03:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16280866,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 03:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280866', 'tblTempUsageDetail_20' ) start [2025-11-28 03:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16280866', 'tblTempUsageDetail_20' ) end [2025-11-28 03:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-28 03:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-28 03:00:30] Production.INFO: ==18874== Releasing lock... [2025-11-28 03:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 03:00:30] Production.INFO: 35.5 MB #Memory Used# [2025-11-28 04:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 01:00:06 [end_date_ymd] => 2025-11-28 04:00:06 [RateCDR] => 1 ) [2025-11-28 04:00: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-11-28 01:00:06' and `end` < '2025-11-28 04:00: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-11-28 04:00:18] Production.INFO: count ==856 [2025-11-28 04:00:18] Production.ERROR: pbx CDR StartTime 2025-11-28 01:00:06 - End Time 2025-11-28 04:00:06 [2025-11-28 04:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281114', 'tblTempUsageDetail_20' ) start [2025-11-28 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281114', 'tblTempUsageDetail_20' ) end [2025-11-28 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281114', 'tblTempVendorCDR_20' ) start [2025-11-28 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281114', 'tblTempVendorCDR_20' ) end [2025-11-28 04:00:18] Production.INFO: ProcessCDR(1,16281114,1,1,2) [2025-11-28 04:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16281114,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 04:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16281114,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 04:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16281114,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 04:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16281114,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 04:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281114', 'tblTempUsageDetail_20' ) start [2025-11-28 04:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281114', 'tblTempUsageDetail_20' ) end [2025-11-28 04:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-28 04:00:29] Production.ERROR: pbx prc_insertCDR end [2025-11-28 04:00:29] Production.INFO: ==23878== Releasing lock... [2025-11-28 04:00:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 04:00:29] Production.INFO: 34.75 MB #Memory Used# [2025-11-28 05:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 02:00:07 [end_date_ymd] => 2025-11-28 05:00:07 [RateCDR] => 1 ) [2025-11-28 05:00:07] 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-11-28 02:00:07' and `end` < '2025-11-28 05:00:07' 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-11-28 05:00:19] Production.INFO: count ==1005 [2025-11-28 05:00:20] Production.ERROR: pbx CDR StartTime 2025-11-28 02:00:07 - End Time 2025-11-28 05:00:07 [2025-11-28 05:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 05:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281363', 'tblTempUsageDetail_20' ) start [2025-11-28 05:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281363', 'tblTempUsageDetail_20' ) end [2025-11-28 05:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281363', 'tblTempVendorCDR_20' ) start [2025-11-28 05:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281363', 'tblTempVendorCDR_20' ) end [2025-11-28 05:00:20] Production.INFO: ProcessCDR(1,16281363,1,1,2) [2025-11-28 05:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16281363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 05:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16281363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 05:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16281363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 05:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16281363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 05:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281363', 'tblTempUsageDetail_20' ) start [2025-11-28 05:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281363', 'tblTempUsageDetail_20' ) end [2025-11-28 05:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-28 05:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-28 05:00:30] Production.INFO: ==29377== Releasing lock... [2025-11-28 05:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 05:00:30] Production.INFO: 36.5 MB #Memory Used# [2025-11-28 06:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 03:00:06 [end_date_ymd] => 2025-11-28 06:00:06 [RateCDR] => 1 ) [2025-11-28 06:00: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-11-28 03:00:06' and `end` < '2025-11-28 06:00: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-11-28 06:00:18] Production.INFO: count ==535 [2025-11-28 06:00:18] Production.ERROR: pbx CDR StartTime 2025-11-28 03:00:06 - End Time 2025-11-28 06:00:06 [2025-11-28 06:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281610', 'tblTempUsageDetail_20' ) start [2025-11-28 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281610', 'tblTempUsageDetail_20' ) end [2025-11-28 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281610', 'tblTempVendorCDR_20' ) start [2025-11-28 06:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281610', 'tblTempVendorCDR_20' ) end [2025-11-28 06:00:18] Production.INFO: ProcessCDR(1,16281610,1,1,2) [2025-11-28 06:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16281610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 06:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16281610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 06:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16281610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 06:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16281610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 06:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281610', 'tblTempUsageDetail_20' ) start [2025-11-28 06:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281610', 'tblTempUsageDetail_20' ) end [2025-11-28 06:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-28 06:00:29] Production.ERROR: pbx prc_insertCDR end [2025-11-28 06:00:29] Production.INFO: ==3319== Releasing lock... [2025-11-28 06:00:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 06:00:29] Production.INFO: 32.5 MB #Memory Used# [2025-11-28 07:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 04:00:06 [end_date_ymd] => 2025-11-28 07:00:06 [RateCDR] => 1 ) [2025-11-28 07:00: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-11-28 04:00:06' and `end` < '2025-11-28 07:00: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-11-28 07:00:18] Production.INFO: count ==358 [2025-11-28 07:00:18] Production.ERROR: pbx CDR StartTime 2025-11-28 04:00:06 - End Time 2025-11-28 07:00:06 [2025-11-28 07:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281857', 'tblTempUsageDetail_20' ) start [2025-11-28 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16281857', 'tblTempUsageDetail_20' ) end [2025-11-28 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281857', 'tblTempVendorCDR_20' ) start [2025-11-28 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16281857', 'tblTempVendorCDR_20' ) end [2025-11-28 07:00:18] Production.INFO: ProcessCDR(1,16281857,1,1,2) [2025-11-28 07:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16281857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 07:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16281857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 07:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16281857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 07:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16281857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 07:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281857', 'tblTempUsageDetail_20' ) start [2025-11-28 07:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16281857', 'tblTempUsageDetail_20' ) end [2025-11-28 07:00:28] Production.ERROR: pbx prc_insertCDR start [2025-11-28 07:00:28] Production.ERROR: pbx prc_insertCDR end [2025-11-28 07:00:28] Production.INFO: ==8519== Releasing lock... [2025-11-28 07:00:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 07:00:28] Production.INFO: 31.5 MB #Memory Used# [2025-11-28 08:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 05:00:06 [end_date_ymd] => 2025-11-28 08:00:06 [RateCDR] => 1 ) [2025-11-28 08:00: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-11-28 05:00:06' and `end` < '2025-11-28 08:00: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-11-28 08:00:18] Production.INFO: count ==214 [2025-11-28 08:00:18] Production.ERROR: pbx CDR StartTime 2025-11-28 05:00:06 - End Time 2025-11-28 08:00:06 [2025-11-28 08:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282104', 'tblTempUsageDetail_20' ) start [2025-11-28 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282104', 'tblTempUsageDetail_20' ) end [2025-11-28 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282104', 'tblTempVendorCDR_20' ) start [2025-11-28 08:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282104', 'tblTempVendorCDR_20' ) end [2025-11-28 08:00:18] Production.INFO: ProcessCDR(1,16282104,1,1,2) [2025-11-28 08:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16282104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 08:00:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16282104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 08:00:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16282104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 08:00:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16282104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 08:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282104', 'tblTempUsageDetail_20' ) start [2025-11-28 08:00:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282104', 'tblTempUsageDetail_20' ) end [2025-11-28 08:00:28] Production.ERROR: pbx prc_insertCDR start [2025-11-28 08:00:28] Production.ERROR: pbx prc_insertCDR end [2025-11-28 08:00:28] Production.INFO: ==13333== Releasing lock... [2025-11-28 08:00:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 08:00:28] Production.INFO: 29.75 MB #Memory Used# [2025-11-28 09:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 06:00:06 [end_date_ymd] => 2025-11-28 09:00:06 [RateCDR] => 1 ) [2025-11-28 09:00: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-11-28 06:00:06' and `end` < '2025-11-28 09:00: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-11-28 09:00:19] Production.INFO: count ==1071 [2025-11-28 09:00:19] Production.ERROR: pbx CDR StartTime 2025-11-28 06:00:06 - End Time 2025-11-28 09:00:06 [2025-11-28 09:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282350', 'tblTempUsageDetail_20' ) start [2025-11-28 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282350', 'tblTempUsageDetail_20' ) end [2025-11-28 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282350', 'tblTempVendorCDR_20' ) start [2025-11-28 09:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282350', 'tblTempVendorCDR_20' ) end [2025-11-28 09:00:19] Production.INFO: ProcessCDR(1,16282350,1,1,2) [2025-11-28 09:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16282350,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 09:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16282350,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 09:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16282350,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 09:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16282350,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 09:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282350', 'tblTempUsageDetail_20' ) start [2025-11-28 09:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282350', 'tblTempUsageDetail_20' ) end [2025-11-28 09:00:31] Production.ERROR: pbx prc_insertCDR start [2025-11-28 09:00:31] Production.ERROR: pbx prc_insertCDR end [2025-11-28 09:00:31] Production.INFO: ==18255== Releasing lock... [2025-11-28 09:00:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 09:00:31] Production.INFO: 36.5 MB #Memory Used# [2025-11-28 10:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 07:00:06 [end_date_ymd] => 2025-11-28 10:00:06 [RateCDR] => 1 ) [2025-11-28 10:00: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-11-28 07:00:06' and `end` < '2025-11-28 10:00: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-11-28 10:00:20] Production.INFO: count ==2462 [2025-11-28 10:00:21] Production.ERROR: pbx CDR StartTime 2025-11-28 07:00:06 - End Time 2025-11-28 10:00:06 [2025-11-28 10:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 10:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282598', 'tblTempUsageDetail_20' ) start [2025-11-28 10:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282598', 'tblTempUsageDetail_20' ) end [2025-11-28 10:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282598', 'tblTempVendorCDR_20' ) start [2025-11-28 10:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282598', 'tblTempVendorCDR_20' ) end [2025-11-28 10:00:21] Production.INFO: ProcessCDR(1,16282598,1,1,2) [2025-11-28 10:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16282598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 10:00:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16282598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 10:00:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16282598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 10:00:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16282598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 10:00:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282598', 'tblTempUsageDetail_20' ) start [2025-11-28 10:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282598', 'tblTempUsageDetail_20' ) end [2025-11-28 10:00:33] Production.ERROR: pbx prc_insertCDR start [2025-11-28 10:00:35] Production.ERROR: pbx prc_insertCDR end [2025-11-28 10:00:35] Production.INFO: ==23062== Releasing lock... [2025-11-28 10:00:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 10:00:35] Production.INFO: 47 MB #Memory Used# [2025-11-28 11:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 08:00:06 [end_date_ymd] => 2025-11-28 11:00:06 [RateCDR] => 1 ) [2025-11-28 11:00: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-11-28 08:00:06' and `end` < '2025-11-28 11:00: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-11-28 11:00:19] Production.INFO: count ==4773 [2025-11-28 11:00:22] Production.ERROR: pbx CDR StartTime 2025-11-28 08:00:06 - End Time 2025-11-28 11:00:06 [2025-11-28 11:00:22] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 11:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282845', 'tblTempUsageDetail_20' ) start [2025-11-28 11:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16282845', 'tblTempUsageDetail_20' ) end [2025-11-28 11:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282845', 'tblTempVendorCDR_20' ) start [2025-11-28 11:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16282845', 'tblTempVendorCDR_20' ) end [2025-11-28 11:00:22] Production.INFO: ProcessCDR(1,16282845,1,1,2) [2025-11-28 11:00:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16282845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 11:00:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16282845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 11:00:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16282845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 11:00:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16282845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 11:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282845', 'tblTempUsageDetail_20' ) start [2025-11-28 11:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16282845', 'tblTempUsageDetail_20' ) end [2025-11-28 11:00:35] Production.ERROR: pbx prc_insertCDR start [2025-11-28 11:00:38] Production.ERROR: pbx prc_insertCDR end [2025-11-28 11:00:38] Production.INFO: ==27955== Releasing lock... [2025-11-28 11:00:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 11:00:38] Production.INFO: 64 MB #Memory Used# [2025-11-28 12:00:07] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 09:00:07 [end_date_ymd] => 2025-11-28 12:00:07 [RateCDR] => 1 ) [2025-11-28 12:00:07] 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-11-28 09:00:07' and `end` < '2025-11-28 12:00:07' 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-11-28 12:00:20] Production.INFO: count ==6109 [2025-11-28 12:00:23] Production.ERROR: pbx CDR StartTime 2025-11-28 09:00:07 - End Time 2025-11-28 12:00:07 [2025-11-28 12:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 12:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283092', 'tblTempUsageDetail_20' ) start [2025-11-28 12:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283092', 'tblTempUsageDetail_20' ) end [2025-11-28 12:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283092', 'tblTempVendorCDR_20' ) start [2025-11-28 12:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283092', 'tblTempVendorCDR_20' ) end [2025-11-28 12:00:24] Production.INFO: ProcessCDR(1,16283092,1,1,2) [2025-11-28 12:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16283092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 12:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16283092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 12:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16283092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 12:00:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16283092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 12:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283092', 'tblTempUsageDetail_20' ) start [2025-11-28 12:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283092', 'tblTempUsageDetail_20' ) end [2025-11-28 12:00:37] Production.ERROR: pbx prc_insertCDR start [2025-11-28 12:00:40] Production.ERROR: pbx prc_insertCDR end [2025-11-28 12:00:40] Production.INFO: ==365== Releasing lock... [2025-11-28 12:00:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 12:00:40] Production.INFO: 74 MB #Memory Used# [2025-11-28 13:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 10:00:06 [end_date_ymd] => 2025-11-28 13:00:06 [RateCDR] => 1 ) [2025-11-28 13:00: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-11-28 10:00:06' and `end` < '2025-11-28 13:00: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-11-28 13:00:21] Production.INFO: count ==6405 [2025-11-28 13:00:24] Production.ERROR: pbx CDR StartTime 2025-11-28 10:00:06 - End Time 2025-11-28 13:00:06 [2025-11-28 13:00:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283339', 'tblTempUsageDetail_20' ) start [2025-11-28 13:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283339', 'tblTempUsageDetail_20' ) end [2025-11-28 13:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283339', 'tblTempVendorCDR_20' ) start [2025-11-28 13:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283339', 'tblTempVendorCDR_20' ) end [2025-11-28 13:00:25] Production.INFO: ProcessCDR(1,16283339,1,1,2) [2025-11-28 13:00:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16283339,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 13:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16283339,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 13:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16283339,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 13:00:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16283339,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 13:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283339', 'tblTempUsageDetail_20' ) start [2025-11-28 13:00:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283339', 'tblTempUsageDetail_20' ) end [2025-11-28 13:00:37] Production.ERROR: pbx prc_insertCDR start [2025-11-28 13:00:39] Production.ERROR: pbx prc_insertCDR end [2025-11-28 13:00:39] Production.INFO: ==5119== Releasing lock... [2025-11-28 13:00:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 13:00:39] Production.INFO: 76.25 MB #Memory Used# [2025-11-28 14:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 11:00:06 [end_date_ymd] => 2025-11-28 14:00:06 [RateCDR] => 1 ) [2025-11-28 14:00: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-11-28 11:00:06' and `end` < '2025-11-28 14:00: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-11-28 14:00:24] Production.INFO: count ==5896 [2025-11-28 14:00:27] Production.ERROR: pbx CDR StartTime 2025-11-28 11:00:06 - End Time 2025-11-28 14:00:06 [2025-11-28 14:00:27] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 14:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283585', 'tblTempUsageDetail_20' ) start [2025-11-28 14:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283585', 'tblTempUsageDetail_20' ) end [2025-11-28 14:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283585', 'tblTempVendorCDR_20' ) start [2025-11-28 14:00:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283585', 'tblTempVendorCDR_20' ) end [2025-11-28 14:00:27] Production.INFO: ProcessCDR(1,16283585,1,1,2) [2025-11-28 14:00:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16283585,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 14:00:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16283585,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 14:00:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16283585,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 14:00:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16283585,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 14:00:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283585', 'tblTempUsageDetail_20' ) start [2025-11-28 14:00:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283585', 'tblTempUsageDetail_20' ) end [2025-11-28 14:00:39] Production.ERROR: pbx prc_insertCDR start [2025-11-28 14:00:42] Production.ERROR: pbx prc_insertCDR end [2025-11-28 14:00:42] Production.INFO: ==9810== Releasing lock... [2025-11-28 14:00:42] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 14:00:42] Production.INFO: 72.5 MB #Memory Used# [2025-11-28 15:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 12:00:06 [end_date_ymd] => 2025-11-28 15:00:06 [RateCDR] => 1 ) [2025-11-28 15:00: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-11-28 12:00:06' and `end` < '2025-11-28 15:00: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-11-28 15:00:20] Production.INFO: count ==5760 [2025-11-28 15:00:23] Production.ERROR: pbx CDR StartTime 2025-11-28 12:00:06 - End Time 2025-11-28 15:00:06 [2025-11-28 15:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283833', 'tblTempUsageDetail_20' ) start [2025-11-28 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16283833', 'tblTempUsageDetail_20' ) end [2025-11-28 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283833', 'tblTempVendorCDR_20' ) start [2025-11-28 15:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16283833', 'tblTempVendorCDR_20' ) end [2025-11-28 15:00:23] Production.INFO: ProcessCDR(1,16283833,1,1,2) [2025-11-28 15:00:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16283833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 15:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16283833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 15:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16283833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 15:00:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16283833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 15:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283833', 'tblTempUsageDetail_20' ) start [2025-11-28 15:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16283833', 'tblTempUsageDetail_20' ) end [2025-11-28 15:00:36] Production.ERROR: pbx prc_insertCDR start [2025-11-28 15:00:38] Production.ERROR: pbx prc_insertCDR end [2025-11-28 15:00:38] Production.INFO: ==14366== Releasing lock... [2025-11-28 15:00:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 15:00:38] Production.INFO: 71.25 MB #Memory Used# [2025-11-28 16:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 13:00:06 [end_date_ymd] => 2025-11-28 16:00:06 [RateCDR] => 1 ) [2025-11-28 16:00: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-11-28 13:00:06' and `end` < '2025-11-28 16:00: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-11-28 16:00:21] Production.INFO: count ==5949 [2025-11-28 16:00:24] Production.ERROR: pbx CDR StartTime 2025-11-28 13:00:06 - End Time 2025-11-28 16:00:06 [2025-11-28 16:00:24] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 16:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284080', 'tblTempUsageDetail_20' ) start [2025-11-28 16:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284080', 'tblTempUsageDetail_20' ) end [2025-11-28 16:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284080', 'tblTempVendorCDR_20' ) start [2025-11-28 16:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284080', 'tblTempVendorCDR_20' ) end [2025-11-28 16:00:24] Production.INFO: ProcessCDR(1,16284080,1,1,2) [2025-11-28 16:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16284080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 16:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16284080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 16:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16284080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 16:00:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16284080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 16:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284080', 'tblTempUsageDetail_20' ) start [2025-11-28 16:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284080', 'tblTempUsageDetail_20' ) end [2025-11-28 16:00:36] Production.ERROR: pbx prc_insertCDR start [2025-11-28 16:00:39] Production.ERROR: pbx prc_insertCDR end [2025-11-28 16:00:39] Production.INFO: ==18739== Releasing lock... [2025-11-28 16:00:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 16:00:39] Production.INFO: 72.75 MB #Memory Used# [2025-11-28 17:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 14:00:06 [end_date_ymd] => 2025-11-28 17:00:06 [RateCDR] => 1 ) [2025-11-28 17:00: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-11-28 14:00:06' and `end` < '2025-11-28 17:00: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-11-28 17:00:21] Production.INFO: count ==5871 [2025-11-28 17:00:23] Production.ERROR: pbx CDR StartTime 2025-11-28 14:00:06 - End Time 2025-11-28 17:00:06 [2025-11-28 17:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 17:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284326', 'tblTempUsageDetail_20' ) start [2025-11-28 17:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284326', 'tblTempUsageDetail_20' ) end [2025-11-28 17:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284326', 'tblTempVendorCDR_20' ) start [2025-11-28 17:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284326', 'tblTempVendorCDR_20' ) end [2025-11-28 17:00:24] Production.INFO: ProcessCDR(1,16284326,1,1,2) [2025-11-28 17:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16284326,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 17:00:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16284326,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 17:00:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16284326,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 17:00:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16284326,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 17:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284326', 'tblTempUsageDetail_20' ) start [2025-11-28 17:00:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284326', 'tblTempUsageDetail_20' ) end [2025-11-28 17:00:36] Production.ERROR: pbx prc_insertCDR start [2025-11-28 17:00:38] Production.ERROR: pbx prc_insertCDR end [2025-11-28 17:00:38] Production.INFO: ==23290== Releasing lock... [2025-11-28 17:00:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 17:00:38] Production.INFO: 72.25 MB #Memory Used# [2025-11-28 18:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 15:00:06 [end_date_ymd] => 2025-11-28 18:00:06 [RateCDR] => 1 ) [2025-11-28 18:00: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-11-28 15:00:06' and `end` < '2025-11-28 18:00: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-11-28 18:00:21] Production.INFO: count ==5379 [2025-11-28 18:00:23] Production.ERROR: pbx CDR StartTime 2025-11-28 15:00:06 - End Time 2025-11-28 18:00:06 [2025-11-28 18:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 18:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284571', 'tblTempUsageDetail_20' ) start [2025-11-28 18:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284571', 'tblTempUsageDetail_20' ) end [2025-11-28 18:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284571', 'tblTempVendorCDR_20' ) start [2025-11-28 18:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284571', 'tblTempVendorCDR_20' ) end [2025-11-28 18:00:23] Production.INFO: ProcessCDR(1,16284571,1,1,2) [2025-11-28 18:00:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16284571,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 18:00:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16284571,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 18:00:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16284571,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 18:00:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16284571,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 18:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284571', 'tblTempUsageDetail_20' ) start [2025-11-28 18:00:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284571', 'tblTempUsageDetail_20' ) end [2025-11-28 18:00:35] Production.ERROR: pbx prc_insertCDR start [2025-11-28 18:00:36] Production.ERROR: pbx prc_insertCDR end [2025-11-28 18:00:36] Production.INFO: ==28158== Releasing lock... [2025-11-28 18:00:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 18:00:36] Production.INFO: 68.5 MB #Memory Used# [2025-11-28 19:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 16:00:06 [end_date_ymd] => 2025-11-28 19:00:06 [RateCDR] => 1 ) [2025-11-28 19:00: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-11-28 16:00:06' and `end` < '2025-11-28 19:00: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-11-28 19:00:19] Production.INFO: count ==4720 [2025-11-28 19:00:21] Production.ERROR: pbx CDR StartTime 2025-11-28 16:00:06 - End Time 2025-11-28 19:00:06 [2025-11-28 19:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284817', 'tblTempUsageDetail_20' ) start [2025-11-28 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16284817', 'tblTempUsageDetail_20' ) end [2025-11-28 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284817', 'tblTempVendorCDR_20' ) start [2025-11-28 19:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16284817', 'tblTempVendorCDR_20' ) end [2025-11-28 19:00:21] Production.INFO: ProcessCDR(1,16284817,1,1,2) [2025-11-28 19:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16284817,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 19:00:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16284817,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 19:00:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16284817,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 19:00:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16284817,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 19:00:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284817', 'tblTempUsageDetail_20' ) start [2025-11-28 19:00:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16284817', 'tblTempUsageDetail_20' ) end [2025-11-28 19:00:33] Production.ERROR: pbx prc_insertCDR start [2025-11-28 19:00:34] Production.ERROR: pbx prc_insertCDR end [2025-11-28 19:00:34] Production.INFO: ==2194== Releasing lock... [2025-11-28 19:00:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 19:00:34] Production.INFO: 63.5 MB #Memory Used# [2025-11-28 20:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 17:00:06 [end_date_ymd] => 2025-11-28 20:00:06 [RateCDR] => 1 ) [2025-11-28 20:00: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-11-28 17:00:06' and `end` < '2025-11-28 20:00: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-11-28 20:00:18] Production.INFO: count ==3753 [2025-11-28 20:00:20] Production.ERROR: pbx CDR StartTime 2025-11-28 17:00:06 - End Time 2025-11-28 20:00:06 [2025-11-28 20:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285065', 'tblTempUsageDetail_20' ) start [2025-11-28 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285065', 'tblTempUsageDetail_20' ) end [2025-11-28 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285065', 'tblTempVendorCDR_20' ) start [2025-11-28 20:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285065', 'tblTempVendorCDR_20' ) end [2025-11-28 20:00:20] Production.INFO: ProcessCDR(1,16285065,1,1,2) [2025-11-28 20:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16285065,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 20:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16285065,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 20:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16285065,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 20:00:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16285065,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 20:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285065', 'tblTempUsageDetail_20' ) start [2025-11-28 20:00:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285065', 'tblTempUsageDetail_20' ) end [2025-11-28 20:00:32] Production.ERROR: pbx prc_insertCDR start [2025-11-28 20:00:32] Production.ERROR: pbx prc_insertCDR end [2025-11-28 20:00:32] Production.INFO: ==7043== Releasing lock... [2025-11-28 20:00:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 20:00:32] Production.INFO: 56.25 MB #Memory Used# [2025-11-28 21:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 18:00:06 [end_date_ymd] => 2025-11-28 21:00:06 [RateCDR] => 1 ) [2025-11-28 21:00: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-11-28 18:00:06' and `end` < '2025-11-28 21:00: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-11-28 21:00:18] Production.INFO: count ==2971 [2025-11-28 21:00:20] Production.ERROR: pbx CDR StartTime 2025-11-28 18:00:06 - End Time 2025-11-28 21:00:06 [2025-11-28 21:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 21:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285312', 'tblTempUsageDetail_20' ) start [2025-11-28 21:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285312', 'tblTempUsageDetail_20' ) end [2025-11-28 21:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285312', 'tblTempVendorCDR_20' ) start [2025-11-28 21:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285312', 'tblTempVendorCDR_20' ) end [2025-11-28 21:00:20] Production.INFO: ProcessCDR(1,16285312,1,1,2) [2025-11-28 21:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16285312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 21:00:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16285312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 21:00:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16285312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 21:00:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16285312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 21:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285312', 'tblTempUsageDetail_20' ) start [2025-11-28 21:00:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285312', 'tblTempUsageDetail_20' ) end [2025-11-28 21:00:31] Production.ERROR: pbx prc_insertCDR start [2025-11-28 21:00:32] Production.ERROR: pbx prc_insertCDR end [2025-11-28 21:00:32] Production.INFO: ==11656== Releasing lock... [2025-11-28 21:00:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 21:00:32] Production.INFO: 50.25 MB #Memory Used# [2025-11-28 22:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 19:00:06 [end_date_ymd] => 2025-11-28 22:00:06 [RateCDR] => 1 ) [2025-11-28 22:00: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-11-28 19:00:06' and `end` < '2025-11-28 22:00: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-11-28 22:00:18] Production.INFO: count ==2215 [2025-11-28 22:00:19] Production.ERROR: pbx CDR StartTime 2025-11-28 19:00:06 - End Time 2025-11-28 22:00:06 [2025-11-28 22:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285559', 'tblTempUsageDetail_20' ) start [2025-11-28 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285559', 'tblTempUsageDetail_20' ) end [2025-11-28 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285559', 'tblTempVendorCDR_20' ) start [2025-11-28 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285559', 'tblTempVendorCDR_20' ) end [2025-11-28 22:00:19] Production.INFO: ProcessCDR(1,16285559,1,1,2) [2025-11-28 22:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16285559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 22:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16285559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 22:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16285559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 22:00:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16285559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 22:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285559', 'tblTempUsageDetail_20' ) start [2025-11-28 22:00:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285559', 'tblTempUsageDetail_20' ) end [2025-11-28 22:00:30] Production.ERROR: pbx prc_insertCDR start [2025-11-28 22:00:31] Production.ERROR: pbx prc_insertCDR end [2025-11-28 22:00:31] Production.INFO: ==16411== Releasing lock... [2025-11-28 22:00:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 22:00:31] Production.INFO: 44.75 MB #Memory Used# [2025-11-28 23:00:06] Production.ERROR: Array ( [start_date_ymd] => 2025-11-28 20:00:06 [end_date_ymd] => 2025-11-28 23:00:06 [RateCDR] => 1 ) [2025-11-28 23:00: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-11-28 20:00:06' and `end` < '2025-11-28 23:00: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-11-28 23:00:18] Production.INFO: count ==1664 [2025-11-28 23:00:19] Production.ERROR: pbx CDR StartTime 2025-11-28 20:00:06 - End Time 2025-11-28 23:00:06 [2025-11-28 23:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-11-28 23:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285805', 'tblTempUsageDetail_20' ) start [2025-11-28 23:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16285805', 'tblTempUsageDetail_20' ) end [2025-11-28 23:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285805', 'tblTempVendorCDR_20' ) start [2025-11-28 23:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16285805', 'tblTempVendorCDR_20' ) end [2025-11-28 23:00:19] Production.INFO: ProcessCDR(1,16285805,1,1,2) [2025-11-28 23:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16285805,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 23:00:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16285805,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-11-28 23:00:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16285805,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 23:00:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16285805,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-11-28 23:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285805', 'tblTempUsageDetail_20' ) start [2025-11-28 23:00:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16285805', 'tblTempUsageDetail_20' ) end [2025-11-28 23:00:29] Production.ERROR: pbx prc_insertCDR start [2025-11-28 23:00:30] Production.ERROR: pbx prc_insertCDR end [2025-11-28 23:00:30] Production.INFO: ==21353== Releasing lock... [2025-11-28 23:00:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-11-28 23:00:30] Production.INFO: 40.75 MB #Memory Used#