[2026-01-22 00:02:05] Production.INFO: next invoice date [2026-01-22 00:02:05] Production.INFO: 2026-02-22 [2026-01-22 00:02:05] Production.INFO: getdaysdiff [2026-01-22 00:02:05] Production.INFO: +31 [2026-01-22 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (253,16,1,31,31,'RMScheduler',2026-01-22 00:02:05,1,0,,,0) [2026-01-22 00:02:05] Production.INFO: next invoice date [2026-01-22 00:02:05] Production.INFO: 2026-02-22 [2026-01-22 00:02:05] Production.INFO: getdaysdiff [2026-01-22 00:02:05] Production.INFO: +31 [2026-01-22 00:02:05] Production.INFO: call prc_setAccountDiscountPlan (253,13,2,31,31,'RMScheduler',2026-01-22 00:02:05,1,0,,,0) [2026-01-22 00:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 21:02:06 [end_date_ymd] => 2026-01-22 00:02:06 [RateCDR] => 1 ) [2026-01-22 00:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 21:02:06' and `end` < '2026-01-22 00:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 00:02:38] Production.INFO: count ==654 [2026-01-22 00:02:38] Production.ERROR: pbx CDR StartTime 2026-01-21 21:02:06 - End Time 2026-01-22 00:02:06 [2026-01-22 00:02:38] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 00:02:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606159', 'tblTempUsageDetail_20' ) start [2026-01-22 00:02:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606159', 'tblTempUsageDetail_20' ) end [2026-01-22 00:02:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606159', 'tblTempVendorCDR_20' ) start [2026-01-22 00:02:38] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606159', 'tblTempVendorCDR_20' ) end [2026-01-22 00:02:38] Production.INFO: ProcessCDR(1,16606159,1,1,2) [2026-01-22 00:02:38] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16606159,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 00:05:54] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16606159,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 00:05:54] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16606159,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 00:09:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16606159,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 00:09:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606159', 'tblTempUsageDetail_20' ) start [2026-01-22 00:09:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606159', 'tblTempUsageDetail_20' ) end [2026-01-22 00:09:47] Production.ERROR: pbx prc_insertCDR start [2026-01-22 00:09:48] Production.ERROR: pbx prc_insertCDR end [2026-01-22 00:09:51] Production.INFO: ==22777== Releasing lock... [2026-01-22 00:09:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 00:09:51] Production.INFO: 38 MB #Memory Used# [2026-01-22 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 22:02:05 [end_date_ymd] => 2026-01-22 01:02:05 [RateCDR] => 1 ) [2026-01-22 01:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 22:02:05' and `end` < '2026-01-22 01:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 01:02:17] Production.INFO: count ==605 [2026-01-22 01:02:18] Production.ERROR: pbx CDR StartTime 2026-01-21 22:02:05 - End Time 2026-01-22 01:02:05 [2026-01-22 01:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606406', 'tblTempUsageDetail_20' ) start [2026-01-22 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606406', 'tblTempUsageDetail_20' ) end [2026-01-22 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606406', 'tblTempVendorCDR_20' ) start [2026-01-22 01:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606406', 'tblTempVendorCDR_20' ) end [2026-01-22 01:02:18] Production.INFO: ProcessCDR(1,16606406,1,1,2) [2026-01-22 01:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16606406,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 01:05:42] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16606406,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 01:05:42] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16606406,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 01:09:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16606406,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 01:09:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606406', 'tblTempUsageDetail_20' ) start [2026-01-22 01:09:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606406', 'tblTempUsageDetail_20' ) end [2026-01-22 01:09:50] Production.ERROR: pbx prc_insertCDR start [2026-01-22 01:09:50] Production.ERROR: pbx prc_insertCDR end [2026-01-22 01:09:50] Production.INFO: ==27062== Releasing lock... [2026-01-22 01:09:50] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 01:09:50] Production.INFO: 33.25 MB #Memory Used# [2026-01-22 02:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-21 23:02:05 [end_date_ymd] => 2026-01-22 02:02:05 [RateCDR] => 1 ) [2026-01-22 02:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-21 23:02:05' and `end` < '2026-01-22 02:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 02:02:22] Production.INFO: count ==569 [2026-01-22 02:02:22] Production.ERROR: pbx CDR StartTime 2026-01-21 23:02:05 - End Time 2026-01-22 02:02:05 [2026-01-22 02:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 02:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606653', 'tblTempUsageDetail_20' ) start [2026-01-22 02:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606653', 'tblTempUsageDetail_20' ) end [2026-01-22 02:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606653', 'tblTempVendorCDR_20' ) start [2026-01-22 02:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606653', 'tblTempVendorCDR_20' ) end [2026-01-22 02:02:22] Production.INFO: ProcessCDR(1,16606653,1,1,2) [2026-01-22 02:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16606653,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 02:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16606653,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 02:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16606653,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 02:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16606653,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 02:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606653', 'tblTempUsageDetail_20' ) start [2026-01-22 02:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606653', 'tblTempUsageDetail_20' ) end [2026-01-22 02:09:29] Production.ERROR: pbx prc_insertCDR start [2026-01-22 02:09:29] Production.ERROR: pbx prc_insertCDR end [2026-01-22 02:09:29] Production.INFO: ==31498== Releasing lock... [2026-01-22 02:09:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 02:09:29] Production.INFO: 32.75 MB #Memory Used# [2026-01-22 03:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 00:02:05 [end_date_ymd] => 2026-01-22 03:02:05 [RateCDR] => 1 ) [2026-01-22 03:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 00:02:05' and `end` < '2026-01-22 03:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 03:02:17] Production.INFO: count ==482 [2026-01-22 03:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 00:02:05 - End Time 2026-01-22 03:02:05 [2026-01-22 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606900', 'tblTempUsageDetail_20' ) start [2026-01-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16606900', 'tblTempUsageDetail_20' ) end [2026-01-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606900', 'tblTempVendorCDR_20' ) start [2026-01-22 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16606900', 'tblTempVendorCDR_20' ) end [2026-01-22 03:02:17] Production.INFO: ProcessCDR(1,16606900,1,1,2) [2026-01-22 03:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16606900,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 03:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16606900,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 03:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16606900,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 03:09:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16606900,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 03:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606900', 'tblTempUsageDetail_20' ) start [2026-01-22 03:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16606900', 'tblTempUsageDetail_20' ) end [2026-01-22 03:09:31] Production.ERROR: pbx prc_insertCDR start [2026-01-22 03:09:31] Production.ERROR: pbx prc_insertCDR end [2026-01-22 03:09:31] Production.INFO: ==3653== Releasing lock... [2026-01-22 03:09:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 03:09:31] Production.INFO: 32.5 MB #Memory Used# [2026-01-22 04:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 01:02:06 [end_date_ymd] => 2026-01-22 04:02:06 [RateCDR] => 1 ) [2026-01-22 04:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 01:02:06' and `end` < '2026-01-22 04:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 04:02:18] Production.INFO: count ==305 [2026-01-22 04:02:18] Production.ERROR: pbx CDR StartTime 2026-01-22 01:02:06 - End Time 2026-01-22 04:02:06 [2026-01-22 04:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607148', 'tblTempUsageDetail_20' ) start [2026-01-22 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607148', 'tblTempUsageDetail_20' ) end [2026-01-22 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607148', 'tblTempVendorCDR_20' ) start [2026-01-22 04:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607148', 'tblTempVendorCDR_20' ) end [2026-01-22 04:02:18] Production.INFO: ProcessCDR(1,16607148,1,1,2) [2026-01-22 04:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16607148,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 04:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16607148,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 04:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16607148,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 04:09:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16607148,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 04:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607148', 'tblTempUsageDetail_20' ) start [2026-01-22 04:09:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607148', 'tblTempUsageDetail_20' ) end [2026-01-22 04:09:23] Production.ERROR: pbx prc_insertCDR start [2026-01-22 04:09:23] Production.ERROR: pbx prc_insertCDR end [2026-01-22 04:09:23] Production.INFO: ==9108== Releasing lock... [2026-01-22 04:09:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 04:09:23] Production.INFO: 31.25 MB #Memory Used# [2026-01-22 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 02:02:05 [end_date_ymd] => 2026-01-22 05:02:05 [RateCDR] => 1 ) [2026-01-22 05:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 02:02:05' and `end` < '2026-01-22 05:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 05:02:17] Production.INFO: count ==165 [2026-01-22 05:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 02:02:05 - End Time 2026-01-22 05:02:05 [2026-01-22 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607396', 'tblTempUsageDetail_20' ) start [2026-01-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607396', 'tblTempUsageDetail_20' ) end [2026-01-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607396', 'tblTempVendorCDR_20' ) start [2026-01-22 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607396', 'tblTempVendorCDR_20' ) end [2026-01-22 05:02:17] Production.INFO: ProcessCDR(1,16607396,1,1,2) [2026-01-22 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16607396,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 05:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16607396,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 05:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16607396,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 05:09:41] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16607396,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 05:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607396', 'tblTempUsageDetail_20' ) start [2026-01-22 05:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607396', 'tblTempUsageDetail_20' ) end [2026-01-22 05:09:41] Production.ERROR: pbx prc_insertCDR start [2026-01-22 05:09:41] Production.ERROR: pbx prc_insertCDR end [2026-01-22 05:09:41] Production.INFO: ==13556== Releasing lock... [2026-01-22 05:09:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 05:09:41] Production.INFO: 29.5 MB #Memory Used# [2026-01-22 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 03:02:05 [end_date_ymd] => 2026-01-22 06:02:05 [RateCDR] => 1 ) [2026-01-22 06:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 03:02:05' and `end` < '2026-01-22 06:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 06:02:17] Production.INFO: count ==120 [2026-01-22 06:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 03:02:05 - End Time 2026-01-22 06:02:05 [2026-01-22 06:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607643', 'tblTempUsageDetail_20' ) start [2026-01-22 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607643', 'tblTempUsageDetail_20' ) end [2026-01-22 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607643', 'tblTempVendorCDR_20' ) start [2026-01-22 06:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607643', 'tblTempVendorCDR_20' ) end [2026-01-22 06:02:17] Production.INFO: ProcessCDR(1,16607643,1,1,2) [2026-01-22 06:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16607643,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 06:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16607643,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 06:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16607643,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 06:09:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16607643,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 06:09:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607643', 'tblTempUsageDetail_20' ) start [2026-01-22 06:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607643', 'tblTempUsageDetail_20' ) end [2026-01-22 06:09:40] Production.ERROR: pbx prc_insertCDR start [2026-01-22 06:09:40] Production.ERROR: pbx prc_insertCDR end [2026-01-22 06:09:40] Production.INFO: ==18624== Releasing lock... [2026-01-22 06:09:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 06:09:40] Production.INFO: 29.25 MB #Memory Used# [2026-01-22 07:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 04:02:05 [end_date_ymd] => 2026-01-22 07:02:05 [RateCDR] => 1 ) [2026-01-22 07:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 04:02:05' and `end` < '2026-01-22 07:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 07:02:17] Production.INFO: count ==120 [2026-01-22 07:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 04:02:05 - End Time 2026-01-22 07:02:05 [2026-01-22 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607890', 'tblTempUsageDetail_20' ) start [2026-01-22 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16607890', 'tblTempUsageDetail_20' ) end [2026-01-22 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607890', 'tblTempVendorCDR_20' ) start [2026-01-22 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16607890', 'tblTempVendorCDR_20' ) end [2026-01-22 07:02:17] Production.INFO: ProcessCDR(1,16607890,1,1,2) [2026-01-22 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16607890,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 07:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16607890,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 07:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16607890,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 07:09:31] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16607890,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 07:09:31] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607890', 'tblTempUsageDetail_20' ) start [2026-01-22 07:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16607890', 'tblTempUsageDetail_20' ) end [2026-01-22 07:09:32] Production.ERROR: pbx prc_insertCDR start [2026-01-22 07:09:32] Production.ERROR: pbx prc_insertCDR end [2026-01-22 07:09:32] Production.INFO: ==23132== Releasing lock... [2026-01-22 07:09:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 07:09:32] Production.INFO: 29 MB #Memory Used# [2026-01-22 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 05:02:05 [end_date_ymd] => 2026-01-22 08:02:05 [RateCDR] => 1 ) [2026-01-22 08:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 05:02:05' and `end` < '2026-01-22 08:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 08:02:17] Production.INFO: count ==154 [2026-01-22 08:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 05:02:05 - End Time 2026-01-22 08:02:05 [2026-01-22 08:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608137', 'tblTempUsageDetail_20' ) start [2026-01-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608137', 'tblTempUsageDetail_20' ) end [2026-01-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608137', 'tblTempVendorCDR_20' ) start [2026-01-22 08:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608137', 'tblTempVendorCDR_20' ) end [2026-01-22 08:02:17] Production.INFO: ProcessCDR(1,16608137,1,1,2) [2026-01-22 08:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16608137,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 08:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16608137,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 08:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16608137,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 08:09:33] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16608137,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 08:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608137', 'tblTempUsageDetail_20' ) start [2026-01-22 08:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608137', 'tblTempUsageDetail_20' ) end [2026-01-22 08:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-22 08:09:33] Production.ERROR: pbx prc_insertCDR end [2026-01-22 08:09:33] Production.INFO: ==27623== Releasing lock... [2026-01-22 08:09:33] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 08:09:33] Production.INFO: 29.25 MB #Memory Used# [2026-01-22 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 06:02:05 [end_date_ymd] => 2026-01-22 09:02:05 [RateCDR] => 1 ) [2026-01-22 09:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 06:02:05' and `end` < '2026-01-22 09:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 09:02:17] Production.INFO: count ==771 [2026-01-22 09:02:17] Production.ERROR: pbx CDR StartTime 2026-01-22 06:02:05 - End Time 2026-01-22 09:02:05 [2026-01-22 09:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608384', 'tblTempUsageDetail_20' ) start [2026-01-22 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608384', 'tblTempUsageDetail_20' ) end [2026-01-22 09:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608384', 'tblTempVendorCDR_20' ) start [2026-01-22 09:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608384', 'tblTempVendorCDR_20' ) end [2026-01-22 09:02:18] Production.INFO: ProcessCDR(1,16608384,1,1,2) [2026-01-22 09:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16608384,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 09:05:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16608384,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 09:05:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16608384,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 09:09:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16608384,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 09:09:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608384', 'tblTempUsageDetail_20' ) start [2026-01-22 09:09:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608384', 'tblTempUsageDetail_20' ) end [2026-01-22 09:09:14] Production.ERROR: pbx prc_insertCDR start [2026-01-22 09:09:15] Production.ERROR: pbx prc_insertCDR end [2026-01-22 09:09:15] Production.INFO: ==32054== Releasing lock... [2026-01-22 09:09:15] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 09:09:15] Production.INFO: 34 MB #Memory Used# [2026-01-22 10:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 07:02:06 [end_date_ymd] => 2026-01-22 10:02:06 [RateCDR] => 1 ) [2026-01-22 10:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 07:02:06' and `end` < '2026-01-22 10:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 10:02:20] Production.INFO: count ==2340 [2026-01-22 10:02:21] Production.ERROR: pbx CDR StartTime 2026-01-22 07:02:06 - End Time 2026-01-22 10:02:06 [2026-01-22 10:02:21] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608631', 'tblTempUsageDetail_20' ) start [2026-01-22 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608631', 'tblTempUsageDetail_20' ) end [2026-01-22 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608631', 'tblTempVendorCDR_20' ) start [2026-01-22 10:02:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608631', 'tblTempVendorCDR_20' ) end [2026-01-22 10:02:21] Production.INFO: ProcessCDR(1,16608631,1,1,2) [2026-01-22 10:02:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16608631,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 10:05:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16608631,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 10:05:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16608631,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 10:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16608631,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 10:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608631', 'tblTempUsageDetail_20' ) start [2026-01-22 10:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608631', 'tblTempUsageDetail_20' ) end [2026-01-22 10:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-22 10:09:26] Production.ERROR: pbx prc_insertCDR end [2026-01-22 10:09:26] Production.INFO: ==4010== Releasing lock... [2026-01-22 10:09:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 10:09:26] Production.INFO: 46 MB #Memory Used# [2026-01-22 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 08:02:05 [end_date_ymd] => 2026-01-22 11:02:05 [RateCDR] => 1 ) [2026-01-22 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 08:02:05' and `end` < '2026-01-22 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 11:02:18] Production.INFO: count ==3978 [2026-01-22 11:02:20] Production.ERROR: pbx CDR StartTime 2026-01-22 08:02:05 - End Time 2026-01-22 11:02:05 [2026-01-22 11:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608878', 'tblTempUsageDetail_20' ) start [2026-01-22 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16608878', 'tblTempUsageDetail_20' ) end [2026-01-22 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608878', 'tblTempVendorCDR_20' ) start [2026-01-22 11:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16608878', 'tblTempVendorCDR_20' ) end [2026-01-22 11:02:20] Production.INFO: ProcessCDR(1,16608878,1,1,2) [2026-01-22 11:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16608878,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 11:05:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16608878,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 11:05:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16608878,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 11:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16608878,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 11:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608878', 'tblTempUsageDetail_20' ) start [2026-01-22 11:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16608878', 'tblTempUsageDetail_20' ) end [2026-01-22 11:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-22 11:09:38] Production.ERROR: pbx prc_insertCDR end [2026-01-22 11:09:38] Production.INFO: ==8283== Releasing lock... [2026-01-22 11:09:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 11:09:38] Production.INFO: 57.75 MB #Memory Used# [2026-01-22 12:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 09:02:06 [end_date_ymd] => 2026-01-22 12:02:06 [RateCDR] => 1 ) [2026-01-22 12:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 09:02:06' and `end` < '2026-01-22 12:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 12:02:22] Production.INFO: count ==5072 [2026-01-22 12:02:24] Production.ERROR: pbx CDR StartTime 2026-01-22 09:02:06 - End Time 2026-01-22 12:02:06 [2026-01-22 12:02:24] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 12:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609125', 'tblTempUsageDetail_20' ) start [2026-01-22 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609125', 'tblTempUsageDetail_20' ) end [2026-01-22 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609125', 'tblTempVendorCDR_20' ) start [2026-01-22 12:02:25] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609125', 'tblTempVendorCDR_20' ) end [2026-01-22 12:02:25] Production.INFO: ProcessCDR(1,16609125,1,1,2) [2026-01-22 12:02:25] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16609125,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 12:05:39] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16609125,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 12:05:39] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16609125,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 12:09:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16609125,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 12:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609125', 'tblTempUsageDetail_20' ) start [2026-01-22 12:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609125', 'tblTempUsageDetail_20' ) end [2026-01-22 12:09:32] Production.ERROR: pbx prc_insertCDR start [2026-01-22 12:09:35] Production.ERROR: pbx prc_insertCDR end [2026-01-22 12:09:35] Production.INFO: ==12545== Releasing lock... [2026-01-22 12:09:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 12:09:35] Production.INFO: 66.25 MB #Memory Used# [2026-01-22 13:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 10:02:06 [end_date_ymd] => 2026-01-22 13:02:06 [RateCDR] => 1 ) [2026-01-22 13:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 10:02:06' and `end` < '2026-01-22 13:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 13:02:21] Production.INFO: count ==5499 [2026-01-22 13:02:23] Production.ERROR: pbx CDR StartTime 2026-01-22 10:02:06 - End Time 2026-01-22 13:02:06 [2026-01-22 13:02:23] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 13:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609372', 'tblTempUsageDetail_20' ) start [2026-01-22 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609372', 'tblTempUsageDetail_20' ) end [2026-01-22 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609372', 'tblTempVendorCDR_20' ) start [2026-01-22 13:02:24] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609372', 'tblTempVendorCDR_20' ) end [2026-01-22 13:02:24] Production.INFO: ProcessCDR(1,16609372,1,1,2) [2026-01-22 13:02:24] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16609372,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 13:05:44] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16609372,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 13:05:44] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16609372,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 13:09:51] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16609372,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 13:09:51] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609372', 'tblTempUsageDetail_20' ) start [2026-01-22 13:09:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609372', 'tblTempUsageDetail_20' ) end [2026-01-22 13:09:52] Production.ERROR: pbx prc_insertCDR start [2026-01-22 13:09:55] Production.ERROR: pbx prc_insertCDR end [2026-01-22 13:09:55] Production.INFO: ==16873== Releasing lock... [2026-01-22 13:09:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 13:09:55] Production.INFO: 69.5 MB #Memory Used# [2026-01-22 14:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 11:02:05 [end_date_ymd] => 2026-01-22 14:02:05 [RateCDR] => 1 ) [2026-01-22 14:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 11:02:05' and `end` < '2026-01-22 14:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 14:02:29] Production.INFO: count ==5572 [2026-01-22 14:02:32] Production.ERROR: pbx CDR StartTime 2026-01-22 11:02:05 - End Time 2026-01-22 14:02:05 [2026-01-22 14:02:32] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 14:02:32] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609619', 'tblTempUsageDetail_20' ) start [2026-01-22 14:02:33] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609619', 'tblTempUsageDetail_20' ) end [2026-01-22 14:02:33] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609619', 'tblTempVendorCDR_20' ) start [2026-01-22 14:02:33] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609619', 'tblTempVendorCDR_20' ) end [2026-01-22 14:02:33] Production.INFO: ProcessCDR(1,16609619,1,1,2) [2026-01-22 14:02:33] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16609619,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 14:05:50] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16609619,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 14:05:50] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16609619,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 14:09:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16609619,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 14:09:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609619', 'tblTempUsageDetail_20' ) start [2026-01-22 14:09:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609619', 'tblTempUsageDetail_20' ) end [2026-01-22 14:09:50] Production.ERROR: pbx prc_insertCDR start [2026-01-22 14:09:53] Production.ERROR: pbx prc_insertCDR end [2026-01-22 14:09:53] Production.INFO: ==21431== Releasing lock... [2026-01-22 14:09:53] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 14:09:53] Production.INFO: 70 MB #Memory Used# [2026-01-22 15:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 12:02:06 [end_date_ymd] => 2026-01-22 15:02:06 [RateCDR] => 1 ) [2026-01-22 15:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 12:02:06' and `end` < '2026-01-22 15:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 15:02:20] Production.INFO: count ==5443 [2026-01-22 15:02:22] Production.ERROR: pbx CDR StartTime 2026-01-22 12:02:06 - End Time 2026-01-22 15:02:06 [2026-01-22 15:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 15:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609866', 'tblTempUsageDetail_20' ) start [2026-01-22 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16609866', 'tblTempUsageDetail_20' ) end [2026-01-22 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609866', 'tblTempVendorCDR_20' ) start [2026-01-22 15:02:23] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16609866', 'tblTempVendorCDR_20' ) end [2026-01-22 15:02:23] Production.INFO: ProcessCDR(1,16609866,1,1,2) [2026-01-22 15:02:23] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16609866,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 15:05:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16609866,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 15:05:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16609866,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 15:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16609866,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 15:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609866', 'tblTempUsageDetail_20' ) start [2026-01-22 15:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16609866', 'tblTempUsageDetail_20' ) end [2026-01-22 15:09:29] Production.ERROR: pbx prc_insertCDR start [2026-01-22 15:09:32] Production.ERROR: pbx prc_insertCDR end [2026-01-22 15:09:32] Production.INFO: ==25725== Releasing lock... [2026-01-22 15:09:32] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 15:09:32] Production.INFO: 69 MB #Memory Used# [2026-01-22 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 13:02:05 [end_date_ymd] => 2026-01-22 16:02:05 [RateCDR] => 1 ) [2026-01-22 16:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 13:02:05' and `end` < '2026-01-22 16:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 16:02:23] Production.INFO: count ==5447 [2026-01-22 16:02:26] Production.ERROR: pbx CDR StartTime 2026-01-22 13:02:05 - End Time 2026-01-22 16:02:05 [2026-01-22 16:02:26] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 16:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610113', 'tblTempUsageDetail_20' ) start [2026-01-22 16:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610113', 'tblTempUsageDetail_20' ) end [2026-01-22 16:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610113', 'tblTempVendorCDR_20' ) start [2026-01-22 16:02:26] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610113', 'tblTempVendorCDR_20' ) end [2026-01-22 16:02:26] Production.INFO: ProcessCDR(1,16610113,1,1,2) [2026-01-22 16:02:26] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16610113,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 16:05:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16610113,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 16:05:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16610113,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 16:09:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16610113,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 16:09:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610113', 'tblTempUsageDetail_20' ) start [2026-01-22 16:09:41] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610113', 'tblTempUsageDetail_20' ) end [2026-01-22 16:09:41] Production.ERROR: pbx prc_insertCDR start [2026-01-22 16:09:44] Production.ERROR: pbx prc_insertCDR end [2026-01-22 16:09:44] Production.INFO: ==30135== Releasing lock... [2026-01-22 16:09:44] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 16:09:44] Production.INFO: 69 MB #Memory Used# [2026-01-22 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 14:02:05 [end_date_ymd] => 2026-01-22 17:02:05 [RateCDR] => 1 ) [2026-01-22 17:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 14:02:05' and `end` < '2026-01-22 17:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 17:02:19] Production.INFO: count ==5839 [2026-01-22 17:02:22] Production.ERROR: pbx CDR StartTime 2026-01-22 14:02:05 - End Time 2026-01-22 17:02:05 [2026-01-22 17:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610360', 'tblTempUsageDetail_20' ) start [2026-01-22 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610360', 'tblTempUsageDetail_20' ) end [2026-01-22 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610360', 'tblTempVendorCDR_20' ) start [2026-01-22 17:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610360', 'tblTempVendorCDR_20' ) end [2026-01-22 17:02:22] Production.INFO: ProcessCDR(1,16610360,1,1,2) [2026-01-22 17:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16610360,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 17:05:34] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16610360,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 17:05:34] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16610360,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 17:09:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16610360,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 17:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610360', 'tblTempUsageDetail_20' ) start [2026-01-22 17:09:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610360', 'tblTempUsageDetail_20' ) end [2026-01-22 17:09:35] Production.ERROR: pbx prc_insertCDR start [2026-01-22 17:09:38] Production.ERROR: pbx prc_insertCDR end [2026-01-22 17:09:38] Production.INFO: ==2222== Releasing lock... [2026-01-22 17:09:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 17:09:38] Production.INFO: 72 MB #Memory Used# [2026-01-22 18:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 15:02:06 [end_date_ymd] => 2026-01-22 18:02:06 [RateCDR] => 1 ) [2026-01-22 18:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 15:02:06' and `end` < '2026-01-22 18:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 18:02:19] Production.INFO: count ==5418 [2026-01-22 18:02:22] Production.ERROR: pbx CDR StartTime 2026-01-22 15:02:06 - End Time 2026-01-22 18:02:06 [2026-01-22 18:02:22] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610605', 'tblTempUsageDetail_20' ) start [2026-01-22 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610605', 'tblTempUsageDetail_20' ) end [2026-01-22 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610605', 'tblTempVendorCDR_20' ) start [2026-01-22 18:02:22] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610605', 'tblTempVendorCDR_20' ) end [2026-01-22 18:02:22] Production.INFO: ProcessCDR(1,16610605,1,1,2) [2026-01-22 18:02:22] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16610605,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 18:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16610605,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 18:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16610605,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 18:09:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16610605,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 18:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610605', 'tblTempUsageDetail_20' ) start [2026-01-22 18:09:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610605', 'tblTempUsageDetail_20' ) end [2026-01-22 18:09:28] Production.ERROR: pbx prc_insertCDR start [2026-01-22 18:09:30] Production.ERROR: pbx prc_insertCDR end [2026-01-22 18:09:30] Production.INFO: ==6782== Releasing lock... [2026-01-22 18:09:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 18:09:30] Production.INFO: 68.75 MB #Memory Used# [2026-01-22 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 16:02:05 [end_date_ymd] => 2026-01-22 19:02:05 [RateCDR] => 1 ) [2026-01-22 19:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 16:02:05' and `end` < '2026-01-22 19:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 19:02:18] Production.INFO: count ==4183 [2026-01-22 19:02:20] Production.ERROR: pbx CDR StartTime 2026-01-22 16:02:05 - End Time 2026-01-22 19:02:05 [2026-01-22 19:02:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610852', 'tblTempUsageDetail_20' ) start [2026-01-22 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16610852', 'tblTempUsageDetail_20' ) end [2026-01-22 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610852', 'tblTempVendorCDR_20' ) start [2026-01-22 19:02:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16610852', 'tblTempVendorCDR_20' ) end [2026-01-22 19:02:20] Production.INFO: ProcessCDR(1,16610852,1,1,2) [2026-01-22 19:02:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16610852,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 19:05:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16610852,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 19:05:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16610852,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 19:09:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16610852,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 19:09:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610852', 'tblTempUsageDetail_20' ) start [2026-01-22 19:09:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16610852', 'tblTempUsageDetail_20' ) end [2026-01-22 19:09:30] Production.ERROR: pbx prc_insertCDR start [2026-01-22 19:09:31] Production.ERROR: pbx prc_insertCDR end [2026-01-22 19:09:31] Production.INFO: ==11679== Releasing lock... [2026-01-22 19:09:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 19:09:31] Production.INFO: 59.5 MB #Memory Used# [2026-01-22 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 17:02:05 [end_date_ymd] => 2026-01-22 20:02:05 [RateCDR] => 1 ) [2026-01-22 20:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 17:02:05' and `end` < '2026-01-22 20:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 20:02:18] Production.INFO: count ==2789 [2026-01-22 20:02:19] Production.ERROR: pbx CDR StartTime 2026-01-22 17:02:05 - End Time 2026-01-22 20:02:05 [2026-01-22 20:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611099', 'tblTempUsageDetail_20' ) start [2026-01-22 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611099', 'tblTempUsageDetail_20' ) end [2026-01-22 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611099', 'tblTempVendorCDR_20' ) start [2026-01-22 20:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611099', 'tblTempVendorCDR_20' ) end [2026-01-22 20:02:19] Production.INFO: ProcessCDR(1,16611099,1,1,2) [2026-01-22 20:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16611099,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 20:05:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16611099,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 20:05:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16611099,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 20:09:32] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16611099,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 20:09:32] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611099', 'tblTempUsageDetail_20' ) start [2026-01-22 20:09:33] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611099', 'tblTempUsageDetail_20' ) end [2026-01-22 20:09:33] Production.ERROR: pbx prc_insertCDR start [2026-01-22 20:09:34] Production.ERROR: pbx prc_insertCDR end [2026-01-22 20:09:34] Production.INFO: ==16067== Releasing lock... [2026-01-22 20:09:34] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 20:09:34] Production.INFO: 49.5 MB #Memory Used# [2026-01-22 21:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 18:02:06 [end_date_ymd] => 2026-01-22 21:02:06 [RateCDR] => 1 ) [2026-01-22 21:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 18:02:06' and `end` < '2026-01-22 21:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 21:02:18] Production.INFO: count ==2036 [2026-01-22 21:02:19] Production.ERROR: pbx CDR StartTime 2026-01-22 18:02:06 - End Time 2026-01-22 21:02:06 [2026-01-22 21:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611346', 'tblTempUsageDetail_20' ) start [2026-01-22 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611346', 'tblTempUsageDetail_20' ) end [2026-01-22 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611346', 'tblTempVendorCDR_20' ) start [2026-01-22 21:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611346', 'tblTempVendorCDR_20' ) end [2026-01-22 21:02:19] Production.INFO: ProcessCDR(1,16611346,1,1,2) [2026-01-22 21:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16611346,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 21:05:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16611346,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 21:05:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16611346,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 21:09:15] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16611346,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 21:09:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611346', 'tblTempUsageDetail_20' ) start [2026-01-22 21:09:15] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611346', 'tblTempUsageDetail_20' ) end [2026-01-22 21:09:15] Production.ERROR: pbx prc_insertCDR start [2026-01-22 21:09:16] Production.ERROR: pbx prc_insertCDR end [2026-01-22 21:09:16] Production.INFO: ==20436== Releasing lock... [2026-01-22 21:09:16] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 21:09:16] Production.INFO: 43.75 MB #Memory Used# [2026-01-22 22:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 19:02:06 [end_date_ymd] => 2026-01-22 22:02:06 [RateCDR] => 1 ) [2026-01-22 22:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 19:02:06' and `end` < '2026-01-22 22:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 22:02:18] Production.INFO: count ==1594 [2026-01-22 22:02:18] Production.ERROR: pbx CDR StartTime 2026-01-22 19:02:06 - End Time 2026-01-22 22:02:06 [2026-01-22 22:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 22:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611593', 'tblTempUsageDetail_20' ) start [2026-01-22 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611593', 'tblTempUsageDetail_20' ) end [2026-01-22 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611593', 'tblTempVendorCDR_20' ) start [2026-01-22 22:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611593', 'tblTempVendorCDR_20' ) end [2026-01-22 22:02:19] Production.INFO: ProcessCDR(1,16611593,1,1,2) [2026-01-22 22:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16611593,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 22:05:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16611593,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 22:05:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16611593,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 22:09:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16611593,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 22:09:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611593', 'tblTempUsageDetail_20' ) start [2026-01-22 22:09:20] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611593', 'tblTempUsageDetail_20' ) end [2026-01-22 22:09:20] Production.ERROR: pbx prc_insertCDR start [2026-01-22 22:09:20] Production.ERROR: pbx prc_insertCDR end [2026-01-22 22:09:20] Production.INFO: ==25039== Releasing lock... [2026-01-22 22:09:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 22:09:20] Production.INFO: 40.25 MB #Memory Used# [2026-01-22 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-22 20:02:06 [end_date_ymd] => 2026-01-22 23:02:06 [RateCDR] => 1 ) [2026-01-22 23:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-01-22 20:02:06' and `end` < '2026-01-22 23:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-01-22 23:02:18] Production.INFO: count ==1166 [2026-01-22 23:02:19] Production.ERROR: pbx CDR StartTime 2026-01-22 20:02:06 - End Time 2026-01-22 23:02:06 [2026-01-22 23:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-22 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611840', 'tblTempUsageDetail_20' ) start [2026-01-22 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16611840', 'tblTempUsageDetail_20' ) end [2026-01-22 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611840', 'tblTempVendorCDR_20' ) start [2026-01-22 23:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16611840', 'tblTempVendorCDR_20' ) end [2026-01-22 23:02:19] Production.INFO: ProcessCDR(1,16611840,1,1,2) [2026-01-22 23:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16611840,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 23:05:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16611840,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-22 23:05:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16611840,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 23:09:24] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16611840,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-22 23:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611840', 'tblTempUsageDetail_20' ) start [2026-01-22 23:09:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16611840', 'tblTempUsageDetail_20' ) end [2026-01-22 23:09:24] Production.ERROR: pbx prc_insertCDR start [2026-01-22 23:09:25] Production.ERROR: pbx prc_insertCDR end [2026-01-22 23:09:25] Production.INFO: ==29345== Releasing lock... [2026-01-22 23:09:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-22 23:09:25] Production.INFO: 37 MB #Memory Used#