[2026-03-31 00:02:05] Production.INFO: next invoice date [2026-03-31 00:02:05] Production.INFO: 2026-05-01 [2026-03-31 00:02:05] Production.INFO: getdaysdiff [2026-03-31 00:02:05] Production.INFO: +31 [2026-03-31 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (208,11,1,31,31,'RMScheduler',2026-03-31 00:02:05,0,0,,,0) [2026-03-31 00:02:05] Production.INFO: next invoice date [2026-03-31 00:02:05] Production.INFO: 2026-05-01 [2026-03-31 00:02:05] Production.INFO: getdaysdiff [2026-03-31 00:02:05] Production.INFO: +31 [2026-03-31 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (208,13,2,31,31,'RMScheduler',2026-03-31 00:02:05,0,0,,,0) [2026-03-31 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-30 21:02:06 [end_date_ymd] => 2026-03-31 00:02:06 [RateCDR] => 1 ) [2026-03-31 00:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-30 21:02:06' and `end` < '2026-03-31 00:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 00:02:18] Production.INFO: count ==734 [2026-03-31 00:02:18] Production.ERROR: pbx CDR StartTime 2026-03-30 21:02:06 - End Time 2026-03-31 00:02:06 [2026-03-31 00:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009012', 'tblTempUsageDetail_20' ) start [2026-03-31 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009012', 'tblTempUsageDetail_20' ) end [2026-03-31 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009012', 'tblTempVendorCDR_20' ) start [2026-03-31 00:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009012', 'tblTempVendorCDR_20' ) end [2026-03-31 00:02:18] Production.INFO: ProcessCDR(1,17009012,1,1,2) [2026-03-31 00:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17009012,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 00:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17009012,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 00:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17009012,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 00:02:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17009012,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 00:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009012', 'tblTempUsageDetail_20' ) start [2026-03-31 00:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009012', 'tblTempUsageDetail_20' ) end [2026-03-31 00:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-31 00:02:40] Production.ERROR: pbx prc_insertCDR end [2026-03-31 00:02:42] Production.INFO: ==12935== Releasing lock... [2026-03-31 00:02:42] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 00:02:42] Production.INFO: 38.75 MB #Memory Used# [2026-03-31 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-30 22:02:05 [end_date_ymd] => 2026-03-31 01:02:05 [RateCDR] => 1 ) [2026-03-31 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-30 22:02:05' and `end` < '2026-03-31 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-31 01:02:18] Production.INFO: count ==599 [2026-03-31 01:02:18] Production.ERROR: pbx CDR StartTime 2026-03-30 22:02:05 - End Time 2026-03-31 01:02:05 [2026-03-31 01:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009259', 'tblTempUsageDetail_20' ) start [2026-03-31 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009259', 'tblTempUsageDetail_20' ) end [2026-03-31 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009259', 'tblTempVendorCDR_20' ) start [2026-03-31 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009259', 'tblTempVendorCDR_20' ) end [2026-03-31 01:02:18] Production.INFO: ProcessCDR(1,17009259,1,1,2) [2026-03-31 01:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17009259,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 01:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17009259,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 01:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17009259,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 01:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17009259,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 01:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009259', 'tblTempUsageDetail_20' ) start [2026-03-31 01:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009259', 'tblTempUsageDetail_20' ) end [2026-03-31 01:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-31 01:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-31 01:02:39] Production.INFO: ==17493== Releasing lock... [2026-03-31 01:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 01:02:39] Production.INFO: 33.25 MB #Memory Used# [2026-03-31 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-30 23:02:06 [end_date_ymd] => 2026-03-31 02:02:06 [RateCDR] => 1 ) [2026-03-31 02: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-30 23:02:06' and `end` < '2026-03-31 02: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-31 02:02:18] Production.INFO: count ==659 [2026-03-31 02:02:18] Production.ERROR: pbx CDR StartTime 2026-03-30 23:02:06 - End Time 2026-03-31 02:02:06 [2026-03-31 02:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009506', 'tblTempUsageDetail_20' ) start [2026-03-31 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009506', 'tblTempUsageDetail_20' ) end [2026-03-31 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009506', 'tblTempVendorCDR_20' ) start [2026-03-31 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009506', 'tblTempVendorCDR_20' ) end [2026-03-31 02:02:18] Production.INFO: ProcessCDR(1,17009506,1,1,2) [2026-03-31 02:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17009506,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 02:02:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17009506,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 02:02:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17009506,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 02:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17009506,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 02:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009506', 'tblTempUsageDetail_20' ) start [2026-03-31 02:02:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009506', 'tblTempUsageDetail_20' ) end [2026-03-31 02:02:39] Production.ERROR: pbx prc_insertCDR start [2026-03-31 02:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-31 02:02:39] Production.INFO: ==22028== Releasing lock... [2026-03-31 02:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 02:02:39] Production.INFO: 34 MB #Memory Used# [2026-03-31 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 00:02:06 [end_date_ymd] => 2026-03-31 03:02:06 [RateCDR] => 1 ) [2026-03-31 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-31 00:02:06' and `end` < '2026-03-31 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-31 03:02:17] Production.INFO: count ==632 [2026-03-31 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 00:02:06 - End Time 2026-03-31 03:02:06 [2026-03-31 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009753', 'tblTempUsageDetail_20' ) start [2026-03-31 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17009753', 'tblTempUsageDetail_20' ) end [2026-03-31 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009753', 'tblTempVendorCDR_20' ) start [2026-03-31 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17009753', 'tblTempVendorCDR_20' ) end [2026-03-31 03:02:17] Production.INFO: ProcessCDR(1,17009753,1,1,2) [2026-03-31 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17009753,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 03:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17009753,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 03:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17009753,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 03:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17009753,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 03:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009753', 'tblTempUsageDetail_20' ) start [2026-03-31 03:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17009753', 'tblTempUsageDetail_20' ) end [2026-03-31 03:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-31 03:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-31 03:02:38] Production.INFO: ==27121== Releasing lock... [2026-03-31 03:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 03:02:38] Production.INFO: 33.75 MB #Memory Used# [2026-03-31 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 01:02:05 [end_date_ymd] => 2026-03-31 04:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 01:02:05' and `end` < '2026-03-31 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-31 04:02:17] Production.INFO: count ==489 [2026-03-31 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 01:02:05 - End Time 2026-03-31 04:02:05 [2026-03-31 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010001', 'tblTempUsageDetail_20' ) start [2026-03-31 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010001', 'tblTempUsageDetail_20' ) end [2026-03-31 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010001', 'tblTempVendorCDR_20' ) start [2026-03-31 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010001', 'tblTempVendorCDR_20' ) end [2026-03-31 04:02:17] Production.INFO: ProcessCDR(1,17010001,1,1,2) [2026-03-31 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17010001,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 04:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17010001,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 04:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17010001,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 04:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17010001,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010001', 'tblTempUsageDetail_20' ) start [2026-03-31 04:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010001', 'tblTempUsageDetail_20' ) end [2026-03-31 04:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-31 04:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-31 04:02:36] Production.INFO: ==32631== Releasing lock... [2026-03-31 04:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 04:02:36] Production.INFO: 32.5 MB #Memory Used# [2026-03-31 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 02:02:05 [end_date_ymd] => 2026-03-31 05:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 02:02:05' and `end` < '2026-03-31 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-31 05:02:16] Production.INFO: count ==248 [2026-03-31 05:02:16] Production.ERROR: pbx CDR StartTime 2026-03-31 02:02:05 - End Time 2026-03-31 05:02:05 [2026-03-31 05:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 05:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010249', 'tblTempUsageDetail_20' ) start [2026-03-31 05:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010249', 'tblTempUsageDetail_20' ) end [2026-03-31 05:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010249', 'tblTempVendorCDR_20' ) start [2026-03-31 05:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010249', 'tblTempVendorCDR_20' ) end [2026-03-31 05:02:16] Production.INFO: ProcessCDR(1,17010249,1,1,2) [2026-03-31 05:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17010249,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 05:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17010249,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 05:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17010249,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 05:02:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17010249,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 05:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010249', 'tblTempUsageDetail_20' ) start [2026-03-31 05:02:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010249', 'tblTempUsageDetail_20' ) end [2026-03-31 05:02:36] Production.ERROR: pbx prc_insertCDR start [2026-03-31 05:02:36] Production.ERROR: pbx prc_insertCDR end [2026-03-31 05:02:36] Production.INFO: ==4605== Releasing lock... [2026-03-31 05:02:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 05:02:36] Production.INFO: 30.5 MB #Memory Used# [2026-03-31 06:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 03:02:06 [end_date_ymd] => 2026-03-31 06:02:06 [RateCDR] => 1 ) [2026-03-31 06:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-31 03:02:06' and `end` < '2026-03-31 06:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 06:02:17] Production.INFO: count ==65 [2026-03-31 06:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 03:02:06 - End Time 2026-03-31 06:02:06 [2026-03-31 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010496', 'tblTempUsageDetail_20' ) start [2026-03-31 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010496', 'tblTempUsageDetail_20' ) end [2026-03-31 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010496', 'tblTempVendorCDR_20' ) start [2026-03-31 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010496', 'tblTempVendorCDR_20' ) end [2026-03-31 06:02:17] Production.INFO: ProcessCDR(1,17010496,1,1,2) [2026-03-31 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17010496,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 06:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17010496,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 06:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17010496,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 06:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17010496,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 06:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010496', 'tblTempUsageDetail_20' ) start [2026-03-31 06:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010496', 'tblTempUsageDetail_20' ) end [2026-03-31 06:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-31 06:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-31 06:02:38] Production.INFO: ==8942== Releasing lock... [2026-03-31 06:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 06:02:38] Production.INFO: 28.5 MB #Memory Used# [2026-03-31 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 04:02:06 [end_date_ymd] => 2026-03-31 07:02:06 [RateCDR] => 1 ) [2026-03-31 07: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-31 04:02:06' and `end` < '2026-03-31 07: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-31 07:02:17] Production.INFO: count ==49 [2026-03-31 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 04:02:06 - End Time 2026-03-31 07:02:06 [2026-03-31 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010743', 'tblTempUsageDetail_20' ) start [2026-03-31 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010743', 'tblTempUsageDetail_20' ) end [2026-03-31 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010743', 'tblTempVendorCDR_20' ) start [2026-03-31 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010743', 'tblTempVendorCDR_20' ) end [2026-03-31 07:02:17] Production.INFO: ProcessCDR(1,17010743,1,1,2) [2026-03-31 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17010743,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 07:02:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17010743,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 07:02:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17010743,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 07:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17010743,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 07:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010743', 'tblTempUsageDetail_20' ) start [2026-03-31 07:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010743', 'tblTempUsageDetail_20' ) end [2026-03-31 07:02:37] Production.ERROR: pbx prc_insertCDR start [2026-03-31 07:02:37] Production.ERROR: pbx prc_insertCDR end [2026-03-31 07:02:37] Production.INFO: ==13381== Releasing lock... [2026-03-31 07:02:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 07:02:37] Production.INFO: 28.5 MB #Memory Used# [2026-03-31 08:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 05:02:06 [end_date_ymd] => 2026-03-31 08:02:06 [RateCDR] => 1 ) [2026-03-31 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-31 05:02:06' and `end` < '2026-03-31 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-31 08:02:17] Production.INFO: count ==105 [2026-03-31 08:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 05:02:06 - End Time 2026-03-31 08:02:06 [2026-03-31 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010990', 'tblTempUsageDetail_20' ) start [2026-03-31 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17010990', 'tblTempUsageDetail_20' ) end [2026-03-31 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010990', 'tblTempVendorCDR_20' ) start [2026-03-31 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17010990', 'tblTempVendorCDR_20' ) end [2026-03-31 08:02:17] Production.INFO: ProcessCDR(1,17010990,1,1,2) [2026-03-31 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17010990,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 08:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17010990,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 08:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17010990,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 08:02:37] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17010990,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 08:02:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010990', 'tblTempUsageDetail_20' ) start [2026-03-31 08:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17010990', 'tblTempUsageDetail_20' ) end [2026-03-31 08:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-31 08:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-31 08:02:38] Production.INFO: ==17761== Releasing lock... [2026-03-31 08:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 08:02:38] Production.INFO: 29 MB #Memory Used# [2026-03-31 09:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 06:02:06 [end_date_ymd] => 2026-03-31 09:02:06 [RateCDR] => 1 ) [2026-03-31 09:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-31 06:02:06' and `end` < '2026-03-31 09:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 09:02:17] Production.INFO: count ==582 [2026-03-31 09:02:18] Production.ERROR: pbx CDR StartTime 2026-03-31 06:02:06 - End Time 2026-03-31 09:02:06 [2026-03-31 09:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011237', 'tblTempUsageDetail_20' ) start [2026-03-31 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011237', 'tblTempUsageDetail_20' ) end [2026-03-31 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011237', 'tblTempVendorCDR_20' ) start [2026-03-31 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011237', 'tblTempVendorCDR_20' ) end [2026-03-31 09:02:18] Production.INFO: ProcessCDR(1,17011237,1,1,2) [2026-03-31 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17011237,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 09:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17011237,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 09:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17011237,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 09:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17011237,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 09:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011237', 'tblTempUsageDetail_20' ) start [2026-03-31 09:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011237', 'tblTempUsageDetail_20' ) end [2026-03-31 09:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-31 09:02:39] Production.ERROR: pbx prc_insertCDR end [2026-03-31 09:02:39] Production.INFO: ==22409== Releasing lock... [2026-03-31 09:02:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 09:02:39] Production.INFO: 33.5 MB #Memory Used# [2026-03-31 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 07:02:06 [end_date_ymd] => 2026-03-31 10:02:06 [RateCDR] => 1 ) [2026-03-31 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-31 07:02:06' and `end` < '2026-03-31 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-31 10:02:18] Production.INFO: count ==1820 [2026-03-31 10:02:19] Production.ERROR: pbx CDR StartTime 2026-03-31 07:02:06 - End Time 2026-03-31 10:02:06 [2026-03-31 10:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011484', 'tblTempUsageDetail_20' ) start [2026-03-31 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011484', 'tblTempUsageDetail_20' ) end [2026-03-31 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011484', 'tblTempVendorCDR_20' ) start [2026-03-31 10:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011484', 'tblTempVendorCDR_20' ) end [2026-03-31 10:02:19] Production.INFO: ProcessCDR(1,17011484,1,1,2) [2026-03-31 10:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17011484,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 10:02:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17011484,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 10:02:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17011484,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 10:02:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17011484,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 10:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011484', 'tblTempUsageDetail_20' ) start [2026-03-31 10:02:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011484', 'tblTempUsageDetail_20' ) end [2026-03-31 10:02:42] Production.ERROR: pbx prc_insertCDR start [2026-03-31 10:02:44] Production.ERROR: pbx prc_insertCDR end [2026-03-31 10:02:44] Production.INFO: ==26846== Releasing lock... [2026-03-31 10:02:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 10:02:44] Production.INFO: 42.25 MB #Memory Used# [2026-03-31 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 08:02:05 [end_date_ymd] => 2026-03-31 11:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 08:02:05' and `end` < '2026-03-31 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-31 11:02:20] Production.INFO: count ==3293 [2026-03-31 11:02:21] Production.ERROR: pbx CDR StartTime 2026-03-31 08:02:05 - End Time 2026-03-31 11:02:05 [2026-03-31 11:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 11:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011731', 'tblTempUsageDetail_20' ) start [2026-03-31 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011731', 'tblTempUsageDetail_20' ) end [2026-03-31 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011731', 'tblTempVendorCDR_20' ) start [2026-03-31 11:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011731', 'tblTempVendorCDR_20' ) end [2026-03-31 11:02:22] Production.INFO: ProcessCDR(1,17011731,1,1,2) [2026-03-31 11:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17011731,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 11:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17011731,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 11:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17011731,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 11:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17011731,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 11:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011731', 'tblTempUsageDetail_20' ) start [2026-03-31 11:02:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011731', 'tblTempUsageDetail_20' ) end [2026-03-31 11:02:45] Production.ERROR: pbx prc_insertCDR start [2026-03-31 11:02:47] Production.ERROR: pbx prc_insertCDR end [2026-03-31 11:02:47] Production.INFO: ==31175== Releasing lock... [2026-03-31 11:02:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 11:02:47] Production.INFO: 53.25 MB #Memory Used# [2026-03-31 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 09:02:05 [end_date_ymd] => 2026-03-31 12:02:05 [RateCDR] => 1 ) [2026-03-31 12:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-31 09:02:05' and `end` < '2026-03-31 12:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 12:02:18] Production.INFO: count ==4509 [2026-03-31 12:02:21] Production.ERROR: pbx CDR StartTime 2026-03-31 09:02:05 - End Time 2026-03-31 12:02:05 [2026-03-31 12:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011978', 'tblTempUsageDetail_20' ) start [2026-03-31 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17011978', 'tblTempUsageDetail_20' ) end [2026-03-31 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011978', 'tblTempVendorCDR_20' ) start [2026-03-31 12:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17011978', 'tblTempVendorCDR_20' ) end [2026-03-31 12:02:21] Production.INFO: ProcessCDR(1,17011978,1,1,2) [2026-03-31 12:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17011978,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 12:02:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17011978,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 12:02:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17011978,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 12:02:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17011978,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 12:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011978', 'tblTempUsageDetail_20' ) start [2026-03-31 12:02:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17011978', 'tblTempUsageDetail_20' ) end [2026-03-31 12:02:44] Production.ERROR: pbx prc_insertCDR start [2026-03-31 12:02:48] Production.ERROR: pbx prc_insertCDR end [2026-03-31 12:02:48] Production.INFO: ==3382== Releasing lock... [2026-03-31 12:02:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 12:02:48] Production.INFO: 62 MB #Memory Used# [2026-03-31 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 10:02:05 [end_date_ymd] => 2026-03-31 13:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 10:02:05' and `end` < '2026-03-31 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-31 13:02:22] Production.INFO: count ==4810 [2026-03-31 13:02:25] Production.ERROR: pbx CDR StartTime 2026-03-31 10:02:05 - End Time 2026-03-31 13:02:05 [2026-03-31 13:02:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 13:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012225', 'tblTempUsageDetail_20' ) start [2026-03-31 13:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012225', 'tblTempUsageDetail_20' ) end [2026-03-31 13:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012225', 'tblTempVendorCDR_20' ) start [2026-03-31 13:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012225', 'tblTempVendorCDR_20' ) end [2026-03-31 13:02:26] Production.INFO: ProcessCDR(1,17012225,1,1,2) [2026-03-31 13:02:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17012225,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 13:02:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17012225,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 13:02:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17012225,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 13:02:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17012225,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 13:02:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012225', 'tblTempUsageDetail_20' ) start [2026-03-31 13:02:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012225', 'tblTempUsageDetail_20' ) end [2026-03-31 13:02:50] Production.ERROR: pbx prc_insertCDR start [2026-03-31 13:02:53] Production.ERROR: pbx prc_insertCDR end [2026-03-31 13:02:53] Production.INFO: ==7951== Releasing lock... [2026-03-31 13:02:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 13:02:53] Production.INFO: 64.25 MB #Memory Used# [2026-03-31 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 11:02:05 [end_date_ymd] => 2026-03-31 14:02:05 [RateCDR] => 1 ) [2026-03-31 14:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-31 11:02:05' and `end` < '2026-03-31 14:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 14:02:18] Production.INFO: count ==4823 [2026-03-31 14:02:21] Production.ERROR: pbx CDR StartTime 2026-03-31 11:02:05 - End Time 2026-03-31 14:02:05 [2026-03-31 14:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 14:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012472', 'tblTempUsageDetail_20' ) start [2026-03-31 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012472', 'tblTempUsageDetail_20' ) end [2026-03-31 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012472', 'tblTempVendorCDR_20' ) start [2026-03-31 14:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012472', 'tblTempVendorCDR_20' ) end [2026-03-31 14:02:22] Production.INFO: ProcessCDR(1,17012472,1,1,2) [2026-03-31 14:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17012472,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 14:02:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17012472,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 14:02:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17012472,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 14:07:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17012472,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 14:07:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012472', 'tblTempUsageDetail_20' ) start [2026-03-31 14:07:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012472', 'tblTempUsageDetail_20' ) end [2026-03-31 14:07:17] Production.ERROR: pbx prc_insertCDR start [2026-03-31 14:07:20] Production.ERROR: pbx prc_insertCDR end [2026-03-31 14:07:20] Production.INFO: ==12379== Releasing lock... [2026-03-31 14:07:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 14:07:20] Production.INFO: 64.5 MB #Memory Used# [2026-03-31 15:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 12:02:05 [end_date_ymd] => 2026-03-31 15:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 12:02:05' and `end` < '2026-03-31 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-31 15:02:19] Production.INFO: count ==4689 [2026-03-31 15:02:22] Production.ERROR: pbx CDR StartTime 2026-03-31 12:02:05 - End Time 2026-03-31 15:02:05 [2026-03-31 15:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012719', 'tblTempUsageDetail_20' ) start [2026-03-31 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012719', 'tblTempUsageDetail_20' ) end [2026-03-31 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012719', 'tblTempVendorCDR_20' ) start [2026-03-31 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012719', 'tblTempVendorCDR_20' ) end [2026-03-31 15:02:23] Production.INFO: ProcessCDR(1,17012719,1,1,2) [2026-03-31 15:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17012719,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 15:06:16] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17012719,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 15:06:16] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17012719,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 15:10:53] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17012719,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 15:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012719', 'tblTempUsageDetail_20' ) start [2026-03-31 15:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012719', 'tblTempUsageDetail_20' ) end [2026-03-31 15:10:53] Production.ERROR: pbx prc_insertCDR start [2026-03-31 15:10:56] Production.ERROR: pbx prc_insertCDR end [2026-03-31 15:10:56] Production.INFO: ==16973== Releasing lock... [2026-03-31 15:10:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 15:10:56] Production.INFO: 63.5 MB #Memory Used# [2026-03-31 16:02:04] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 13:02:04 [end_date_ymd] => 2026-03-31 16:02:04 [RateCDR] => 1 ) [2026-03-31 16:02:04] 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-31 13:02:04' and `end` < '2026-03-31 16:02:04' 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-31 16:02:17] Production.INFO: count ==4799 [2026-03-31 16:02:20] Production.ERROR: pbx CDR StartTime 2026-03-31 13:02:04 - End Time 2026-03-31 16:02:04 [2026-03-31 16:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 16:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012966', 'tblTempUsageDetail_20' ) start [2026-03-31 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17012966', 'tblTempUsageDetail_20' ) end [2026-03-31 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012966', 'tblTempVendorCDR_20' ) start [2026-03-31 16:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17012966', 'tblTempVendorCDR_20' ) end [2026-03-31 16:02:21] Production.INFO: ProcessCDR(1,17012966,1,1,2) [2026-03-31 16:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17012966,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 16:06:16] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17012966,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 16:06:16] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17012966,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 16:10:59] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17012966,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 16:10:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012966', 'tblTempUsageDetail_20' ) start [2026-03-31 16:10:59] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17012966', 'tblTempUsageDetail_20' ) end [2026-03-31 16:10:59] Production.ERROR: pbx prc_insertCDR start [2026-03-31 16:11:02] Production.ERROR: pbx prc_insertCDR end [2026-03-31 16:11:02] Production.INFO: ==21684== Releasing lock... [2026-03-31 16:11:02] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 16:11:02] Production.INFO: 64.25 MB #Memory Used# [2026-03-31 17:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 14:02:06 [end_date_ymd] => 2026-03-31 17:02:06 [RateCDR] => 1 ) [2026-03-31 17: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-31 14:02:06' and `end` < '2026-03-31 17: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-31 17:02:21] Production.INFO: count ==4904 [2026-03-31 17:02:24] Production.ERROR: pbx CDR StartTime 2026-03-31 14:02:06 - End Time 2026-03-31 17:02:06 [2026-03-31 17:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 17:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013213', 'tblTempUsageDetail_20' ) start [2026-03-31 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013213', 'tblTempUsageDetail_20' ) end [2026-03-31 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013213', 'tblTempVendorCDR_20' ) start [2026-03-31 17:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013213', 'tblTempVendorCDR_20' ) end [2026-03-31 17:02:25] Production.INFO: ProcessCDR(1,17013213,1,1,2) [2026-03-31 17:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17013213,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 17:06:56] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17013213,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 17:06:56] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17013213,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 17:11:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17013213,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 17:11:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013213', 'tblTempUsageDetail_20' ) start [2026-03-31 17:11:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013213', 'tblTempUsageDetail_20' ) end [2026-03-31 17:11:42] Production.ERROR: pbx prc_insertCDR start [2026-03-31 17:11:45] Production.ERROR: pbx prc_insertCDR end [2026-03-31 17:11:45] Production.INFO: ==26606== Releasing lock... [2026-03-31 17:11:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 17:11:45] Production.INFO: 65 MB #Memory Used# [2026-03-31 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 15:02:06 [end_date_ymd] => 2026-03-31 18:02:06 [RateCDR] => 1 ) [2026-03-31 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-31 15:02:06' and `end` < '2026-03-31 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-31 18:02:18] Production.INFO: count ==4218 [2026-03-31 18:02:21] Production.ERROR: pbx CDR StartTime 2026-03-31 15:02:06 - End Time 2026-03-31 18:02:06 [2026-03-31 18:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 18:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013460', 'tblTempUsageDetail_20' ) start [2026-03-31 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013460', 'tblTempUsageDetail_20' ) end [2026-03-31 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013460', 'tblTempVendorCDR_20' ) start [2026-03-31 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013460', 'tblTempVendorCDR_20' ) end [2026-03-31 18:02:22] Production.INFO: ProcessCDR(1,17013460,1,1,2) [2026-03-31 18:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17013460,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 18:07:20] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17013460,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 18:07:20] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17013460,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 18:12:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17013460,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 18:12:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013460', 'tblTempUsageDetail_20' ) start [2026-03-31 18:12:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013460', 'tblTempUsageDetail_20' ) end [2026-03-31 18:12:22] Production.ERROR: pbx prc_insertCDR start [2026-03-31 18:12:23] Production.ERROR: pbx prc_insertCDR end [2026-03-31 18:12:23] Production.INFO: ==31121== Releasing lock... [2026-03-31 18:12:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 18:12:23] Production.INFO: 60 MB #Memory Used# [2026-03-31 19:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 16:02:06 [end_date_ymd] => 2026-03-31 19:02:06 [RateCDR] => 1 ) [2026-03-31 19:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-31 16:02:06' and `end` < '2026-03-31 19:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-31 19:02:18] Production.INFO: count ==3099 [2026-03-31 19:02:20] Production.ERROR: pbx CDR StartTime 2026-03-31 16:02:06 - End Time 2026-03-31 19:02:06 [2026-03-31 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013705', 'tblTempUsageDetail_20' ) start [2026-03-31 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013705', 'tblTempUsageDetail_20' ) end [2026-03-31 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013705', 'tblTempVendorCDR_20' ) start [2026-03-31 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013705', 'tblTempVendorCDR_20' ) end [2026-03-31 19:02:20] Production.INFO: ProcessCDR(1,17013705,1,1,2) [2026-03-31 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17013705,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 19:06:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17013705,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 19:06:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17013705,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 19:10:58] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17013705,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 19:10:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013705', 'tblTempUsageDetail_20' ) start [2026-03-31 19:10:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013705', 'tblTempUsageDetail_20' ) end [2026-03-31 19:10:58] Production.ERROR: pbx prc_insertCDR start [2026-03-31 19:10:59] Production.ERROR: pbx prc_insertCDR end [2026-03-31 19:10:59] Production.INFO: ==3286== Releasing lock... [2026-03-31 19:10:59] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 19:10:59] Production.INFO: 51.75 MB #Memory Used# [2026-03-31 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 17:02:05 [end_date_ymd] => 2026-03-31 20:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 17:02:05' and `end` < '2026-03-31 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-31 20:02:16] Production.INFO: count ==2073 [2026-03-31 20:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 17:02:05 - End Time 2026-03-31 20:02:05 [2026-03-31 20:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013952', 'tblTempUsageDetail_20' ) start [2026-03-31 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17013952', 'tblTempUsageDetail_20' ) end [2026-03-31 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013952', 'tblTempVendorCDR_20' ) start [2026-03-31 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17013952', 'tblTempVendorCDR_20' ) end [2026-03-31 20:02:18] Production.INFO: ProcessCDR(1,17013952,1,1,2) [2026-03-31 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17013952,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 20:06:12] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17013952,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 20:06:12] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17013952,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 20:10:53] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17013952,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 20:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013952', 'tblTempUsageDetail_20' ) start [2026-03-31 20:10:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17013952', 'tblTempUsageDetail_20' ) end [2026-03-31 20:10:53] Production.ERROR: pbx prc_insertCDR start [2026-03-31 20:10:54] Production.ERROR: pbx prc_insertCDR end [2026-03-31 20:10:54] Production.INFO: ==7665== Releasing lock... [2026-03-31 20:10:54] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 20:10:54] Production.INFO: 44.25 MB #Memory Used# [2026-03-31 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 18:02:05 [end_date_ymd] => 2026-03-31 21:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 18:02:05' and `end` < '2026-03-31 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-31 21:02:16] Production.INFO: count ==1433 [2026-03-31 21:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 18:02:05 - End Time 2026-03-31 21:02:05 [2026-03-31 21:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014199', 'tblTempUsageDetail_20' ) start [2026-03-31 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014199', 'tblTempUsageDetail_20' ) end [2026-03-31 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014199', 'tblTempVendorCDR_20' ) start [2026-03-31 21:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014199', 'tblTempVendorCDR_20' ) end [2026-03-31 21:02:17] Production.INFO: ProcessCDR(1,17014199,1,1,2) [2026-03-31 21:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17014199,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 21:06:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17014199,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 21:06:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17014199,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 21:10:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17014199,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 21:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014199', 'tblTempUsageDetail_20' ) start [2026-03-31 21:10:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014199', 'tblTempUsageDetail_20' ) end [2026-03-31 21:10:42] Production.ERROR: pbx prc_insertCDR start [2026-03-31 21:10:43] Production.ERROR: pbx prc_insertCDR end [2026-03-31 21:10:43] Production.INFO: ==12164== Releasing lock... [2026-03-31 21:10:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 21:10:43] Production.INFO: 39 MB #Memory Used# [2026-03-31 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 19:02:05 [end_date_ymd] => 2026-03-31 22:02:05 [RateCDR] => 1 ) [2026-03-31 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-31 19:02:05' and `end` < '2026-03-31 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-31 22:02:16] Production.INFO: count ==1254 [2026-03-31 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 19:02:05 - End Time 2026-03-31 22:02:05 [2026-03-31 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014446', 'tblTempUsageDetail_20' ) start [2026-03-31 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014446', 'tblTempUsageDetail_20' ) end [2026-03-31 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014446', 'tblTempVendorCDR_20' ) start [2026-03-31 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014446', 'tblTempVendorCDR_20' ) end [2026-03-31 22:02:17] Production.INFO: ProcessCDR(1,17014446,1,1,2) [2026-03-31 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17014446,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 22:06:08] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17014446,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 22:06:08] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17014446,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 22:10:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17014446,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 22:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014446', 'tblTempUsageDetail_20' ) start [2026-03-31 22:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014446', 'tblTempUsageDetail_20' ) end [2026-03-31 22:10:43] Production.ERROR: pbx prc_insertCDR start [2026-03-31 22:10:44] Production.ERROR: pbx prc_insertCDR end [2026-03-31 22:10:44] Production.INFO: ==16539== Releasing lock... [2026-03-31 22:10:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 22:10:44] Production.INFO: 37.75 MB #Memory Used# [2026-03-31 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-31 20:02:06 [end_date_ymd] => 2026-03-31 23:02:06 [RateCDR] => 1 ) [2026-03-31 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-31 20:02:06' and `end` < '2026-03-31 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-31 23:02:17] Production.INFO: count ==909 [2026-03-31 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-31 20:02:06 - End Time 2026-03-31 23:02:06 [2026-03-31 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-31 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014693', 'tblTempUsageDetail_20' ) start [2026-03-31 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '17014693', 'tblTempUsageDetail_20' ) end [2026-03-31 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014693', 'tblTempVendorCDR_20' ) start [2026-03-31 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '17014693', 'tblTempVendorCDR_20' ) end [2026-03-31 23:02:17] Production.INFO: ProcessCDR(1,17014693,1,1,2) [2026-03-31 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,17014693,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 23:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,17014693,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-31 23:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,17014693,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 23:10:44] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,17014693,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-31 23:10:44] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014693', 'tblTempUsageDetail_20' ) start [2026-03-31 23:10:45] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('17014693', 'tblTempUsageDetail_20' ) end [2026-03-31 23:10:45] Production.ERROR: pbx prc_insertCDR start [2026-03-31 23:10:45] Production.ERROR: pbx prc_insertCDR end [2026-03-31 23:10:45] Production.INFO: ==21030== Releasing lock... [2026-03-31 23:10:45] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-31 23:10:45] Production.INFO: 36 MB #Memory Used#