[2026-03-29 00:02:04] Production.INFO: next invoice date [2026-03-29 00:02:04] Production.INFO: 2026-04-29 [2026-03-29 00:02:04] Production.INFO: getdaysdiff [2026-03-29 00:02:04] Production.INFO: +31 [2026-03-29 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (1,11,1,31,31,'RMScheduler',2026-03-29 00:02:04,1,0,,,0) [2026-03-29 00:02:04] Production.INFO: next invoice date [2026-03-29 00:02:04] Production.INFO: 2026-04-29 [2026-03-29 00:02:04] Production.INFO: getdaysdiff [2026-03-29 00:02:04] Production.INFO: +31 [2026-03-29 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (1,13,2,31,31,'RMScheduler',2026-03-29 00:02:04,1,0,,,0) [2026-03-29 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 21:02:05 [end_date_ymd] => 2026-03-29 00:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-28 21:02:05' and `end` < '2026-03-29 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-03-29 00:02:18] Production.INFO: count ==926 [2026-03-29 00:02:18] Production.ERROR: pbx CDR StartTime 2026-03-28 21:02:05 - End Time 2026-03-29 00:02:05 [2026-03-29 00:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997155', 'tblTempUsageDetail_20' ) start [2026-03-29 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997155', 'tblTempUsageDetail_20' ) end [2026-03-29 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997155', 'tblTempVendorCDR_20' ) start [2026-03-29 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997155', 'tblTempVendorCDR_20' ) end [2026-03-29 00:02:18] Production.INFO: ProcessCDR(1,16997155,1,1,2) [2026-03-29 00:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16997155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 00:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16997155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 00:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16997155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 00:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16997155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 00:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997155', 'tblTempUsageDetail_20' ) start [2026-03-29 00:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997155', 'tblTempUsageDetail_20' ) end [2026-03-29 00:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 00:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-29 00:02:41] Production.INFO: ==25654== Releasing lock... [2026-03-29 00:02:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 00:02:41] Production.INFO: 39.5 MB #Memory Used# [2026-03-29 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 22:02:05 [end_date_ymd] => 2026-03-29 01:02:05 [RateCDR] => 1 ) [2026-03-29 01: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-03-28 22:02:05' and `end` < '2026-03-29 01: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-03-29 01:02:25] Production.INFO: count ==775 [2026-03-29 01:02:26] Production.ERROR: pbx CDR StartTime 2026-03-28 22:02:05 - End Time 2026-03-29 01:02:05 [2026-03-29 01:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 01:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997402', 'tblTempUsageDetail_20' ) start [2026-03-29 01:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997402', 'tblTempUsageDetail_20' ) end [2026-03-29 01:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997402', 'tblTempVendorCDR_20' ) start [2026-03-29 01:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997402', 'tblTempVendorCDR_20' ) end [2026-03-29 01:02:26] Production.INFO: ProcessCDR(1,16997402,1,1,2) [2026-03-29 01:02:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16997402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 01:02:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16997402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 01:02:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16997402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 01:02:45] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16997402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 01:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997402', 'tblTempUsageDetail_20' ) start [2026-03-29 01:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997402', 'tblTempUsageDetail_20' ) end [2026-03-29 01:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-29 01:02:46] Production.ERROR: pbx prc_insertCDR end [2026-03-29 01:02:46] Production.INFO: ==29939== Releasing lock... [2026-03-29 01:02:46] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 01:02:46] Production.INFO: 35.25 MB #Memory Used# [2026-03-29 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 23:02:05 [end_date_ymd] => 2026-03-29 02:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-28 23:02:05' and `end` < '2026-03-29 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-03-29 02:02:17] Production.INFO: count ==665 [2026-03-29 02:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 23:02:05 - End Time 2026-03-29 02:02:05 [2026-03-29 02:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997649', 'tblTempUsageDetail_20' ) start [2026-03-29 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997649', 'tblTempUsageDetail_20' ) end [2026-03-29 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997649', 'tblTempVendorCDR_20' ) start [2026-03-29 02:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997649', 'tblTempVendorCDR_20' ) end [2026-03-29 02:02:17] Production.INFO: ProcessCDR(1,16997649,1,1,2) [2026-03-29 02:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16997649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 02:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16997649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 02:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16997649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 02:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16997649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 02:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997649', 'tblTempUsageDetail_20' ) start [2026-03-29 02:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997649', 'tblTempUsageDetail_20' ) end [2026-03-29 02:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 02:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-29 02:02:38] Production.INFO: ==2069== Releasing lock... [2026-03-29 02:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 02:02:38] Production.INFO: 34 MB #Memory Used# [2026-03-29 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 00:02:06 [end_date_ymd] => 2026-03-29 03:02:06 [RateCDR] => 1 ) [2026-03-29 03: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-03-29 00:02:06' and `end` < '2026-03-29 03: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-03-29 03:02:17] Production.INFO: count ==619 [2026-03-29 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 00:02:06 - End Time 2026-03-29 03:02:06 [2026-03-29 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997896', 'tblTempUsageDetail_20' ) start [2026-03-29 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16997896', 'tblTempUsageDetail_20' ) end [2026-03-29 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997896', 'tblTempVendorCDR_20' ) start [2026-03-29 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16997896', 'tblTempVendorCDR_20' ) end [2026-03-29 03:02:17] Production.INFO: ProcessCDR(1,16997896,1,1,2) [2026-03-29 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16997896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 03:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16997896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 03:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16997896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 03:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16997896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 03:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997896', 'tblTempUsageDetail_20' ) start [2026-03-29 03:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16997896', 'tblTempUsageDetail_20' ) end [2026-03-29 03:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 03:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 03:02:37] Production.INFO: ==6724== Releasing lock... [2026-03-29 03:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 03:02:37] Production.INFO: 33.5 MB #Memory Used# [2026-03-29 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 01:02:05 [end_date_ymd] => 2026-03-29 04:02:05 [RateCDR] => 1 ) [2026-03-29 04: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-03-29 01:02:05' and `end` < '2026-03-29 04: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-03-29 04:02:17] Production.INFO: count ==686 [2026-03-29 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 01:02:05 - End Time 2026-03-29 04:02:05 [2026-03-29 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998144', 'tblTempUsageDetail_20' ) start [2026-03-29 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998144', 'tblTempUsageDetail_20' ) end [2026-03-29 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998144', 'tblTempVendorCDR_20' ) start [2026-03-29 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998144', 'tblTempVendorCDR_20' ) end [2026-03-29 04:02:17] Production.INFO: ProcessCDR(1,16998144,1,1,2) [2026-03-29 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16998144,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 04:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16998144,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 04:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16998144,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 04:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16998144,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 04:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998144', 'tblTempUsageDetail_20' ) start [2026-03-29 04:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998144', 'tblTempUsageDetail_20' ) end [2026-03-29 04:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 04:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 04:02:37] Production.INFO: ==11393== Releasing lock... [2026-03-29 04:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 04:02:37] Production.INFO: 33.75 MB #Memory Used# [2026-03-29 05:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 02:02:06 [end_date_ymd] => 2026-03-29 05:02:06 [RateCDR] => 1 ) [2026-03-29 05: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-03-29 02:02:06' and `end` < '2026-03-29 05: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-03-29 05:02:18] Production.INFO: count ==533 [2026-03-29 05:02:18] Production.ERROR: pbx CDR StartTime 2026-03-29 02:02:06 - End Time 2026-03-29 05:02:06 [2026-03-29 05:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998392', 'tblTempUsageDetail_20' ) start [2026-03-29 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998392', 'tblTempUsageDetail_20' ) end [2026-03-29 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998392', 'tblTempVendorCDR_20' ) start [2026-03-29 05:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998392', 'tblTempVendorCDR_20' ) end [2026-03-29 05:02:18] Production.INFO: ProcessCDR(1,16998392,1,1,2) [2026-03-29 05:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16998392,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 05:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16998392,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 05:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16998392,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 05:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16998392,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 05:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998392', 'tblTempUsageDetail_20' ) start [2026-03-29 05:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998392', 'tblTempUsageDetail_20' ) end [2026-03-29 05:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-29 05:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 05:02:39] Production.INFO: ==16086== Releasing lock... [2026-03-29 05:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 05:02:39] Production.INFO: 33 MB #Memory Used# [2026-03-29 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 03:02:05 [end_date_ymd] => 2026-03-29 06:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 03:02:05' and `end` < '2026-03-29 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-03-29 06:02:16] Production.INFO: count ==363 [2026-03-29 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 03:02:05 - End Time 2026-03-29 06:02:05 [2026-03-29 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998639', 'tblTempUsageDetail_20' ) start [2026-03-29 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998639', 'tblTempUsageDetail_20' ) end [2026-03-29 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998639', 'tblTempVendorCDR_20' ) start [2026-03-29 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998639', 'tblTempVendorCDR_20' ) end [2026-03-29 06:02:17] Production.INFO: ProcessCDR(1,16998639,1,1,2) [2026-03-29 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16998639,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 06:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16998639,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 06:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16998639,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 06:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16998639,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 06:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998639', 'tblTempUsageDetail_20' ) start [2026-03-29 06:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998639', 'tblTempUsageDetail_20' ) end [2026-03-29 06:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 06:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 06:02:37] Production.INFO: ==20539== Releasing lock... [2026-03-29 06:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 06:02:37] Production.INFO: 31.5 MB #Memory Used# [2026-03-29 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 04:02:05 [end_date_ymd] => 2026-03-29 07:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 04:02:05' and `end` < '2026-03-29 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-03-29 07:02:16] Production.INFO: count ==299 [2026-03-29 07:02:16] Production.ERROR: pbx CDR StartTime 2026-03-29 04:02:05 - End Time 2026-03-29 07:02:05 [2026-03-29 07:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998886', 'tblTempUsageDetail_20' ) start [2026-03-29 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16998886', 'tblTempUsageDetail_20' ) end [2026-03-29 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998886', 'tblTempVendorCDR_20' ) start [2026-03-29 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16998886', 'tblTempVendorCDR_20' ) end [2026-03-29 07:02:16] Production.INFO: ProcessCDR(1,16998886,1,1,2) [2026-03-29 07:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16998886,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 07:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16998886,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 07:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16998886,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 07:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16998886,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 07:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998886', 'tblTempUsageDetail_20' ) start [2026-03-29 07:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16998886', 'tblTempUsageDetail_20' ) end [2026-03-29 07:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-29 07:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 07:02:37] Production.INFO: ==25184== Releasing lock... [2026-03-29 07:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 07:02:37] Production.INFO: 31.25 MB #Memory Used# [2026-03-29 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 05:02:06 [end_date_ymd] => 2026-03-29 08:02:06 [RateCDR] => 1 ) [2026-03-29 08: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-03-29 05:02:06' and `end` < '2026-03-29 08: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-03-29 08:02:17] Production.INFO: count ==251 [2026-03-29 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 05:02:06 - End Time 2026-03-29 08:02:06 [2026-03-29 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999133', 'tblTempUsageDetail_20' ) start [2026-03-29 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999133', 'tblTempUsageDetail_20' ) end [2026-03-29 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999133', 'tblTempVendorCDR_20' ) start [2026-03-29 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999133', 'tblTempVendorCDR_20' ) end [2026-03-29 08:02:17] Production.INFO: ProcessCDR(1,16999133,1,1,2) [2026-03-29 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16999133,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 08:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16999133,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 08:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16999133,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 08:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16999133,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999133', 'tblTempUsageDetail_20' ) start [2026-03-29 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999133', 'tblTempUsageDetail_20' ) end [2026-03-29 08:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 08:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 08:02:37] Production.INFO: ==29487== Releasing lock... [2026-03-29 08:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 08:02:37] Production.INFO: 30.25 MB #Memory Used# [2026-03-29 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 06:02:05 [end_date_ymd] => 2026-03-29 09:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 06:02:05' and `end` < '2026-03-29 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-03-29 09:02:16] Production.INFO: count ==258 [2026-03-29 09:02:16] Production.ERROR: pbx CDR StartTime 2026-03-29 06:02:05 - End Time 2026-03-29 09:02:05 [2026-03-29 09:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999380', 'tblTempUsageDetail_20' ) start [2026-03-29 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999380', 'tblTempUsageDetail_20' ) end [2026-03-29 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999380', 'tblTempVendorCDR_20' ) start [2026-03-29 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999380', 'tblTempVendorCDR_20' ) end [2026-03-29 09:02:17] Production.INFO: ProcessCDR(1,16999380,1,1,2) [2026-03-29 09:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16999380,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 09:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16999380,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 09:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16999380,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 09:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16999380,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 09:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999380', 'tblTempUsageDetail_20' ) start [2026-03-29 09:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999380', 'tblTempUsageDetail_20' ) end [2026-03-29 09:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-29 09:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-29 09:02:36] Production.INFO: ==1449== Releasing lock... [2026-03-29 09:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 09:02:36] Production.INFO: 30.75 MB #Memory Used# [2026-03-29 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 07:02:06 [end_date_ymd] => 2026-03-29 10:02:06 [RateCDR] => 1 ) [2026-03-29 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-03-29 07:02:06' and `end` < '2026-03-29 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-03-29 10:02:17] Production.INFO: count ==147 [2026-03-29 10:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 07:02:06 - End Time 2026-03-29 10:02:06 [2026-03-29 10:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999627', 'tblTempUsageDetail_20' ) start [2026-03-29 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999627', 'tblTempUsageDetail_20' ) end [2026-03-29 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999627', 'tblTempVendorCDR_20' ) start [2026-03-29 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999627', 'tblTempVendorCDR_20' ) end [2026-03-29 10:02:17] Production.INFO: ProcessCDR(1,16999627,1,1,2) [2026-03-29 10:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16999627,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 10:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16999627,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 10:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16999627,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 10:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16999627,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 10:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999627', 'tblTempUsageDetail_20' ) start [2026-03-29 10:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999627', 'tblTempUsageDetail_20' ) end [2026-03-29 10:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 10:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 10:02:37] Production.INFO: ==5814== Releasing lock... [2026-03-29 10:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 10:02:37] Production.INFO: 29.5 MB #Memory Used# [2026-03-29 11:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 08:02:06 [end_date_ymd] => 2026-03-29 11:02:06 [RateCDR] => 1 ) [2026-03-29 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-03-29 08:02:06' and `end` < '2026-03-29 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-03-29 11:02:17] Production.INFO: count ==276 [2026-03-29 11:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 08:02:06 - End Time 2026-03-29 11:02:06 [2026-03-29 11:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999874', 'tblTempUsageDetail_20' ) start [2026-03-29 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16999874', 'tblTempUsageDetail_20' ) end [2026-03-29 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999874', 'tblTempVendorCDR_20' ) start [2026-03-29 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16999874', 'tblTempVendorCDR_20' ) end [2026-03-29 11:02:17] Production.INFO: ProcessCDR(1,16999874,1,1,2) [2026-03-29 11:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16999874,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 11:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16999874,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 11:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16999874,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 11:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16999874,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 11:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999874', 'tblTempUsageDetail_20' ) start [2026-03-29 11:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16999874', 'tblTempUsageDetail_20' ) end [2026-03-29 11:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-29 11:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 11:02:37] Production.INFO: ==10103== Releasing lock... [2026-03-29 11:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 11:02:37] Production.INFO: 30.5 MB #Memory Used# [2026-03-29 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 09:02:06 [end_date_ymd] => 2026-03-29 12:02:06 [RateCDR] => 1 ) [2026-03-29 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-03-29 09:02:06' and `end` < '2026-03-29 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-03-29 12:02:17] Production.INFO: count ==472 [2026-03-29 12:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 09:02:06 - End Time 2026-03-29 12:02:06 [2026-03-29 12:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000121', 'tblTempUsageDetail_20' ) start [2026-03-29 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000121', 'tblTempUsageDetail_20' ) end [2026-03-29 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000121', 'tblTempVendorCDR_20' ) start [2026-03-29 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000121', 'tblTempVendorCDR_20' ) end [2026-03-29 12:02:17] Production.INFO: ProcessCDR(1,17000121,1,1,2) [2026-03-29 12:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17000121,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 12:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17000121,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 12:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17000121,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 12:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17000121,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 12:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000121', 'tblTempUsageDetail_20' ) start [2026-03-29 12:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000121', 'tblTempUsageDetail_20' ) end [2026-03-29 12:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 12:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 12:02:39] Production.INFO: ==14426== Releasing lock... [2026-03-29 12:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 12:02:39] Production.INFO: 32.75 MB #Memory Used# [2026-03-29 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 10:02:05 [end_date_ymd] => 2026-03-29 13:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 10:02:05' and `end` < '2026-03-29 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-03-29 13:02:16] Production.INFO: count ==691 [2026-03-29 13:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 10:02:05 - End Time 2026-03-29 13:02:05 [2026-03-29 13:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000368', 'tblTempUsageDetail_20' ) start [2026-03-29 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000368', 'tblTempUsageDetail_20' ) end [2026-03-29 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000368', 'tblTempVendorCDR_20' ) start [2026-03-29 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000368', 'tblTempVendorCDR_20' ) end [2026-03-29 13:02:17] Production.INFO: ProcessCDR(1,17000368,1,1,2) [2026-03-29 13:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17000368,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 13:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17000368,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 13:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17000368,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 13:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17000368,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 13:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000368', 'tblTempUsageDetail_20' ) start [2026-03-29 13:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000368', 'tblTempUsageDetail_20' ) end [2026-03-29 13:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 13:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-29 13:02:38] Production.INFO: ==18859== Releasing lock... [2026-03-29 13:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 13:02:38] Production.INFO: 34.5 MB #Memory Used# [2026-03-29 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 11:02:06 [end_date_ymd] => 2026-03-29 14:02:06 [RateCDR] => 1 ) [2026-03-29 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-03-29 11:02:06' and `end` < '2026-03-29 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-03-29 14:02:17] Production.INFO: count ==888 [2026-03-29 14:02:18] Production.ERROR: pbx CDR StartTime 2026-03-29 11:02:06 - End Time 2026-03-29 14:02:06 [2026-03-29 14:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000615', 'tblTempUsageDetail_20' ) start [2026-03-29 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000615', 'tblTempUsageDetail_20' ) end [2026-03-29 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000615', 'tblTempVendorCDR_20' ) start [2026-03-29 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000615', 'tblTempVendorCDR_20' ) end [2026-03-29 14:02:18] Production.INFO: ProcessCDR(1,17000615,1,1,2) [2026-03-29 14:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17000615,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 14:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17000615,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 14:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17000615,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 14:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17000615,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 14:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000615', 'tblTempUsageDetail_20' ) start [2026-03-29 14:02:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000615', 'tblTempUsageDetail_20' ) end [2026-03-29 14:02:40] Production.ERROR: pbx prc_insertCDR start [2026-03-29 14:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-29 14:02:40] Production.INFO: ==23313== Releasing lock... [2026-03-29 14:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 14:02:40] Production.INFO: 36 MB #Memory Used# [2026-03-29 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 12:02:05 [end_date_ymd] => 2026-03-29 15:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 12:02:05' and `end` < '2026-03-29 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-03-29 15:02:16] Production.INFO: count ==950 [2026-03-29 15:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 12:02:05 - End Time 2026-03-29 15:02:05 [2026-03-29 15:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000862', 'tblTempUsageDetail_20' ) start [2026-03-29 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17000862', 'tblTempUsageDetail_20' ) end [2026-03-29 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000862', 'tblTempVendorCDR_20' ) start [2026-03-29 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17000862', 'tblTempVendorCDR_20' ) end [2026-03-29 15:02:17] Production.INFO: ProcessCDR(1,17000862,1,1,2) [2026-03-29 15:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17000862,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 15:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17000862,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 15:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17000862,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 15:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17000862,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 15:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000862', 'tblTempUsageDetail_20' ) start [2026-03-29 15:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17000862', 'tblTempUsageDetail_20' ) end [2026-03-29 15:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 15:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 15:02:39] Production.INFO: ==27972== Releasing lock... [2026-03-29 15:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 15:02:39] Production.INFO: 37 MB #Memory Used# [2026-03-29 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 13:02:05 [end_date_ymd] => 2026-03-29 16:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 13:02:05' and `end` < '2026-03-29 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-03-29 16:02:16] Production.INFO: count ==935 [2026-03-29 16:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 13:02:05 - End Time 2026-03-29 16:02:05 [2026-03-29 16:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001109', 'tblTempUsageDetail_20' ) start [2026-03-29 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001109', 'tblTempUsageDetail_20' ) end [2026-03-29 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001109', 'tblTempVendorCDR_20' ) start [2026-03-29 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001109', 'tblTempVendorCDR_20' ) end [2026-03-29 16:02:17] Production.INFO: ProcessCDR(1,17001109,1,1,2) [2026-03-29 16:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17001109,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 16:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17001109,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 16:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17001109,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 16:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17001109,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 16:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001109', 'tblTempUsageDetail_20' ) start [2026-03-29 16:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001109', 'tblTempUsageDetail_20' ) end [2026-03-29 16:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 16:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-29 16:02:38] Production.INFO: ==32376== Releasing lock... [2026-03-29 16:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 16:02:38] Production.INFO: 36.25 MB #Memory Used# [2026-03-29 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 14:02:05 [end_date_ymd] => 2026-03-29 17:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 14:02:05' and `end` < '2026-03-29 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-03-29 17:02:17] Production.INFO: count ==938 [2026-03-29 17:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 14:02:05 - End Time 2026-03-29 17:02:05 [2026-03-29 17:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001356', 'tblTempUsageDetail_20' ) start [2026-03-29 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001356', 'tblTempUsageDetail_20' ) end [2026-03-29 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001356', 'tblTempVendorCDR_20' ) start [2026-03-29 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001356', 'tblTempVendorCDR_20' ) end [2026-03-29 17:02:17] Production.INFO: ProcessCDR(1,17001356,1,1,2) [2026-03-29 17:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17001356,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 17:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17001356,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 17:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17001356,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 17:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17001356,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 17:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001356', 'tblTempUsageDetail_20' ) start [2026-03-29 17:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001356', 'tblTempUsageDetail_20' ) end [2026-03-29 17:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 17:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 17:02:39] Production.INFO: ==4386== Releasing lock... [2026-03-29 17:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 17:02:39] Production.INFO: 37 MB #Memory Used# [2026-03-29 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 15:02:05 [end_date_ymd] => 2026-03-29 18:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 15:02:05' and `end` < '2026-03-29 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-03-29 18:02:19] Production.INFO: count ==1029 [2026-03-29 18:02:20] Production.ERROR: pbx CDR StartTime 2026-03-29 15:02:05 - End Time 2026-03-29 18:02:05 [2026-03-29 18:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001603', 'tblTempUsageDetail_20' ) start [2026-03-29 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001603', 'tblTempUsageDetail_20' ) end [2026-03-29 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001603', 'tblTempVendorCDR_20' ) start [2026-03-29 18:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001603', 'tblTempVendorCDR_20' ) end [2026-03-29 18:02:20] Production.INFO: ProcessCDR(1,17001603,1,1,2) [2026-03-29 18:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17001603,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 18:02:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17001603,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 18:02:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17001603,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 18:02:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17001603,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 18:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001603', 'tblTempUsageDetail_20' ) start [2026-03-29 18:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001603', 'tblTempUsageDetail_20' ) end [2026-03-29 18:02:42] Production.ERROR: pbx prc_insertCDR start [2026-03-29 18:02:43] Production.ERROR: pbx prc_insertCDR end [2026-03-29 18:02:43] Production.INFO: ==8902== Releasing lock... [2026-03-29 18:02:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 18:02:43] Production.INFO: 37.75 MB #Memory Used# [2026-03-29 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 16:02:05 [end_date_ymd] => 2026-03-29 19:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 16:02:05' and `end` < '2026-03-29 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-03-29 19:02:17] Production.INFO: count ==1150 [2026-03-29 19:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 16:02:05 - End Time 2026-03-29 19:02:05 [2026-03-29 19:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001850', 'tblTempUsageDetail_20' ) start [2026-03-29 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17001850', 'tblTempUsageDetail_20' ) end [2026-03-29 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001850', 'tblTempVendorCDR_20' ) start [2026-03-29 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17001850', 'tblTempVendorCDR_20' ) end [2026-03-29 19:02:17] Production.INFO: ProcessCDR(1,17001850,1,1,2) [2026-03-29 19:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17001850,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 19:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17001850,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 19:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17001850,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 19:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17001850,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 19:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001850', 'tblTempUsageDetail_20' ) start [2026-03-29 19:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17001850', 'tblTempUsageDetail_20' ) end [2026-03-29 19:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 19:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 19:02:39] Production.INFO: ==13291== Releasing lock... [2026-03-29 19:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 19:02:39] Production.INFO: 38.5 MB #Memory Used# [2026-03-29 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 17:02:05 [end_date_ymd] => 2026-03-29 20:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 17:02:05' and `end` < '2026-03-29 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-03-29 20:02:16] Production.INFO: count ==1182 [2026-03-29 20:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 17:02:05 - End Time 2026-03-29 20:02:05 [2026-03-29 20:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002097', 'tblTempUsageDetail_20' ) start [2026-03-29 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002097', 'tblTempUsageDetail_20' ) end [2026-03-29 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002097', 'tblTempVendorCDR_20' ) start [2026-03-29 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002097', 'tblTempVendorCDR_20' ) end [2026-03-29 20:02:17] Production.INFO: ProcessCDR(1,17002097,1,1,2) [2026-03-29 20:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17002097,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 20:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17002097,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 20:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17002097,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 20:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17002097,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 20:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002097', 'tblTempUsageDetail_20' ) start [2026-03-29 20:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002097', 'tblTempUsageDetail_20' ) end [2026-03-29 20:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-29 20:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-29 20:02:39] Production.INFO: ==17683== Releasing lock... [2026-03-29 20:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 20:02:39] Production.INFO: 38.25 MB #Memory Used# [2026-03-29 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 18:02:06 [end_date_ymd] => 2026-03-29 21:02:06 [RateCDR] => 1 ) [2026-03-29 21: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-03-29 18:02:06' and `end` < '2026-03-29 21: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-03-29 21:02:17] Production.INFO: count ==1120 [2026-03-29 21:02:18] Production.ERROR: pbx CDR StartTime 2026-03-29 18:02:06 - End Time 2026-03-29 21:02:06 [2026-03-29 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002344', 'tblTempUsageDetail_20' ) start [2026-03-29 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002344', 'tblTempUsageDetail_20' ) end [2026-03-29 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002344', 'tblTempVendorCDR_20' ) start [2026-03-29 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002344', 'tblTempVendorCDR_20' ) end [2026-03-29 21:02:18] Production.INFO: ProcessCDR(1,17002344,1,1,2) [2026-03-29 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17002344,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 21:02:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17002344,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 21:02:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17002344,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 21:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17002344,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 21:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002344', 'tblTempUsageDetail_20' ) start [2026-03-29 21:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002344', 'tblTempUsageDetail_20' ) end [2026-03-29 21:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-29 21:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-29 21:02:40] Production.INFO: ==22087== Releasing lock... [2026-03-29 21:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 21:02:40] Production.INFO: 37.5 MB #Memory Used# [2026-03-29 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 19:02:05 [end_date_ymd] => 2026-03-29 22:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 19:02:05' and `end` < '2026-03-29 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-03-29 22:02:16] Production.INFO: count ==1021 [2026-03-29 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 19:02:05 - End Time 2026-03-29 22:02:05 [2026-03-29 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002591', 'tblTempUsageDetail_20' ) start [2026-03-29 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002591', 'tblTempUsageDetail_20' ) end [2026-03-29 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002591', 'tblTempVendorCDR_20' ) start [2026-03-29 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002591', 'tblTempVendorCDR_20' ) end [2026-03-29 22:02:17] Production.INFO: ProcessCDR(1,17002591,1,1,2) [2026-03-29 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17002591,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 22:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17002591,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 22:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17002591,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 22:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17002591,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002591', 'tblTempUsageDetail_20' ) start [2026-03-29 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002591', 'tblTempUsageDetail_20' ) end [2026-03-29 22:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 22:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 22:02:37] Production.INFO: ==26431== Releasing lock... [2026-03-29 22:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 22:02:37] Production.INFO: 37 MB #Memory Used# [2026-03-29 23:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-29 20:02:05 [end_date_ymd] => 2026-03-29 23:02:05 [RateCDR] => 1 ) [2026-03-29 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-03-29 20:02:05' and `end` < '2026-03-29 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-03-29 23:02:17] Production.INFO: count ==857 [2026-03-29 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-29 20:02:05 - End Time 2026-03-29 23:02:05 [2026-03-29 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-29 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002838', 'tblTempUsageDetail_20' ) start [2026-03-29 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17002838', 'tblTempUsageDetail_20' ) end [2026-03-29 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002838', 'tblTempVendorCDR_20' ) start [2026-03-29 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17002838', 'tblTempVendorCDR_20' ) end [2026-03-29 23:02:17] Production.INFO: ProcessCDR(1,17002838,1,1,2) [2026-03-29 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17002838,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 23:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17002838,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-29 23:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17002838,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 23:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17002838,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-29 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002838', 'tblTempUsageDetail_20' ) start [2026-03-29 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17002838', 'tblTempUsageDetail_20' ) end [2026-03-29 23:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-29 23:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-29 23:02:37] Production.INFO: ==30833== Releasing lock... [2026-03-29 23:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-29 23:02:37] Production.INFO: 35.5 MB #Memory Used#