[2026-01-02 00:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-01 21:00:06 [end_date_ymd] => 2026-01-02 00:00:06 [RateCDR] => 1 ) [2026-01-02 00:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-01 21:00:06' and `end` < '2026-01-02 00:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 00:00:25] Production.INFO: count ==1331 [2026-01-02 00:00:25] Production.ERROR: pbx CDR StartTime 2026-01-01 21:00:06 - End Time 2026-01-02 00:00:06 [2026-01-02 00:00:25] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 00:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16487589', 'tblTempUsageDetail_20' ) start [2026-01-02 00:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16487589', 'tblTempUsageDetail_20' ) end [2026-01-02 00:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16487589', 'tblTempVendorCDR_20' ) start [2026-01-02 00:00:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16487589', 'tblTempVendorCDR_20' ) end [2026-01-02 00:00:25] Production.INFO: ProcessCDR(1,16487589,1,1,2) [2026-01-02 00:00:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16487589,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 00:03:41] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16487589,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 00:03:41] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16487589,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 00:07:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16487589,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 00:07:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16487589', 'tblTempUsageDetail_20' ) start [2026-01-02 00:07:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16487589', 'tblTempUsageDetail_20' ) end [2026-01-02 00:07:24] Production.ERROR: pbx prc_insertCDR start [2026-01-02 00:07:24] Production.ERROR: pbx prc_insertCDR end [2026-01-02 00:07:32] Production.INFO: ==21832== Releasing lock... [2026-01-02 00:07:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 00:07:32] Production.INFO: 40.5 MB #Memory Used# [2026-01-02 01:00:04] Production.ERROR: Array ( [start_date_ymd] => 2026-01-01 22:00:04 [end_date_ymd] => 2026-01-02 01:00:04 [RateCDR] => 1 ) [2026-01-02 01:00: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-01-01 22:00:04' and `end` < '2026-01-02 01:00: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-01-02 01:00:28] Production.INFO: count ==809 [2026-01-02 01:00:28] Production.ERROR: pbx CDR StartTime 2026-01-01 22:00:04 - End Time 2026-01-02 01:00:04 [2026-01-02 01:00:28] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 01:00:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16487836', 'tblTempUsageDetail_20' ) start [2026-01-02 01:00:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16487836', 'tblTempUsageDetail_20' ) end [2026-01-02 01:00:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16487836', 'tblTempVendorCDR_20' ) start [2026-01-02 01:00:28] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16487836', 'tblTempVendorCDR_20' ) end [2026-01-02 01:00:28] Production.INFO: ProcessCDR(1,16487836,1,1,2) [2026-01-02 01:00:28] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16487836,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 01:03:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16487836,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 01:03:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16487836,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 01:07:03] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16487836,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 01:07:03] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16487836', 'tblTempUsageDetail_20' ) start [2026-01-02 01:07:04] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16487836', 'tblTempUsageDetail_20' ) end [2026-01-02 01:07:04] Production.ERROR: pbx prc_insertCDR start [2026-01-02 01:07:05] Production.ERROR: pbx prc_insertCDR end [2026-01-02 01:07:05] Production.INFO: ==26507== Releasing lock... [2026-01-02 01:07:05] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 01:07:05] Production.INFO: 35.25 MB #Memory Used# [2026-01-02 02:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-01 23:00:06 [end_date_ymd] => 2026-01-02 02:00:06 [RateCDR] => 1 ) [2026-01-02 02:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-01 23:00:06' and `end` < '2026-01-02 02:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 02:00:18] Production.INFO: count ==752 [2026-01-02 02:00:18] Production.ERROR: pbx CDR StartTime 2026-01-01 23:00:06 - End Time 2026-01-02 02:00:06 [2026-01-02 02:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 02:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488083', 'tblTempUsageDetail_20' ) start [2026-01-02 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488083', 'tblTempUsageDetail_20' ) end [2026-01-02 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488083', 'tblTempVendorCDR_20' ) start [2026-01-02 02:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488083', 'tblTempVendorCDR_20' ) end [2026-01-02 02:00:19] Production.INFO: ProcessCDR(1,16488083,1,1,2) [2026-01-02 02:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16488083,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 02:03:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16488083,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 02:03:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16488083,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 02:06:58] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16488083,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 02:06:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488083', 'tblTempUsageDetail_20' ) start [2026-01-02 02:06:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488083', 'tblTempUsageDetail_20' ) end [2026-01-02 02:06:58] Production.ERROR: pbx prc_insertCDR start [2026-01-02 02:06:58] Production.ERROR: pbx prc_insertCDR end [2026-01-02 02:06:58] Production.INFO: ==32257== Releasing lock... [2026-01-02 02:06:58] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 02:06:58] Production.INFO: 34 MB #Memory Used# [2026-01-02 03:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 00:00:06 [end_date_ymd] => 2026-01-02 03:00:06 [RateCDR] => 1 ) [2026-01-02 03:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 00:00:06' and `end` < '2026-01-02 03:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 03:00:18] Production.INFO: count ==649 [2026-01-02 03:00:18] Production.ERROR: pbx CDR StartTime 2026-01-02 00:00:06 - End Time 2026-01-02 03:00:06 [2026-01-02 03:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488330', 'tblTempUsageDetail_20' ) start [2026-01-02 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488330', 'tblTempUsageDetail_20' ) end [2026-01-02 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488330', 'tblTempVendorCDR_20' ) start [2026-01-02 03:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488330', 'tblTempVendorCDR_20' ) end [2026-01-02 03:00:18] Production.INFO: ProcessCDR(1,16488330,1,1,2) [2026-01-02 03:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16488330,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 03:03:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16488330,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 03:03:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16488330,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 03:06:55] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16488330,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 03:06:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488330', 'tblTempUsageDetail_20' ) start [2026-01-02 03:06:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488330', 'tblTempUsageDetail_20' ) end [2026-01-02 03:06:55] Production.ERROR: pbx prc_insertCDR start [2026-01-02 03:06:56] Production.ERROR: pbx prc_insertCDR end [2026-01-02 03:06:56] Production.INFO: ==4604== Releasing lock... [2026-01-02 03:06:56] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 03:06:56] Production.INFO: 33.5 MB #Memory Used# [2026-01-02 04:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 01:00:06 [end_date_ymd] => 2026-01-02 04:00:06 [RateCDR] => 1 ) [2026-01-02 04:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 01:00:06' and `end` < '2026-01-02 04:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 04:00:18] Production.INFO: count ==533 [2026-01-02 04:00:18] Production.ERROR: pbx CDR StartTime 2026-01-02 01:00:06 - End Time 2026-01-02 04:00:06 [2026-01-02 04:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488578', 'tblTempUsageDetail_20' ) start [2026-01-02 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488578', 'tblTempUsageDetail_20' ) end [2026-01-02 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488578', 'tblTempVendorCDR_20' ) start [2026-01-02 04:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488578', 'tblTempVendorCDR_20' ) end [2026-01-02 04:00:18] Production.INFO: ProcessCDR(1,16488578,1,1,2) [2026-01-02 04:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16488578,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 04:02:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16488578,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 04:02:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16488578,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 04:06:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16488578,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 04:06:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488578', 'tblTempUsageDetail_20' ) start [2026-01-02 04:06:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488578', 'tblTempUsageDetail_20' ) end [2026-01-02 04:06:30] Production.ERROR: pbx prc_insertCDR start [2026-01-02 04:06:30] Production.ERROR: pbx prc_insertCDR end [2026-01-02 04:06:30] Production.INFO: ==9097== Releasing lock... [2026-01-02 04:06:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 04:06:30] Production.INFO: 32.25 MB #Memory Used# [2026-01-02 05:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 02:00:05 [end_date_ymd] => 2026-01-02 05:00:05 [RateCDR] => 1 ) [2026-01-02 05:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 02:00:05' and `end` < '2026-01-02 05:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 05:00:18] Production.INFO: count ==304 [2026-01-02 05:00:18] Production.ERROR: pbx CDR StartTime 2026-01-02 02:00:05 - End Time 2026-01-02 05:00:05 [2026-01-02 05:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 05:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488826', 'tblTempUsageDetail_20' ) start [2026-01-02 05:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16488826', 'tblTempUsageDetail_20' ) end [2026-01-02 05:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488826', 'tblTempVendorCDR_20' ) start [2026-01-02 05:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16488826', 'tblTempVendorCDR_20' ) end [2026-01-02 05:00:18] Production.INFO: ProcessCDR(1,16488826,1,1,2) [2026-01-02 05:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16488826,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 05:03:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16488826,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 05:03:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16488826,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 05:06:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16488826,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 05:06:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488826', 'tblTempUsageDetail_20' ) start [2026-01-02 05:06:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16488826', 'tblTempUsageDetail_20' ) end [2026-01-02 05:06:55] Production.ERROR: pbx prc_insertCDR start [2026-01-02 05:06:55] Production.ERROR: pbx prc_insertCDR end [2026-01-02 05:06:55] Production.INFO: ==13716== Releasing lock... [2026-01-02 05:06:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 05:06:55] Production.INFO: 30.5 MB #Memory Used# [2026-01-02 06:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 03:00:05 [end_date_ymd] => 2026-01-02 06:00:05 [RateCDR] => 1 ) [2026-01-02 06:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 03:00:05' and `end` < '2026-01-02 06:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 06:00:17] Production.INFO: count ==170 [2026-01-02 06:00:17] Production.ERROR: pbx CDR StartTime 2026-01-02 03:00:05 - End Time 2026-01-02 06:00:05 [2026-01-02 06:00:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 06:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489073', 'tblTempUsageDetail_20' ) start [2026-01-02 06:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489073', 'tblTempUsageDetail_20' ) end [2026-01-02 06:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489073', 'tblTempVendorCDR_20' ) start [2026-01-02 06:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489073', 'tblTempVendorCDR_20' ) end [2026-01-02 06:00:17] Production.INFO: ProcessCDR(1,16489073,1,1,2) [2026-01-02 06:00:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16489073,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 06:03:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16489073,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 06:03:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16489073,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 06:07:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16489073,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 06:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489073', 'tblTempUsageDetail_20' ) start [2026-01-02 06:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489073', 'tblTempUsageDetail_20' ) end [2026-01-02 06:07:14] Production.ERROR: pbx prc_insertCDR start [2026-01-02 06:07:14] Production.ERROR: pbx prc_insertCDR end [2026-01-02 06:07:14] Production.INFO: ==18664== Releasing lock... [2026-01-02 06:07:14] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 06:07:14] Production.INFO: 29.5 MB #Memory Used# [2026-01-02 07:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 04:00:06 [end_date_ymd] => 2026-01-02 07:00:06 [RateCDR] => 1 ) [2026-01-02 07:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 04:00:06' and `end` < '2026-01-02 07:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 07:00:17] Production.INFO: count ==132 [2026-01-02 07:00:17] Production.ERROR: pbx CDR StartTime 2026-01-02 04:00:06 - End Time 2026-01-02 07:00:06 [2026-01-02 07:00:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 07:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489320', 'tblTempUsageDetail_20' ) start [2026-01-02 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489320', 'tblTempUsageDetail_20' ) end [2026-01-02 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489320', 'tblTempVendorCDR_20' ) start [2026-01-02 07:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489320', 'tblTempVendorCDR_20' ) end [2026-01-02 07:00:18] Production.INFO: ProcessCDR(1,16489320,1,1,2) [2026-01-02 07:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16489320,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 07:03:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16489320,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 07:03:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16489320,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 07:06:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16489320,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 07:06:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489320', 'tblTempUsageDetail_20' ) start [2026-01-02 07:06:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489320', 'tblTempUsageDetail_20' ) end [2026-01-02 07:06:49] Production.ERROR: pbx prc_insertCDR start [2026-01-02 07:06:49] Production.ERROR: pbx prc_insertCDR end [2026-01-02 07:06:49] Production.INFO: ==24486== Releasing lock... [2026-01-02 07:06:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 07:06:49] Production.INFO: 29 MB #Memory Used# [2026-01-02 08:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 05:00:05 [end_date_ymd] => 2026-01-02 08:00:05 [RateCDR] => 1 ) [2026-01-02 08:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 05:00:05' and `end` < '2026-01-02 08:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 08:00:17] Production.INFO: count ==178 [2026-01-02 08:00:17] Production.ERROR: pbx CDR StartTime 2026-01-02 05:00:05 - End Time 2026-01-02 08:00:05 [2026-01-02 08:00:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 08:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489567', 'tblTempUsageDetail_20' ) start [2026-01-02 08:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489567', 'tblTempUsageDetail_20' ) end [2026-01-02 08:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489567', 'tblTempVendorCDR_20' ) start [2026-01-02 08:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489567', 'tblTempVendorCDR_20' ) end [2026-01-02 08:00:17] Production.INFO: ProcessCDR(1,16489567,1,1,2) [2026-01-02 08:00:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16489567,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 08:03:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16489567,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 08:03:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16489567,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 08:07:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16489567,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 08:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489567', 'tblTempUsageDetail_20' ) start [2026-01-02 08:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489567', 'tblTempUsageDetail_20' ) end [2026-01-02 08:07:14] Production.ERROR: pbx prc_insertCDR start [2026-01-02 08:07:15] Production.ERROR: pbx prc_insertCDR end [2026-01-02 08:07:15] Production.INFO: ==29943== Releasing lock... [2026-01-02 08:07:15] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 08:07:15] Production.INFO: 29.5 MB #Memory Used# [2026-01-02 09:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 06:00:05 [end_date_ymd] => 2026-01-02 09:00:05 [RateCDR] => 1 ) [2026-01-02 09:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 06:00:05' and `end` < '2026-01-02 09:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 09:00:17] Production.INFO: count ==817 [2026-01-02 09:00:17] Production.ERROR: pbx CDR StartTime 2026-01-02 06:00:05 - End Time 2026-01-02 09:00:05 [2026-01-02 09:00:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 09:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489814', 'tblTempUsageDetail_20' ) start [2026-01-02 09:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16489814', 'tblTempUsageDetail_20' ) end [2026-01-02 09:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489814', 'tblTempVendorCDR_20' ) start [2026-01-02 09:00:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16489814', 'tblTempVendorCDR_20' ) end [2026-01-02 09:00:17] Production.INFO: ProcessCDR(1,16489814,1,1,2) [2026-01-02 09:00:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16489814,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 09:03:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16489814,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 09:03:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16489814,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 09:07:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16489814,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 09:07:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489814', 'tblTempUsageDetail_20' ) start [2026-01-02 09:07:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16489814', 'tblTempUsageDetail_20' ) end [2026-01-02 09:07:21] Production.ERROR: pbx prc_insertCDR start [2026-01-02 09:07:22] Production.ERROR: pbx prc_insertCDR end [2026-01-02 09:07:22] Production.INFO: ==3682== Releasing lock... [2026-01-02 09:07:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 09:07:22] Production.INFO: 34.25 MB #Memory Used# [2026-01-02 10:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 07:00:06 [end_date_ymd] => 2026-01-02 10:00:06 [RateCDR] => 1 ) [2026-01-02 10:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 07:00:06' and `end` < '2026-01-02 10:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 10:00:21] Production.INFO: count ==2460 [2026-01-02 10:00:22] Production.ERROR: pbx CDR StartTime 2026-01-02 07:00:06 - End Time 2026-01-02 10:00:06 [2026-01-02 10:00:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 10:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490061', 'tblTempUsageDetail_20' ) start [2026-01-02 10:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490061', 'tblTempUsageDetail_20' ) end [2026-01-02 10:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490061', 'tblTempVendorCDR_20' ) start [2026-01-02 10:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490061', 'tblTempVendorCDR_20' ) end [2026-01-02 10:00:22] Production.INFO: ProcessCDR(1,16490061,1,1,2) [2026-01-02 10:00:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16490061,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 10:03:45] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16490061,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 10:03:45] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16490061,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 10:07:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16490061,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 10:07:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490061', 'tblTempUsageDetail_20' ) start [2026-01-02 10:07:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490061', 'tblTempUsageDetail_20' ) end [2026-01-02 10:07:33] Production.ERROR: pbx prc_insertCDR start [2026-01-02 10:07:35] Production.ERROR: pbx prc_insertCDR end [2026-01-02 10:07:35] Production.INFO: ==8900== Releasing lock... [2026-01-02 10:07:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 10:07:35] Production.INFO: 47 MB #Memory Used# [2026-01-02 11:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 08:00:06 [end_date_ymd] => 2026-01-02 11:00:06 [RateCDR] => 1 ) [2026-01-02 11:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 08:00:06' and `end` < '2026-01-02 11:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 11:00:19] Production.INFO: count ==4256 [2026-01-02 11:00:21] Production.ERROR: pbx CDR StartTime 2026-01-02 08:00:06 - End Time 2026-01-02 11:00:06 [2026-01-02 11:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 11:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490308', 'tblTempUsageDetail_20' ) start [2026-01-02 11:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490308', 'tblTempUsageDetail_20' ) end [2026-01-02 11:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490308', 'tblTempVendorCDR_20' ) start [2026-01-02 11:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490308', 'tblTempVendorCDR_20' ) end [2026-01-02 11:00:21] Production.INFO: ProcessCDR(1,16490308,1,1,2) [2026-01-02 11:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16490308,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 11:03:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16490308,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 11:03:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16490308,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 11:07:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16490308,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 11:07:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490308', 'tblTempUsageDetail_20' ) start [2026-01-02 11:07:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490308', 'tblTempUsageDetail_20' ) end [2026-01-02 11:07:30] Production.ERROR: pbx prc_insertCDR start [2026-01-02 11:07:33] Production.ERROR: pbx prc_insertCDR end [2026-01-02 11:07:33] Production.INFO: ==13266== Releasing lock... [2026-01-02 11:07:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 11:07:33] Production.INFO: 60 MB #Memory Used# [2026-01-02 12:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 09:00:05 [end_date_ymd] => 2026-01-02 12:00:05 [RateCDR] => 1 ) [2026-01-02 12:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 09:00:05' and `end` < '2026-01-02 12:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 12:00:19] Production.INFO: count ==5220 [2026-01-02 12:00:22] Production.ERROR: pbx CDR StartTime 2026-01-02 09:00:05 - End Time 2026-01-02 12:00:05 [2026-01-02 12:00:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 12:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490555', 'tblTempUsageDetail_20' ) start [2026-01-02 12:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490555', 'tblTempUsageDetail_20' ) end [2026-01-02 12:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490555', 'tblTempVendorCDR_20' ) start [2026-01-02 12:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490555', 'tblTempVendorCDR_20' ) end [2026-01-02 12:00:22] Production.INFO: ProcessCDR(1,16490555,1,1,2) [2026-01-02 12:00:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16490555,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 12:03:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16490555,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 12:03:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16490555,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 12:07:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16490555,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 12:07:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490555', 'tblTempUsageDetail_20' ) start [2026-01-02 12:07:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490555', 'tblTempUsageDetail_20' ) end [2026-01-02 12:07:36] Production.ERROR: pbx prc_insertCDR start [2026-01-02 12:07:38] Production.ERROR: pbx prc_insertCDR end [2026-01-02 12:07:38] Production.INFO: ==17828== Releasing lock... [2026-01-02 12:07:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 12:07:38] Production.INFO: 67.25 MB #Memory Used# [2026-01-02 13:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 10:00:05 [end_date_ymd] => 2026-01-02 13:00:05 [RateCDR] => 1 ) [2026-01-02 13:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 10:00:05' and `end` < '2026-01-02 13:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 13:00:21] Production.INFO: count ==4917 [2026-01-02 13:00:23] Production.ERROR: pbx CDR StartTime 2026-01-02 10:00:05 - End Time 2026-01-02 13:00:05 [2026-01-02 13:00:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 13:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490802', 'tblTempUsageDetail_20' ) start [2026-01-02 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16490802', 'tblTempUsageDetail_20' ) end [2026-01-02 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490802', 'tblTempVendorCDR_20' ) start [2026-01-02 13:00:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16490802', 'tblTempVendorCDR_20' ) end [2026-01-02 13:00:24] Production.INFO: ProcessCDR(1,16490802,1,1,2) [2026-01-02 13:00:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16490802,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 13:03:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16490802,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 13:03:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16490802,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 13:07:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16490802,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 13:07:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490802', 'tblTempUsageDetail_20' ) start [2026-01-02 13:07:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16490802', 'tblTempUsageDetail_20' ) end [2026-01-02 13:07:26] Production.ERROR: pbx prc_insertCDR start [2026-01-02 13:07:28] Production.ERROR: pbx prc_insertCDR end [2026-01-02 13:07:28] Production.INFO: ==22363== Releasing lock... [2026-01-02 13:07:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 13:07:28] Production.INFO: 65 MB #Memory Used# [2026-01-02 14:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 11:00:05 [end_date_ymd] => 2026-01-02 14:00:05 [RateCDR] => 1 ) [2026-01-02 14:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 11:00:05' and `end` < '2026-01-02 14:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 14:00:18] Production.INFO: count ==4549 [2026-01-02 14:00:20] Production.ERROR: pbx CDR StartTime 2026-01-02 11:00:05 - End Time 2026-01-02 14:00:05 [2026-01-02 14:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 14:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491049', 'tblTempUsageDetail_20' ) start [2026-01-02 14:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491049', 'tblTempUsageDetail_20' ) end [2026-01-02 14:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491049', 'tblTempVendorCDR_20' ) start [2026-01-02 14:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491049', 'tblTempVendorCDR_20' ) end [2026-01-02 14:00:20] Production.INFO: ProcessCDR(1,16491049,1,1,2) [2026-01-02 14:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16491049,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 14:03:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16491049,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 14:03:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16491049,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 14:07:01] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16491049,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 14:07:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491049', 'tblTempUsageDetail_20' ) start [2026-01-02 14:07:02] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491049', 'tblTempUsageDetail_20' ) end [2026-01-02 14:07:02] Production.ERROR: pbx prc_insertCDR start [2026-01-02 14:07:08] Production.ERROR: pbx prc_insertCDR end [2026-01-02 14:07:08] Production.INFO: ==26751== Releasing lock... [2026-01-02 14:07:08] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 14:07:08] Production.INFO: 62.25 MB #Memory Used# [2026-01-02 15:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 12:00:06 [end_date_ymd] => 2026-01-02 15:00:06 [RateCDR] => 1 ) [2026-01-02 15:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 12:00:06' and `end` < '2026-01-02 15:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 15:00:19] Production.INFO: count ==4427 [2026-01-02 15:00:21] Production.ERROR: pbx CDR StartTime 2026-01-02 12:00:06 - End Time 2026-01-02 15:00:06 [2026-01-02 15:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 15:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491296', 'tblTempUsageDetail_20' ) start [2026-01-02 15:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491296', 'tblTempUsageDetail_20' ) end [2026-01-02 15:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491296', 'tblTempVendorCDR_20' ) start [2026-01-02 15:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491296', 'tblTempVendorCDR_20' ) end [2026-01-02 15:00:22] Production.INFO: ProcessCDR(1,16491296,1,1,2) [2026-01-02 15:00:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16491296,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 15:03:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16491296,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 15:03:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16491296,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 15:07:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16491296,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 15:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491296', 'tblTempUsageDetail_20' ) start [2026-01-02 15:07:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491296', 'tblTempUsageDetail_20' ) end [2026-01-02 15:07:14] Production.ERROR: pbx prc_insertCDR start [2026-01-02 15:07:17] Production.ERROR: pbx prc_insertCDR end [2026-01-02 15:07:17] Production.INFO: ==31313== Releasing lock... [2026-01-02 15:07:17] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 15:07:17] Production.INFO: 61.25 MB #Memory Used# [2026-01-02 16:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 13:00:06 [end_date_ymd] => 2026-01-02 16:00:06 [RateCDR] => 1 ) [2026-01-02 16:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 13:00:06' and `end` < '2026-01-02 16:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 16:00:20] Production.INFO: count ==4417 [2026-01-02 16:00:22] Production.ERROR: pbx CDR StartTime 2026-01-02 13:00:06 - End Time 2026-01-02 16:00:06 [2026-01-02 16:00:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 16:00:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491543', 'tblTempUsageDetail_20' ) start [2026-01-02 16:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491543', 'tblTempUsageDetail_20' ) end [2026-01-02 16:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491543', 'tblTempVendorCDR_20' ) start [2026-01-02 16:00:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491543', 'tblTempVendorCDR_20' ) end [2026-01-02 16:00:23] Production.INFO: ProcessCDR(1,16491543,1,1,2) [2026-01-02 16:00:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16491543,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 16:03:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16491543,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 16:03:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16491543,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 16:07:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16491543,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 16:07:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491543', 'tblTempUsageDetail_20' ) start [2026-01-02 16:07:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491543', 'tblTempUsageDetail_20' ) end [2026-01-02 16:07:24] Production.ERROR: pbx prc_insertCDR start [2026-01-02 16:07:26] Production.ERROR: pbx prc_insertCDR end [2026-01-02 16:07:26] Production.INFO: ==3758== Releasing lock... [2026-01-02 16:07:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 16:07:26] Production.INFO: 61.25 MB #Memory Used# [2026-01-02 17:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 14:00:05 [end_date_ymd] => 2026-01-02 17:00:05 [RateCDR] => 1 ) [2026-01-02 17:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 14:00:05' and `end` < '2026-01-02 17:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 17:00:18] Production.INFO: count ==4351 [2026-01-02 17:00:21] Production.ERROR: pbx CDR StartTime 2026-01-02 14:00:05 - End Time 2026-01-02 17:00:05 [2026-01-02 17:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 17:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491790', 'tblTempUsageDetail_20' ) start [2026-01-02 17:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16491790', 'tblTempUsageDetail_20' ) end [2026-01-02 17:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491790', 'tblTempVendorCDR_20' ) start [2026-01-02 17:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16491790', 'tblTempVendorCDR_20' ) end [2026-01-02 17:00:21] Production.INFO: ProcessCDR(1,16491790,1,1,2) [2026-01-02 17:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16491790,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 17:03:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16491790,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 17:03:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16491790,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 17:07:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16491790,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 17:07:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491790', 'tblTempUsageDetail_20' ) start [2026-01-02 17:07:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16491790', 'tblTempUsageDetail_20' ) end [2026-01-02 17:07:39] Production.ERROR: pbx prc_insertCDR start [2026-01-02 17:07:42] Production.ERROR: pbx prc_insertCDR end [2026-01-02 17:07:42] Production.INFO: ==9015== Releasing lock... [2026-01-02 17:07:42] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 17:07:42] Production.INFO: 60.75 MB #Memory Used# [2026-01-02 18:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 15:00:06 [end_date_ymd] => 2026-01-02 18:00:06 [RateCDR] => 1 ) [2026-01-02 18:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 15:00:06' and `end` < '2026-01-02 18:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 18:00:19] Production.INFO: count ==4189 [2026-01-02 18:00:21] Production.ERROR: pbx CDR StartTime 2026-01-02 15:00:06 - End Time 2026-01-02 18:00:06 [2026-01-02 18:00:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 18:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492034', 'tblTempUsageDetail_20' ) start [2026-01-02 18:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492034', 'tblTempUsageDetail_20' ) end [2026-01-02 18:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492034', 'tblTempVendorCDR_20' ) start [2026-01-02 18:00:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492034', 'tblTempVendorCDR_20' ) end [2026-01-02 18:00:21] Production.INFO: ProcessCDR(1,16492034,1,1,2) [2026-01-02 18:00:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16492034,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 18:03:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16492034,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 18:03:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16492034,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 18:07:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16492034,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 18:07:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492034', 'tblTempUsageDetail_20' ) start [2026-01-02 18:07:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492034', 'tblTempUsageDetail_20' ) end [2026-01-02 18:07:15] Production.ERROR: pbx prc_insertCDR start [2026-01-02 18:07:19] Production.ERROR: pbx prc_insertCDR end [2026-01-02 18:07:19] Production.INFO: ==14333== Releasing lock... [2026-01-02 18:07:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 18:07:19] Production.INFO: 59.5 MB #Memory Used# [2026-01-02 19:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 16:00:06 [end_date_ymd] => 2026-01-02 19:00:06 [RateCDR] => 1 ) [2026-01-02 19:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 16:00:06' and `end` < '2026-01-02 19:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 19:00:18] Production.INFO: count ==3584 [2026-01-02 19:00:20] Production.ERROR: pbx CDR StartTime 2026-01-02 16:00:06 - End Time 2026-01-02 19:00:06 [2026-01-02 19:00:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 19:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492281', 'tblTempUsageDetail_20' ) start [2026-01-02 19:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492281', 'tblTempUsageDetail_20' ) end [2026-01-02 19:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492281', 'tblTempVendorCDR_20' ) start [2026-01-02 19:00:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492281', 'tblTempVendorCDR_20' ) end [2026-01-02 19:00:20] Production.INFO: ProcessCDR(1,16492281,1,1,2) [2026-01-02 19:00:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16492281,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 19:03:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16492281,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 19:03:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16492281,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 19:07:34] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16492281,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 19:07:34] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492281', 'tblTempUsageDetail_20' ) start [2026-01-02 19:07:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492281', 'tblTempUsageDetail_20' ) end [2026-01-02 19:07:35] Production.ERROR: pbx prc_insertCDR start [2026-01-02 19:07:36] Production.ERROR: pbx prc_insertCDR end [2026-01-02 19:07:36] Production.INFO: ==18777== Releasing lock... [2026-01-02 19:07:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 19:07:36] Production.INFO: 55 MB #Memory Used# [2026-01-02 20:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 17:00:05 [end_date_ymd] => 2026-01-02 20:00:05 [RateCDR] => 1 ) [2026-01-02 20:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 17:00:05' and `end` < '2026-01-02 20:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 20:00:18] Production.INFO: count ==2766 [2026-01-02 20:00:19] Production.ERROR: pbx CDR StartTime 2026-01-02 17:00:05 - End Time 2026-01-02 20:00:05 [2026-01-02 20:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 20:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492528', 'tblTempUsageDetail_20' ) start [2026-01-02 20:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492528', 'tblTempUsageDetail_20' ) end [2026-01-02 20:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492528', 'tblTempVendorCDR_20' ) start [2026-01-02 20:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492528', 'tblTempVendorCDR_20' ) end [2026-01-02 20:00:19] Production.INFO: ProcessCDR(1,16492528,1,1,2) [2026-01-02 20:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16492528,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 20:03:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16492528,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 20:03:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16492528,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 20:07:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16492528,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 20:07:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492528', 'tblTempUsageDetail_20' ) start [2026-01-02 20:07:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492528', 'tblTempUsageDetail_20' ) end [2026-01-02 20:07:36] Production.ERROR: pbx prc_insertCDR start [2026-01-02 20:07:36] Production.ERROR: pbx prc_insertCDR end [2026-01-02 20:07:36] Production.INFO: ==23679== Releasing lock... [2026-01-02 20:07:36] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 20:07:36] Production.INFO: 49.5 MB #Memory Used# [2026-01-02 21:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 18:00:05 [end_date_ymd] => 2026-01-02 21:00:05 [RateCDR] => 1 ) [2026-01-02 21:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 18:00:05' and `end` < '2026-01-02 21:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 21:00:18] Production.INFO: count ==2056 [2026-01-02 21:00:18] Production.ERROR: pbx CDR StartTime 2026-01-02 18:00:05 - End Time 2026-01-02 21:00:05 [2026-01-02 21:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 21:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492775', 'tblTempUsageDetail_20' ) start [2026-01-02 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16492775', 'tblTempUsageDetail_20' ) end [2026-01-02 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492775', 'tblTempVendorCDR_20' ) start [2026-01-02 21:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16492775', 'tblTempVendorCDR_20' ) end [2026-01-02 21:00:19] Production.INFO: ProcessCDR(1,16492775,1,1,2) [2026-01-02 21:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16492775,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 21:03:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16492775,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 21:03:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16492775,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 21:07:17] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16492775,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 21:07:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492775', 'tblTempUsageDetail_20' ) start [2026-01-02 21:07:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16492775', 'tblTempUsageDetail_20' ) end [2026-01-02 21:07:17] Production.ERROR: pbx prc_insertCDR start [2026-01-02 21:07:17] Production.ERROR: pbx prc_insertCDR end [2026-01-02 21:07:17] Production.INFO: ==28062== Releasing lock... [2026-01-02 21:07:17] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 21:07:17] Production.INFO: 43.5 MB #Memory Used# [2026-01-02 22:00:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 19:00:06 [end_date_ymd] => 2026-01-02 22:00:06 [RateCDR] => 1 ) [2026-01-02 22:00:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 19:00:06' and `end` < '2026-01-02 22:00:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 22:00:19] Production.INFO: count ==1600 [2026-01-02 22:00:19] Production.ERROR: pbx CDR StartTime 2026-01-02 19:00:06 - End Time 2026-01-02 22:00:06 [2026-01-02 22:00:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16493022', 'tblTempUsageDetail_20' ) start [2026-01-02 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16493022', 'tblTempUsageDetail_20' ) end [2026-01-02 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16493022', 'tblTempVendorCDR_20' ) start [2026-01-02 22:00:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16493022', 'tblTempVendorCDR_20' ) end [2026-01-02 22:00:19] Production.INFO: ProcessCDR(1,16493022,1,1,2) [2026-01-02 22:00:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16493022,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 22:03:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16493022,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 22:03:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16493022,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 22:07:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16493022,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 22:07:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16493022', 'tblTempUsageDetail_20' ) start [2026-01-02 22:07:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16493022', 'tblTempUsageDetail_20' ) end [2026-01-02 22:07:16] Production.ERROR: pbx prc_insertCDR start [2026-01-02 22:07:17] Production.ERROR: pbx prc_insertCDR end [2026-01-02 22:07:17] Production.INFO: ==32506== Releasing lock... [2026-01-02 22:07:17] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 22:07:17] Production.INFO: 40 MB #Memory Used# [2026-01-02 23:00:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-02 20:00:05 [end_date_ymd] => 2026-01-02 23:00:05 [RateCDR] => 1 ) [2026-01-02 23:00:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-02 20:00:05' and `end` < '2026-01-02 23:00:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-02 23:00:17] Production.INFO: count ==1208 [2026-01-02 23:00:18] Production.ERROR: pbx CDR StartTime 2026-01-02 20:00:05 - End Time 2026-01-02 23:00:05 [2026-01-02 23:00:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-02 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16493269', 'tblTempUsageDetail_20' ) start [2026-01-02 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16493269', 'tblTempUsageDetail_20' ) end [2026-01-02 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16493269', 'tblTempVendorCDR_20' ) start [2026-01-02 23:00:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16493269', 'tblTempVendorCDR_20' ) end [2026-01-02 23:00:18] Production.INFO: ProcessCDR(1,16493269,1,1,2) [2026-01-02 23:00:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16493269,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 23:03:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16493269,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-02 23:03:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16493269,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 23:07:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16493269,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-02 23:07:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16493269', 'tblTempUsageDetail_20' ) start [2026-01-02 23:07:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16493269', 'tblTempUsageDetail_20' ) end [2026-01-02 23:07:27] Production.ERROR: pbx prc_insertCDR start [2026-01-02 23:07:27] Production.ERROR: pbx prc_insertCDR end [2026-01-02 23:07:27] Production.INFO: ==4547== Releasing lock... [2026-01-02 23:07:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-02 23:07:27] Production.INFO: 38 MB #Memory Used#