[2026-01-11 00:01:04] Production.INFO: next invoice date [2026-01-11 00:01:04] Production.INFO: 2026-02-11 [2026-01-11 00:01:04] Production.INFO: getdaysdiff [2026-01-11 00:01:04] Production.INFO: +31 [2026-01-11 00:01:04] Production.INFO: call prc_setAccountDiscountPlan (229,16,1,31,31,'RMScheduler',2026-01-11 00:01:04,1,0,,,0) [2026-01-11 00:01:05] Production.INFO: next invoice date [2026-01-11 00:01:05] Production.INFO: 2026-02-11 [2026-01-11 00:01:05] Production.INFO: getdaysdiff [2026-01-11 00:01:05] Production.INFO: +31 [2026-01-11 00:01:05] Production.INFO: call prc_setAccountDiscountPlan (229,13,2,31,31,'RMScheduler',2026-01-11 00:01:04,1,0,,,0) [2026-01-11 00:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-10 21:01:06 [end_date_ymd] => 2026-01-11 00:01:06 [RateCDR] => 1 ) [2026-01-11 00: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-10 21:01:06' and `end` < '2026-01-11 00: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-11 00:01:35] Production.INFO: count ==1282 [2026-01-11 00:01:35] Production.ERROR: pbx CDR StartTime 2026-01-10 21:01:06 - End Time 2026-01-11 00:01:06 [2026-01-11 00:01:35] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 00:01:35] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16540942', 'tblTempUsageDetail_20' ) start [2026-01-11 00:01:35] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16540942', 'tblTempUsageDetail_20' ) end [2026-01-11 00:01:35] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16540942', 'tblTempVendorCDR_20' ) start [2026-01-11 00:01:35] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16540942', 'tblTempVendorCDR_20' ) end [2026-01-11 00:01:35] Production.INFO: ProcessCDR(1,16540942,1,1,2) [2026-01-11 00:01:35] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16540942,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 00:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16540942,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 00:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16540942,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 00:08:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16540942,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 00:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16540942', 'tblTempUsageDetail_20' ) start [2026-01-11 00:08:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16540942', 'tblTempUsageDetail_20' ) end [2026-01-11 00:08:26] Production.ERROR: pbx prc_insertCDR start [2026-01-11 00:08:27] Production.ERROR: pbx prc_insertCDR end [2026-01-11 00:08:29] Production.INFO: ==18633== Releasing lock... [2026-01-11 00:08:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 00:08:29] Production.INFO: 40.5 MB #Memory Used# [2026-01-11 01:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-10 22:01:06 [end_date_ymd] => 2026-01-11 01:01:06 [RateCDR] => 1 ) [2026-01-11 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-10 22:01:06' and `end` < '2026-01-11 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-11 01:01:18] Production.INFO: count ==729 [2026-01-11 01:01:18] Production.ERROR: pbx CDR StartTime 2026-01-10 22:01:06 - End Time 2026-01-11 01:01:06 [2026-01-11 01:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 01:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541189', 'tblTempUsageDetail_20' ) start [2026-01-11 01:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541189', 'tblTempUsageDetail_20' ) end [2026-01-11 01:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541189', 'tblTempVendorCDR_20' ) start [2026-01-11 01:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541189', 'tblTempVendorCDR_20' ) end [2026-01-11 01:01:18] Production.INFO: ProcessCDR(1,16541189,1,1,2) [2026-01-11 01:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16541189,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 01:04:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16541189,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 01:04:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16541189,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 01:08:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16541189,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 01:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541189', 'tblTempUsageDetail_20' ) start [2026-01-11 01:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541189', 'tblTempUsageDetail_20' ) end [2026-01-11 01:08:21] Production.ERROR: pbx prc_insertCDR start [2026-01-11 01:08:21] Production.ERROR: pbx prc_insertCDR end [2026-01-11 01:08:21] Production.INFO: ==23511== Releasing lock... [2026-01-11 01:08:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 01:08:21] Production.INFO: 34 MB #Memory Used# [2026-01-11 02:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-10 23:01:07 [end_date_ymd] => 2026-01-11 02:01:07 [RateCDR] => 1 ) [2026-01-11 02: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-10 23:01:07' and `end` < '2026-01-11 02: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-11 02:01:19] Production.INFO: count ==703 [2026-01-11 02:01:19] Production.ERROR: pbx CDR StartTime 2026-01-10 23:01:07 - End Time 2026-01-11 02:01:07 [2026-01-11 02:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541436', 'tblTempUsageDetail_20' ) start [2026-01-11 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541436', 'tblTempUsageDetail_20' ) end [2026-01-11 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541436', 'tblTempVendorCDR_20' ) start [2026-01-11 02:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541436', 'tblTempVendorCDR_20' ) end [2026-01-11 02:01:19] Production.INFO: ProcessCDR(1,16541436,1,1,2) [2026-01-11 02:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16541436,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 02:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16541436,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 02:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16541436,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 02:08:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16541436,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 02:08:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541436', 'tblTempUsageDetail_20' ) start [2026-01-11 02:08:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541436', 'tblTempUsageDetail_20' ) end [2026-01-11 02:08:30] Production.ERROR: pbx prc_insertCDR start [2026-01-11 02:08:30] Production.ERROR: pbx prc_insertCDR end [2026-01-11 02:08:30] Production.INFO: ==29942== Releasing lock... [2026-01-11 02:08:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 02:08:30] Production.INFO: 34 MB #Memory Used# [2026-01-11 03:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 00:01:06 [end_date_ymd] => 2026-01-11 03:01:06 [RateCDR] => 1 ) [2026-01-11 03: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-11 00:01:06' and `end` < '2026-01-11 03: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-11 03:01:18] Production.INFO: count ==618 [2026-01-11 03:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 00:01:06 - End Time 2026-01-11 03:01:06 [2026-01-11 03:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 03:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541682', 'tblTempUsageDetail_20' ) start [2026-01-11 03:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541682', 'tblTempUsageDetail_20' ) end [2026-01-11 03:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541682', 'tblTempVendorCDR_20' ) start [2026-01-11 03:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541682', 'tblTempVendorCDR_20' ) end [2026-01-11 03:01:18] Production.INFO: ProcessCDR(1,16541682,1,1,2) [2026-01-11 03:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16541682,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 03:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16541682,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 03:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16541682,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 03:08:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16541682,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 03:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541682', 'tblTempUsageDetail_20' ) start [2026-01-11 03:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541682', 'tblTempUsageDetail_20' ) end [2026-01-11 03:08:22] Production.ERROR: pbx prc_insertCDR start [2026-01-11 03:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-11 03:08:22] Production.INFO: ==3008== Releasing lock... [2026-01-11 03:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 03:08:22] Production.INFO: 32.75 MB #Memory Used# [2026-01-11 04:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 01:01:06 [end_date_ymd] => 2026-01-11 04:01:06 [RateCDR] => 1 ) [2026-01-11 04: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-11 01:01:06' and `end` < '2026-01-11 04: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-11 04:01:18] Production.INFO: count ==446 [2026-01-11 04:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 01:01:06 - End Time 2026-01-11 04:01:06 [2026-01-11 04:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541931', 'tblTempUsageDetail_20' ) start [2026-01-11 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16541931', 'tblTempUsageDetail_20' ) end [2026-01-11 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541931', 'tblTempVendorCDR_20' ) start [2026-01-11 04:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16541931', 'tblTempVendorCDR_20' ) end [2026-01-11 04:01:18] Production.INFO: ProcessCDR(1,16541931,1,1,2) [2026-01-11 04:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16541931,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 04:04:29] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16541931,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 04:04:29] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16541931,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 04:08:14] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16541931,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 04:08:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541931', 'tblTempUsageDetail_20' ) start [2026-01-11 04:08:14] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16541931', 'tblTempUsageDetail_20' ) end [2026-01-11 04:08:14] Production.ERROR: pbx prc_insertCDR start [2026-01-11 04:08:14] Production.ERROR: pbx prc_insertCDR end [2026-01-11 04:08:14] Production.INFO: ==7668== Releasing lock... [2026-01-11 04:08:14] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 04:08:14] Production.INFO: 32.5 MB #Memory Used# [2026-01-11 05:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 02:01:06 [end_date_ymd] => 2026-01-11 05:01:06 [RateCDR] => 1 ) [2026-01-11 05: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-11 02:01:06' and `end` < '2026-01-11 05: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-11 05:01:18] Production.INFO: count ==276 [2026-01-11 05:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 02:01:06 - End Time 2026-01-11 05:01:06 [2026-01-11 05:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 05:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542179', 'tblTempUsageDetail_20' ) start [2026-01-11 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542179', 'tblTempUsageDetail_20' ) end [2026-01-11 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542179', 'tblTempVendorCDR_20' ) start [2026-01-11 05:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542179', 'tblTempVendorCDR_20' ) end [2026-01-11 05:01:19] Production.INFO: ProcessCDR(1,16542179,1,1,2) [2026-01-11 05:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16542179,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 05:04:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16542179,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 05:04:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16542179,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 05:08:02] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16542179,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 05:08:02] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542179', 'tblTempUsageDetail_20' ) start [2026-01-11 05:08:02] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542179', 'tblTempUsageDetail_20' ) end [2026-01-11 05:08:02] Production.ERROR: pbx prc_insertCDR start [2026-01-11 05:08:02] Production.ERROR: pbx prc_insertCDR end [2026-01-11 05:08:02] Production.INFO: ==12475== Releasing lock... [2026-01-11 05:08:02] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 05:08:02] Production.INFO: 30.75 MB #Memory Used# [2026-01-11 06:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 03:01:06 [end_date_ymd] => 2026-01-11 06:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 03:01:06' and `end` < '2026-01-11 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-11 06:01:18] Production.INFO: count ==149 [2026-01-11 06:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 03:01:06 - End Time 2026-01-11 06:01:06 [2026-01-11 06:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542426', 'tblTempUsageDetail_20' ) start [2026-01-11 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542426', 'tblTempUsageDetail_20' ) end [2026-01-11 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542426', 'tblTempVendorCDR_20' ) start [2026-01-11 06:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542426', 'tblTempVendorCDR_20' ) end [2026-01-11 06:01:18] Production.INFO: ProcessCDR(1,16542426,1,1,2) [2026-01-11 06:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16542426,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 06:04:26] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16542426,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 06:04:26] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16542426,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 06:08:09] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16542426,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 06:08:09] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542426', 'tblTempUsageDetail_20' ) start [2026-01-11 06:08:09] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542426', 'tblTempUsageDetail_20' ) end [2026-01-11 06:08:09] Production.ERROR: pbx prc_insertCDR start [2026-01-11 06:08:09] Production.ERROR: pbx prc_insertCDR end [2026-01-11 06:08:09] Production.INFO: ==17110== Releasing lock... [2026-01-11 06:08:09] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 06:08:09] Production.INFO: 29.25 MB #Memory Used# [2026-01-11 07:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 04:01:07 [end_date_ymd] => 2026-01-11 07:01:07 [RateCDR] => 1 ) [2026-01-11 07: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-11 04:01:07' and `end` < '2026-01-11 07: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-11 07:01:18] Production.INFO: count ==91 [2026-01-11 07:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 04:01:07 - End Time 2026-01-11 07:01:07 [2026-01-11 07:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542673', 'tblTempUsageDetail_20' ) start [2026-01-11 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542673', 'tblTempUsageDetail_20' ) end [2026-01-11 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542673', 'tblTempVendorCDR_20' ) start [2026-01-11 07:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542673', 'tblTempVendorCDR_20' ) end [2026-01-11 07:01:18] Production.INFO: ProcessCDR(1,16542673,1,1,2) [2026-01-11 07:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16542673,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 07:04:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16542673,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 07:04:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16542673,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 07:08:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16542673,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 07:08:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542673', 'tblTempUsageDetail_20' ) start [2026-01-11 07:08:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542673', 'tblTempUsageDetail_20' ) end [2026-01-11 07:08:22] Production.ERROR: pbx prc_insertCDR start [2026-01-11 07:08:22] Production.ERROR: pbx prc_insertCDR end [2026-01-11 07:08:22] Production.INFO: ==22312== Releasing lock... [2026-01-11 07:08:22] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 07:08:22] Production.INFO: 28.5 MB #Memory Used# [2026-01-11 08:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 05:01:06 [end_date_ymd] => 2026-01-11 08:01:06 [RateCDR] => 1 ) [2026-01-11 08: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-11 05:01:06' and `end` < '2026-01-11 08: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-11 08:01:19] Production.INFO: count ==76 [2026-01-11 08:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 05:01:06 - End Time 2026-01-11 08:01:06 [2026-01-11 08:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542919', 'tblTempUsageDetail_20' ) start [2026-01-11 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16542919', 'tblTempUsageDetail_20' ) end [2026-01-11 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542919', 'tblTempVendorCDR_20' ) start [2026-01-11 08:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16542919', 'tblTempVendorCDR_20' ) end [2026-01-11 08:01:19] Production.INFO: ProcessCDR(1,16542919,1,1,2) [2026-01-11 08:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16542919,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 08:04:33] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16542919,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 08:04:33] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16542919,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 08:08:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16542919,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 08:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542919', 'tblTempUsageDetail_20' ) start [2026-01-11 08:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16542919', 'tblTempUsageDetail_20' ) end [2026-01-11 08:08:18] Production.ERROR: pbx prc_insertCDR start [2026-01-11 08:08:18] Production.ERROR: pbx prc_insertCDR end [2026-01-11 08:08:18] Production.INFO: ==29021== Releasing lock... [2026-01-11 08:08:18] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 08:08:18] Production.INFO: 28.25 MB #Memory Used# [2026-01-11 09:01:05] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 06:01:05 [end_date_ymd] => 2026-01-11 09:01:05 [RateCDR] => 1 ) [2026-01-11 09: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-11 06:01:05' and `end` < '2026-01-11 09: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-11 09:01:17] Production.INFO: count ==79 [2026-01-11 09:01:17] Production.ERROR: pbx CDR StartTime 2026-01-11 06:01:05 - End Time 2026-01-11 09:01:05 [2026-01-11 09:01:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 09:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543167', 'tblTempUsageDetail_20' ) start [2026-01-11 09:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543167', 'tblTempUsageDetail_20' ) end [2026-01-11 09:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543167', 'tblTempVendorCDR_20' ) start [2026-01-11 09:01:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543167', 'tblTempVendorCDR_20' ) end [2026-01-11 09:01:17] Production.INFO: ProcessCDR(1,16543167,1,1,2) [2026-01-11 09:01:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16543167,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 09:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16543167,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 09:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16543167,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 09:08:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16543167,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 09:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543167', 'tblTempUsageDetail_20' ) start [2026-01-11 09:08:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543167', 'tblTempUsageDetail_20' ) end [2026-01-11 09:08:19] Production.ERROR: pbx prc_insertCDR start [2026-01-11 09:08:19] Production.ERROR: pbx prc_insertCDR end [2026-01-11 09:08:19] Production.INFO: ==1485== Releasing lock... [2026-01-11 09:08:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 09:08:19] Production.INFO: 28.25 MB #Memory Used# [2026-01-11 10:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 07:01:06 [end_date_ymd] => 2026-01-11 10:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 07:01:06' and `end` < '2026-01-11 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-11 10:01:18] Production.INFO: count ==149 [2026-01-11 10:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 07:01:06 - End Time 2026-01-11 10:01:06 [2026-01-11 10:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 10:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543414', 'tblTempUsageDetail_20' ) start [2026-01-11 10:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543414', 'tblTempUsageDetail_20' ) end [2026-01-11 10:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543414', 'tblTempVendorCDR_20' ) start [2026-01-11 10:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543414', 'tblTempVendorCDR_20' ) end [2026-01-11 10:01:18] Production.INFO: ProcessCDR(1,16543414,1,1,2) [2026-01-11 10:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16543414,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 10:04:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16543414,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 10:04:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16543414,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 10:08:13] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16543414,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 10:08:13] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543414', 'tblTempUsageDetail_20' ) start [2026-01-11 10:08:13] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543414', 'tblTempUsageDetail_20' ) end [2026-01-11 10:08:13] Production.ERROR: pbx prc_insertCDR start [2026-01-11 10:08:13] Production.ERROR: pbx prc_insertCDR end [2026-01-11 10:08:13] Production.INFO: ==6518== Releasing lock... [2026-01-11 10:08:13] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 10:08:13] Production.INFO: 29.5 MB #Memory Used# [2026-01-11 11:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 08:01:06 [end_date_ymd] => 2026-01-11 11:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 08:01:06' and `end` < '2026-01-11 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-11 11:01:18] Production.INFO: count ==317 [2026-01-11 11:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 08:01:06 - End Time 2026-01-11 11:01:06 [2026-01-11 11:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 11:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543661', 'tblTempUsageDetail_20' ) start [2026-01-11 11:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543661', 'tblTempUsageDetail_20' ) end [2026-01-11 11:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543661', 'tblTempVendorCDR_20' ) start [2026-01-11 11:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543661', 'tblTempVendorCDR_20' ) end [2026-01-11 11:01:18] Production.INFO: ProcessCDR(1,16543661,1,1,2) [2026-01-11 11:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16543661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 11:04:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16543661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 11:04:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16543661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 11:08:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16543661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 11:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543661', 'tblTempUsageDetail_20' ) start [2026-01-11 11:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543661', 'tblTempUsageDetail_20' ) end [2026-01-11 11:08:25] Production.ERROR: pbx prc_insertCDR start [2026-01-11 11:08:25] Production.ERROR: pbx prc_insertCDR end [2026-01-11 11:08:26] Production.INFO: ==11310== Releasing lock... [2026-01-11 11:08:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 11:08:26] Production.INFO: 30.5 MB #Memory Used# [2026-01-11 12:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 09:01:06 [end_date_ymd] => 2026-01-11 12:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 09:01:06' and `end` < '2026-01-11 12: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-11 12:01:18] Production.INFO: count ==601 [2026-01-11 12:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 09:01:06 - End Time 2026-01-11 12:01:06 [2026-01-11 12:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 12:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543907', 'tblTempUsageDetail_20' ) start [2026-01-11 12:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16543907', 'tblTempUsageDetail_20' ) end [2026-01-11 12:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543907', 'tblTempVendorCDR_20' ) start [2026-01-11 12:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16543907', 'tblTempVendorCDR_20' ) end [2026-01-11 12:01:19] Production.INFO: ProcessCDR(1,16543907,1,1,2) [2026-01-11 12:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16543907,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 12:04:31] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16543907,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 12:04:31] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16543907,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 12:08:16] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16543907,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 12:08:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543907', 'tblTempUsageDetail_20' ) start [2026-01-11 12:08:16] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16543907', 'tblTempUsageDetail_20' ) end [2026-01-11 12:08:16] Production.ERROR: pbx prc_insertCDR start [2026-01-11 12:08:16] Production.ERROR: pbx prc_insertCDR end [2026-01-11 12:08:16] Production.INFO: ==15903== Releasing lock... [2026-01-11 12:08:16] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 12:08:16] Production.INFO: 33 MB #Memory Used# [2026-01-11 13:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 10:01:07 [end_date_ymd] => 2026-01-11 13:01:07 [RateCDR] => 1 ) [2026-01-11 13: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-11 10:01:07' and `end` < '2026-01-11 13: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-11 13:01:19] Production.INFO: count ==873 [2026-01-11 13:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 10:01:07 - End Time 2026-01-11 13:01:07 [2026-01-11 13:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 13:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544155', 'tblTempUsageDetail_20' ) start [2026-01-11 13:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544155', 'tblTempUsageDetail_20' ) end [2026-01-11 13:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544155', 'tblTempVendorCDR_20' ) start [2026-01-11 13:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544155', 'tblTempVendorCDR_20' ) end [2026-01-11 13:01:19] Production.INFO: ProcessCDR(1,16544155,1,1,2) [2026-01-11 13:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16544155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 13:04:37] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16544155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 13:04:37] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16544155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 13:08:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16544155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 13:08:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544155', 'tblTempUsageDetail_20' ) start [2026-01-11 13:08:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544155', 'tblTempUsageDetail_20' ) end [2026-01-11 13:08:30] Production.ERROR: pbx prc_insertCDR start [2026-01-11 13:08:30] Production.ERROR: pbx prc_insertCDR end [2026-01-11 13:08:30] Production.INFO: ==20593== Releasing lock... [2026-01-11 13:08:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 13:08:30] Production.INFO: 35.5 MB #Memory Used# [2026-01-11 14:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 11:01:06 [end_date_ymd] => 2026-01-11 14:01:06 [RateCDR] => 1 ) [2026-01-11 14: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-11 11:01:06' and `end` < '2026-01-11 14: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-11 14:01:18] Production.INFO: count ==1025 [2026-01-11 14:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 11:01:06 - End Time 2026-01-11 14:01:06 [2026-01-11 14:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 14:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544402', 'tblTempUsageDetail_20' ) start [2026-01-11 14:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544402', 'tblTempUsageDetail_20' ) end [2026-01-11 14:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544402', 'tblTempVendorCDR_20' ) start [2026-01-11 14:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544402', 'tblTempVendorCDR_20' ) end [2026-01-11 14:01:19] Production.INFO: ProcessCDR(1,16544402,1,1,2) [2026-01-11 14:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16544402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 14:05:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16544402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 14:05:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16544402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 14:08:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16544402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 14:08:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544402', 'tblTempUsageDetail_20' ) start [2026-01-11 14:08:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544402', 'tblTempUsageDetail_20' ) end [2026-01-11 14:08:54] Production.ERROR: pbx prc_insertCDR start [2026-01-11 14:08:55] Production.ERROR: pbx prc_insertCDR end [2026-01-11 14:08:55] Production.INFO: ==25379== Releasing lock... [2026-01-11 14:08:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 14:08:55] Production.INFO: 36.25 MB #Memory Used# [2026-01-11 15:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 12:01:06 [end_date_ymd] => 2026-01-11 15:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 12:01:06' and `end` < '2026-01-11 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-11 15:01:19] Production.INFO: count ==1078 [2026-01-11 15:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 12:01:06 - End Time 2026-01-11 15:01:06 [2026-01-11 15:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 15:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544649', 'tblTempUsageDetail_20' ) start [2026-01-11 15:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544649', 'tblTempUsageDetail_20' ) end [2026-01-11 15:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544649', 'tblTempVendorCDR_20' ) start [2026-01-11 15:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544649', 'tblTempVendorCDR_20' ) end [2026-01-11 15:01:19] Production.INFO: ProcessCDR(1,16544649,1,1,2) [2026-01-11 15:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16544649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 15:04:25] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16544649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 15:04:25] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16544649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 15:08:18] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16544649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 15:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544649', 'tblTempUsageDetail_20' ) start [2026-01-11 15:08:18] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544649', 'tblTempUsageDetail_20' ) end [2026-01-11 15:08:18] Production.ERROR: pbx prc_insertCDR start [2026-01-11 15:08:19] Production.ERROR: pbx prc_insertCDR end [2026-01-11 15:08:19] Production.INFO: ==30277== Releasing lock... [2026-01-11 15:08:19] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 15:08:19] Production.INFO: 36.25 MB #Memory Used# [2026-01-11 16:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 13:01:06 [end_date_ymd] => 2026-01-11 16:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 13:01:06' and `end` < '2026-01-11 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-11 16:01:18] Production.INFO: count ==1118 [2026-01-11 16:01:18] Production.ERROR: pbx CDR StartTime 2026-01-11 13:01:06 - End Time 2026-01-11 16:01:06 [2026-01-11 16:01:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 16:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544896', 'tblTempUsageDetail_20' ) start [2026-01-11 16:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16544896', 'tblTempUsageDetail_20' ) end [2026-01-11 16:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544896', 'tblTempVendorCDR_20' ) start [2026-01-11 16:01:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16544896', 'tblTempVendorCDR_20' ) end [2026-01-11 16:01:18] Production.INFO: ProcessCDR(1,16544896,1,1,2) [2026-01-11 16:01:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16544896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 16:04:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16544896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 16:04:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16544896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 16:08:11] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16544896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 16:08:11] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544896', 'tblTempUsageDetail_20' ) start [2026-01-11 16:08:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16544896', 'tblTempUsageDetail_20' ) end [2026-01-11 16:08:12] Production.ERROR: pbx prc_insertCDR start [2026-01-11 16:08:13] Production.ERROR: pbx prc_insertCDR end [2026-01-11 16:08:13] Production.INFO: ==2969== Releasing lock... [2026-01-11 16:08:13] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 16:08:13] Production.INFO: 36.75 MB #Memory Used# [2026-01-11 17:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 14:01:07 [end_date_ymd] => 2026-01-11 17:01:07 [RateCDR] => 1 ) [2026-01-11 17: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-11 14:01:07' and `end` < '2026-01-11 17: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-11 17:01:19] Production.INFO: count ==1283 [2026-01-11 17:01:20] Production.ERROR: pbx CDR StartTime 2026-01-11 14:01:07 - End Time 2026-01-11 17:01:07 [2026-01-11 17:01:20] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 17:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545143', 'tblTempUsageDetail_20' ) start [2026-01-11 17:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545143', 'tblTempUsageDetail_20' ) end [2026-01-11 17:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545143', 'tblTempVendorCDR_20' ) start [2026-01-11 17:01:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545143', 'tblTempVendorCDR_20' ) end [2026-01-11 17:01:20] Production.INFO: ProcessCDR(1,16545143,1,1,2) [2026-01-11 17:01:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16545143,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 17:04:44] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16545143,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 17:04:44] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16545143,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 17:08:52] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16545143,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 17:08:52] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545143', 'tblTempUsageDetail_20' ) start [2026-01-11 17:08:53] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545143', 'tblTempUsageDetail_20' ) end [2026-01-11 17:08:53] Production.ERROR: pbx prc_insertCDR start [2026-01-11 17:08:54] Production.ERROR: pbx prc_insertCDR end [2026-01-11 17:08:54] Production.INFO: ==8376== Releasing lock... [2026-01-11 17:08:54] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 17:08:54] Production.INFO: 38 MB #Memory Used# [2026-01-11 18:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 15:01:06 [end_date_ymd] => 2026-01-11 18:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 15:01:06' and `end` < '2026-01-11 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-11 18:01:18] Production.INFO: count ==1479 [2026-01-11 18:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 15:01:06 - End Time 2026-01-11 18:01:06 [2026-01-11 18:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 18:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545387', 'tblTempUsageDetail_20' ) start [2026-01-11 18:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545387', 'tblTempUsageDetail_20' ) end [2026-01-11 18:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545387', 'tblTempVendorCDR_20' ) start [2026-01-11 18:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545387', 'tblTempVendorCDR_20' ) end [2026-01-11 18:01:19] Production.INFO: ProcessCDR(1,16545387,1,1,2) [2026-01-11 18:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16545387,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 18:04:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16545387,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 18:04:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16545387,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 18:08:46] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16545387,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 18:08:46] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545387', 'tblTempUsageDetail_20' ) start [2026-01-11 18:08:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545387', 'tblTempUsageDetail_20' ) end [2026-01-11 18:08:47] Production.ERROR: pbx prc_insertCDR start [2026-01-11 18:08:49] Production.ERROR: pbx prc_insertCDR end [2026-01-11 18:08:49] Production.INFO: ==14071== Releasing lock... [2026-01-11 18:08:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 18:08:49] Production.INFO: 39.25 MB #Memory Used# [2026-01-11 19:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 16:01:06 [end_date_ymd] => 2026-01-11 19:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 16:01:06' and `end` < '2026-01-11 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-11 19:01:18] Production.INFO: count ==1626 [2026-01-11 19:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 16:01:06 - End Time 2026-01-11 19:01:06 [2026-01-11 19:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 19:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545634', 'tblTempUsageDetail_20' ) start [2026-01-11 19:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545634', 'tblTempUsageDetail_20' ) end [2026-01-11 19:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545634', 'tblTempVendorCDR_20' ) start [2026-01-11 19:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545634', 'tblTempVendorCDR_20' ) end [2026-01-11 19:01:19] Production.INFO: ProcessCDR(1,16545634,1,1,2) [2026-01-11 19:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16545634,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 19:04:32] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16545634,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 19:04:32] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16545634,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 19:08:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16545634,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 19:08:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545634', 'tblTempUsageDetail_20' ) start [2026-01-11 19:08:24] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545634', 'tblTempUsageDetail_20' ) end [2026-01-11 19:08:24] Production.ERROR: pbx prc_insertCDR start [2026-01-11 19:08:25] Production.ERROR: pbx prc_insertCDR end [2026-01-11 19:08:25] Production.INFO: ==19494== Releasing lock... [2026-01-11 19:08:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 19:08:25] Production.INFO: 40.25 MB #Memory Used# [2026-01-11 20:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 17:01:06 [end_date_ymd] => 2026-01-11 20:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 17:01:06' and `end` < '2026-01-11 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-11 20:01:19] Production.INFO: count ==1592 [2026-01-11 20:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 17:01:06 - End Time 2026-01-11 20:01:06 [2026-01-11 20:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 20:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545881', 'tblTempUsageDetail_20' ) start [2026-01-11 20:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16545881', 'tblTempUsageDetail_20' ) end [2026-01-11 20:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545881', 'tblTempVendorCDR_20' ) start [2026-01-11 20:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16545881', 'tblTempVendorCDR_20' ) end [2026-01-11 20:01:19] Production.INFO: ProcessCDR(1,16545881,1,1,2) [2026-01-11 20:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16545881,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 20:04:43] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16545881,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 20:04:43] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16545881,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 20:08:42] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16545881,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 20:08:42] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545881', 'tblTempUsageDetail_20' ) start [2026-01-11 20:08:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16545881', 'tblTempUsageDetail_20' ) end [2026-01-11 20:08:43] Production.ERROR: pbx prc_insertCDR start [2026-01-11 20:08:43] Production.ERROR: pbx prc_insertCDR end [2026-01-11 20:08:43] Production.INFO: ==25456== Releasing lock... [2026-01-11 20:08:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 20:08:43] Production.INFO: 40 MB #Memory Used# [2026-01-11 21:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 18:01:06 [end_date_ymd] => 2026-01-11 21:01:06 [RateCDR] => 1 ) [2026-01-11 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-11 18:01:06' and `end` < '2026-01-11 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-11 21:01:18] Production.INFO: count ==1378 [2026-01-11 21:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 18:01:06 - End Time 2026-01-11 21:01:06 [2026-01-11 21:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546128', 'tblTempUsageDetail_20' ) start [2026-01-11 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546128', 'tblTempUsageDetail_20' ) end [2026-01-11 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546128', 'tblTempVendorCDR_20' ) start [2026-01-11 21:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546128', 'tblTempVendorCDR_20' ) end [2026-01-11 21:01:19] Production.INFO: ProcessCDR(1,16546128,1,1,2) [2026-01-11 21:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16546128,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 21:04:36] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16546128,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 21:04:36] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16546128,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 21:08:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16546128,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 21:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546128', 'tblTempUsageDetail_20' ) start [2026-01-11 21:08:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546128', 'tblTempUsageDetail_20' ) end [2026-01-11 21:08:25] Production.ERROR: pbx prc_insertCDR start [2026-01-11 21:08:25] Production.ERROR: pbx prc_insertCDR end [2026-01-11 21:08:25] Production.INFO: ==31837== Releasing lock... [2026-01-11 21:08:25] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 21:08:25] Production.INFO: 38.5 MB #Memory Used# [2026-01-11 22:01:06] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 19:01:06 [end_date_ymd] => 2026-01-11 22:01:06 [RateCDR] => 1 ) [2026-01-11 22: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-11 19:01:06' and `end` < '2026-01-11 22: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-11 22:01:18] Production.INFO: count ==1108 [2026-01-11 22:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 19:01:06 - End Time 2026-01-11 22:01:06 [2026-01-11 22:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 22:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546375', 'tblTempUsageDetail_20' ) start [2026-01-11 22:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546375', 'tblTempUsageDetail_20' ) end [2026-01-11 22:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546375', 'tblTempVendorCDR_20' ) start [2026-01-11 22:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546375', 'tblTempVendorCDR_20' ) end [2026-01-11 22:01:19] Production.INFO: ProcessCDR(1,16546375,1,1,2) [2026-01-11 22:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16546375,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 22:04:38] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16546375,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 22:04:38] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16546375,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 22:08:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16546375,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 22:08:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546375', 'tblTempUsageDetail_20' ) start [2026-01-11 22:08:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546375', 'tblTempUsageDetail_20' ) end [2026-01-11 22:08:29] Production.ERROR: pbx prc_insertCDR start [2026-01-11 22:08:29] Production.ERROR: pbx prc_insertCDR end [2026-01-11 22:08:29] Production.INFO: ==5445== Releasing lock... [2026-01-11 22:08:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 22:08:29] Production.INFO: 36.5 MB #Memory Used# [2026-01-11 23:01:07] Production.ERROR: Array ( [start_date_ymd] => 2026-01-11 20:01:07 [end_date_ymd] => 2026-01-11 23:01:07 [RateCDR] => 1 ) [2026-01-11 23: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-11 20:01:07' and `end` < '2026-01-11 23: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-11 23:01:19] Production.INFO: count ==893 [2026-01-11 23:01:19] Production.ERROR: pbx CDR StartTime 2026-01-11 20:01:07 - End Time 2026-01-11 23:01:07 [2026-01-11 23:01:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-01-11 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546622', 'tblTempUsageDetail_20' ) start [2026-01-11 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16546622', 'tblTempUsageDetail_20' ) end [2026-01-11 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546622', 'tblTempVendorCDR_20' ) start [2026-01-11 23:01:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16546622', 'tblTempVendorCDR_20' ) end [2026-01-11 23:01:19] Production.INFO: ProcessCDR(1,16546622,1,1,2) [2026-01-11 23:01:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16546622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 23:04:35] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16546622,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-01-11 23:04:35] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16546622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 23:08:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16546622,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-01-11 23:08:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546622', 'tblTempUsageDetail_20' ) start [2026-01-11 23:08:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16546622', 'tblTempUsageDetail_20' ) end [2026-01-11 23:08:38] Production.ERROR: pbx prc_insertCDR start [2026-01-11 23:08:38] Production.ERROR: pbx prc_insertCDR end [2026-01-11 23:08:38] Production.INFO: ==12356== Releasing lock... [2026-01-11 23:08:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-01-11 23:08:38] Production.INFO: 35.5 MB #Memory Used#