[2026-01-15 00:01:06] Production.INFO: next invoice date [2026-01-15 00:01:06] Production.INFO: 2026-02-15 [2026-01-15 00:01:06] Production.INFO: getdaysdiff [2026-01-15 00:01:06] Production.INFO: +31 [2026-01-15 00:01:06] Production.INFO: call prc_setAccountDiscountPlan (230,16,1,31,31,'RMScheduler',2026-01-15 00:01:05,1,0,,,0) [2026-01-15 00:01:06] Production.INFO: next invoice date [2026-01-15 00:01:06] Production.INFO: 2026-02-15 [2026-01-15 00:01:06] Production.INFO: getdaysdiff [2026-01-15 00:01:06] Production.INFO: +31 [2026-01-15 00:01:06] Production.INFO: call prc_setAccountDiscountPlan (230,13,2,31,31,'RMScheduler',2026-01-15 00:01:05,1,0,,,0) [2026-01-15 00:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-14 21:01:07 [end_date_ymd] => 2026-01-15 00:01:07 [RateCDR] => 1 ) [2026-01-15 00:01:07] 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-14 21:01:07' and `end` < '2026-01-15 00:01:07' 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-15 00:01:25] Production.INFO: count ==942 [2026-01-15 00:01:26] Production.ERROR: pbx CDR StartTime 2026-01-14 21:01:07 - End Time 2026-01-15 00:01:07 [2026-01-15 00:01:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 00:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16564657', 'tblTempUsageDetail_20' ) start [2026-01-15 00:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16564657', 'tblTempUsageDetail_20' ) end [2026-01-15 00:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16564657', 'tblTempVendorCDR_20' ) start [2026-01-15 00:01:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16564657', 'tblTempVendorCDR_20' ) end [2026-01-15 00:01:26] Production.INFO: ProcessCDR(1,16564657,1,1,2) [2026-01-15 00:01:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16564657,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 00:04:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16564657,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 00:04:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16564657,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 00:08:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16564657,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 00:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16564657', 'tblTempUsageDetail_20' ) start [2026-01-15 00:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16564657', 'tblTempUsageDetail_20' ) end [2026-01-15 00:08:19] Production.ERROR: pbx prc_insertCDR start [2026-01-15 00:08:19] Production.ERROR: pbx prc_insertCDR end [2026-01-15 00:08:21] Production.INFO: ==32319== Releasing lock... [2026-01-15 00:08:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 00:08:21] Production.INFO: 38.75 MB #Memory Used# [2026-01-15 01:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-14 22:01:06 [end_date_ymd] => 2026-01-15 01:01:06 [RateCDR] => 1 ) [2026-01-15 01:01: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-14 22:01:06' and `end` < '2026-01-15 01:01: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-15 01:01:22] Production.INFO: count ==606 [2026-01-15 01:01:22] Production.ERROR: pbx CDR StartTime 2026-01-14 22:01:06 - End Time 2026-01-15 01:01:06 [2026-01-15 01:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 01:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16564904', 'tblTempUsageDetail_20' ) start [2026-01-15 01:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16564904', 'tblTempUsageDetail_20' ) end [2026-01-15 01:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16564904', 'tblTempVendorCDR_20' ) start [2026-01-15 01:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16564904', 'tblTempVendorCDR_20' ) end [2026-01-15 01:01:22] Production.INFO: ProcessCDR(1,16564904,1,1,2) [2026-01-15 01:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16564904,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 01:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16564904,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 01:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16564904,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 01:08:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16564904,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 01:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16564904', 'tblTempUsageDetail_20' ) start [2026-01-15 01:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16564904', 'tblTempUsageDetail_20' ) end [2026-01-15 01:08:19] Production.ERROR: pbx prc_insertCDR start [2026-01-15 01:08:19] Production.ERROR: pbx prc_insertCDR end [2026-01-15 01:08:19] Production.INFO: ==4901== Releasing lock... [2026-01-15 01:08:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 01:08:19] Production.INFO: 33.25 MB #Memory Used# [2026-01-15 02:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-14 23:01:06 [end_date_ymd] => 2026-01-15 02:01:06 [RateCDR] => 1 ) [2026-01-15 02:01: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-14 23:01:06' and `end` < '2026-01-15 02:01: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-15 02:01:18] Production.INFO: count ==532 [2026-01-15 02:01:18] Production.ERROR: pbx CDR StartTime 2026-01-14 23:01:06 - End Time 2026-01-15 02:01:06 [2026-01-15 02:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 02:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565151', 'tblTempUsageDetail_20' ) start [2026-01-15 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565151', 'tblTempUsageDetail_20' ) end [2026-01-15 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565151', 'tblTempVendorCDR_20' ) start [2026-01-15 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565151', 'tblTempVendorCDR_20' ) end [2026-01-15 02:01:19] Production.INFO: ProcessCDR(1,16565151,1,1,2) [2026-01-15 02:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16565151,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 02:04:28] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16565151,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 02:04:28] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16565151,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 02:08:16] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16565151,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 02:08:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565151', 'tblTempUsageDetail_20' ) start [2026-01-15 02:08:17] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565151', 'tblTempUsageDetail_20' ) end [2026-01-15 02:08:17] Production.ERROR: pbx prc_insertCDR start [2026-01-15 02:08:18] Production.ERROR: pbx prc_insertCDR end [2026-01-15 02:08:18] Production.INFO: ==10032== Releasing lock... [2026-01-15 02:08:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 02:08:18] Production.INFO: 32.5 MB #Memory Used# [2026-01-15 03:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 00:01:07 [end_date_ymd] => 2026-01-15 03:01:07 [RateCDR] => 1 ) [2026-01-15 03:01:07] 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-15 00:01:07' and `end` < '2026-01-15 03:01:07' 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-15 03:01:19] Production.INFO: count ==447 [2026-01-15 03:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 00:01:07 - End Time 2026-01-15 03:01:07 [2026-01-15 03:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565398', 'tblTempUsageDetail_20' ) start [2026-01-15 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565398', 'tblTempUsageDetail_20' ) end [2026-01-15 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565398', 'tblTempVendorCDR_20' ) start [2026-01-15 03:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565398', 'tblTempVendorCDR_20' ) end [2026-01-15 03:01:19] Production.INFO: ProcessCDR(1,16565398,1,1,2) [2026-01-15 03:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16565398,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 03:04:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16565398,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 03:04:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16565398,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 03:08:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16565398,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 03:08:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565398', 'tblTempUsageDetail_20' ) start [2026-01-15 03:08:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565398', 'tblTempUsageDetail_20' ) end [2026-01-15 03:08:27] Production.ERROR: pbx prc_insertCDR start [2026-01-15 03:08:27] Production.ERROR: pbx prc_insertCDR end [2026-01-15 03:08:27] Production.INFO: ==14634== Releasing lock... [2026-01-15 03:08:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 03:08:27] Production.INFO: 32.25 MB #Memory Used# [2026-01-15 04:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 01:01:05 [end_date_ymd] => 2026-01-15 04:01:05 [RateCDR] => 1 ) [2026-01-15 04:01: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-15 01:01:05' and `end` < '2026-01-15 04:01: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-15 04:01:17] Production.INFO: count ==334 [2026-01-15 04:01:18] Production.ERROR: pbx CDR StartTime 2026-01-15 01:01:05 - End Time 2026-01-15 04:01:05 [2026-01-15 04:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565646', 'tblTempUsageDetail_20' ) start [2026-01-15 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565646', 'tblTempUsageDetail_20' ) end [2026-01-15 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565646', 'tblTempVendorCDR_20' ) start [2026-01-15 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565646', 'tblTempVendorCDR_20' ) end [2026-01-15 04:01:18] Production.INFO: ProcessCDR(1,16565646,1,1,2) [2026-01-15 04:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16565646,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 04:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16565646,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 04:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16565646,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 04:08:12] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16565646,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 04:08:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565646', 'tblTempUsageDetail_20' ) start [2026-01-15 04:08:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565646', 'tblTempUsageDetail_20' ) end [2026-01-15 04:08:12] Production.ERROR: pbx prc_insertCDR start [2026-01-15 04:08:12] Production.ERROR: pbx prc_insertCDR end [2026-01-15 04:08:13] Production.INFO: ==19811== Releasing lock... [2026-01-15 04:08:13] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 04:08:13] Production.INFO: 30.5 MB #Memory Used# [2026-01-15 05:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 02:01:07 [end_date_ymd] => 2026-01-15 05:01:07 [RateCDR] => 1 ) [2026-01-15 05:01:07] 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-15 02:01:07' and `end` < '2026-01-15 05:01:07' 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-15 05:01:19] Production.INFO: count ==251 [2026-01-15 05:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 02:01:07 - End Time 2026-01-15 05:01:07 [2026-01-15 05:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565894', 'tblTempUsageDetail_20' ) start [2026-01-15 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16565894', 'tblTempUsageDetail_20' ) end [2026-01-15 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565894', 'tblTempVendorCDR_20' ) start [2026-01-15 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16565894', 'tblTempVendorCDR_20' ) end [2026-01-15 05:01:19] Production.INFO: ProcessCDR(1,16565894,1,1,2) [2026-01-15 05:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16565894,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 05:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16565894,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 05:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16565894,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 05:08:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16565894,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 05:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565894', 'tblTempUsageDetail_20' ) start [2026-01-15 05:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16565894', 'tblTempUsageDetail_20' ) end [2026-01-15 05:08:23] Production.ERROR: pbx prc_insertCDR start [2026-01-15 05:08:23] Production.ERROR: pbx prc_insertCDR end [2026-01-15 05:08:23] Production.INFO: ==24482== Releasing lock... [2026-01-15 05:08:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 05:08:23] Production.INFO: 30.75 MB #Memory Used# [2026-01-15 06:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 03:01:06 [end_date_ymd] => 2026-01-15 06:01:06 [RateCDR] => 1 ) [2026-01-15 06:01: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-15 03:01:06' and `end` < '2026-01-15 06:01: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-15 06:01:18] Production.INFO: count ==195 [2026-01-15 06:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 03:01:06 - End Time 2026-01-15 06:01:06 [2026-01-15 06:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 06:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566141', 'tblTempUsageDetail_20' ) start [2026-01-15 06:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566141', 'tblTempUsageDetail_20' ) end [2026-01-15 06:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566141', 'tblTempVendorCDR_20' ) start [2026-01-15 06:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566141', 'tblTempVendorCDR_20' ) end [2026-01-15 06:01:19] Production.INFO: ProcessCDR(1,16566141,1,1,2) [2026-01-15 06:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16566141,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 06:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16566141,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 06:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16566141,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 06:08:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16566141,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 06:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566141', 'tblTempUsageDetail_20' ) start [2026-01-15 06:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566141', 'tblTempUsageDetail_20' ) end [2026-01-15 06:08:22] Production.ERROR: pbx prc_insertCDR start [2026-01-15 06:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-15 06:08:22] Production.INFO: ==28960== Releasing lock... [2026-01-15 06:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 06:08:22] Production.INFO: 29.5 MB #Memory Used# [2026-01-15 07:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 04:01:05 [end_date_ymd] => 2026-01-15 07:01:05 [RateCDR] => 1 ) [2026-01-15 07:01: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-15 04:01:05' and `end` < '2026-01-15 07:01: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-15 07:01:18] Production.INFO: count ==216 [2026-01-15 07:01:18] Production.ERROR: pbx CDR StartTime 2026-01-15 04:01:05 - End Time 2026-01-15 07:01:05 [2026-01-15 07:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566388', 'tblTempUsageDetail_20' ) start [2026-01-15 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566388', 'tblTempUsageDetail_20' ) end [2026-01-15 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566388', 'tblTempVendorCDR_20' ) start [2026-01-15 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566388', 'tblTempVendorCDR_20' ) end [2026-01-15 07:01:18] Production.INFO: ProcessCDR(1,16566388,1,1,2) [2026-01-15 07:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16566388,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 07:04:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16566388,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 07:04:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16566388,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 07:08:20] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16566388,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 07:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566388', 'tblTempUsageDetail_20' ) start [2026-01-15 07:08:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566388', 'tblTempUsageDetail_20' ) end [2026-01-15 07:08:20] Production.ERROR: pbx prc_insertCDR start [2026-01-15 07:08:20] Production.ERROR: pbx prc_insertCDR end [2026-01-15 07:08:20] Production.INFO: ==1002== Releasing lock... [2026-01-15 07:08:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 07:08:20] Production.INFO: 30 MB #Memory Used# [2026-01-15 08:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 05:01:07 [end_date_ymd] => 2026-01-15 08:01:07 [RateCDR] => 1 ) [2026-01-15 08:01:07] 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-15 05:01:07' and `end` < '2026-01-15 08:01:07' 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-15 08:01:19] Production.INFO: count ==257 [2026-01-15 08:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 05:01:07 - End Time 2026-01-15 08:01:07 [2026-01-15 08:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566635', 'tblTempUsageDetail_20' ) start [2026-01-15 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566635', 'tblTempUsageDetail_20' ) end [2026-01-15 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566635', 'tblTempVendorCDR_20' ) start [2026-01-15 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566635', 'tblTempVendorCDR_20' ) end [2026-01-15 08:01:19] Production.INFO: ProcessCDR(1,16566635,1,1,2) [2026-01-15 08:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16566635,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 08:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16566635,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 08:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16566635,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 08:08:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16566635,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 08:08:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566635', 'tblTempUsageDetail_20' ) start [2026-01-15 08:08:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566635', 'tblTempUsageDetail_20' ) end [2026-01-15 08:08:35] Production.ERROR: pbx prc_insertCDR start [2026-01-15 08:08:35] Production.ERROR: pbx prc_insertCDR end [2026-01-15 08:08:35] Production.INFO: ==6047== Releasing lock... [2026-01-15 08:08:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 08:08:35] Production.INFO: 30.75 MB #Memory Used# [2026-01-15 09:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 06:01:06 [end_date_ymd] => 2026-01-15 09:01:06 [RateCDR] => 1 ) [2026-01-15 09:01: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-15 06:01:06' and `end` < '2026-01-15 09:01: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-15 09:01:18] Production.INFO: count ==791 [2026-01-15 09:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 06:01:06 - End Time 2026-01-15 09:01:06 [2026-01-15 09:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566882', 'tblTempUsageDetail_20' ) start [2026-01-15 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16566882', 'tblTempUsageDetail_20' ) end [2026-01-15 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566882', 'tblTempVendorCDR_20' ) start [2026-01-15 09:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16566882', 'tblTempVendorCDR_20' ) end [2026-01-15 09:01:19] Production.INFO: ProcessCDR(1,16566882,1,1,2) [2026-01-15 09:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16566882,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 09:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16566882,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 09:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16566882,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 09:08:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16566882,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 09:08:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566882', 'tblTempUsageDetail_20' ) start [2026-01-15 09:08:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16566882', 'tblTempUsageDetail_20' ) end [2026-01-15 09:08:41] Production.ERROR: pbx prc_insertCDR start [2026-01-15 09:08:41] Production.ERROR: pbx prc_insertCDR end [2026-01-15 09:08:41] Production.INFO: ==10305== Releasing lock... [2026-01-15 09:08:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 09:08:41] Production.INFO: 34.5 MB #Memory Used# [2026-01-15 10:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 07:01:06 [end_date_ymd] => 2026-01-15 10:01:06 [RateCDR] => 1 ) [2026-01-15 10:01: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-15 07:01:06' and `end` < '2026-01-15 10:01: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-15 10:01:22] Production.INFO: count ==2148 [2026-01-15 10:01:23] Production.ERROR: pbx CDR StartTime 2026-01-15 07:01:06 - End Time 2026-01-15 10:01:06 [2026-01-15 10:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567129', 'tblTempUsageDetail_20' ) start [2026-01-15 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567129', 'tblTempUsageDetail_20' ) end [2026-01-15 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567129', 'tblTempVendorCDR_20' ) start [2026-01-15 10:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567129', 'tblTempVendorCDR_20' ) end [2026-01-15 10:01:23] Production.INFO: ProcessCDR(1,16567129,1,1,2) [2026-01-15 10:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16567129,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 10:04:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16567129,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 10:04:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16567129,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 10:08:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16567129,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 10:08:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567129', 'tblTempUsageDetail_20' ) start [2026-01-15 10:08:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567129', 'tblTempUsageDetail_20' ) end [2026-01-15 10:08:27] Production.ERROR: pbx prc_insertCDR start [2026-01-15 10:08:29] Production.ERROR: pbx prc_insertCDR end [2026-01-15 10:08:29] Production.INFO: ==15633== Releasing lock... [2026-01-15 10:08:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 10:08:29] Production.INFO: 44.5 MB #Memory Used# [2026-01-15 11:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 08:01:06 [end_date_ymd] => 2026-01-15 11:01:06 [RateCDR] => 1 ) [2026-01-15 11:01: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-15 08:01:06' and `end` < '2026-01-15 11:01: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-15 11:01:20] Production.INFO: count ==3898 [2026-01-15 11:01:22] Production.ERROR: pbx CDR StartTime 2026-01-15 08:01:06 - End Time 2026-01-15 11:01:06 [2026-01-15 11:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 11:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567376', 'tblTempUsageDetail_20' ) start [2026-01-15 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567376', 'tblTempUsageDetail_20' ) end [2026-01-15 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567376', 'tblTempVendorCDR_20' ) start [2026-01-15 11:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567376', 'tblTempVendorCDR_20' ) end [2026-01-15 11:01:23] Production.INFO: ProcessCDR(1,16567376,1,1,2) [2026-01-15 11:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16567376,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 11:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16567376,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 11:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16567376,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 11:08:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16567376,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 11:08:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567376', 'tblTempUsageDetail_20' ) start [2026-01-15 11:08:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567376', 'tblTempUsageDetail_20' ) end [2026-01-15 11:08:46] Production.ERROR: pbx prc_insertCDR start [2026-01-15 11:08:49] Production.ERROR: pbx prc_insertCDR end [2026-01-15 11:08:49] Production.INFO: ==20152== Releasing lock... [2026-01-15 11:08:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 11:08:49] Production.INFO: 57.25 MB #Memory Used# [2026-01-15 12:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 09:01:05 [end_date_ymd] => 2026-01-15 12:01:05 [RateCDR] => 1 ) [2026-01-15 12:01: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-15 09:01:05' and `end` < '2026-01-15 12:01: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-15 12:01:20] Production.INFO: count ==5144 [2026-01-15 12:01:23] Production.ERROR: pbx CDR StartTime 2026-01-15 09:01:05 - End Time 2026-01-15 12:01:05 [2026-01-15 12:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 12:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567623', 'tblTempUsageDetail_20' ) start [2026-01-15 12:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567623', 'tblTempUsageDetail_20' ) end [2026-01-15 12:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567623', 'tblTempVendorCDR_20' ) start [2026-01-15 12:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567623', 'tblTempVendorCDR_20' ) end [2026-01-15 12:01:23] Production.INFO: ProcessCDR(1,16567623,1,1,2) [2026-01-15 12:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16567623,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 12:05:19] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16567623,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 12:05:19] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16567623,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 12:08:57] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16567623,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 12:08:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567623', 'tblTempUsageDetail_20' ) start [2026-01-15 12:08:58] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567623', 'tblTempUsageDetail_20' ) end [2026-01-15 12:08:58] Production.ERROR: pbx prc_insertCDR start [2026-01-15 12:09:00] Production.ERROR: pbx prc_insertCDR end [2026-01-15 12:09:00] Production.INFO: ==25806== Releasing lock... [2026-01-15 12:09:00] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 12:09:00] Production.INFO: 66.75 MB #Memory Used# [2026-01-15 13:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 10:01:06 [end_date_ymd] => 2026-01-15 13:01:06 [RateCDR] => 1 ) [2026-01-15 13:01: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-15 10:01:06' and `end` < '2026-01-15 13:01: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-15 13:01:19] Production.INFO: count ==5300 [2026-01-15 13:01:22] Production.ERROR: pbx CDR StartTime 2026-01-15 10:01:06 - End Time 2026-01-15 13:01:06 [2026-01-15 13:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 13:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567870', 'tblTempUsageDetail_20' ) start [2026-01-15 13:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16567870', 'tblTempUsageDetail_20' ) end [2026-01-15 13:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567870', 'tblTempVendorCDR_20' ) start [2026-01-15 13:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16567870', 'tblTempVendorCDR_20' ) end [2026-01-15 13:01:22] Production.INFO: ProcessCDR(1,16567870,1,1,2) [2026-01-15 13:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16567870,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 13:05:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16567870,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 13:05:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16567870,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 13:09:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16567870,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 13:09:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567870', 'tblTempUsageDetail_20' ) start [2026-01-15 13:09:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16567870', 'tblTempUsageDetail_20' ) end [2026-01-15 13:09:15] Production.ERROR: pbx prc_insertCDR start [2026-01-15 13:09:18] Production.ERROR: pbx prc_insertCDR end [2026-01-15 13:09:18] Production.INFO: ==30287== Releasing lock... [2026-01-15 13:09:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 13:09:18] Production.INFO: 68.25 MB #Memory Used# [2026-01-15 14:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 11:01:07 [end_date_ymd] => 2026-01-15 14:01:07 [RateCDR] => 1 ) [2026-01-15 14:01:07] 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-15 11:01:07' and `end` < '2026-01-15 14:01:07' 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-15 14:01:20] Production.INFO: count ==5256 [2026-01-15 14:01:23] Production.ERROR: pbx CDR StartTime 2026-01-15 11:01:07 - End Time 2026-01-15 14:01:07 [2026-01-15 14:01:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 14:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568117', 'tblTempUsageDetail_20' ) start [2026-01-15 14:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568117', 'tblTempUsageDetail_20' ) end [2026-01-15 14:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568117', 'tblTempVendorCDR_20' ) start [2026-01-15 14:01:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568117', 'tblTempVendorCDR_20' ) end [2026-01-15 14:01:23] Production.INFO: ProcessCDR(1,16568117,1,1,2) [2026-01-15 14:01:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16568117,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 14:05:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16568117,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 14:05:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16568117,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 14:08:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16568117,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 14:08:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568117', 'tblTempUsageDetail_20' ) start [2026-01-15 14:08:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568117', 'tblTempUsageDetail_20' ) end [2026-01-15 14:08:46] Production.ERROR: pbx prc_insertCDR start [2026-01-15 14:08:48] Production.ERROR: pbx prc_insertCDR end [2026-01-15 14:08:48] Production.INFO: ==2188== Releasing lock... [2026-01-15 14:08:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 14:08:48] Production.INFO: 67.5 MB #Memory Used# [2026-01-15 15:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 12:01:06 [end_date_ymd] => 2026-01-15 15:01:06 [RateCDR] => 1 ) [2026-01-15 15:01: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-15 12:01:06' and `end` < '2026-01-15 15:01: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-15 15:01:19] Production.INFO: count ==5195 [2026-01-15 15:01:22] Production.ERROR: pbx CDR StartTime 2026-01-15 12:01:06 - End Time 2026-01-15 15:01:06 [2026-01-15 15:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 15:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568364', 'tblTempUsageDetail_20' ) start [2026-01-15 15:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568364', 'tblTempUsageDetail_20' ) end [2026-01-15 15:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568364', 'tblTempVendorCDR_20' ) start [2026-01-15 15:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568364', 'tblTempVendorCDR_20' ) end [2026-01-15 15:01:22] Production.INFO: ProcessCDR(1,16568364,1,1,2) [2026-01-15 15:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16568364,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 15:05:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16568364,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 15:05:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16568364,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 15:09:00] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16568364,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 15:09:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568364', 'tblTempUsageDetail_20' ) start [2026-01-15 15:09:00] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568364', 'tblTempUsageDetail_20' ) end [2026-01-15 15:09:00] Production.ERROR: pbx prc_insertCDR start [2026-01-15 15:09:07] Production.ERROR: pbx prc_insertCDR end [2026-01-15 15:09:07] Production.INFO: ==6938== Releasing lock... [2026-01-15 15:09:07] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 15:09:07] Production.INFO: 67 MB #Memory Used# [2026-01-15 16:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 13:01:06 [end_date_ymd] => 2026-01-15 16:01:06 [RateCDR] => 1 ) [2026-01-15 16:01: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-15 13:01:06' and `end` < '2026-01-15 16:01: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-15 16:01:19] Production.INFO: count ==5087 [2026-01-15 16:01:22] Production.ERROR: pbx CDR StartTime 2026-01-15 13:01:06 - End Time 2026-01-15 16:01:06 [2026-01-15 16:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 16:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568611', 'tblTempUsageDetail_20' ) start [2026-01-15 16:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568611', 'tblTempUsageDetail_20' ) end [2026-01-15 16:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568611', 'tblTempVendorCDR_20' ) start [2026-01-15 16:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568611', 'tblTempVendorCDR_20' ) end [2026-01-15 16:01:22] Production.INFO: ProcessCDR(1,16568611,1,1,2) [2026-01-15 16:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16568611,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 16:05:00] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16568611,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 16:05:00] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16568611,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 16:08:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16568611,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 16:08:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568611', 'tblTempUsageDetail_20' ) start [2026-01-15 16:08:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568611', 'tblTempUsageDetail_20' ) end [2026-01-15 16:08:51] Production.ERROR: pbx prc_insertCDR start [2026-01-15 16:08:52] Production.ERROR: pbx prc_insertCDR end [2026-01-15 16:08:52] Production.INFO: ==11746== Releasing lock... [2026-01-15 16:08:52] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 16:08:52] Production.INFO: 66.25 MB #Memory Used# [2026-01-15 17:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 14:01:06 [end_date_ymd] => 2026-01-15 17:01:06 [RateCDR] => 1 ) [2026-01-15 17:01: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-15 14:01:06' and `end` < '2026-01-15 17:01: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-15 17:01:19] Production.INFO: count ==4895 [2026-01-15 17:01:22] Production.ERROR: pbx CDR StartTime 2026-01-15 14:01:06 - End Time 2026-01-15 17:01:06 [2026-01-15 17:01:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 17:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568857', 'tblTempUsageDetail_20' ) start [2026-01-15 17:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16568857', 'tblTempUsageDetail_20' ) end [2026-01-15 17:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568857', 'tblTempVendorCDR_20' ) start [2026-01-15 17:01:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16568857', 'tblTempVendorCDR_20' ) end [2026-01-15 17:01:22] Production.INFO: ProcessCDR(1,16568857,1,1,2) [2026-01-15 17:01:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16568857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 17:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16568857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 17:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16568857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 17:08:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16568857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 17:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568857', 'tblTempUsageDetail_20' ) start [2026-01-15 17:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16568857', 'tblTempUsageDetail_20' ) end [2026-01-15 17:08:22] Production.ERROR: pbx prc_insertCDR start [2026-01-15 17:08:25] Production.ERROR: pbx prc_insertCDR end [2026-01-15 17:08:25] Production.INFO: ==16247== Releasing lock... [2026-01-15 17:08:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 17:08:25] Production.INFO: 64.75 MB #Memory Used# [2026-01-15 18:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 15:01:06 [end_date_ymd] => 2026-01-15 18:01:06 [RateCDR] => 1 ) [2026-01-15 18:01: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-15 15:01:06' and `end` < '2026-01-15 18:01: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-15 18:01:19] Production.INFO: count ==4154 [2026-01-15 18:01:21] Production.ERROR: pbx CDR StartTime 2026-01-15 15:01:06 - End Time 2026-01-15 18:01:06 [2026-01-15 18:01:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 18:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569104', 'tblTempUsageDetail_20' ) start [2026-01-15 18:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569104', 'tblTempUsageDetail_20' ) end [2026-01-15 18:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569104', 'tblTempVendorCDR_20' ) start [2026-01-15 18:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569104', 'tblTempVendorCDR_20' ) end [2026-01-15 18:01:21] Production.INFO: ProcessCDR(1,16569104,1,1,2) [2026-01-15 18:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16569104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 18:04:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16569104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 18:04:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16569104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 18:08:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16569104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 18:08:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569104', 'tblTempUsageDetail_20' ) start [2026-01-15 18:08:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569104', 'tblTempUsageDetail_20' ) end [2026-01-15 18:08:32] Production.ERROR: pbx prc_insertCDR start [2026-01-15 18:08:33] Production.ERROR: pbx prc_insertCDR end [2026-01-15 18:08:33] Production.INFO: ==20539== Releasing lock... [2026-01-15 18:08:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 18:08:33] Production.INFO: 59.25 MB #Memory Used# [2026-01-15 19:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 16:01:06 [end_date_ymd] => 2026-01-15 19:01:06 [RateCDR] => 1 ) [2026-01-15 19:01: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-15 16:01:06' and `end` < '2026-01-15 19:01: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-15 19:01:20] Production.INFO: count ==3449 [2026-01-15 19:01:21] Production.ERROR: pbx CDR StartTime 2026-01-15 16:01:06 - End Time 2026-01-15 19:01:06 [2026-01-15 19:01:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569351', 'tblTempUsageDetail_20' ) start [2026-01-15 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569351', 'tblTempUsageDetail_20' ) end [2026-01-15 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569351', 'tblTempVendorCDR_20' ) start [2026-01-15 19:01:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569351', 'tblTempVendorCDR_20' ) end [2026-01-15 19:01:21] Production.INFO: ProcessCDR(1,16569351,1,1,2) [2026-01-15 19:01:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16569351,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 19:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16569351,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 19:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16569351,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 19:08:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16569351,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 19:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569351', 'tblTempUsageDetail_20' ) start [2026-01-15 19:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569351', 'tblTempUsageDetail_20' ) end [2026-01-15 19:08:26] Production.ERROR: pbx prc_insertCDR start [2026-01-15 19:08:28] Production.ERROR: pbx prc_insertCDR end [2026-01-15 19:08:28] Production.INFO: ==24949== Releasing lock... [2026-01-15 19:08:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 19:08:28] Production.INFO: 54 MB #Memory Used# [2026-01-15 20:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 17:01:06 [end_date_ymd] => 2026-01-15 20:01:06 [RateCDR] => 1 ) [2026-01-15 20:01: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-15 17:01:06' and `end` < '2026-01-15 20:01: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-15 20:01:18] Production.INFO: count ==2741 [2026-01-15 20:01:20] Production.ERROR: pbx CDR StartTime 2026-01-15 17:01:06 - End Time 2026-01-15 20:01:06 [2026-01-15 20:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569598', 'tblTempUsageDetail_20' ) start [2026-01-15 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569598', 'tblTempUsageDetail_20' ) end [2026-01-15 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569598', 'tblTempVendorCDR_20' ) start [2026-01-15 20:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569598', 'tblTempVendorCDR_20' ) end [2026-01-15 20:01:20] Production.INFO: ProcessCDR(1,16569598,1,1,2) [2026-01-15 20:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16569598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 20:04:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16569598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 20:04:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16569598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 20:08:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16569598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 20:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569598', 'tblTempUsageDetail_20' ) start [2026-01-15 20:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569598', 'tblTempUsageDetail_20' ) end [2026-01-15 20:08:22] Production.ERROR: pbx prc_insertCDR start [2026-01-15 20:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-15 20:08:22] Production.INFO: ==29246== Releasing lock... [2026-01-15 20:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 20:08:22] Production.INFO: 48.75 MB #Memory Used# [2026-01-15 21:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 18:01:06 [end_date_ymd] => 2026-01-15 21:01:06 [RateCDR] => 1 ) [2026-01-15 21:01: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-15 18:01:06' and `end` < '2026-01-15 21:01: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-15 21:01:19] Production.INFO: count ==2225 [2026-01-15 21:01:19] Production.ERROR: pbx CDR StartTime 2026-01-15 18:01:06 - End Time 2026-01-15 21:01:06 [2026-01-15 21:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569844', 'tblTempUsageDetail_20' ) start [2026-01-15 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16569844', 'tblTempUsageDetail_20' ) end [2026-01-15 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569844', 'tblTempVendorCDR_20' ) start [2026-01-15 21:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16569844', 'tblTempVendorCDR_20' ) end [2026-01-15 21:01:20] Production.INFO: ProcessCDR(1,16569844,1,1,2) [2026-01-15 21:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16569844,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 21:05:13] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16569844,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 21:05:13] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16569844,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 21:09:07] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16569844,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 21:09:07] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569844', 'tblTempUsageDetail_20' ) start [2026-01-15 21:09:07] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16569844', 'tblTempUsageDetail_20' ) end [2026-01-15 21:09:07] Production.ERROR: pbx prc_insertCDR start [2026-01-15 21:09:08] Production.ERROR: pbx prc_insertCDR end [2026-01-15 21:09:08] Production.INFO: ==1101== Releasing lock... [2026-01-15 21:09:08] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 21:09:08] Production.INFO: 44.75 MB #Memory Used# [2026-01-15 22:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 19:01:07 [end_date_ymd] => 2026-01-15 22:01:07 [RateCDR] => 1 ) [2026-01-15 22:01:07] 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-15 19:01:07' and `end` < '2026-01-15 22:01:07' 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-15 22:01:19] Production.INFO: count ==1588 [2026-01-15 22:01:20] Production.ERROR: pbx CDR StartTime 2026-01-15 19:01:07 - End Time 2026-01-15 22:01:07 [2026-01-15 22:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 22:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570092', 'tblTempUsageDetail_20' ) start [2026-01-15 22:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570092', 'tblTempUsageDetail_20' ) end [2026-01-15 22:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570092', 'tblTempVendorCDR_20' ) start [2026-01-15 22:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570092', 'tblTempVendorCDR_20' ) end [2026-01-15 22:01:20] Production.INFO: ProcessCDR(1,16570092,1,1,2) [2026-01-15 22:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16570092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 22:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16570092,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 22:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16570092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 22:08:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16570092,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 22:08:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570092', 'tblTempUsageDetail_20' ) start [2026-01-15 22:08:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570092', 'tblTempUsageDetail_20' ) end [2026-01-15 22:08:15] Production.ERROR: pbx prc_insertCDR start [2026-01-15 22:08:15] Production.ERROR: pbx prc_insertCDR end [2026-01-15 22:08:15] Production.INFO: ==5472== Releasing lock... [2026-01-15 22:08:15] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 22:08:15] Production.INFO: 40 MB #Memory Used# [2026-01-15 23:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-15 20:01:06 [end_date_ymd] => 2026-01-15 23:01:06 [RateCDR] => 1 ) [2026-01-15 23:01: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-15 20:01:06' and `end` < '2026-01-15 23:01: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-15 23:01:18] Production.INFO: count ==1127 [2026-01-15 23:01:18] Production.ERROR: pbx CDR StartTime 2026-01-15 20:01:06 - End Time 2026-01-15 23:01:06 [2026-01-15 23:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-15 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570338', 'tblTempUsageDetail_20' ) start [2026-01-15 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16570338', 'tblTempUsageDetail_20' ) end [2026-01-15 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570338', 'tblTempVendorCDR_20' ) start [2026-01-15 23:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16570338', 'tblTempVendorCDR_20' ) end [2026-01-15 23:01:18] Production.INFO: ProcessCDR(1,16570338,1,1,2) [2026-01-15 23:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16570338,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 23:04:40] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16570338,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-15 23:04:40] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16570338,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 23:08:36] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16570338,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-15 23:08:36] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570338', 'tblTempUsageDetail_20' ) start [2026-01-15 23:08:37] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16570338', 'tblTempUsageDetail_20' ) end [2026-01-15 23:08:37] Production.ERROR: pbx prc_insertCDR start [2026-01-15 23:08:37] Production.ERROR: pbx prc_insertCDR end [2026-01-15 23:08:37] Production.INFO: ==9737== Releasing lock... [2026-01-15 23:08:37] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-15 23:08:37] Production.INFO: 36.5 MB #Memory Used#