[2026-01-23 00:02:05] Production.INFO: next invoice date [2026-01-23 00:02:05] Production.INFO: 2026-02-23 [2026-01-23 00:02:05] Production.INFO: getdaysdiff [2026-01-23 00:02:05] Production.INFO: +31 [2026-01-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (226,11,1,31,31,'RMScheduler',2026-01-23 00:02:05,1,0,,,0) [2026-01-23 00:02:05] Production.INFO: next invoice date [2026-01-23 00:02:05] Production.INFO: 2026-02-23 [2026-01-23 00:02:05] Production.INFO: getdaysdiff [2026-01-23 00:02:05] Production.INFO: +31 [2026-01-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (226,13,2,31,31,'RMScheduler',2026-01-23 00:02:05,1,0,,,0) [2026-01-23 00:02:05] Production.INFO: next invoice date [2026-01-23 00:02:05] Production.INFO: 2026-02-23 [2026-01-23 00:02:05] Production.INFO: getdaysdiff [2026-01-23 00:02:05] Production.INFO: +31 [2026-01-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (252,16,1,31,31,'RMScheduler',2026-01-23 00:02:05,1,0,,,0) [2026-01-23 00:02:05] Production.INFO: next invoice date [2026-01-23 00:02:05] Production.INFO: 2026-02-23 [2026-01-23 00:02:05] Production.INFO: getdaysdiff [2026-01-23 00:02:05] Production.INFO: +31 [2026-01-23 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (252,13,2,31,31,'RMScheduler',2026-01-23 00:02:05,1,0,,,0) [2026-01-23 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 21:02:06 [end_date_ymd] => 2026-01-23 00:02:06 [RateCDR] => 1 ) [2026-01-23 00: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-22 21:02:06' and `end` < '2026-01-23 00: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-23 00:02:40] Production.INFO: count ==652 [2026-01-23 00:02:40] Production.ERROR: pbx CDR StartTime 2026-01-22 21:02:06 - End Time 2026-01-23 00:02:06 [2026-01-23 00:02:40] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 00:02:40] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612087', 'tblTempUsageDetail_20' ) start [2026-01-23 00:02:40] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612087', 'tblTempUsageDetail_20' ) end [2026-01-23 00:02:40] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612087', 'tblTempVendorCDR_20' ) start [2026-01-23 00:02:40] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612087', 'tblTempVendorCDR_20' ) end [2026-01-23 00:02:40] Production.INFO: ProcessCDR(1,16612087,1,1,2) [2026-01-23 00:02:40] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16612087,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 00:05:58] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16612087,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 00:05:58] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16612087,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 00:09:55] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16612087,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 00:09:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612087', 'tblTempUsageDetail_20' ) start [2026-01-23 00:09:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612087', 'tblTempUsageDetail_20' ) end [2026-01-23 00:09:55] Production.ERROR: pbx prc_insertCDR start [2026-01-23 00:09:55] Production.ERROR: pbx prc_insertCDR end [2026-01-23 00:09:58] Production.INFO: ==1770== Releasing lock... [2026-01-23 00:09:58] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 00:09:58] Production.INFO: 38 MB #Memory Used# [2026-01-23 01:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 22:02:06 [end_date_ymd] => 2026-01-23 01:02:06 [RateCDR] => 1 ) [2026-01-23 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-22 22:02:06' and `end` < '2026-01-23 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-23 01:02:18] Production.INFO: count ==613 [2026-01-23 01:02:18] Production.ERROR: pbx CDR StartTime 2026-01-22 22:02:06 - End Time 2026-01-23 01:02:06 [2026-01-23 01:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612334', 'tblTempUsageDetail_20' ) start [2026-01-23 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612334', 'tblTempUsageDetail_20' ) end [2026-01-23 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612334', 'tblTempVendorCDR_20' ) start [2026-01-23 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612334', 'tblTempVendorCDR_20' ) end [2026-01-23 01:02:18] Production.INFO: ProcessCDR(1,16612334,1,1,2) [2026-01-23 01:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16612334,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 01:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16612334,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 01:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16612334,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 01:09:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16612334,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 01:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612334', 'tblTempUsageDetail_20' ) start [2026-01-23 01:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612334', 'tblTempUsageDetail_20' ) end [2026-01-23 01:09:22] Production.ERROR: pbx prc_insertCDR start [2026-01-23 01:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-23 01:09:23] Production.INFO: ==6972== Releasing lock... [2026-01-23 01:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 01:09:23] Production.INFO: 33 MB #Memory Used# [2026-01-23 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 23:02:05 [end_date_ymd] => 2026-01-23 02:02:05 [RateCDR] => 1 ) [2026-01-23 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-22 23:02:05' and `end` < '2026-01-23 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-23 02:02:18] Production.INFO: count ==611 [2026-01-23 02:02:19] Production.ERROR: pbx CDR StartTime 2026-01-22 23:02:05 - End Time 2026-01-23 02:02:05 [2026-01-23 02:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 02:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612581', 'tblTempUsageDetail_20' ) start [2026-01-23 02:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612581', 'tblTempUsageDetail_20' ) end [2026-01-23 02:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612581', 'tblTempVendorCDR_20' ) start [2026-01-23 02:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612581', 'tblTempVendorCDR_20' ) end [2026-01-23 02:02:19] Production.INFO: ProcessCDR(1,16612581,1,1,2) [2026-01-23 02:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16612581,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 02:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16612581,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 02:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16612581,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 02:09:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16612581,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 02:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612581', 'tblTempUsageDetail_20' ) start [2026-01-23 02:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612581', 'tblTempUsageDetail_20' ) end [2026-01-23 02:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 02:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-23 02:09:19] Production.INFO: ==12245== Releasing lock... [2026-01-23 02:09:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 02:09:19] Production.INFO: 33.25 MB #Memory Used# [2026-01-23 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 00:02:05 [end_date_ymd] => 2026-01-23 03:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 00:02:05' and `end` < '2026-01-23 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-23 03:02:17] Production.INFO: count ==536 [2026-01-23 03:02:17] Production.ERROR: pbx CDR StartTime 2026-01-23 00:02:05 - End Time 2026-01-23 03:02:05 [2026-01-23 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612828', 'tblTempUsageDetail_20' ) start [2026-01-23 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16612828', 'tblTempUsageDetail_20' ) end [2026-01-23 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612828', 'tblTempVendorCDR_20' ) start [2026-01-23 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16612828', 'tblTempVendorCDR_20' ) end [2026-01-23 03:02:17] Production.INFO: ProcessCDR(1,16612828,1,1,2) [2026-01-23 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16612828,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 03:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16612828,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 03:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16612828,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 03:09:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16612828,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 03:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612828', 'tblTempUsageDetail_20' ) start [2026-01-23 03:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16612828', 'tblTempUsageDetail_20' ) end [2026-01-23 03:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 03:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-23 03:09:18] Production.INFO: ==17425== Releasing lock... [2026-01-23 03:09:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 03:09:18] Production.INFO: 32.75 MB #Memory Used# [2026-01-23 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 01:02:06 [end_date_ymd] => 2026-01-23 04:02:06 [RateCDR] => 1 ) [2026-01-23 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-23 01:02:06' and `end` < '2026-01-23 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-23 04:02:18] Production.INFO: count ==352 [2026-01-23 04:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 01:02:06 - End Time 2026-01-23 04:02:06 [2026-01-23 04:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613076', 'tblTempUsageDetail_20' ) start [2026-01-23 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613076', 'tblTempUsageDetail_20' ) end [2026-01-23 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613076', 'tblTempVendorCDR_20' ) start [2026-01-23 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613076', 'tblTempVendorCDR_20' ) end [2026-01-23 04:02:18] Production.INFO: ProcessCDR(1,16613076,1,1,2) [2026-01-23 04:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16613076,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 04:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16613076,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 04:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16613076,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 04:09:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16613076,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 04:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613076', 'tblTempUsageDetail_20' ) start [2026-01-23 04:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613076', 'tblTempUsageDetail_20' ) end [2026-01-23 04:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-23 04:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-23 04:09:26] Production.INFO: ==23042== Releasing lock... [2026-01-23 04:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 04:09:26] Production.INFO: 31.25 MB #Memory Used# [2026-01-23 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 02:02:05 [end_date_ymd] => 2026-01-23 05:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 02:02:05' and `end` < '2026-01-23 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-23 05:02:18] Production.INFO: count ==169 [2026-01-23 05:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 02:02:05 - End Time 2026-01-23 05:02:05 [2026-01-23 05:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613324', 'tblTempUsageDetail_20' ) start [2026-01-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613324', 'tblTempUsageDetail_20' ) end [2026-01-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613324', 'tblTempVendorCDR_20' ) start [2026-01-23 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613324', 'tblTempVendorCDR_20' ) end [2026-01-23 05:02:18] Production.INFO: ProcessCDR(1,16613324,1,1,2) [2026-01-23 05:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16613324,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 05:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16613324,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 05:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16613324,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 05:09:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16613324,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 05:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613324', 'tblTempUsageDetail_20' ) start [2026-01-23 05:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613324', 'tblTempUsageDetail_20' ) end [2026-01-23 05:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 05:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-23 05:09:18] Production.INFO: ==27983== Releasing lock... [2026-01-23 05:09:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 05:09:18] Production.INFO: 29.75 MB #Memory Used# [2026-01-23 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 03:02:05 [end_date_ymd] => 2026-01-23 06:02:05 [RateCDR] => 1 ) [2026-01-23 06: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-23 03:02:05' and `end` < '2026-01-23 06: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-23 06:02:18] Production.INFO: count ==113 [2026-01-23 06:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 03:02:05 - End Time 2026-01-23 06:02:05 [2026-01-23 06:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613571', 'tblTempUsageDetail_20' ) start [2026-01-23 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613571', 'tblTempUsageDetail_20' ) end [2026-01-23 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613571', 'tblTempVendorCDR_20' ) start [2026-01-23 06:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613571', 'tblTempVendorCDR_20' ) end [2026-01-23 06:02:18] Production.INFO: ProcessCDR(1,16613571,1,1,2) [2026-01-23 06:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16613571,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 06:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16613571,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 06:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16613571,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 06:09:10] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16613571,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 06:09:10] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613571', 'tblTempUsageDetail_20' ) start [2026-01-23 06:09:10] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613571', 'tblTempUsageDetail_20' ) end [2026-01-23 06:09:10] Production.ERROR: pbx prc_insertCDR start [2026-01-23 06:09:10] Production.ERROR: pbx prc_insertCDR end [2026-01-23 06:09:10] Production.INFO: ==791== Releasing lock... [2026-01-23 06:09:10] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 06:09:10] Production.INFO: 28.75 MB #Memory Used# [2026-01-23 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 04:02:05 [end_date_ymd] => 2026-01-23 07:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 04:02:05' and `end` < '2026-01-23 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-23 07:02:17] Production.INFO: count ==101 [2026-01-23 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-23 04:02:05 - End Time 2026-01-23 07:02:05 [2026-01-23 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613818', 'tblTempUsageDetail_20' ) start [2026-01-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16613818', 'tblTempUsageDetail_20' ) end [2026-01-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613818', 'tblTempVendorCDR_20' ) start [2026-01-23 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16613818', 'tblTempVendorCDR_20' ) end [2026-01-23 07:02:17] Production.INFO: ProcessCDR(1,16613818,1,1,2) [2026-01-23 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16613818,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 07:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16613818,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 07:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16613818,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 07:09:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16613818,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 07:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613818', 'tblTempUsageDetail_20' ) start [2026-01-23 07:09:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16613818', 'tblTempUsageDetail_20' ) end [2026-01-23 07:09:26] Production.ERROR: pbx prc_insertCDR start [2026-01-23 07:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-23 07:09:26] Production.INFO: ==5777== Releasing lock... [2026-01-23 07:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 07:09:26] Production.INFO: 28.5 MB #Memory Used# [2026-01-23 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 05:02:05 [end_date_ymd] => 2026-01-23 08:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 05:02:05' and `end` < '2026-01-23 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-23 08:02:18] Production.INFO: count ==130 [2026-01-23 08:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 05:02:05 - End Time 2026-01-23 08:02:05 [2026-01-23 08:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614065', 'tblTempUsageDetail_20' ) start [2026-01-23 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614065', 'tblTempUsageDetail_20' ) end [2026-01-23 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614065', 'tblTempVendorCDR_20' ) start [2026-01-23 08:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614065', 'tblTempVendorCDR_20' ) end [2026-01-23 08:02:18] Production.INFO: ProcessCDR(1,16614065,1,1,2) [2026-01-23 08:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16614065,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 08:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16614065,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 08:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16614065,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 08:09:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16614065,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 08:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614065', 'tblTempUsageDetail_20' ) start [2026-01-23 08:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614065', 'tblTempUsageDetail_20' ) end [2026-01-23 08:09:40] Production.ERROR: pbx prc_insertCDR start [2026-01-23 08:09:40] Production.ERROR: pbx prc_insertCDR end [2026-01-23 08:09:40] Production.INFO: ==11009== Releasing lock... [2026-01-23 08:09:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 08:09:40] Production.INFO: 29.25 MB #Memory Used# [2026-01-23 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 06:02:06 [end_date_ymd] => 2026-01-23 09:02:06 [RateCDR] => 1 ) [2026-01-23 09: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-23 06:02:06' and `end` < '2026-01-23 09: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-23 09:02:18] Production.INFO: count ==835 [2026-01-23 09:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 06:02:06 - End Time 2026-01-23 09:02:06 [2026-01-23 09:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614312', 'tblTempUsageDetail_20' ) start [2026-01-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614312', 'tblTempUsageDetail_20' ) end [2026-01-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614312', 'tblTempVendorCDR_20' ) start [2026-01-23 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614312', 'tblTempVendorCDR_20' ) end [2026-01-23 09:02:18] Production.INFO: ProcessCDR(1,16614312,1,1,2) [2026-01-23 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16614312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 09:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16614312,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 09:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16614312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 09:09:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16614312,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 09:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614312', 'tblTempUsageDetail_20' ) start [2026-01-23 09:09:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614312', 'tblTempUsageDetail_20' ) end [2026-01-23 09:09:38] Production.ERROR: pbx prc_insertCDR start [2026-01-23 09:09:39] Production.ERROR: pbx prc_insertCDR end [2026-01-23 09:09:39] Production.INFO: ==16684== Releasing lock... [2026-01-23 09:09:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 09:09:39] Production.INFO: 34.25 MB #Memory Used# [2026-01-23 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 07:02:06 [end_date_ymd] => 2026-01-23 10:02:06 [RateCDR] => 1 ) [2026-01-23 10: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-23 07:02:06' and `end` < '2026-01-23 10: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-23 10:02:19] Production.INFO: count ==2404 [2026-01-23 10:02:21] Production.ERROR: pbx CDR StartTime 2026-01-23 07:02:06 - End Time 2026-01-23 10:02:06 [2026-01-23 10:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614559', 'tblTempUsageDetail_20' ) start [2026-01-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614559', 'tblTempUsageDetail_20' ) end [2026-01-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614559', 'tblTempVendorCDR_20' ) start [2026-01-23 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614559', 'tblTempVendorCDR_20' ) end [2026-01-23 10:02:21] Production.INFO: ProcessCDR(1,16614559,1,1,2) [2026-01-23 10:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16614559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 10:05:44] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16614559,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 10:05:44] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16614559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 10:09:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16614559,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 10:09:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614559', 'tblTempUsageDetail_20' ) start [2026-01-23 10:09:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614559', 'tblTempUsageDetail_20' ) end [2026-01-23 10:09:45] Production.ERROR: pbx prc_insertCDR start [2026-01-23 10:09:46] Production.ERROR: pbx prc_insertCDR end [2026-01-23 10:09:46] Production.INFO: ==21395== Releasing lock... [2026-01-23 10:09:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 10:09:46] Production.INFO: 46.5 MB #Memory Used# [2026-01-23 11:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 08:02:06 [end_date_ymd] => 2026-01-23 11:02:06 [RateCDR] => 1 ) [2026-01-23 11: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-23 08:02:06' and `end` < '2026-01-23 11: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-23 11:02:19] Production.INFO: count ==3984 [2026-01-23 11:02:21] Production.ERROR: pbx CDR StartTime 2026-01-23 08:02:06 - End Time 2026-01-23 11:02:06 [2026-01-23 11:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614806', 'tblTempUsageDetail_20' ) start [2026-01-23 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16614806', 'tblTempUsageDetail_20' ) end [2026-01-23 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614806', 'tblTempVendorCDR_20' ) start [2026-01-23 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16614806', 'tblTempVendorCDR_20' ) end [2026-01-23 11:02:21] Production.INFO: ProcessCDR(1,16614806,1,1,2) [2026-01-23 11:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16614806,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 11:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16614806,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 11:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16614806,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 11:09:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16614806,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 11:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614806', 'tblTempUsageDetail_20' ) start [2026-01-23 11:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16614806', 'tblTempUsageDetail_20' ) end [2026-01-23 11:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 11:09:20] Production.ERROR: pbx prc_insertCDR end [2026-01-23 11:09:20] Production.INFO: ==26066== Releasing lock... [2026-01-23 11:09:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 11:09:20] Production.INFO: 58 MB #Memory Used# [2026-01-23 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 09:02:06 [end_date_ymd] => 2026-01-23 12:02:06 [RateCDR] => 1 ) [2026-01-23 12: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-23 09:02:06' and `end` < '2026-01-23 12: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-23 12:02:22] Production.INFO: count ==5095 [2026-01-23 12:02:24] Production.ERROR: pbx CDR StartTime 2026-01-23 09:02:06 - End Time 2026-01-23 12:02:06 [2026-01-23 12:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 12:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615053', 'tblTempUsageDetail_20' ) start [2026-01-23 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615053', 'tblTempUsageDetail_20' ) end [2026-01-23 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615053', 'tblTempVendorCDR_20' ) start [2026-01-23 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615053', 'tblTempVendorCDR_20' ) end [2026-01-23 12:02:25] Production.INFO: ProcessCDR(1,16615053,1,1,2) [2026-01-23 12:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16615053,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 12:05:44] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16615053,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 12:05:44] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16615053,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 12:09:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16615053,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 12:09:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615053', 'tblTempUsageDetail_20' ) start [2026-01-23 12:09:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615053', 'tblTempUsageDetail_20' ) end [2026-01-23 12:09:47] Production.ERROR: pbx prc_insertCDR start [2026-01-23 12:09:49] Production.ERROR: pbx prc_insertCDR end [2026-01-23 12:09:49] Production.INFO: ==30793== Releasing lock... [2026-01-23 12:09:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 12:09:49] Production.INFO: 66.25 MB #Memory Used# [2026-01-23 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 10:02:05 [end_date_ymd] => 2026-01-23 13:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 10:02:05' and `end` < '2026-01-23 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-23 13:02:18] Production.INFO: count ==5152 [2026-01-23 13:02:21] Production.ERROR: pbx CDR StartTime 2026-01-23 10:02:05 - End Time 2026-01-23 13:02:05 [2026-01-23 13:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615300', 'tblTempUsageDetail_20' ) start [2026-01-23 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615300', 'tblTempUsageDetail_20' ) end [2026-01-23 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615300', 'tblTempVendorCDR_20' ) start [2026-01-23 13:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615300', 'tblTempVendorCDR_20' ) end [2026-01-23 13:02:21] Production.INFO: ProcessCDR(1,16615300,1,1,2) [2026-01-23 13:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16615300,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 13:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16615300,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 13:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16615300,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 13:09:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16615300,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 13:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615300', 'tblTempUsageDetail_20' ) start [2026-01-23 13:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615300', 'tblTempUsageDetail_20' ) end [2026-01-23 13:09:32] Production.ERROR: pbx prc_insertCDR start [2026-01-23 13:09:34] Production.ERROR: pbx prc_insertCDR end [2026-01-23 13:09:34] Production.INFO: ==2950== Releasing lock... [2026-01-23 13:09:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 13:09:34] Production.INFO: 66.75 MB #Memory Used# [2026-01-23 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 11:02:06 [end_date_ymd] => 2026-01-23 14:02:06 [RateCDR] => 1 ) [2026-01-23 14: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-23 11:02:06' and `end` < '2026-01-23 14: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-23 14:02:19] Production.INFO: count ==5268 [2026-01-23 14:02:22] Production.ERROR: pbx CDR StartTime 2026-01-23 11:02:06 - End Time 2026-01-23 14:02:06 [2026-01-23 14:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615547', 'tblTempUsageDetail_20' ) start [2026-01-23 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615547', 'tblTempUsageDetail_20' ) end [2026-01-23 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615547', 'tblTempVendorCDR_20' ) start [2026-01-23 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615547', 'tblTempVendorCDR_20' ) end [2026-01-23 14:02:22] Production.INFO: ProcessCDR(1,16615547,1,1,2) [2026-01-23 14:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16615547,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 14:05:46] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16615547,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 14:05:46] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16615547,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 14:09:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16615547,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 14:09:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615547', 'tblTempUsageDetail_20' ) start [2026-01-23 14:09:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615547', 'tblTempUsageDetail_20' ) end [2026-01-23 14:09:55] Production.ERROR: pbx prc_insertCDR start [2026-01-23 14:09:57] Production.ERROR: pbx prc_insertCDR end [2026-01-23 14:09:57] Production.INFO: ==7387== Releasing lock... [2026-01-23 14:09:57] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 14:09:57] Production.INFO: 67.75 MB #Memory Used# [2026-01-23 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 12:02:05 [end_date_ymd] => 2026-01-23 15:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 12:02:05' and `end` < '2026-01-23 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-23 15:02:25] Production.INFO: count ==5052 [2026-01-23 15:02:28] Production.ERROR: pbx CDR StartTime 2026-01-23 12:02:05 - End Time 2026-01-23 15:02:05 [2026-01-23 15:02:28] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 15:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615794', 'tblTempUsageDetail_20' ) start [2026-01-23 15:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16615794', 'tblTempUsageDetail_20' ) end [2026-01-23 15:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615794', 'tblTempVendorCDR_20' ) start [2026-01-23 15:02:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16615794', 'tblTempVendorCDR_20' ) end [2026-01-23 15:02:28] Production.INFO: ProcessCDR(1,16615794,1,1,2) [2026-01-23 15:02:28] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16615794,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 15:05:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16615794,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 15:05:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16615794,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 15:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16615794,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 15:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615794', 'tblTempUsageDetail_20' ) start [2026-01-23 15:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16615794', 'tblTempUsageDetail_20' ) end [2026-01-23 15:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-23 15:09:37] Production.ERROR: pbx prc_insertCDR end [2026-01-23 15:09:37] Production.INFO: ==11843== Releasing lock... [2026-01-23 15:09:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 15:09:37] Production.INFO: 66 MB #Memory Used# [2026-01-23 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 13:02:05 [end_date_ymd] => 2026-01-23 16:02:05 [RateCDR] => 1 ) [2026-01-23 16: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-23 13:02:05' and `end` < '2026-01-23 16: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-23 16:02:19] Production.INFO: count ==5437 [2026-01-23 16:02:22] Production.ERROR: pbx CDR StartTime 2026-01-23 13:02:05 - End Time 2026-01-23 16:02:05 [2026-01-23 16:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616041', 'tblTempUsageDetail_20' ) start [2026-01-23 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616041', 'tblTempUsageDetail_20' ) end [2026-01-23 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616041', 'tblTempVendorCDR_20' ) start [2026-01-23 16:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616041', 'tblTempVendorCDR_20' ) end [2026-01-23 16:02:22] Production.INFO: ProcessCDR(1,16616041,1,1,2) [2026-01-23 16:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16616041,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 16:05:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16616041,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 16:05:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16616041,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 16:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16616041,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 16:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616041', 'tblTempUsageDetail_20' ) start [2026-01-23 16:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616041', 'tblTempUsageDetail_20' ) end [2026-01-23 16:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-23 16:09:27] Production.ERROR: pbx prc_insertCDR end [2026-01-23 16:09:28] Production.INFO: ==16423== Releasing lock... [2026-01-23 16:09:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 16:09:28] Production.INFO: 69 MB #Memory Used# [2026-01-23 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 14:02:05 [end_date_ymd] => 2026-01-23 17:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 14:02:05' and `end` < '2026-01-23 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-23 17:02:22] Production.INFO: count ==5522 [2026-01-23 17:02:25] Production.ERROR: pbx CDR StartTime 2026-01-23 14:02:05 - End Time 2026-01-23 17:02:05 [2026-01-23 17:02:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616288', 'tblTempUsageDetail_20' ) start [2026-01-23 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616288', 'tblTempUsageDetail_20' ) end [2026-01-23 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616288', 'tblTempVendorCDR_20' ) start [2026-01-23 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616288', 'tblTempVendorCDR_20' ) end [2026-01-23 17:02:25] Production.INFO: ProcessCDR(1,16616288,1,1,2) [2026-01-23 17:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16616288,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 17:05:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16616288,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 17:05:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16616288,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 17:09:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16616288,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 17:09:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616288', 'tblTempUsageDetail_20' ) start [2026-01-23 17:09:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616288', 'tblTempUsageDetail_20' ) end [2026-01-23 17:09:51] Production.ERROR: pbx prc_insertCDR start [2026-01-23 17:09:54] Production.ERROR: pbx prc_insertCDR end [2026-01-23 17:09:54] Production.INFO: ==21102== Releasing lock... [2026-01-23 17:09:54] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 17:09:54] Production.INFO: 69.5 MB #Memory Used# [2026-01-23 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 15:02:05 [end_date_ymd] => 2026-01-23 18:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 15:02:05' and `end` < '2026-01-23 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-23 18:02:18] Production.INFO: count ==5555 [2026-01-23 18:02:21] Production.ERROR: pbx CDR StartTime 2026-01-23 15:02:05 - End Time 2026-01-23 18:02:05 [2026-01-23 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616532', 'tblTempUsageDetail_20' ) start [2026-01-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616532', 'tblTempUsageDetail_20' ) end [2026-01-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616532', 'tblTempVendorCDR_20' ) start [2026-01-23 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616532', 'tblTempVendorCDR_20' ) end [2026-01-23 18:02:21] Production.INFO: ProcessCDR(1,16616532,1,1,2) [2026-01-23 18:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16616532,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 18:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16616532,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 18:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16616532,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 18:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16616532,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 18:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616532', 'tblTempUsageDetail_20' ) start [2026-01-23 18:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616532', 'tblTempUsageDetail_20' ) end [2026-01-23 18:09:29] Production.ERROR: pbx prc_insertCDR start [2026-01-23 18:09:31] Production.ERROR: pbx prc_insertCDR end [2026-01-23 18:09:31] Production.INFO: ==25574== Releasing lock... [2026-01-23 18:09:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 18:09:31] Production.INFO: 69.75 MB #Memory Used# [2026-01-23 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 16:02:05 [end_date_ymd] => 2026-01-23 19:02:05 [RateCDR] => 1 ) [2026-01-23 19: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-23 16:02:05' and `end` < '2026-01-23 19: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-23 19:02:18] Production.INFO: count ==4511 [2026-01-23 19:02:20] Production.ERROR: pbx CDR StartTime 2026-01-23 16:02:05 - End Time 2026-01-23 19:02:05 [2026-01-23 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616779', 'tblTempUsageDetail_20' ) start [2026-01-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16616779', 'tblTempUsageDetail_20' ) end [2026-01-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616779', 'tblTempVendorCDR_20' ) start [2026-01-23 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16616779', 'tblTempVendorCDR_20' ) end [2026-01-23 19:02:20] Production.INFO: ProcessCDR(1,16616779,1,1,2) [2026-01-23 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16616779,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 19:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16616779,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 19:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16616779,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 19:09:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16616779,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 19:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616779', 'tblTempUsageDetail_20' ) start [2026-01-23 19:09:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16616779', 'tblTempUsageDetail_20' ) end [2026-01-23 19:09:22] Production.ERROR: pbx prc_insertCDR start [2026-01-23 19:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-23 19:09:23] Production.INFO: ==30802== Releasing lock... [2026-01-23 19:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 19:09:23] Production.INFO: 62 MB #Memory Used# [2026-01-23 20:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 17:02:06 [end_date_ymd] => 2026-01-23 20:02:06 [RateCDR] => 1 ) [2026-01-23 20: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-23 17:02:06' and `end` < '2026-01-23 20: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-23 20:02:20] Production.INFO: count ==3461 [2026-01-23 20:02:22] Production.ERROR: pbx CDR StartTime 2026-01-23 17:02:06 - End Time 2026-01-23 20:02:06 [2026-01-23 20:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 20:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617026', 'tblTempUsageDetail_20' ) start [2026-01-23 20:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617026', 'tblTempUsageDetail_20' ) end [2026-01-23 20:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617026', 'tblTempVendorCDR_20' ) start [2026-01-23 20:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617026', 'tblTempVendorCDR_20' ) end [2026-01-23 20:02:22] Production.INFO: ProcessCDR(1,16617026,1,1,2) [2026-01-23 20:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16617026,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 20:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16617026,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 20:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16617026,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 20:09:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16617026,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 20:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617026', 'tblTempUsageDetail_20' ) start [2026-01-23 20:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617026', 'tblTempUsageDetail_20' ) end [2026-01-23 20:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 20:09:19] Production.ERROR: pbx prc_insertCDR end [2026-01-23 20:09:19] Production.INFO: ==2899== Releasing lock... [2026-01-23 20:09:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 20:09:19] Production.INFO: 54 MB #Memory Used# [2026-01-23 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 18:02:05 [end_date_ymd] => 2026-01-23 21:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 18:02:05' and `end` < '2026-01-23 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-23 21:02:17] Production.INFO: count ==2909 [2026-01-23 21:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 18:02:05 - End Time 2026-01-23 21:02:05 [2026-01-23 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617273', 'tblTempUsageDetail_20' ) start [2026-01-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617273', 'tblTempUsageDetail_20' ) end [2026-01-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617273', 'tblTempVendorCDR_20' ) start [2026-01-23 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617273', 'tblTempVendorCDR_20' ) end [2026-01-23 21:02:18] Production.INFO: ProcessCDR(1,16617273,1,1,2) [2026-01-23 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16617273,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 21:05:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16617273,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 21:05:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16617273,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 21:09:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16617273,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 21:09:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617273', 'tblTempUsageDetail_20' ) start [2026-01-23 21:09:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617273', 'tblTempUsageDetail_20' ) end [2026-01-23 21:09:18] Production.ERROR: pbx prc_insertCDR start [2026-01-23 21:09:19] Production.ERROR: pbx prc_insertCDR end [2026-01-23 21:09:19] Production.INFO: ==7363== Releasing lock... [2026-01-23 21:09:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 21:09:19] Production.INFO: 49.75 MB #Memory Used# [2026-01-23 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 19:02:05 [end_date_ymd] => 2026-01-23 22:02:05 [RateCDR] => 1 ) [2026-01-23 22: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-23 19:02:05' and `end` < '2026-01-23 22: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-23 22:02:18] Production.INFO: count ==2436 [2026-01-23 22:02:19] Production.ERROR: pbx CDR StartTime 2026-01-23 19:02:05 - End Time 2026-01-23 22:02:05 [2026-01-23 22:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617520', 'tblTempUsageDetail_20' ) start [2026-01-23 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617520', 'tblTempUsageDetail_20' ) end [2026-01-23 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617520', 'tblTempVendorCDR_20' ) start [2026-01-23 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617520', 'tblTempVendorCDR_20' ) end [2026-01-23 22:02:19] Production.INFO: ProcessCDR(1,16617520,1,1,2) [2026-01-23 22:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16617520,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 22:05:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16617520,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 22:05:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16617520,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 22:09:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16617520,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 22:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617520', 'tblTempUsageDetail_20' ) start [2026-01-23 22:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617520', 'tblTempUsageDetail_20' ) end [2026-01-23 22:09:40] Production.ERROR: pbx prc_insertCDR start [2026-01-23 22:09:41] Production.ERROR: pbx prc_insertCDR end [2026-01-23 22:09:41] Production.INFO: ==11803== Releasing lock... [2026-01-23 22:09:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 22:09:41] Production.INFO: 46.5 MB #Memory Used# [2026-01-23 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-23 20:02:05 [end_date_ymd] => 2026-01-23 23:02:05 [RateCDR] => 1 ) [2026-01-23 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-23 20:02:05' and `end` < '2026-01-23 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-23 23:02:17] Production.INFO: count ==2041 [2026-01-23 23:02:18] Production.ERROR: pbx CDR StartTime 2026-01-23 20:02:05 - End Time 2026-01-23 23:02:05 [2026-01-23 23:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-23 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617767', 'tblTempUsageDetail_20' ) start [2026-01-23 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16617767', 'tblTempUsageDetail_20' ) end [2026-01-23 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617767', 'tblTempVendorCDR_20' ) start [2026-01-23 23:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16617767', 'tblTempVendorCDR_20' ) end [2026-01-23 23:02:18] Production.INFO: ProcessCDR(1,16617767,1,1,2) [2026-01-23 23:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16617767,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 23:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16617767,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-23 23:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16617767,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 23:09:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16617767,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-23 23:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617767', 'tblTempUsageDetail_20' ) start [2026-01-23 23:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16617767', 'tblTempUsageDetail_20' ) end [2026-01-23 23:09:40] Production.ERROR: pbx prc_insertCDR start [2026-01-23 23:09:41] Production.ERROR: pbx prc_insertCDR end [2026-01-23 23:09:41] Production.INFO: ==16458== Releasing lock... [2026-01-23 23:09:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-23 23:09:41] Production.INFO: 43.75 MB #Memory Used#