[2026-03-22 00:02:04] Production.INFO: next invoice date [2026-03-22 00:02:04] Production.INFO: 2026-04-22 [2026-03-22 00:02:04] Production.INFO: getdaysdiff [2026-03-22 00:02:04] Production.INFO: +31 [2026-03-22 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (253,16,1,31,31,'RMScheduler',2026-03-22 00:02:04,1,0,,,0) [2026-03-22 00:02:04] Production.INFO: next invoice date [2026-03-22 00:02:04] Production.INFO: 2026-04-22 [2026-03-22 00:02:04] Production.INFO: getdaysdiff [2026-03-22 00:02:04] Production.INFO: +31 [2026-03-22 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (253,13,2,31,31,'RMScheduler',2026-03-22 00:02:04,1,0,,,0) [2026-03-22 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-21 21:02:05 [end_date_ymd] => 2026-03-22 00:02:05 [RateCDR] => 1 ) [2026-03-22 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-21 21:02:05' and `end` < '2026-03-22 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-22 00:02:19] Production.INFO: count ==824 [2026-03-22 00:02:19] Production.ERROR: pbx CDR StartTime 2026-03-21 21:02:05 - End Time 2026-03-22 00:02:05 [2026-03-22 00:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16955656', 'tblTempUsageDetail_20' ) start [2026-03-22 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16955656', 'tblTempUsageDetail_20' ) end [2026-03-22 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16955656', 'tblTempVendorCDR_20' ) start [2026-03-22 00:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16955656', 'tblTempVendorCDR_20' ) end [2026-03-22 00:02:19] Production.INFO: ProcessCDR(1,16955656,1,1,2) [2026-03-22 00:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16955656,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 00:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16955656,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 00:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16955656,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 00:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16955656,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 00:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16955656', 'tblTempUsageDetail_20' ) start [2026-03-22 00:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16955656', 'tblTempUsageDetail_20' ) end [2026-03-22 00:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-22 00:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-22 00:02:43] Production.INFO: ==26233== Releasing lock... [2026-03-22 00:02:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 00:02:43] Production.INFO: 38.75 MB #Memory Used# [2026-03-22 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-21 22:02:05 [end_date_ymd] => 2026-03-22 01:02:05 [RateCDR] => 1 ) [2026-03-22 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-21 22:02:05' and `end` < '2026-03-22 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-22 01:02:17] Production.INFO: count ==844 [2026-03-22 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-21 22:02:05 - End Time 2026-03-22 01:02:05 [2026-03-22 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16955903', 'tblTempUsageDetail_20' ) start [2026-03-22 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16955903', 'tblTempUsageDetail_20' ) end [2026-03-22 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16955903', 'tblTempVendorCDR_20' ) start [2026-03-22 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16955903', 'tblTempVendorCDR_20' ) end [2026-03-22 01:02:17] Production.INFO: ProcessCDR(1,16955903,1,1,2) [2026-03-22 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16955903,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 01:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16955903,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 01:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16955903,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 01:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16955903,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 01:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16955903', 'tblTempUsageDetail_20' ) start [2026-03-22 01:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16955903', 'tblTempUsageDetail_20' ) end [2026-03-22 01:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 01:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 01:02:37] Production.INFO: ==30711== Releasing lock... [2026-03-22 01:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 01:02:37] Production.INFO: 34.5 MB #Memory Used# [2026-03-22 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-21 23:02:05 [end_date_ymd] => 2026-03-22 02:02:05 [RateCDR] => 1 ) [2026-03-22 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-21 23:02:05' and `end` < '2026-03-22 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-22 02:02:23] Production.INFO: count ==858 [2026-03-22 02:02:23] Production.ERROR: pbx CDR StartTime 2026-03-21 23:02:05 - End Time 2026-03-22 02:02:05 [2026-03-22 02:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 02:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956150', 'tblTempUsageDetail_20' ) start [2026-03-22 02:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956150', 'tblTempUsageDetail_20' ) end [2026-03-22 02:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956150', 'tblTempVendorCDR_20' ) start [2026-03-22 02:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956150', 'tblTempVendorCDR_20' ) end [2026-03-22 02:02:23] Production.INFO: ProcessCDR(1,16956150,1,1,2) [2026-03-22 02:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16956150,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 02:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16956150,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 02:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16956150,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 02:02:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16956150,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 02:02:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956150', 'tblTempUsageDetail_20' ) start [2026-03-22 02:02:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956150', 'tblTempUsageDetail_20' ) end [2026-03-22 02:02:43] Production.ERROR: pbx prc_insertCDR start [2026-03-22 02:02:44] Production.ERROR: pbx prc_insertCDR end [2026-03-22 02:02:44] Production.INFO: ==2943== Releasing lock... [2026-03-22 02:02:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 02:02:44] Production.INFO: 34.5 MB #Memory Used# [2026-03-22 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 00:02:05 [end_date_ymd] => 2026-03-22 03:02:05 [RateCDR] => 1 ) [2026-03-22 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-03-22 00:02:05' and `end` < '2026-03-22 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-03-22 03:02:16] Production.INFO: count ==1292 [2026-03-22 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 00:02:05 - End Time 2026-03-22 03:02:05 [2026-03-22 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956397', 'tblTempUsageDetail_20' ) start [2026-03-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956397', 'tblTempUsageDetail_20' ) end [2026-03-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956397', 'tblTempVendorCDR_20' ) start [2026-03-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956397', 'tblTempVendorCDR_20' ) end [2026-03-22 03:02:17] Production.INFO: ProcessCDR(1,16956397,1,1,2) [2026-03-22 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16956397,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 03:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16956397,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 03:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16956397,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 03:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16956397,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 03:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956397', 'tblTempUsageDetail_20' ) start [2026-03-22 03:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956397', 'tblTempUsageDetail_20' ) end [2026-03-22 03:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 03:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 03:02:37] Production.INFO: ==7560== Releasing lock... [2026-03-22 03:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 03:02:37] Production.INFO: 37.75 MB #Memory Used# [2026-03-22 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 01:02:05 [end_date_ymd] => 2026-03-22 04:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 01:02:05' and `end` < '2026-03-22 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-22 04:02:17] Production.INFO: count ==1206 [2026-03-22 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 01:02:05 - End Time 2026-03-22 04:02:05 [2026-03-22 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956645', 'tblTempUsageDetail_20' ) start [2026-03-22 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956645', 'tblTempUsageDetail_20' ) end [2026-03-22 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956645', 'tblTempVendorCDR_20' ) start [2026-03-22 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956645', 'tblTempVendorCDR_20' ) end [2026-03-22 04:02:17] Production.INFO: ProcessCDR(1,16956645,1,1,2) [2026-03-22 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16956645,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 04:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16956645,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 04:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16956645,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 04:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16956645,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956645', 'tblTempUsageDetail_20' ) start [2026-03-22 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956645', 'tblTempUsageDetail_20' ) end [2026-03-22 04:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 04:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-22 04:02:36] Production.INFO: ==12116== Releasing lock... [2026-03-22 04:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 04:02:36] Production.INFO: 37.5 MB #Memory Used# [2026-03-22 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 02:02:05 [end_date_ymd] => 2026-03-22 05:02:05 [RateCDR] => 1 ) [2026-03-22 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-03-22 02:02:05' and `end` < '2026-03-22 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-03-22 05:02:17] Production.INFO: count ==1031 [2026-03-22 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 02:02:05 - End Time 2026-03-22 05:02:05 [2026-03-22 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956893', 'tblTempUsageDetail_20' ) start [2026-03-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16956893', 'tblTempUsageDetail_20' ) end [2026-03-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956893', 'tblTempVendorCDR_20' ) start [2026-03-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16956893', 'tblTempVendorCDR_20' ) end [2026-03-22 05:02:17] Production.INFO: ProcessCDR(1,16956893,1,1,2) [2026-03-22 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16956893,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 05:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16956893,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 05:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16956893,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 05:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16956893,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 05:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956893', 'tblTempUsageDetail_20' ) start [2026-03-22 05:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16956893', 'tblTempUsageDetail_20' ) end [2026-03-22 05:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 05:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-22 05:02:36] Production.INFO: ==16805== Releasing lock... [2026-03-22 05:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 05:02:36] Production.INFO: 35.75 MB #Memory Used# [2026-03-22 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 03:02:05 [end_date_ymd] => 2026-03-22 06:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 03:02:05' and `end` < '2026-03-22 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-22 06:02:16] Production.INFO: count ==377 [2026-03-22 06:02:16] Production.ERROR: pbx CDR StartTime 2026-03-22 03:02:05 - End Time 2026-03-22 06:02:05 [2026-03-22 06:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957140', 'tblTempUsageDetail_20' ) start [2026-03-22 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957140', 'tblTempUsageDetail_20' ) end [2026-03-22 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957140', 'tblTempVendorCDR_20' ) start [2026-03-22 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957140', 'tblTempVendorCDR_20' ) end [2026-03-22 06:02:16] Production.INFO: ProcessCDR(1,16957140,1,1,2) [2026-03-22 06:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16957140,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 06:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16957140,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 06:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16957140,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 06:02:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16957140,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 06:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957140', 'tblTempUsageDetail_20' ) start [2026-03-22 06:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957140', 'tblTempUsageDetail_20' ) end [2026-03-22 06:02:35] Production.ERROR: pbx prc_insertCDR start [2026-03-22 06:02:35] Production.ERROR: pbx prc_insertCDR end [2026-03-22 06:02:35] Production.INFO: ==21496== Releasing lock... [2026-03-22 06:02:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 06:02:35] Production.INFO: 31.5 MB #Memory Used# [2026-03-22 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 04:02:05 [end_date_ymd] => 2026-03-22 07:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 04:02:05' and `end` < '2026-03-22 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-22 07:02:16] Production.INFO: count ==185 [2026-03-22 07:02:16] Production.ERROR: pbx CDR StartTime 2026-03-22 04:02:05 - End Time 2026-03-22 07:02:05 [2026-03-22 07:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957387', 'tblTempUsageDetail_20' ) start [2026-03-22 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957387', 'tblTempUsageDetail_20' ) end [2026-03-22 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957387', 'tblTempVendorCDR_20' ) start [2026-03-22 07:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957387', 'tblTempVendorCDR_20' ) end [2026-03-22 07:02:16] Production.INFO: ProcessCDR(1,16957387,1,1,2) [2026-03-22 07:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16957387,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 07:02:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16957387,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 07:02:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16957387,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 07:02:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16957387,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 07:02:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957387', 'tblTempUsageDetail_20' ) start [2026-03-22 07:02:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957387', 'tblTempUsageDetail_20' ) end [2026-03-22 07:02:30] Production.ERROR: pbx prc_insertCDR start [2026-03-22 07:02:30] Production.ERROR: pbx prc_insertCDR end [2026-03-22 07:02:30] Production.INFO: ==26146== Releasing lock... [2026-03-22 07:02:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 07:02:30] Production.INFO: 29.75 MB #Memory Used# [2026-03-22 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 05:02:06 [end_date_ymd] => 2026-03-22 08:02:06 [RateCDR] => 1 ) [2026-03-22 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-22 05:02:06' and `end` < '2026-03-22 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-22 08:02:17] Production.INFO: count ==105 [2026-03-22 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 05:02:06 - End Time 2026-03-22 08:02:06 [2026-03-22 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957634', 'tblTempUsageDetail_20' ) start [2026-03-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957634', 'tblTempUsageDetail_20' ) end [2026-03-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957634', 'tblTempVendorCDR_20' ) start [2026-03-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957634', 'tblTempVendorCDR_20' ) end [2026-03-22 08:02:17] Production.INFO: ProcessCDR(1,16957634,1,1,2) [2026-03-22 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16957634,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 08:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16957634,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 08:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16957634,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 08:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16957634,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957634', 'tblTempUsageDetail_20' ) start [2026-03-22 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957634', 'tblTempUsageDetail_20' ) end [2026-03-22 08:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 08:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 08:02:37] Production.INFO: ==30736== Releasing lock... [2026-03-22 08:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 08:02:37] Production.INFO: 28.75 MB #Memory Used# [2026-03-22 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 06:02:05 [end_date_ymd] => 2026-03-22 09:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 06:02:05' and `end` < '2026-03-22 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-22 09:02:16] Production.INFO: count ==98 [2026-03-22 09:02:16] Production.ERROR: pbx CDR StartTime 2026-03-22 06:02:05 - End Time 2026-03-22 09:02:05 [2026-03-22 09:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957881', 'tblTempUsageDetail_20' ) start [2026-03-22 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16957881', 'tblTempUsageDetail_20' ) end [2026-03-22 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957881', 'tblTempVendorCDR_20' ) start [2026-03-22 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16957881', 'tblTempVendorCDR_20' ) end [2026-03-22 09:02:16] Production.INFO: ProcessCDR(1,16957881,1,1,2) [2026-03-22 09:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16957881,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 09:02:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16957881,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 09:02:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16957881,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 09:02:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16957881,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 09:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957881', 'tblTempUsageDetail_20' ) start [2026-03-22 09:02:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16957881', 'tblTempUsageDetail_20' ) end [2026-03-22 09:02:35] Production.ERROR: pbx prc_insertCDR start [2026-03-22 09:02:35] Production.ERROR: pbx prc_insertCDR end [2026-03-22 09:02:35] Production.INFO: ==3036== Releasing lock... [2026-03-22 09:02:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 09:02:35] Production.INFO: 28.75 MB #Memory Used# [2026-03-22 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 07:02:06 [end_date_ymd] => 2026-03-22 10:02:06 [RateCDR] => 1 ) [2026-03-22 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-22 07:02:06' and `end` < '2026-03-22 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-22 10:02:17] Production.INFO: count ==193 [2026-03-22 10:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 07:02:06 - End Time 2026-03-22 10:02:06 [2026-03-22 10:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958128', 'tblTempUsageDetail_20' ) start [2026-03-22 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958128', 'tblTempUsageDetail_20' ) end [2026-03-22 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958128', 'tblTempVendorCDR_20' ) start [2026-03-22 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958128', 'tblTempVendorCDR_20' ) end [2026-03-22 10:02:17] Production.INFO: ProcessCDR(1,16958128,1,1,2) [2026-03-22 10:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16958128,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 10:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16958128,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 10:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16958128,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 10:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16958128,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 10:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958128', 'tblTempUsageDetail_20' ) start [2026-03-22 10:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958128', 'tblTempUsageDetail_20' ) end [2026-03-22 10:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 10:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 10:02:37] Production.INFO: ==7654== Releasing lock... [2026-03-22 10:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 10:02:37] Production.INFO: 30 MB #Memory Used# [2026-03-22 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 08:02:05 [end_date_ymd] => 2026-03-22 11:02:05 [RateCDR] => 1 ) [2026-03-22 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-22 08:02:05' and `end` < '2026-03-22 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-22 11:02:16] Production.INFO: count ==287 [2026-03-22 11:02:16] Production.ERROR: pbx CDR StartTime 2026-03-22 08:02:05 - End Time 2026-03-22 11:02:05 [2026-03-22 11:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 11:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958375', 'tblTempUsageDetail_20' ) start [2026-03-22 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958375', 'tblTempUsageDetail_20' ) end [2026-03-22 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958375', 'tblTempVendorCDR_20' ) start [2026-03-22 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958375', 'tblTempVendorCDR_20' ) end [2026-03-22 11:02:17] Production.INFO: ProcessCDR(1,16958375,1,1,2) [2026-03-22 11:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16958375,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 11:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16958375,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 11:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16958375,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 11:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16958375,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 11:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958375', 'tblTempUsageDetail_20' ) start [2026-03-22 11:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958375', 'tblTempUsageDetail_20' ) end [2026-03-22 11:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 11:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-22 11:02:36] Production.INFO: ==12317== Releasing lock... [2026-03-22 11:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 11:02:36] Production.INFO: 31 MB #Memory Used# [2026-03-22 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 09:02:06 [end_date_ymd] => 2026-03-22 12:02:06 [RateCDR] => 1 ) [2026-03-22 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-22 09:02:06' and `end` < '2026-03-22 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-22 12:02:17] Production.INFO: count ==1101 [2026-03-22 12:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 09:02:06 - End Time 2026-03-22 12:02:06 [2026-03-22 12:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958622', 'tblTempUsageDetail_20' ) start [2026-03-22 12:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958622', 'tblTempUsageDetail_20' ) end [2026-03-22 12:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958622', 'tblTempVendorCDR_20' ) start [2026-03-22 12:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958622', 'tblTempVendorCDR_20' ) end [2026-03-22 12:02:18] Production.INFO: ProcessCDR(1,16958622,1,1,2) [2026-03-22 12:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16958622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 12:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16958622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 12:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16958622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 12:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16958622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 12:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958622', 'tblTempUsageDetail_20' ) start [2026-03-22 12:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958622', 'tblTempUsageDetail_20' ) end [2026-03-22 12:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-22 12:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 12:02:38] Production.INFO: ==16940== Releasing lock... [2026-03-22 12:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 12:02:38] Production.INFO: 37 MB #Memory Used# [2026-03-22 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 10:02:05 [end_date_ymd] => 2026-03-22 13:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 10:02:05' and `end` < '2026-03-22 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-22 13:02:17] Production.INFO: count ==1384 [2026-03-22 13:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 10:02:05 - End Time 2026-03-22 13:02:05 [2026-03-22 13:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958869', 'tblTempUsageDetail_20' ) start [2026-03-22 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16958869', 'tblTempUsageDetail_20' ) end [2026-03-22 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958869', 'tblTempVendorCDR_20' ) start [2026-03-22 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16958869', 'tblTempVendorCDR_20' ) end [2026-03-22 13:02:17] Production.INFO: ProcessCDR(1,16958869,1,1,2) [2026-03-22 13:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16958869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 13:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16958869,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 13:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16958869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 13:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16958869,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 13:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958869', 'tblTempUsageDetail_20' ) start [2026-03-22 13:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16958869', 'tblTempUsageDetail_20' ) end [2026-03-22 13:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-22 13:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 13:02:38] Production.INFO: ==21573== Releasing lock... [2026-03-22 13:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 13:02:38] Production.INFO: 38.5 MB #Memory Used# [2026-03-22 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 11:02:06 [end_date_ymd] => 2026-03-22 14:02:06 [RateCDR] => 1 ) [2026-03-22 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-22 11:02:06' and `end` < '2026-03-22 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-22 14:02:17] Production.INFO: count ==1603 [2026-03-22 14:02:18] Production.ERROR: pbx CDR StartTime 2026-03-22 11:02:06 - End Time 2026-03-22 14:02:06 [2026-03-22 14:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959116', 'tblTempUsageDetail_20' ) start [2026-03-22 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959116', 'tblTempUsageDetail_20' ) end [2026-03-22 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959116', 'tblTempVendorCDR_20' ) start [2026-03-22 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959116', 'tblTempVendorCDR_20' ) end [2026-03-22 14:02:18] Production.INFO: ProcessCDR(1,16959116,1,1,2) [2026-03-22 14:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16959116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 14:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16959116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 14:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16959116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 14:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16959116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 14:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959116', 'tblTempUsageDetail_20' ) start [2026-03-22 14:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959116', 'tblTempUsageDetail_20' ) end [2026-03-22 14:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-22 14:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-22 14:02:40] Production.INFO: ==26177== Releasing lock... [2026-03-22 14:02:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 14:02:40] Production.INFO: 40.25 MB #Memory Used# [2026-03-22 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 12:02:05 [end_date_ymd] => 2026-03-22 15:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 12:02:05' and `end` < '2026-03-22 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-22 15:02:17] Production.INFO: count ==1088 [2026-03-22 15:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 12:02:05 - End Time 2026-03-22 15:02:05 [2026-03-22 15:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959363', 'tblTempUsageDetail_20' ) start [2026-03-22 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959363', 'tblTempUsageDetail_20' ) end [2026-03-22 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959363', 'tblTempVendorCDR_20' ) start [2026-03-22 15:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959363', 'tblTempVendorCDR_20' ) end [2026-03-22 15:02:17] Production.INFO: ProcessCDR(1,16959363,1,1,2) [2026-03-22 15:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16959363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 15:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16959363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 15:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16959363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 15:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16959363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 15:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959363', 'tblTempUsageDetail_20' ) start [2026-03-22 15:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959363', 'tblTempUsageDetail_20' ) end [2026-03-22 15:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 15:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 15:02:37] Production.INFO: ==31018== Releasing lock... [2026-03-22 15:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 15:02:37] Production.INFO: 36.5 MB #Memory Used# [2026-03-22 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 13:02:05 [end_date_ymd] => 2026-03-22 16:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 13:02:05' and `end` < '2026-03-22 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-22 16:02:16] Production.INFO: count ==1094 [2026-03-22 16:02:16] Production.ERROR: pbx CDR StartTime 2026-03-22 13:02:05 - End Time 2026-03-22 16:02:05 [2026-03-22 16:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 16:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959610', 'tblTempUsageDetail_20' ) start [2026-03-22 16:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959610', 'tblTempUsageDetail_20' ) end [2026-03-22 16:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959610', 'tblTempVendorCDR_20' ) start [2026-03-22 16:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959610', 'tblTempVendorCDR_20' ) end [2026-03-22 16:02:16] Production.INFO: ProcessCDR(1,16959610,1,1,2) [2026-03-22 16:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16959610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 16:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16959610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 16:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16959610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 16:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16959610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 16:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959610', 'tblTempUsageDetail_20' ) start [2026-03-22 16:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959610', 'tblTempUsageDetail_20' ) end [2026-03-22 16:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-22 16:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 16:02:37] Production.INFO: ==3154== Releasing lock... [2026-03-22 16:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 16:02:37] Production.INFO: 36.5 MB #Memory Used# [2026-03-22 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 14:02:05 [end_date_ymd] => 2026-03-22 17:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 14:02:05' and `end` < '2026-03-22 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-22 17:02:17] Production.INFO: count ==1258 [2026-03-22 17:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 14:02:05 - End Time 2026-03-22 17:02:05 [2026-03-22 17:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959857', 'tblTempUsageDetail_20' ) start [2026-03-22 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16959857', 'tblTempUsageDetail_20' ) end [2026-03-22 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959857', 'tblTempVendorCDR_20' ) start [2026-03-22 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16959857', 'tblTempVendorCDR_20' ) end [2026-03-22 17:02:17] Production.INFO: ProcessCDR(1,16959857,1,1,2) [2026-03-22 17:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16959857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 17:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16959857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 17:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16959857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 17:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16959857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 17:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959857', 'tblTempUsageDetail_20' ) start [2026-03-22 17:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16959857', 'tblTempUsageDetail_20' ) end [2026-03-22 17:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 17:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 17:02:38] Production.INFO: ==7697== Releasing lock... [2026-03-22 17:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 17:02:38] Production.INFO: 37.75 MB #Memory Used# [2026-03-22 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 15:02:06 [end_date_ymd] => 2026-03-22 18:02:06 [RateCDR] => 1 ) [2026-03-22 18: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-22 15:02:06' and `end` < '2026-03-22 18: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-22 18:02:17] Production.INFO: count ==1466 [2026-03-22 18:02:18] Production.ERROR: pbx CDR StartTime 2026-03-22 15:02:06 - End Time 2026-03-22 18:02:06 [2026-03-22 18:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 18:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960104', 'tblTempUsageDetail_20' ) start [2026-03-22 18:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960104', 'tblTempUsageDetail_20' ) end [2026-03-22 18:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960104', 'tblTempVendorCDR_20' ) start [2026-03-22 18:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960104', 'tblTempVendorCDR_20' ) end [2026-03-22 18:02:18] Production.INFO: ProcessCDR(1,16960104,1,1,2) [2026-03-22 18:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16960104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 18:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16960104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 18:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16960104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 18:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16960104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 18:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960104', 'tblTempUsageDetail_20' ) start [2026-03-22 18:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960104', 'tblTempUsageDetail_20' ) end [2026-03-22 18:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-22 18:02:41] Production.ERROR: pbx prc_insertCDR end [2026-03-22 18:02:41] Production.INFO: ==12694== Releasing lock... [2026-03-22 18:02:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 18:02:41] Production.INFO: 39.25 MB #Memory Used# [2026-03-22 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 16:02:05 [end_date_ymd] => 2026-03-22 19:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 16:02:05' and `end` < '2026-03-22 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-22 19:02:16] Production.INFO: count ==1553 [2026-03-22 19:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 16:02:05 - End Time 2026-03-22 19:02:05 [2026-03-22 19:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960350', 'tblTempUsageDetail_20' ) start [2026-03-22 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960350', 'tblTempUsageDetail_20' ) end [2026-03-22 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960350', 'tblTempVendorCDR_20' ) start [2026-03-22 19:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960350', 'tblTempVendorCDR_20' ) end [2026-03-22 19:02:17] Production.INFO: ProcessCDR(1,16960350,1,1,2) [2026-03-22 19:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16960350,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 19:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16960350,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 19:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16960350,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 19:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16960350,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 19:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960350', 'tblTempUsageDetail_20' ) start [2026-03-22 19:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960350', 'tblTempUsageDetail_20' ) end [2026-03-22 19:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-22 19:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 19:02:38] Production.INFO: ==17110== Releasing lock... [2026-03-22 19:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 19:02:38] Production.INFO: 40 MB #Memory Used# [2026-03-22 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 17:02:05 [end_date_ymd] => 2026-03-22 20:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 17:02:05' and `end` < '2026-03-22 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-22 20:02:17] Production.INFO: count ==1439 [2026-03-22 20:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 17:02:05 - End Time 2026-03-22 20:02:05 [2026-03-22 20:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960597', 'tblTempUsageDetail_20' ) start [2026-03-22 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960597', 'tblTempUsageDetail_20' ) end [2026-03-22 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960597', 'tblTempVendorCDR_20' ) start [2026-03-22 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960597', 'tblTempVendorCDR_20' ) end [2026-03-22 20:02:17] Production.INFO: ProcessCDR(1,16960597,1,1,2) [2026-03-22 20:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16960597,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 20:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16960597,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 20:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16960597,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 20:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16960597,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 20:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960597', 'tblTempUsageDetail_20' ) start [2026-03-22 20:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960597', 'tblTempUsageDetail_20' ) end [2026-03-22 20:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-22 20:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 20:02:38] Production.INFO: ==21612== Releasing lock... [2026-03-22 20:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 20:02:38] Production.INFO: 39.5 MB #Memory Used# [2026-03-22 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 18:02:05 [end_date_ymd] => 2026-03-22 21:02:05 [RateCDR] => 1 ) [2026-03-22 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-03-22 18:02:05' and `end` < '2026-03-22 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-03-22 21:02:17] Production.INFO: count ==1292 [2026-03-22 21:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 18:02:05 - End Time 2026-03-22 21:02:05 [2026-03-22 21:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960844', 'tblTempUsageDetail_20' ) start [2026-03-22 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16960844', 'tblTempUsageDetail_20' ) end [2026-03-22 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960844', 'tblTempVendorCDR_20' ) start [2026-03-22 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16960844', 'tblTempVendorCDR_20' ) end [2026-03-22 21:02:17] Production.INFO: ProcessCDR(1,16960844,1,1,2) [2026-03-22 21:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16960844,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 21:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16960844,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 21:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16960844,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 21:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16960844,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 21:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960844', 'tblTempUsageDetail_20' ) start [2026-03-22 21:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16960844', 'tblTempUsageDetail_20' ) end [2026-03-22 21:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-22 21:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-22 21:02:39] Production.INFO: ==26104== Releasing lock... [2026-03-22 21:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 21:02:39] Production.INFO: 37.75 MB #Memory Used# [2026-03-22 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 19:02:05 [end_date_ymd] => 2026-03-22 22:02:05 [RateCDR] => 1 ) [2026-03-22 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-22 19:02:05' and `end` < '2026-03-22 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-22 22:02:17] Production.INFO: count ==1263 [2026-03-22 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 19:02:05 - End Time 2026-03-22 22:02:05 [2026-03-22 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961091', 'tblTempUsageDetail_20' ) start [2026-03-22 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961091', 'tblTempUsageDetail_20' ) end [2026-03-22 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961091', 'tblTempVendorCDR_20' ) start [2026-03-22 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961091', 'tblTempVendorCDR_20' ) end [2026-03-22 22:02:17] Production.INFO: ProcessCDR(1,16961091,1,1,2) [2026-03-22 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16961091,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 22:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16961091,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 22:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16961091,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 22:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16961091,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961091', 'tblTempUsageDetail_20' ) start [2026-03-22 22:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961091', 'tblTempUsageDetail_20' ) end [2026-03-22 22:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 22:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-22 22:02:37] Production.INFO: ==30607== Releasing lock... [2026-03-22 22:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 22:02:37] Production.INFO: 37.75 MB #Memory Used# [2026-03-22 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-22 20:02:06 [end_date_ymd] => 2026-03-22 23:02:06 [RateCDR] => 1 ) [2026-03-22 23: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-22 20:02:06' and `end` < '2026-03-22 23: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-22 23:02:17] Production.INFO: count ==1168 [2026-03-22 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-22 20:02:06 - End Time 2026-03-22 23:02:06 [2026-03-22 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-22 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961338', 'tblTempUsageDetail_20' ) start [2026-03-22 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16961338', 'tblTempUsageDetail_20' ) end [2026-03-22 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961338', 'tblTempVendorCDR_20' ) start [2026-03-22 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16961338', 'tblTempVendorCDR_20' ) end [2026-03-22 23:02:17] Production.INFO: ProcessCDR(1,16961338,1,1,2) [2026-03-22 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16961338,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 23:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16961338,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-22 23:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16961338,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 23:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16961338,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-22 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961338', 'tblTempUsageDetail_20' ) start [2026-03-22 23:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16961338', 'tblTempUsageDetail_20' ) end [2026-03-22 23:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-22 23:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-22 23:02:38] Production.INFO: ==2670== Releasing lock... [2026-03-22 23:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-22 23:02:38] Production.INFO: 37 MB #Memory Used#