[2026-01-16 00:01:05] Production.INFO: next invoice date [2026-01-16 00:01:05] Production.INFO: 2026-02-16 [2026-01-16 00:01:05] Production.INFO: getdaysdiff [2026-01-16 00:01:05] Production.INFO: +31 [2026-01-16 00:01:05] Production.INFO: call prc_setAccountDiscountPlan (107,16,1,31,31,'RMScheduler',2026-01-16 00:01:05,1,0,,,0) [2026-01-16 00:01:05] Production.INFO: next invoice date [2026-01-16 00:01:05] Production.INFO: 2026-02-16 [2026-01-16 00:01:05] Production.INFO: getdaysdiff [2026-01-16 00:01:05] Production.INFO: +31 [2026-01-16 00:01:05] Production.INFO: call prc_setAccountDiscountPlan (140,16,1,31,31,'RMScheduler',2026-01-16 00:01:05,1,0,,,0) [2026-01-16 00:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 21:01:06 [end_date_ymd] => 2026-01-16 00:01:06 [RateCDR] => 1 ) [2026-01-16 00:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-15 21:01:06' and `end` < '2026-01-16 00:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 00:01:38] Production.INFO: count ==932 [2026-01-16 00:01:38] Production.ERROR: pbx CDR StartTime 2026-01-15 21:01:06 - End Time 2026-01-16 00:01:06 [2026-01-16 00:01:38] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 00:01:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570586', 'tblTempUsageDetail_20' ) start [2026-01-16 00:01:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570586', 'tblTempUsageDetail_20' ) end [2026-01-16 00:01:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570586', 'tblTempVendorCDR_20' ) start [2026-01-16 00:01:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570586', 'tblTempVendorCDR_20' ) end [2026-01-16 00:01:38] Production.INFO: ProcessCDR(1,16570586,1,1,2) [2026-01-16 00:01:38] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16570586,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 00:04:55] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16570586,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 00:04:55] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16570586,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 00:08:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16570586,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 00:08:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570586', 'tblTempUsageDetail_20' ) start [2026-01-16 00:08:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570586', 'tblTempUsageDetail_20' ) end [2026-01-16 00:08:48] Production.ERROR: pbx prc_insertCDR start [2026-01-16 00:08:48] Production.ERROR: pbx prc_insertCDR end [2026-01-16 00:08:51] Production.INFO: ==15902== Releasing lock... [2026-01-16 00:08:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 00:08:51] Production.INFO: 39.25 MB #Memory Used# [2026-01-16 01:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 22:01:07 [end_date_ymd] => 2026-01-16 01:01:07 [RateCDR] => 1 ) [2026-01-16 01:01: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` >= '2026-01-15 22:01:07' and `end` < '2026-01-16 01:01: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 ,'') [2026-01-16 01:01:20] Production.INFO: count ==665 [2026-01-16 01:01:20] Production.ERROR: pbx CDR StartTime 2026-01-15 22:01:07 - End Time 2026-01-16 01:01:07 [2026-01-16 01:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 01:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570833', 'tblTempUsageDetail_20' ) start [2026-01-16 01:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570833', 'tblTempUsageDetail_20' ) end [2026-01-16 01:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570833', 'tblTempVendorCDR_20' ) start [2026-01-16 01:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570833', 'tblTempVendorCDR_20' ) end [2026-01-16 01:01:20] Production.INFO: ProcessCDR(1,16570833,1,1,2) [2026-01-16 01:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16570833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 01:04:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16570833,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 01:04:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16570833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 01:08:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16570833,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 01:08:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570833', 'tblTempUsageDetail_20' ) start [2026-01-16 01:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570833', 'tblTempUsageDetail_20' ) end [2026-01-16 01:08:18] Production.ERROR: pbx prc_insertCDR start [2026-01-16 01:08:18] Production.ERROR: pbx prc_insertCDR end [2026-01-16 01:08:18] Production.INFO: ==20274== Releasing lock... [2026-01-16 01:08:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 01:08:18] Production.INFO: 33.5 MB #Memory Used# [2026-01-16 02:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 23:01:06 [end_date_ymd] => 2026-01-16 02:01:06 [RateCDR] => 1 ) [2026-01-16 02:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-15 23:01:06' and `end` < '2026-01-16 02:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 02:01:18] Production.INFO: count ==627 [2026-01-16 02:01:18] Production.ERROR: pbx CDR StartTime 2026-01-15 23:01:06 - End Time 2026-01-16 02:01:06 [2026-01-16 02:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 02:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571080', 'tblTempUsageDetail_20' ) start [2026-01-16 02:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571080', 'tblTempUsageDetail_20' ) end [2026-01-16 02:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571080', 'tblTempVendorCDR_20' ) start [2026-01-16 02:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571080', 'tblTempVendorCDR_20' ) end [2026-01-16 02:01:18] Production.INFO: ProcessCDR(1,16571080,1,1,2) [2026-01-16 02:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16571080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 02:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16571080,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 02:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16571080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 02:08:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16571080,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 02:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571080', 'tblTempUsageDetail_20' ) start [2026-01-16 02:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571080', 'tblTempUsageDetail_20' ) end [2026-01-16 02:08:23] Production.ERROR: pbx prc_insertCDR start [2026-01-16 02:08:23] Production.ERROR: pbx prc_insertCDR end [2026-01-16 02:08:23] Production.INFO: ==24681== Releasing lock... [2026-01-16 02:08:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 02:08:23] Production.INFO: 33.5 MB #Memory Used# [2026-01-16 03:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 00:01:07 [end_date_ymd] => 2026-01-16 03:01:07 [RateCDR] => 1 ) [2026-01-16 03:01: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` >= '2026-01-16 00:01:07' and `end` < '2026-01-16 03:01: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 ,'') [2026-01-16 03:01:19] Production.INFO: count ==502 [2026-01-16 03:01:19] Production.ERROR: pbx CDR StartTime 2026-01-16 00:01:07 - End Time 2026-01-16 03:01:07 [2026-01-16 03:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571327', 'tblTempUsageDetail_20' ) start [2026-01-16 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571327', 'tblTempUsageDetail_20' ) end [2026-01-16 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571327', 'tblTempVendorCDR_20' ) start [2026-01-16 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571327', 'tblTempVendorCDR_20' ) end [2026-01-16 03:01:19] Production.INFO: ProcessCDR(1,16571327,1,1,2) [2026-01-16 03:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16571327,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 03:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16571327,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 03:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16571327,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 03:08:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16571327,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 03:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571327', 'tblTempUsageDetail_20' ) start [2026-01-16 03:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571327', 'tblTempUsageDetail_20' ) end [2026-01-16 03:08:32] Production.ERROR: pbx prc_insertCDR start [2026-01-16 03:08:32] Production.ERROR: pbx prc_insertCDR end [2026-01-16 03:08:32] Production.INFO: ==29014== Releasing lock... [2026-01-16 03:08:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 03:08:32] Production.INFO: 32.75 MB #Memory Used# [2026-01-16 04:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 01:01:06 [end_date_ymd] => 2026-01-16 04:01:06 [RateCDR] => 1 ) [2026-01-16 04:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 01:01:06' and `end` < '2026-01-16 04:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 04:01:18] Production.INFO: count ==324 [2026-01-16 04:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 01:01:06 - End Time 2026-01-16 04:01:06 [2026-01-16 04:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571575', 'tblTempUsageDetail_20' ) start [2026-01-16 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571575', 'tblTempUsageDetail_20' ) end [2026-01-16 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571575', 'tblTempVendorCDR_20' ) start [2026-01-16 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571575', 'tblTempVendorCDR_20' ) end [2026-01-16 04:01:18] Production.INFO: ProcessCDR(1,16571575,1,1,2) [2026-01-16 04:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16571575,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 04:04:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16571575,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 04:04:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16571575,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 04:08:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16571575,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 04:08:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571575', 'tblTempUsageDetail_20' ) start [2026-01-16 04:08:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571575', 'tblTempUsageDetail_20' ) end [2026-01-16 04:08:37] Production.ERROR: pbx prc_insertCDR start [2026-01-16 04:08:37] Production.ERROR: pbx prc_insertCDR end [2026-01-16 04:08:38] Production.INFO: ==1293== Releasing lock... [2026-01-16 04:08:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 04:08:38] Production.INFO: 31.25 MB #Memory Used# [2026-01-16 05:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 02:01:05 [end_date_ymd] => 2026-01-16 05:01:05 [RateCDR] => 1 ) [2026-01-16 05:01:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 02:01:05' and `end` < '2026-01-16 05:01:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 05:01:18] Production.INFO: count ==205 [2026-01-16 05:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 02:01:05 - End Time 2026-01-16 05:01:05 [2026-01-16 05:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571823', 'tblTempUsageDetail_20' ) start [2026-01-16 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16571823', 'tblTempUsageDetail_20' ) end [2026-01-16 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571823', 'tblTempVendorCDR_20' ) start [2026-01-16 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16571823', 'tblTempVendorCDR_20' ) end [2026-01-16 05:01:18] Production.INFO: ProcessCDR(1,16571823,1,1,2) [2026-01-16 05:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16571823,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 05:04:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16571823,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 05:04:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16571823,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 05:08:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16571823,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 05:08:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571823', 'tblTempUsageDetail_20' ) start [2026-01-16 05:08:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16571823', 'tblTempUsageDetail_20' ) end [2026-01-16 05:08:40] Production.ERROR: pbx prc_insertCDR start [2026-01-16 05:08:40] Production.ERROR: pbx prc_insertCDR end [2026-01-16 05:08:40] Production.INFO: ==6728== Releasing lock... [2026-01-16 05:08:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 05:08:40] Production.INFO: 29.5 MB #Memory Used# [2026-01-16 06:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 03:01:05 [end_date_ymd] => 2026-01-16 06:01:05 [RateCDR] => 1 ) [2026-01-16 06:01:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 03:01:05' and `end` < '2026-01-16 06:01:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 06:01:18] Production.INFO: count ==142 [2026-01-16 06:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 03:01:05 - End Time 2026-01-16 06:01:05 [2026-01-16 06:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572069', 'tblTempUsageDetail_20' ) start [2026-01-16 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572069', 'tblTempUsageDetail_20' ) end [2026-01-16 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572069', 'tblTempVendorCDR_20' ) start [2026-01-16 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572069', 'tblTempVendorCDR_20' ) end [2026-01-16 06:01:18] Production.INFO: ProcessCDR(1,16572069,1,1,2) [2026-01-16 06:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16572069,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 06:04:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16572069,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 06:04:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16572069,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 06:08:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16572069,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 06:08:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572069', 'tblTempUsageDetail_20' ) start [2026-01-16 06:08:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572069', 'tblTempUsageDetail_20' ) end [2026-01-16 06:08:28] Production.ERROR: pbx prc_insertCDR start [2026-01-16 06:08:28] Production.ERROR: pbx prc_insertCDR end [2026-01-16 06:08:28] Production.INFO: ==10957== Releasing lock... [2026-01-16 06:08:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 06:08:28] Production.INFO: 29.5 MB #Memory Used# [2026-01-16 07:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 04:01:06 [end_date_ymd] => 2026-01-16 07:01:06 [RateCDR] => 1 ) [2026-01-16 07:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 04:01:06' and `end` < '2026-01-16 07:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 07:01:18] Production.INFO: count ==116 [2026-01-16 07:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 04:01:06 - End Time 2026-01-16 07:01:06 [2026-01-16 07:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572317', 'tblTempUsageDetail_20' ) start [2026-01-16 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572317', 'tblTempUsageDetail_20' ) end [2026-01-16 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572317', 'tblTempVendorCDR_20' ) start [2026-01-16 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572317', 'tblTempVendorCDR_20' ) end [2026-01-16 07:01:18] Production.INFO: ProcessCDR(1,16572317,1,1,2) [2026-01-16 07:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16572317,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 07:04:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16572317,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 07:04:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16572317,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 07:08:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16572317,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 07:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572317', 'tblTempUsageDetail_20' ) start [2026-01-16 07:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572317', 'tblTempUsageDetail_20' ) end [2026-01-16 07:08:24] Production.ERROR: pbx prc_insertCDR start [2026-01-16 07:08:24] Production.ERROR: pbx prc_insertCDR end [2026-01-16 07:08:24] Production.INFO: ==15437== Releasing lock... [2026-01-16 07:08:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 07:08:24] Production.INFO: 29 MB #Memory Used# [2026-01-16 08:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 05:01:06 [end_date_ymd] => 2026-01-16 08:01:06 [RateCDR] => 1 ) [2026-01-16 08:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 05:01:06' and `end` < '2026-01-16 08:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 08:01:18] Production.INFO: count ==168 [2026-01-16 08:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 05:01:06 - End Time 2026-01-16 08:01:06 [2026-01-16 08:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572564', 'tblTempUsageDetail_20' ) start [2026-01-16 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572564', 'tblTempUsageDetail_20' ) end [2026-01-16 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572564', 'tblTempVendorCDR_20' ) start [2026-01-16 08:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572564', 'tblTempVendorCDR_20' ) end [2026-01-16 08:01:18] Production.INFO: ProcessCDR(1,16572564,1,1,2) [2026-01-16 08:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16572564,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 08:04:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16572564,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 08:04:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16572564,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 08:08:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16572564,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 08:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572564', 'tblTempUsageDetail_20' ) start [2026-01-16 08:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572564', 'tblTempUsageDetail_20' ) end [2026-01-16 08:08:24] Production.ERROR: pbx prc_insertCDR start [2026-01-16 08:08:24] Production.ERROR: pbx prc_insertCDR end [2026-01-16 08:08:24] Production.INFO: ==20593== Releasing lock... [2026-01-16 08:08:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 08:08:24] Production.INFO: 29.25 MB #Memory Used# [2026-01-16 09:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 06:01:06 [end_date_ymd] => 2026-01-16 09:01:06 [RateCDR] => 1 ) [2026-01-16 09:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 06:01:06' and `end` < '2026-01-16 09:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 09:01:18] Production.INFO: count ==800 [2026-01-16 09:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 06:01:06 - End Time 2026-01-16 09:01:06 [2026-01-16 09:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 09:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572810', 'tblTempUsageDetail_20' ) start [2026-01-16 09:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16572810', 'tblTempUsageDetail_20' ) end [2026-01-16 09:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572810', 'tblTempVendorCDR_20' ) start [2026-01-16 09:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16572810', 'tblTempVendorCDR_20' ) end [2026-01-16 09:01:18] Production.INFO: ProcessCDR(1,16572810,1,1,2) [2026-01-16 09:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16572810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 09:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16572810,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 09:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16572810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 09:08:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16572810,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 09:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572810', 'tblTempUsageDetail_20' ) start [2026-01-16 09:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16572810', 'tblTempUsageDetail_20' ) end [2026-01-16 09:08:26] Production.ERROR: pbx prc_insertCDR start [2026-01-16 09:08:27] Production.ERROR: pbx prc_insertCDR end [2026-01-16 09:08:27] Production.INFO: ==25457== Releasing lock... [2026-01-16 09:08:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 09:08:27] Production.INFO: 34.5 MB #Memory Used# [2026-01-16 10:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 07:01:07 [end_date_ymd] => 2026-01-16 10:01:07 [RateCDR] => 1 ) [2026-01-16 10:01: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` >= '2026-01-16 07:01:07' and `end` < '2026-01-16 10:01: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 ,'') [2026-01-16 10:01:22] Production.INFO: count ==2041 [2026-01-16 10:01:23] Production.ERROR: pbx CDR StartTime 2026-01-16 07:01:07 - End Time 2026-01-16 10:01:07 [2026-01-16 10:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573058', 'tblTempUsageDetail_20' ) start [2026-01-16 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573058', 'tblTempUsageDetail_20' ) end [2026-01-16 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573058', 'tblTempVendorCDR_20' ) start [2026-01-16 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573058', 'tblTempVendorCDR_20' ) end [2026-01-16 10:01:23] Production.INFO: ProcessCDR(1,16573058,1,1,2) [2026-01-16 10:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16573058,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 10:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16573058,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 10:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16573058,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 10:08:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16573058,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 10:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573058', 'tblTempUsageDetail_20' ) start [2026-01-16 10:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573058', 'tblTempUsageDetail_20' ) end [2026-01-16 10:08:21] Production.ERROR: pbx prc_insertCDR start [2026-01-16 10:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-16 10:08:22] Production.INFO: ==31247== Releasing lock... [2026-01-16 10:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 10:08:22] Production.INFO: 43.5 MB #Memory Used# [2026-01-16 11:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 08:01:06 [end_date_ymd] => 2026-01-16 11:01:06 [RateCDR] => 1 ) [2026-01-16 11:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 08:01:06' and `end` < '2026-01-16 11:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 11:01:19] Production.INFO: count ==3769 [2026-01-16 11:01:21] Production.ERROR: pbx CDR StartTime 2026-01-16 08:01:06 - End Time 2026-01-16 11:01:06 [2026-01-16 11:01:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 11:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573304', 'tblTempUsageDetail_20' ) start [2026-01-16 11:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573304', 'tblTempUsageDetail_20' ) end [2026-01-16 11:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573304', 'tblTempVendorCDR_20' ) start [2026-01-16 11:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573304', 'tblTempVendorCDR_20' ) end [2026-01-16 11:01:21] Production.INFO: ProcessCDR(1,16573304,1,1,2) [2026-01-16 11:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16573304,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 11:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16573304,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 11:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16573304,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 11:08:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16573304,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 11:08:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573304', 'tblTempUsageDetail_20' ) start [2026-01-16 11:08:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573304', 'tblTempUsageDetail_20' ) end [2026-01-16 11:08:28] Production.ERROR: pbx prc_insertCDR start [2026-01-16 11:08:31] Production.ERROR: pbx prc_insertCDR end [2026-01-16 11:08:31] Production.INFO: ==5205== Releasing lock... [2026-01-16 11:08:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 11:08:31] Production.INFO: 56.25 MB #Memory Used# [2026-01-16 12:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 09:01:07 [end_date_ymd] => 2026-01-16 12:01:07 [RateCDR] => 1 ) [2026-01-16 12:01: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` >= '2026-01-16 09:01:07' and `end` < '2026-01-16 12:01: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 ,'') [2026-01-16 12:01:23] Production.INFO: count ==4958 [2026-01-16 12:01:25] Production.ERROR: pbx CDR StartTime 2026-01-16 09:01:07 - End Time 2026-01-16 12:01:07 [2026-01-16 12:01:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 12:01:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573552', 'tblTempUsageDetail_20' ) start [2026-01-16 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573552', 'tblTempUsageDetail_20' ) end [2026-01-16 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573552', 'tblTempVendorCDR_20' ) start [2026-01-16 12:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573552', 'tblTempVendorCDR_20' ) end [2026-01-16 12:01:26] Production.INFO: ProcessCDR(1,16573552,1,1,2) [2026-01-16 12:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16573552,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 12:04:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16573552,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 12:04:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16573552,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 12:08:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16573552,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 12:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573552', 'tblTempUsageDetail_20' ) start [2026-01-16 12:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573552', 'tblTempUsageDetail_20' ) end [2026-01-16 12:08:19] Production.ERROR: pbx prc_insertCDR start [2026-01-16 12:08:21] Production.ERROR: pbx prc_insertCDR end [2026-01-16 12:08:21] Production.INFO: ==10628== Releasing lock... [2026-01-16 12:08:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 12:08:21] Production.INFO: 65.25 MB #Memory Used# [2026-01-16 13:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 10:01:06 [end_date_ymd] => 2026-01-16 13:01:06 [RateCDR] => 1 ) [2026-01-16 13:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 10:01:06' and `end` < '2026-01-16 13:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 13:01:20] Production.INFO: count ==5265 [2026-01-16 13:01:22] Production.ERROR: pbx CDR StartTime 2026-01-16 10:01:06 - End Time 2026-01-16 13:01:06 [2026-01-16 13:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 13:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573798', 'tblTempUsageDetail_20' ) start [2026-01-16 13:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16573798', 'tblTempUsageDetail_20' ) end [2026-01-16 13:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573798', 'tblTempVendorCDR_20' ) start [2026-01-16 13:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16573798', 'tblTempVendorCDR_20' ) end [2026-01-16 13:01:23] Production.INFO: ProcessCDR(1,16573798,1,1,2) [2026-01-16 13:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16573798,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 13:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16573798,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 13:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16573798,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 13:08:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16573798,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 13:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573798', 'tblTempUsageDetail_20' ) start [2026-01-16 13:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16573798', 'tblTempUsageDetail_20' ) end [2026-01-16 13:08:19] Production.ERROR: pbx prc_insertCDR start [2026-01-16 13:08:20] Production.ERROR: pbx prc_insertCDR end [2026-01-16 13:08:20] Production.INFO: ==14918== Releasing lock... [2026-01-16 13:08:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 13:08:20] Production.INFO: 67.5 MB #Memory Used# [2026-01-16 14:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 11:01:06 [end_date_ymd] => 2026-01-16 14:01:06 [RateCDR] => 1 ) [2026-01-16 14:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 11:01:06' and `end` < '2026-01-16 14:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 14:01:20] Production.INFO: count ==5093 [2026-01-16 14:01:22] Production.ERROR: pbx CDR StartTime 2026-01-16 11:01:06 - End Time 2026-01-16 14:01:06 [2026-01-16 14:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 14:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574046', 'tblTempUsageDetail_20' ) start [2026-01-16 14:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574046', 'tblTempUsageDetail_20' ) end [2026-01-16 14:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574046', 'tblTempVendorCDR_20' ) start [2026-01-16 14:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574046', 'tblTempVendorCDR_20' ) end [2026-01-16 14:01:22] Production.INFO: ProcessCDR(1,16574046,1,1,2) [2026-01-16 14:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16574046,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 14:04:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16574046,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 14:04:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16574046,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 14:08:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16574046,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 14:08:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574046', 'tblTempUsageDetail_20' ) start [2026-01-16 14:08:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574046', 'tblTempUsageDetail_20' ) end [2026-01-16 14:08:30] Production.ERROR: pbx prc_insertCDR start [2026-01-16 14:08:32] Production.ERROR: pbx prc_insertCDR end [2026-01-16 14:08:32] Production.INFO: ==19243== Releasing lock... [2026-01-16 14:08:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 14:08:32] Production.INFO: 66.25 MB #Memory Used# [2026-01-16 15:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 12:01:06 [end_date_ymd] => 2026-01-16 15:01:06 [RateCDR] => 1 ) [2026-01-16 15:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 12:01:06' and `end` < '2026-01-16 15:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 15:01:20] Production.INFO: count ==5206 [2026-01-16 15:01:23] Production.ERROR: pbx CDR StartTime 2026-01-16 12:01:06 - End Time 2026-01-16 15:01:06 [2026-01-16 15:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 15:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574293', 'tblTempUsageDetail_20' ) start [2026-01-16 15:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574293', 'tblTempUsageDetail_20' ) end [2026-01-16 15:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574293', 'tblTempVendorCDR_20' ) start [2026-01-16 15:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574293', 'tblTempVendorCDR_20' ) end [2026-01-16 15:01:23] Production.INFO: ProcessCDR(1,16574293,1,1,2) [2026-01-16 15:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16574293,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 15:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16574293,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 15:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16574293,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 15:08:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16574293,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 15:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574293', 'tblTempUsageDetail_20' ) start [2026-01-16 15:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574293', 'tblTempUsageDetail_20' ) end [2026-01-16 15:08:24] Production.ERROR: pbx prc_insertCDR start [2026-01-16 15:08:27] Production.ERROR: pbx prc_insertCDR end [2026-01-16 15:08:27] Production.INFO: ==23567== Releasing lock... [2026-01-16 15:08:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 15:08:27] Production.INFO: 67.25 MB #Memory Used# [2026-01-16 16:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 13:01:06 [end_date_ymd] => 2026-01-16 16:01:06 [RateCDR] => 1 ) [2026-01-16 16:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 13:01:06' and `end` < '2026-01-16 16:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 16:01:20] Production.INFO: count ==5396 [2026-01-16 16:01:22] Production.ERROR: pbx CDR StartTime 2026-01-16 13:01:06 - End Time 2026-01-16 16:01:06 [2026-01-16 16:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 16:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574539', 'tblTempUsageDetail_20' ) start [2026-01-16 16:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574539', 'tblTempUsageDetail_20' ) end [2026-01-16 16:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574539', 'tblTempVendorCDR_20' ) start [2026-01-16 16:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574539', 'tblTempVendorCDR_20' ) end [2026-01-16 16:01:23] Production.INFO: ProcessCDR(1,16574539,1,1,2) [2026-01-16 16:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16574539,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 16:04:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16574539,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 16:04:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16574539,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 16:08:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16574539,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 16:08:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574539', 'tblTempUsageDetail_20' ) start [2026-01-16 16:08:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574539', 'tblTempUsageDetail_20' ) end [2026-01-16 16:08:34] Production.ERROR: pbx prc_insertCDR start [2026-01-16 16:08:36] Production.ERROR: pbx prc_insertCDR end [2026-01-16 16:08:36] Production.INFO: ==28688== Releasing lock... [2026-01-16 16:08:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 16:08:36] Production.INFO: 68.5 MB #Memory Used# [2026-01-16 17:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 14:01:06 [end_date_ymd] => 2026-01-16 17:01:06 [RateCDR] => 1 ) [2026-01-16 17:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 14:01:06' and `end` < '2026-01-16 17:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 17:01:31] Production.INFO: count ==5621 [2026-01-16 17:01:34] Production.ERROR: pbx CDR StartTime 2026-01-16 14:01:06 - End Time 2026-01-16 17:01:06 [2026-01-16 17:01:34] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 17:01:34] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574787', 'tblTempUsageDetail_20' ) start [2026-01-16 17:01:34] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16574787', 'tblTempUsageDetail_20' ) end [2026-01-16 17:01:34] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574787', 'tblTempVendorCDR_20' ) start [2026-01-16 17:01:34] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16574787', 'tblTempVendorCDR_20' ) end [2026-01-16 17:01:34] Production.INFO: ProcessCDR(1,16574787,1,1,2) [2026-01-16 17:01:34] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16574787,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 17:04:57] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16574787,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 17:04:57] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16574787,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 17:09:00] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16574787,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 17:09:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574787', 'tblTempUsageDetail_20' ) start [2026-01-16 17:09:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16574787', 'tblTempUsageDetail_20' ) end [2026-01-16 17:09:01] Production.ERROR: pbx prc_insertCDR start [2026-01-16 17:09:09] Production.ERROR: pbx prc_insertCDR end [2026-01-16 17:09:09] Production.INFO: ==580== Releasing lock... [2026-01-16 17:09:09] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 17:09:09] Production.INFO: 70.25 MB #Memory Used# [2026-01-16 18:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 15:01:06 [end_date_ymd] => 2026-01-16 18:01:06 [RateCDR] => 1 ) [2026-01-16 18:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 15:01:06' and `end` < '2026-01-16 18:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 18:01:20] Production.INFO: count ==5222 [2026-01-16 18:01:23] Production.ERROR: pbx CDR StartTime 2026-01-16 15:01:06 - End Time 2026-01-16 18:01:06 [2026-01-16 18:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 18:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575032', 'tblTempUsageDetail_20' ) start [2026-01-16 18:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575032', 'tblTempUsageDetail_20' ) end [2026-01-16 18:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575032', 'tblTempVendorCDR_20' ) start [2026-01-16 18:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575032', 'tblTempVendorCDR_20' ) end [2026-01-16 18:01:23] Production.INFO: ProcessCDR(1,16575032,1,1,2) [2026-01-16 18:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16575032,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 18:04:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16575032,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 18:04:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16575032,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 18:08:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16575032,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 18:08:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575032', 'tblTempUsageDetail_20' ) start [2026-01-16 18:08:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575032', 'tblTempUsageDetail_20' ) end [2026-01-16 18:08:33] Production.ERROR: pbx prc_insertCDR start [2026-01-16 18:08:36] Production.ERROR: pbx prc_insertCDR end [2026-01-16 18:08:36] Production.INFO: ==4950== Releasing lock... [2026-01-16 18:08:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 18:08:36] Production.INFO: 67.25 MB #Memory Used# [2026-01-16 19:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 16:01:06 [end_date_ymd] => 2026-01-16 19:01:06 [RateCDR] => 1 ) [2026-01-16 19:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 16:01:06' and `end` < '2026-01-16 19:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 19:01:19] Production.INFO: count ==5133 [2026-01-16 19:01:21] Production.ERROR: pbx CDR StartTime 2026-01-16 16:01:06 - End Time 2026-01-16 19:01:06 [2026-01-16 19:01:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575278', 'tblTempUsageDetail_20' ) start [2026-01-16 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575278', 'tblTempUsageDetail_20' ) end [2026-01-16 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575278', 'tblTempVendorCDR_20' ) start [2026-01-16 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575278', 'tblTempVendorCDR_20' ) end [2026-01-16 19:01:21] Production.INFO: ProcessCDR(1,16575278,1,1,2) [2026-01-16 19:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16575278,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 19:04:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16575278,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 19:04:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16575278,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 19:08:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16575278,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 19:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575278', 'tblTempUsageDetail_20' ) start [2026-01-16 19:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575278', 'tblTempUsageDetail_20' ) end [2026-01-16 19:08:20] Production.ERROR: pbx prc_insertCDR start [2026-01-16 19:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-16 19:08:22] Production.INFO: ==9296== Releasing lock... [2026-01-16 19:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 19:08:22] Production.INFO: 66.5 MB #Memory Used# [2026-01-16 20:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 17:01:06 [end_date_ymd] => 2026-01-16 20:01:06 [RateCDR] => 1 ) [2026-01-16 20:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 17:01:06' and `end` < '2026-01-16 20:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 20:01:19] Production.INFO: count ==4042 [2026-01-16 20:01:20] Production.ERROR: pbx CDR StartTime 2026-01-16 17:01:06 - End Time 2026-01-16 20:01:06 [2026-01-16 20:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575526', 'tblTempUsageDetail_20' ) start [2026-01-16 20:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575526', 'tblTempUsageDetail_20' ) end [2026-01-16 20:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575526', 'tblTempVendorCDR_20' ) start [2026-01-16 20:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575526', 'tblTempVendorCDR_20' ) end [2026-01-16 20:01:21] Production.INFO: ProcessCDR(1,16575526,1,1,2) [2026-01-16 20:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16575526,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 20:04:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16575526,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 20:04:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16575526,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 20:08:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16575526,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 20:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575526', 'tblTempUsageDetail_20' ) start [2026-01-16 20:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575526', 'tblTempUsageDetail_20' ) end [2026-01-16 20:08:25] Production.ERROR: pbx prc_insertCDR start [2026-01-16 20:08:26] Production.ERROR: pbx prc_insertCDR end [2026-01-16 20:08:26] Production.INFO: ==13552== Releasing lock... [2026-01-16 20:08:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 20:08:26] Production.INFO: 58.25 MB #Memory Used# [2026-01-16 21:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 18:01:06 [end_date_ymd] => 2026-01-16 21:01:06 [RateCDR] => 1 ) [2026-01-16 21:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 18:01:06' and `end` < '2026-01-16 21:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 21:01:19] Production.INFO: count ==2926 [2026-01-16 21:01:20] Production.ERROR: pbx CDR StartTime 2026-01-16 18:01:06 - End Time 2026-01-16 21:01:06 [2026-01-16 21:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575773', 'tblTempUsageDetail_20' ) start [2026-01-16 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16575773', 'tblTempUsageDetail_20' ) end [2026-01-16 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575773', 'tblTempVendorCDR_20' ) start [2026-01-16 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16575773', 'tblTempVendorCDR_20' ) end [2026-01-16 21:01:20] Production.INFO: ProcessCDR(1,16575773,1,1,2) [2026-01-16 21:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16575773,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 21:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16575773,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 21:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16575773,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 21:08:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16575773,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 21:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575773', 'tblTempUsageDetail_20' ) start [2026-01-16 21:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16575773', 'tblTempUsageDetail_20' ) end [2026-01-16 21:08:32] Production.ERROR: pbx prc_insertCDR start [2026-01-16 21:08:32] Production.ERROR: pbx prc_insertCDR end [2026-01-16 21:08:32] Production.INFO: ==19213== Releasing lock... [2026-01-16 21:08:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 21:08:32] Production.INFO: 51 MB #Memory Used# [2026-01-16 22:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 19:01:05 [end_date_ymd] => 2026-01-16 22:01:05 [RateCDR] => 1 ) [2026-01-16 22:01:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 19:01:05' and `end` < '2026-01-16 22:01:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 22:01:17] Production.INFO: count ==2071 [2026-01-16 22:01:18] Production.ERROR: pbx CDR StartTime 2026-01-16 19:01:05 - End Time 2026-01-16 22:01:05 [2026-01-16 22:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16576020', 'tblTempUsageDetail_20' ) start [2026-01-16 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16576020', 'tblTempUsageDetail_20' ) end [2026-01-16 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16576020', 'tblTempVendorCDR_20' ) start [2026-01-16 22:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16576020', 'tblTempVendorCDR_20' ) end [2026-01-16 22:01:18] Production.INFO: ProcessCDR(1,16576020,1,1,2) [2026-01-16 22:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16576020,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 22:04:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16576020,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 22:04:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16576020,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 22:08:11] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16576020,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 22:08:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16576020', 'tblTempUsageDetail_20' ) start [2026-01-16 22:08:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16576020', 'tblTempUsageDetail_20' ) end [2026-01-16 22:08:11] Production.ERROR: pbx prc_insertCDR start [2026-01-16 22:08:12] Production.ERROR: pbx prc_insertCDR end [2026-01-16 22:08:12] Production.INFO: ==25666== Releasing lock... [2026-01-16 22:08:12] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 22:08:12] Production.INFO: 43.75 MB #Memory Used# [2026-01-16 23:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-16 20:01:06 [end_date_ymd] => 2026-01-16 23:01:06 [RateCDR] => 1 ) [2026-01-16 23:01:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-16 20:01:06' and `end` < '2026-01-16 23:01:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-16 23:01:18] Production.INFO: count ==1706 [2026-01-16 23:01:19] Production.ERROR: pbx CDR StartTime 2026-01-16 20:01:06 - End Time 2026-01-16 23:01:06 [2026-01-16 23:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-16 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16576267', 'tblTempUsageDetail_20' ) start [2026-01-16 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16576267', 'tblTempUsageDetail_20' ) end [2026-01-16 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16576267', 'tblTempVendorCDR_20' ) start [2026-01-16 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16576267', 'tblTempVendorCDR_20' ) end [2026-01-16 23:01:19] Production.INFO: ProcessCDR(1,16576267,1,1,2) [2026-01-16 23:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16576267,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 23:04:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16576267,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-16 23:04:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16576267,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 23:08:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16576267,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-16 23:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16576267', 'tblTempUsageDetail_20' ) start [2026-01-16 23:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16576267', 'tblTempUsageDetail_20' ) end [2026-01-16 23:08:32] Production.ERROR: pbx prc_insertCDR start [2026-01-16 23:08:32] Production.ERROR: pbx prc_insertCDR end [2026-01-16 23:08:32] Production.INFO: ==32028== Releasing lock... [2026-01-16 23:08:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-16 23:08:32] Production.INFO: 41 MB #Memory Used#