[2026-01-21 00:02:04] Production.INFO: next invoice date [2026-01-21 00:02:04] Production.INFO: 2026-02-21 [2026-01-21 00:02:04] Production.INFO: getdaysdiff [2026-01-21 00:02:04] Production.INFO: +31 [2026-01-21 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (18,19,1,31,31,'RMScheduler',2026-01-21 00:02:04,1,0,,,0) [2026-01-21 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-20 21:02:05 [end_date_ymd] => 2026-01-21 00:02:05 [RateCDR] => 1 ) [2026-01-21 00:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-20 21:02:05' and `end` < '2026-01-21 00:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 00:02:19] Production.INFO: count ==773 [2026-01-21 00:02:19] Production.ERROR: pbx CDR StartTime 2026-01-20 21:02:05 - End Time 2026-01-21 00:02:05 [2026-01-21 00:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600231', 'tblTempUsageDetail_20' ) start [2026-01-21 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600231', 'tblTempUsageDetail_20' ) end [2026-01-21 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600231', 'tblTempVendorCDR_20' ) start [2026-01-21 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600231', 'tblTempVendorCDR_20' ) end [2026-01-21 00:02:19] Production.INFO: ProcessCDR(1,16600231,1,1,2) [2026-01-21 00:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16600231,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 00:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16600231,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 00:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16600231,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 00:09:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16600231,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 00:09:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600231', 'tblTempUsageDetail_20' ) start [2026-01-21 00:09:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600231', 'tblTempUsageDetail_20' ) end [2026-01-21 00:09:30] Production.ERROR: pbx prc_insertCDR start [2026-01-21 00:09:31] Production.ERROR: pbx prc_insertCDR end [2026-01-21 00:09:53] Production.INFO: ==7215== Releasing lock... [2026-01-21 00:09:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 00:09:53] Production.INFO: 38.5 MB #Memory Used# [2026-01-21 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-20 22:02:06 [end_date_ymd] => 2026-01-21 01:02:06 [RateCDR] => 1 ) [2026-01-21 01:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-20 22:02:06' and `end` < '2026-01-21 01:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 01:02:18] Production.INFO: count ==775 [2026-01-21 01:02:18] Production.ERROR: pbx CDR StartTime 2026-01-20 22:02:06 - End Time 2026-01-21 01:02:06 [2026-01-21 01:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600478', 'tblTempUsageDetail_20' ) start [2026-01-21 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600478', 'tblTempUsageDetail_20' ) end [2026-01-21 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600478', 'tblTempVendorCDR_20' ) start [2026-01-21 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600478', 'tblTempVendorCDR_20' ) end [2026-01-21 01:02:18] Production.INFO: ProcessCDR(1,16600478,1,1,2) [2026-01-21 01:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16600478,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 01:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16600478,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 01:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16600478,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 01:09:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16600478,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 01:09:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600478', 'tblTempUsageDetail_20' ) start [2026-01-21 01:09:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600478', 'tblTempUsageDetail_20' ) end [2026-01-21 01:09:19] Production.ERROR: pbx prc_insertCDR start [2026-01-21 01:09:19] Production.ERROR: pbx prc_insertCDR end [2026-01-21 01:09:19] Production.INFO: ==11584== Releasing lock... [2026-01-21 01:09:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 01:09:19] Production.INFO: 34.25 MB #Memory Used# [2026-01-21 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-20 23:02:05 [end_date_ymd] => 2026-01-21 02:02:05 [RateCDR] => 1 ) [2026-01-21 02:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-20 23:02:05' and `end` < '2026-01-21 02:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 02:02:25] Production.INFO: count ==588 [2026-01-21 02:02:25] Production.ERROR: pbx CDR StartTime 2026-01-20 23:02:05 - End Time 2026-01-21 02:02:05 [2026-01-21 02:02:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 02:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600725', 'tblTempUsageDetail_20' ) start [2026-01-21 02:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600725', 'tblTempUsageDetail_20' ) end [2026-01-21 02:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600725', 'tblTempVendorCDR_20' ) start [2026-01-21 02:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600725', 'tblTempVendorCDR_20' ) end [2026-01-21 02:02:25] Production.INFO: ProcessCDR(1,16600725,1,1,2) [2026-01-21 02:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16600725,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 02:05:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16600725,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 02:05:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16600725,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 02:09:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16600725,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 02:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600725', 'tblTempUsageDetail_20' ) start [2026-01-21 02:09:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600725', 'tblTempUsageDetail_20' ) end [2026-01-21 02:09:37] Production.ERROR: pbx prc_insertCDR start [2026-01-21 02:09:37] Production.ERROR: pbx prc_insertCDR end [2026-01-21 02:09:37] Production.INFO: ==15987== Releasing lock... [2026-01-21 02:09:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 02:09:37] Production.INFO: 32.75 MB #Memory Used# [2026-01-21 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 00:02:05 [end_date_ymd] => 2026-01-21 03:02:05 [RateCDR] => 1 ) [2026-01-21 03:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 00:02:05' and `end` < '2026-01-21 03:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 03:02:17] Production.INFO: count ==415 [2026-01-21 03:02:17] Production.ERROR: pbx CDR StartTime 2026-01-21 00:02:05 - End Time 2026-01-21 03:02:05 [2026-01-21 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600972', 'tblTempUsageDetail_20' ) start [2026-01-21 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16600972', 'tblTempUsageDetail_20' ) end [2026-01-21 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600972', 'tblTempVendorCDR_20' ) start [2026-01-21 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16600972', 'tblTempVendorCDR_20' ) end [2026-01-21 03:02:17] Production.INFO: ProcessCDR(1,16600972,1,1,2) [2026-01-21 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16600972,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 03:05:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16600972,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 03:05:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16600972,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 03:09:12] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16600972,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 03:09:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600972', 'tblTempUsageDetail_20' ) start [2026-01-21 03:09:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16600972', 'tblTempUsageDetail_20' ) end [2026-01-21 03:09:12] Production.ERROR: pbx prc_insertCDR start [2026-01-21 03:09:12] Production.ERROR: pbx prc_insertCDR end [2026-01-21 03:09:12] Production.INFO: ==20677== Releasing lock... [2026-01-21 03:09:12] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 03:09:12] Production.INFO: 31.75 MB #Memory Used# [2026-01-21 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 01:02:06 [end_date_ymd] => 2026-01-21 04:02:06 [RateCDR] => 1 ) [2026-01-21 04:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 01:02:06' and `end` < '2026-01-21 04:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 04:02:17] Production.INFO: count ==212 [2026-01-21 04:02:17] Production.ERROR: pbx CDR StartTime 2026-01-21 01:02:06 - End Time 2026-01-21 04:02:06 [2026-01-21 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601220', 'tblTempUsageDetail_20' ) start [2026-01-21 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601220', 'tblTempUsageDetail_20' ) end [2026-01-21 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601220', 'tblTempVendorCDR_20' ) start [2026-01-21 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601220', 'tblTempVendorCDR_20' ) end [2026-01-21 04:02:18] Production.INFO: ProcessCDR(1,16601220,1,1,2) [2026-01-21 04:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16601220,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 04:05:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16601220,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 04:05:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16601220,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 04:09:11] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16601220,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 04:09:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601220', 'tblTempUsageDetail_20' ) start [2026-01-21 04:09:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601220', 'tblTempUsageDetail_20' ) end [2026-01-21 04:09:11] Production.ERROR: pbx prc_insertCDR start [2026-01-21 04:09:11] Production.ERROR: pbx prc_insertCDR end [2026-01-21 04:09:11] Production.INFO: ==25258== Releasing lock... [2026-01-21 04:09:11] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 04:09:11] Production.INFO: 30 MB #Memory Used# [2026-01-21 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 02:02:05 [end_date_ymd] => 2026-01-21 05:02:05 [RateCDR] => 1 ) [2026-01-21 05:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 02:02:05' and `end` < '2026-01-21 05:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 05:02:17] Production.INFO: count ==154 [2026-01-21 05:02:17] Production.ERROR: pbx CDR StartTime 2026-01-21 02:02:05 - End Time 2026-01-21 05:02:05 [2026-01-21 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601468', 'tblTempUsageDetail_20' ) start [2026-01-21 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601468', 'tblTempUsageDetail_20' ) end [2026-01-21 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601468', 'tblTempVendorCDR_20' ) start [2026-01-21 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601468', 'tblTempVendorCDR_20' ) end [2026-01-21 05:02:17] Production.INFO: ProcessCDR(1,16601468,1,1,2) [2026-01-21 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16601468,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 05:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16601468,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 05:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16601468,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 05:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16601468,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 05:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601468', 'tblTempUsageDetail_20' ) start [2026-01-21 05:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601468', 'tblTempUsageDetail_20' ) end [2026-01-21 05:09:29] Production.ERROR: pbx prc_insertCDR start [2026-01-21 05:09:29] Production.ERROR: pbx prc_insertCDR end [2026-01-21 05:09:29] Production.INFO: ==30428== Releasing lock... [2026-01-21 05:09:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 05:09:29] Production.INFO: 29.5 MB #Memory Used# [2026-01-21 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 03:02:06 [end_date_ymd] => 2026-01-21 06:02:06 [RateCDR] => 1 ) [2026-01-21 06:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 03:02:06' and `end` < '2026-01-21 06:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 06:02:18] Production.INFO: count ==140 [2026-01-21 06:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 03:02:06 - End Time 2026-01-21 06:02:06 [2026-01-21 06:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601715', 'tblTempUsageDetail_20' ) start [2026-01-21 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601715', 'tblTempUsageDetail_20' ) end [2026-01-21 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601715', 'tblTempVendorCDR_20' ) start [2026-01-21 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601715', 'tblTempVendorCDR_20' ) end [2026-01-21 06:02:18] Production.INFO: ProcessCDR(1,16601715,1,1,2) [2026-01-21 06:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16601715,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 06:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16601715,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 06:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16601715,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 06:09:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16601715,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 06:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601715', 'tblTempUsageDetail_20' ) start [2026-01-21 06:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601715', 'tblTempUsageDetail_20' ) end [2026-01-21 06:09:23] Production.ERROR: pbx prc_insertCDR start [2026-01-21 06:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-21 06:09:24] Production.INFO: ==2467== Releasing lock... [2026-01-21 06:09:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 06:09:24] Production.INFO: 29.5 MB #Memory Used# [2026-01-21 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 04:02:05 [end_date_ymd] => 2026-01-21 07:02:05 [RateCDR] => 1 ) [2026-01-21 07:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 04:02:05' and `end` < '2026-01-21 07:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 07:02:17] Production.INFO: count ==159 [2026-01-21 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-21 04:02:05 - End Time 2026-01-21 07:02:05 [2026-01-21 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601962', 'tblTempUsageDetail_20' ) start [2026-01-21 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16601962', 'tblTempUsageDetail_20' ) end [2026-01-21 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601962', 'tblTempVendorCDR_20' ) start [2026-01-21 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16601962', 'tblTempVendorCDR_20' ) end [2026-01-21 07:02:17] Production.INFO: ProcessCDR(1,16601962,1,1,2) [2026-01-21 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16601962,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 07:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16601962,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 07:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16601962,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 07:09:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16601962,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 07:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601962', 'tblTempUsageDetail_20' ) start [2026-01-21 07:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16601962', 'tblTempUsageDetail_20' ) end [2026-01-21 07:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-21 07:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-21 07:09:26] Production.INFO: ==6850== Releasing lock... [2026-01-21 07:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 07:09:26] Production.INFO: 29.25 MB #Memory Used# [2026-01-21 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 05:02:05 [end_date_ymd] => 2026-01-21 08:02:05 [RateCDR] => 1 ) [2026-01-21 08:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 05:02:05' and `end` < '2026-01-21 08:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 08:02:17] Production.INFO: count ==216 [2026-01-21 08:02:17] Production.ERROR: pbx CDR StartTime 2026-01-21 05:02:05 - End Time 2026-01-21 08:02:05 [2026-01-21 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602209', 'tblTempUsageDetail_20' ) start [2026-01-21 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602209', 'tblTempUsageDetail_20' ) end [2026-01-21 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602209', 'tblTempVendorCDR_20' ) start [2026-01-21 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602209', 'tblTempVendorCDR_20' ) end [2026-01-21 08:02:17] Production.INFO: ProcessCDR(1,16602209,1,1,2) [2026-01-21 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16602209,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 08:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16602209,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 08:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16602209,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 08:09:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16602209,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 08:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602209', 'tblTempUsageDetail_20' ) start [2026-01-21 08:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602209', 'tblTempUsageDetail_20' ) end [2026-01-21 08:09:22] Production.ERROR: pbx prc_insertCDR start [2026-01-21 08:09:22] Production.ERROR: pbx prc_insertCDR end [2026-01-21 08:09:22] Production.INFO: ==11191== Releasing lock... [2026-01-21 08:09:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 08:09:22] Production.INFO: 30 MB #Memory Used# [2026-01-21 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 06:02:05 [end_date_ymd] => 2026-01-21 09:02:05 [RateCDR] => 1 ) [2026-01-21 09:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 06:02:05' and `end` < '2026-01-21 09:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 09:02:17] Production.INFO: count ==736 [2026-01-21 09:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 06:02:05 - End Time 2026-01-21 09:02:05 [2026-01-21 09:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602456', 'tblTempUsageDetail_20' ) start [2026-01-21 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602456', 'tblTempUsageDetail_20' ) end [2026-01-21 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602456', 'tblTempVendorCDR_20' ) start [2026-01-21 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602456', 'tblTempVendorCDR_20' ) end [2026-01-21 09:02:18] Production.INFO: ProcessCDR(1,16602456,1,1,2) [2026-01-21 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16602456,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 09:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16602456,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 09:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16602456,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 09:09:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16602456,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 09:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602456', 'tblTempUsageDetail_20' ) start [2026-01-21 09:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602456', 'tblTempUsageDetail_20' ) end [2026-01-21 09:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-21 09:09:24] Production.ERROR: pbx prc_insertCDR end [2026-01-21 09:09:24] Production.INFO: ==16980== Releasing lock... [2026-01-21 09:09:24] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 09:09:24] Production.INFO: 33.75 MB #Memory Used# [2026-01-21 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 07:02:05 [end_date_ymd] => 2026-01-21 10:02:05 [RateCDR] => 1 ) [2026-01-21 10:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 07:02:05' and `end` < '2026-01-21 10:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 10:02:19] Production.INFO: count ==2281 [2026-01-21 10:02:20] Production.ERROR: pbx CDR StartTime 2026-01-21 07:02:05 - End Time 2026-01-21 10:02:05 [2026-01-21 10:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 10:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602703', 'tblTempUsageDetail_20' ) start [2026-01-21 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602703', 'tblTempUsageDetail_20' ) end [2026-01-21 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602703', 'tblTempVendorCDR_20' ) start [2026-01-21 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602703', 'tblTempVendorCDR_20' ) end [2026-01-21 10:02:21] Production.INFO: ProcessCDR(1,16602703,1,1,2) [2026-01-21 10:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16602703,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 10:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16602703,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 10:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16602703,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 10:09:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16602703,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 10:09:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602703', 'tblTempUsageDetail_20' ) start [2026-01-21 10:09:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602703', 'tblTempUsageDetail_20' ) end [2026-01-21 10:09:21] Production.ERROR: pbx prc_insertCDR start [2026-01-21 10:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-21 10:09:23] Production.INFO: ==23501== Releasing lock... [2026-01-21 10:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 10:09:23] Production.INFO: 45.5 MB #Memory Used# [2026-01-21 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 08:02:05 [end_date_ymd] => 2026-01-21 11:02:05 [RateCDR] => 1 ) [2026-01-21 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 08:02:05' and `end` < '2026-01-21 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 11:02:18] Production.INFO: count ==4017 [2026-01-21 11:02:20] Production.ERROR: pbx CDR StartTime 2026-01-21 08:02:05 - End Time 2026-01-21 11:02:05 [2026-01-21 11:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602950', 'tblTempUsageDetail_20' ) start [2026-01-21 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16602950', 'tblTempUsageDetail_20' ) end [2026-01-21 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602950', 'tblTempVendorCDR_20' ) start [2026-01-21 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16602950', 'tblTempVendorCDR_20' ) end [2026-01-21 11:02:20] Production.INFO: ProcessCDR(1,16602950,1,1,2) [2026-01-21 11:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16602950,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 11:05:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16602950,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 11:05:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16602950,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 11:09:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16602950,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 11:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602950', 'tblTempUsageDetail_20' ) start [2026-01-21 11:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16602950', 'tblTempUsageDetail_20' ) end [2026-01-21 11:09:17] Production.ERROR: pbx prc_insertCDR start [2026-01-21 11:09:20] Production.ERROR: pbx prc_insertCDR end [2026-01-21 11:09:20] Production.INFO: ==29162== Releasing lock... [2026-01-21 11:09:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 11:09:20] Production.INFO: 58.25 MB #Memory Used# [2026-01-21 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 09:02:05 [end_date_ymd] => 2026-01-21 12:02:05 [RateCDR] => 1 ) [2026-01-21 12:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 09:02:05' and `end` < '2026-01-21 12:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 12:02:21] Production.INFO: count ==5545 [2026-01-21 12:02:24] Production.ERROR: pbx CDR StartTime 2026-01-21 09:02:05 - End Time 2026-01-21 12:02:05 [2026-01-21 12:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 12:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603197', 'tblTempUsageDetail_20' ) start [2026-01-21 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603197', 'tblTempUsageDetail_20' ) end [2026-01-21 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603197', 'tblTempVendorCDR_20' ) start [2026-01-21 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603197', 'tblTempVendorCDR_20' ) end [2026-01-21 12:02:25] Production.INFO: ProcessCDR(1,16603197,1,1,2) [2026-01-21 12:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16603197,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 12:05:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16603197,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 12:05:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16603197,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 12:09:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16603197,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 12:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603197', 'tblTempUsageDetail_20' ) start [2026-01-21 12:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603197', 'tblTempUsageDetail_20' ) end [2026-01-21 12:09:28] Production.ERROR: pbx prc_insertCDR start [2026-01-21 12:09:31] Production.ERROR: pbx prc_insertCDR end [2026-01-21 12:09:31] Production.INFO: ==1379== Releasing lock... [2026-01-21 12:09:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 12:09:31] Production.INFO: 69.75 MB #Memory Used# [2026-01-21 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 10:02:05 [end_date_ymd] => 2026-01-21 13:02:05 [RateCDR] => 1 ) [2026-01-21 13:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 10:02:05' and `end` < '2026-01-21 13:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 13:02:19] Production.INFO: count ==5612 [2026-01-21 13:02:22] Production.ERROR: pbx CDR StartTime 2026-01-21 10:02:05 - End Time 2026-01-21 13:02:05 [2026-01-21 13:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 13:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603444', 'tblTempUsageDetail_20' ) start [2026-01-21 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603444', 'tblTempUsageDetail_20' ) end [2026-01-21 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603444', 'tblTempVendorCDR_20' ) start [2026-01-21 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603444', 'tblTempVendorCDR_20' ) end [2026-01-21 13:02:23] Production.INFO: ProcessCDR(1,16603444,1,1,2) [2026-01-21 13:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16603444,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 13:05:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16603444,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 13:05:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16603444,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 13:09:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16603444,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 13:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603444', 'tblTempUsageDetail_20' ) start [2026-01-21 13:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603444', 'tblTempUsageDetail_20' ) end [2026-01-21 13:09:41] Production.ERROR: pbx prc_insertCDR start [2026-01-21 13:09:44] Production.ERROR: pbx prc_insertCDR end [2026-01-21 13:09:44] Production.INFO: ==5948== Releasing lock... [2026-01-21 13:09:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 13:09:44] Production.INFO: 70.25 MB #Memory Used# [2026-01-21 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 11:02:05 [end_date_ymd] => 2026-01-21 14:02:05 [RateCDR] => 1 ) [2026-01-21 14:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 11:02:05' and `end` < '2026-01-21 14:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 14:02:21] Production.INFO: count ==5648 [2026-01-21 14:02:24] Production.ERROR: pbx CDR StartTime 2026-01-21 11:02:05 - End Time 2026-01-21 14:02:05 [2026-01-21 14:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 14:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603691', 'tblTempUsageDetail_20' ) start [2026-01-21 14:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603691', 'tblTempUsageDetail_20' ) end [2026-01-21 14:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603691', 'tblTempVendorCDR_20' ) start [2026-01-21 14:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603691', 'tblTempVendorCDR_20' ) end [2026-01-21 14:02:25] Production.INFO: ProcessCDR(1,16603691,1,1,2) [2026-01-21 14:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16603691,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 14:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16603691,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 14:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16603691,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 14:09:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16603691,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 14:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603691', 'tblTempUsageDetail_20' ) start [2026-01-21 14:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603691', 'tblTempUsageDetail_20' ) end [2026-01-21 14:09:41] Production.ERROR: pbx prc_insertCDR start [2026-01-21 14:09:44] Production.ERROR: pbx prc_insertCDR end [2026-01-21 14:09:44] Production.INFO: ==10908== Releasing lock... [2026-01-21 14:09:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 14:09:44] Production.INFO: 70.5 MB #Memory Used# [2026-01-21 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 12:02:05 [end_date_ymd] => 2026-01-21 15:02:05 [RateCDR] => 1 ) [2026-01-21 15:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 12:02:05' and `end` < '2026-01-21 15:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 15:02:19] Production.INFO: count ==5379 [2026-01-21 15:02:22] Production.ERROR: pbx CDR StartTime 2026-01-21 12:02:05 - End Time 2026-01-21 15:02:05 [2026-01-21 15:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603938', 'tblTempUsageDetail_20' ) start [2026-01-21 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16603938', 'tblTempUsageDetail_20' ) end [2026-01-21 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603938', 'tblTempVendorCDR_20' ) start [2026-01-21 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16603938', 'tblTempVendorCDR_20' ) end [2026-01-21 15:02:22] Production.INFO: ProcessCDR(1,16603938,1,1,2) [2026-01-21 15:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16603938,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 15:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16603938,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 15:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16603938,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 15:09:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16603938,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 15:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603938', 'tblTempUsageDetail_20' ) start [2026-01-21 15:09:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16603938', 'tblTempUsageDetail_20' ) end [2026-01-21 15:09:42] Production.ERROR: pbx prc_insertCDR start [2026-01-21 15:09:45] Production.ERROR: pbx prc_insertCDR end [2026-01-21 15:09:45] Production.INFO: ==15511== Releasing lock... [2026-01-21 15:09:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 15:09:45] Production.INFO: 68.5 MB #Memory Used# [2026-01-21 16:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 13:02:06 [end_date_ymd] => 2026-01-21 16:02:06 [RateCDR] => 1 ) [2026-01-21 16:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 13:02:06' and `end` < '2026-01-21 16:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 16:02:24] Production.INFO: count ==5412 [2026-01-21 16:02:27] Production.ERROR: pbx CDR StartTime 2026-01-21 13:02:06 - End Time 2026-01-21 16:02:06 [2026-01-21 16:02:27] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 16:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604185', 'tblTempUsageDetail_20' ) start [2026-01-21 16:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604185', 'tblTempUsageDetail_20' ) end [2026-01-21 16:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604185', 'tblTempVendorCDR_20' ) start [2026-01-21 16:02:27] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604185', 'tblTempVendorCDR_20' ) end [2026-01-21 16:02:27] Production.INFO: ProcessCDR(1,16604185,1,1,2) [2026-01-21 16:02:27] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16604185,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 16:05:48] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16604185,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 16:05:48] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16604185,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 16:09:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16604185,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 16:09:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604185', 'tblTempUsageDetail_20' ) start [2026-01-21 16:09:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604185', 'tblTempUsageDetail_20' ) end [2026-01-21 16:09:51] Production.ERROR: pbx prc_insertCDR start [2026-01-21 16:09:53] Production.ERROR: pbx prc_insertCDR end [2026-01-21 16:09:53] Production.INFO: ==19769== Releasing lock... [2026-01-21 16:09:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 16:09:53] Production.INFO: 68.75 MB #Memory Used# [2026-01-21 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 14:02:05 [end_date_ymd] => 2026-01-21 17:02:05 [RateCDR] => 1 ) [2026-01-21 17:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 14:02:05' and `end` < '2026-01-21 17:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 17:02:20] Production.INFO: count ==5159 [2026-01-21 17:02:22] Production.ERROR: pbx CDR StartTime 2026-01-21 14:02:05 - End Time 2026-01-21 17:02:05 [2026-01-21 17:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604432', 'tblTempUsageDetail_20' ) start [2026-01-21 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604432', 'tblTempUsageDetail_20' ) end [2026-01-21 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604432', 'tblTempVendorCDR_20' ) start [2026-01-21 17:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604432', 'tblTempVendorCDR_20' ) end [2026-01-21 17:02:23] Production.INFO: ProcessCDR(1,16604432,1,1,2) [2026-01-21 17:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16604432,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 17:05:49] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16604432,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 17:05:49] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16604432,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 17:09:59] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16604432,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 17:09:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604432', 'tblTempUsageDetail_20' ) start [2026-01-21 17:09:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604432', 'tblTempUsageDetail_20' ) end [2026-01-21 17:09:59] Production.ERROR: pbx prc_insertCDR start [2026-01-21 17:10:04] Production.ERROR: pbx prc_insertCDR end [2026-01-21 17:10:04] Production.INFO: ==24121== Releasing lock... [2026-01-21 17:10:04] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 17:10:04] Production.INFO: 66.75 MB #Memory Used# [2026-01-21 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 15:02:05 [end_date_ymd] => 2026-01-21 18:02:05 [RateCDR] => 1 ) [2026-01-21 18:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 15:02:05' and `end` < '2026-01-21 18:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 18:02:18] Production.INFO: count ==4345 [2026-01-21 18:02:20] Production.ERROR: pbx CDR StartTime 2026-01-21 15:02:05 - End Time 2026-01-21 18:02:05 [2026-01-21 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604677', 'tblTempUsageDetail_20' ) start [2026-01-21 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604677', 'tblTempUsageDetail_20' ) end [2026-01-21 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604677', 'tblTempVendorCDR_20' ) start [2026-01-21 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604677', 'tblTempVendorCDR_20' ) end [2026-01-21 18:02:20] Production.INFO: ProcessCDR(1,16604677,1,1,2) [2026-01-21 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16604677,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 18:05:47] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16604677,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 18:05:47] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16604677,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 18:09:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16604677,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 18:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604677', 'tblTempUsageDetail_20' ) start [2026-01-21 18:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604677', 'tblTempUsageDetail_20' ) end [2026-01-21 18:09:45] Production.ERROR: pbx prc_insertCDR start [2026-01-21 18:09:46] Production.ERROR: pbx prc_insertCDR end [2026-01-21 18:09:47] Production.INFO: ==28603== Releasing lock... [2026-01-21 18:09:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 18:09:47] Production.INFO: 60.75 MB #Memory Used# [2026-01-21 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 16:02:06 [end_date_ymd] => 2026-01-21 19:02:06 [RateCDR] => 1 ) [2026-01-21 19:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 16:02:06' and `end` < '2026-01-21 19:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 19:02:20] Production.INFO: count ==3328 [2026-01-21 19:02:22] Production.ERROR: pbx CDR StartTime 2026-01-21 16:02:06 - End Time 2026-01-21 19:02:06 [2026-01-21 19:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 19:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604924', 'tblTempUsageDetail_20' ) start [2026-01-21 19:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16604924', 'tblTempUsageDetail_20' ) end [2026-01-21 19:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604924', 'tblTempVendorCDR_20' ) start [2026-01-21 19:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16604924', 'tblTempVendorCDR_20' ) end [2026-01-21 19:02:22] Production.INFO: ProcessCDR(1,16604924,1,1,2) [2026-01-21 19:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16604924,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 19:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16604924,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 19:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16604924,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 19:09:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16604924,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 19:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604924', 'tblTempUsageDetail_20' ) start [2026-01-21 19:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16604924', 'tblTempUsageDetail_20' ) end [2026-01-21 19:09:28] Production.ERROR: pbx prc_insertCDR start [2026-01-21 19:09:29] Production.ERROR: pbx prc_insertCDR end [2026-01-21 19:09:29] Production.INFO: ==857== Releasing lock... [2026-01-21 19:09:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 19:09:29] Production.INFO: 53.25 MB #Memory Used# [2026-01-21 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 17:02:05 [end_date_ymd] => 2026-01-21 20:02:05 [RateCDR] => 1 ) [2026-01-21 20:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 17:02:05' and `end` < '2026-01-21 20:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 20:02:17] Production.INFO: count ==2172 [2026-01-21 20:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 17:02:05 - End Time 2026-01-21 20:02:05 [2026-01-21 20:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605171', 'tblTempUsageDetail_20' ) start [2026-01-21 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605171', 'tblTempUsageDetail_20' ) end [2026-01-21 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605171', 'tblTempVendorCDR_20' ) start [2026-01-21 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605171', 'tblTempVendorCDR_20' ) end [2026-01-21 20:02:18] Production.INFO: ProcessCDR(1,16605171,1,1,2) [2026-01-21 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16605171,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 20:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16605171,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 20:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16605171,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 20:09:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16605171,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 20:09:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605171', 'tblTempUsageDetail_20' ) start [2026-01-21 20:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605171', 'tblTempUsageDetail_20' ) end [2026-01-21 20:09:22] Production.ERROR: pbx prc_insertCDR start [2026-01-21 20:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-21 20:09:23] Production.INFO: ==5307== Releasing lock... [2026-01-21 20:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 20:09:23] Production.INFO: 44.75 MB #Memory Used# [2026-01-21 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 18:02:05 [end_date_ymd] => 2026-01-21 21:02:05 [RateCDR] => 1 ) [2026-01-21 21:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 18:02:05' and `end` < '2026-01-21 21:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 21:02:17] Production.INFO: count ==1611 [2026-01-21 21:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 18:02:05 - End Time 2026-01-21 21:02:05 [2026-01-21 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605418', 'tblTempUsageDetail_20' ) start [2026-01-21 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605418', 'tblTempUsageDetail_20' ) end [2026-01-21 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605418', 'tblTempVendorCDR_20' ) start [2026-01-21 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605418', 'tblTempVendorCDR_20' ) end [2026-01-21 21:02:18] Production.INFO: ProcessCDR(1,16605418,1,1,2) [2026-01-21 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16605418,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 21:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16605418,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 21:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16605418,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 21:09:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16605418,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 21:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605418', 'tblTempUsageDetail_20' ) start [2026-01-21 21:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605418', 'tblTempUsageDetail_20' ) end [2026-01-21 21:09:27] Production.ERROR: pbx prc_insertCDR start [2026-01-21 21:09:28] Production.ERROR: pbx prc_insertCDR end [2026-01-21 21:09:28] Production.INFO: ==9610== Releasing lock... [2026-01-21 21:09:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 21:09:28] Production.INFO: 40.25 MB #Memory Used# [2026-01-21 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 19:02:06 [end_date_ymd] => 2026-01-21 22:02:06 [RateCDR] => 1 ) [2026-01-21 22:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 19:02:06' and `end` < '2026-01-21 22:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 22:02:18] Production.INFO: count ==1263 [2026-01-21 22:02:19] Production.ERROR: pbx CDR StartTime 2026-01-21 19:02:06 - End Time 2026-01-21 22:02:06 [2026-01-21 22:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605665', 'tblTempUsageDetail_20' ) start [2026-01-21 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605665', 'tblTempUsageDetail_20' ) end [2026-01-21 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605665', 'tblTempVendorCDR_20' ) start [2026-01-21 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605665', 'tblTempVendorCDR_20' ) end [2026-01-21 22:02:19] Production.INFO: ProcessCDR(1,16605665,1,1,2) [2026-01-21 22:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16605665,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 22:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16605665,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 22:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16605665,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 22:09:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16605665,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 22:09:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605665', 'tblTempUsageDetail_20' ) start [2026-01-21 22:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605665', 'tblTempUsageDetail_20' ) end [2026-01-21 22:09:28] Production.ERROR: pbx prc_insertCDR start [2026-01-21 22:09:28] Production.ERROR: pbx prc_insertCDR end [2026-01-21 22:09:28] Production.INFO: ==14093== Releasing lock... [2026-01-21 22:09:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 22:09:28] Production.INFO: 37.5 MB #Memory Used# [2026-01-21 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 20:02:05 [end_date_ymd] => 2026-01-21 23:02:05 [RateCDR] => 1 ) [2026-01-21 23:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 20:02:05' and `end` < '2026-01-21 23:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-21 23:02:18] Production.INFO: count ==1125 [2026-01-21 23:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 20:02:05 - End Time 2026-01-21 23:02:05 [2026-01-21 23:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-21 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605912', 'tblTempUsageDetail_20' ) start [2026-01-21 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16605912', 'tblTempUsageDetail_20' ) end [2026-01-21 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605912', 'tblTempVendorCDR_20' ) start [2026-01-21 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16605912', 'tblTempVendorCDR_20' ) end [2026-01-21 23:02:18] Production.INFO: ProcessCDR(1,16605912,1,1,2) [2026-01-21 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16605912,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 23:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16605912,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-21 23:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16605912,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 23:09:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16605912,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-21 23:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605912', 'tblTempUsageDetail_20' ) start [2026-01-21 23:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16605912', 'tblTempUsageDetail_20' ) end [2026-01-21 23:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-21 23:09:27] Production.ERROR: pbx prc_insertCDR end [2026-01-21 23:09:27] Production.INFO: ==18423== Releasing lock... [2026-01-21 23:09:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-21 23:09:27] Production.INFO: 36.5 MB #Memory Used#