[2026-03-28 00:02:04] Production.INFO: next invoice date [2026-03-28 00:02:04] Production.INFO: 2026-04-28 [2026-03-28 00:02:04] Production.INFO: getdaysdiff [2026-03-28 00:02:04] Production.INFO: +31 [2026-03-28 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (103,10,2,31,31,'RMScheduler',2026-03-28 00:02:04,1,0,,,0) [2026-03-28 00:02:04] Production.INFO: next invoice date [2026-03-28 00:02:04] Production.INFO: 2026-04-28 [2026-03-28 00:02:04] Production.INFO: getdaysdiff [2026-03-28 00:02:04] Production.INFO: +31 [2026-03-28 00:02:04] Production.INFO: call prc_setAccountDiscountPlan (103,16,1,31,31,'RMScheduler',2026-03-28 00:02:04,1,0,,,0) [2026-03-28 00:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 21:02:05 [end_date_ymd] => 2026-03-28 00:02:05 [RateCDR] => 1 ) [2026-03-28 00:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 21:02:05' and `end` < '2026-03-28 00:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 00:02:35] Production.INFO: count ==1128 [2026-03-28 00:02:36] Production.ERROR: pbx CDR StartTime 2026-03-27 21:02:05 - End Time 2026-03-28 00:02:05 [2026-03-28 00:02:36] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991227', 'tblTempUsageDetail_20' ) start [2026-03-28 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991227', 'tblTempUsageDetail_20' ) end [2026-03-28 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991227', 'tblTempVendorCDR_20' ) start [2026-03-28 00:02:36] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991227', 'tblTempVendorCDR_20' ) end [2026-03-28 00:02:36] Production.INFO: ProcessCDR(1,16991227,1,1,2) [2026-03-28 00:02:36] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16991227,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 00:06:30] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16991227,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 00:06:30] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16991227,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 00:11:03] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16991227,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 00:11:03] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991227', 'tblTempUsageDetail_20' ) start [2026-03-28 00:11:05] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991227', 'tblTempUsageDetail_20' ) end [2026-03-28 00:11:05] Production.ERROR: pbx prc_insertCDR start [2026-03-28 00:11:05] Production.ERROR: pbx prc_insertCDR end [2026-03-28 00:11:08] Production.INFO: ==12798== Releasing lock... [2026-03-28 00:11:08] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 00:11:08] Production.INFO: 39 MB #Memory Used# [2026-03-28 01:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 22:02:05 [end_date_ymd] => 2026-03-28 01:02:05 [RateCDR] => 1 ) [2026-03-28 01:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 22:02:05' and `end` < '2026-03-28 01:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 01:02:16] Production.INFO: count ==1106 [2026-03-28 01:02:17] Production.ERROR: pbx CDR StartTime 2026-03-27 22:02:05 - End Time 2026-03-28 01:02:05 [2026-03-28 01:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991474', 'tblTempUsageDetail_20' ) start [2026-03-28 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991474', 'tblTempUsageDetail_20' ) end [2026-03-28 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991474', 'tblTempVendorCDR_20' ) start [2026-03-28 01:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991474', 'tblTempVendorCDR_20' ) end [2026-03-28 01:02:17] Production.INFO: ProcessCDR(1,16991474,1,1,2) [2026-03-28 01:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16991474,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 01:06:12] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16991474,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 01:06:12] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16991474,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 01:10:57] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16991474,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 01:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991474', 'tblTempUsageDetail_20' ) start [2026-03-28 01:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991474', 'tblTempUsageDetail_20' ) end [2026-03-28 01:10:57] Production.ERROR: pbx prc_insertCDR start [2026-03-28 01:10:58] Production.ERROR: pbx prc_insertCDR end [2026-03-28 01:10:58] Production.INFO: ==17295== Releasing lock... [2026-03-28 01:10:58] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 01:10:58] Production.INFO: 38 MB #Memory Used# [2026-03-28 02:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-27 23:02:06 [end_date_ymd] => 2026-03-28 02:02:06 [RateCDR] => 1 ) [2026-03-28 02:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-27 23:02:06' and `end` < '2026-03-28 02:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 02:02:17] Production.INFO: count ==1030 [2026-03-28 02:02:18] Production.ERROR: pbx CDR StartTime 2026-03-27 23:02:06 - End Time 2026-03-28 02:02:06 [2026-03-28 02:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991721', 'tblTempUsageDetail_20' ) start [2026-03-28 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991721', 'tblTempUsageDetail_20' ) end [2026-03-28 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991721', 'tblTempVendorCDR_20' ) start [2026-03-28 02:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991721', 'tblTempVendorCDR_20' ) end [2026-03-28 02:02:18] Production.INFO: ProcessCDR(1,16991721,1,1,2) [2026-03-28 02:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16991721,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 02:06:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16991721,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 02:06:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16991721,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 02:10:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16991721,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 02:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991721', 'tblTempUsageDetail_20' ) start [2026-03-28 02:10:55] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991721', 'tblTempUsageDetail_20' ) end [2026-03-28 02:10:55] Production.ERROR: pbx prc_insertCDR start [2026-03-28 02:10:55] Production.ERROR: pbx prc_insertCDR end [2026-03-28 02:10:55] Production.INFO: ==21975== Releasing lock... [2026-03-28 02:10:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 02:10:55] Production.INFO: 37.25 MB #Memory Used# [2026-03-28 03:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 00:02:06 [end_date_ymd] => 2026-03-28 03:02:06 [RateCDR] => 1 ) [2026-03-28 03:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 00:02:06' and `end` < '2026-03-28 03:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 03:02:17] Production.INFO: count ==1095 [2026-03-28 03:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 00:02:06 - End Time 2026-03-28 03:02:06 [2026-03-28 03:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 03:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991968', 'tblTempUsageDetail_20' ) start [2026-03-28 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16991968', 'tblTempUsageDetail_20' ) end [2026-03-28 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991968', 'tblTempVendorCDR_20' ) start [2026-03-28 03:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16991968', 'tblTempVendorCDR_20' ) end [2026-03-28 03:02:18] Production.INFO: ProcessCDR(1,16991968,1,1,2) [2026-03-28 03:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16991968,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 03:06:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16991968,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 03:06:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16991968,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 03:11:12] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16991968,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 03:11:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991968', 'tblTempUsageDetail_20' ) start [2026-03-28 03:11:12] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16991968', 'tblTempUsageDetail_20' ) end [2026-03-28 03:11:12] Production.ERROR: pbx prc_insertCDR start [2026-03-28 03:11:12] Production.ERROR: pbx prc_insertCDR end [2026-03-28 03:11:12] Production.INFO: ==27406== Releasing lock... [2026-03-28 03:11:12] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 03:11:12] Production.INFO: 36.75 MB #Memory Used# [2026-03-28 04:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 01:02:05 [end_date_ymd] => 2026-03-28 04:02:05 [RateCDR] => 1 ) [2026-03-28 04:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 01:02:05' and `end` < '2026-03-28 04:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 04:02:16] Production.INFO: count ==871 [2026-03-28 04:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 01:02:05 - End Time 2026-03-28 04:02:05 [2026-03-28 04:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992216', 'tblTempUsageDetail_20' ) start [2026-03-28 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992216', 'tblTempUsageDetail_20' ) end [2026-03-28 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992216', 'tblTempVendorCDR_20' ) start [2026-03-28 04:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992216', 'tblTempVendorCDR_20' ) end [2026-03-28 04:02:17] Production.INFO: ProcessCDR(1,16992216,1,1,2) [2026-03-28 04:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16992216,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 04:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16992216,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 04:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16992216,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 04:10:43] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16992216,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 04:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992216', 'tblTempUsageDetail_20' ) start [2026-03-28 04:10:43] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992216', 'tblTempUsageDetail_20' ) end [2026-03-28 04:10:43] Production.ERROR: pbx prc_insertCDR start [2026-03-28 04:10:43] Production.ERROR: pbx prc_insertCDR end [2026-03-28 04:10:43] Production.INFO: ==32164== Releasing lock... [2026-03-28 04:10:43] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 04:10:43] Production.INFO: 35.5 MB #Memory Used# [2026-03-28 05:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 02:02:05 [end_date_ymd] => 2026-03-28 05:02:05 [RateCDR] => 1 ) [2026-03-28 05:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 02:02:05' and `end` < '2026-03-28 05:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 05:02:17] Production.INFO: count ==664 [2026-03-28 05:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 02:02:05 - End Time 2026-03-28 05:02:05 [2026-03-28 05:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992464', 'tblTempUsageDetail_20' ) start [2026-03-28 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992464', 'tblTempUsageDetail_20' ) end [2026-03-28 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992464', 'tblTempVendorCDR_20' ) start [2026-03-28 05:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992464', 'tblTempVendorCDR_20' ) end [2026-03-28 05:02:17] Production.INFO: ProcessCDR(1,16992464,1,1,2) [2026-03-28 05:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16992464,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 05:06:06] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16992464,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 05:06:06] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16992464,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 05:10:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16992464,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 05:10:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992464', 'tblTempUsageDetail_20' ) start [2026-03-28 05:10:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992464', 'tblTempUsageDetail_20' ) end [2026-03-28 05:10:47] Production.ERROR: pbx prc_insertCDR start [2026-03-28 05:10:47] Production.ERROR: pbx prc_insertCDR end [2026-03-28 05:10:47] Production.INFO: ==4769== Releasing lock... [2026-03-28 05:10:47] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 05:10:47] Production.INFO: 33.75 MB #Memory Used# [2026-03-28 06:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 03:02:05 [end_date_ymd] => 2026-03-28 06:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 03:02:05' and `end` < '2026-03-28 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-03-28 06:02:16] Production.INFO: count ==385 [2026-03-28 06:02:16] Production.ERROR: pbx CDR StartTime 2026-03-28 03:02:05 - End Time 2026-03-28 06:02:05 [2026-03-28 06:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992711', 'tblTempUsageDetail_20' ) start [2026-03-28 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992711', 'tblTempUsageDetail_20' ) end [2026-03-28 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992711', 'tblTempVendorCDR_20' ) start [2026-03-28 06:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992711', 'tblTempVendorCDR_20' ) end [2026-03-28 06:02:16] Production.INFO: ProcessCDR(1,16992711,1,1,2) [2026-03-28 06:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16992711,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 06:05:15] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16992711,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 06:05:15] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16992711,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 06:09:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16992711,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 06:09:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992711', 'tblTempUsageDetail_20' ) start [2026-03-28 06:09:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992711', 'tblTempUsageDetail_20' ) end [2026-03-28 06:09:54] Production.ERROR: pbx prc_insertCDR start [2026-03-28 06:09:54] Production.ERROR: pbx prc_insertCDR end [2026-03-28 06:09:54] Production.INFO: ==9393== Releasing lock... [2026-03-28 06:09:54] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 06:09:54] Production.INFO: 31.75 MB #Memory Used# [2026-03-28 07:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 04:02:06 [end_date_ymd] => 2026-03-28 07:02:06 [RateCDR] => 1 ) [2026-03-28 07:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 04:02:06' and `end` < '2026-03-28 07:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 07:02:17] Production.INFO: count ==167 [2026-03-28 07:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 04:02:06 - End Time 2026-03-28 07:02:06 [2026-03-28 07:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992958', 'tblTempUsageDetail_20' ) start [2026-03-28 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16992958', 'tblTempUsageDetail_20' ) end [2026-03-28 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992958', 'tblTempVendorCDR_20' ) start [2026-03-28 07:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16992958', 'tblTempVendorCDR_20' ) end [2026-03-28 07:02:17] Production.INFO: ProcessCDR(1,16992958,1,1,2) [2026-03-28 07:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16992958,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 07:06:10] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16992958,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 07:06:10] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16992958,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 07:10:49] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16992958,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 07:10:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992958', 'tblTempUsageDetail_20' ) start [2026-03-28 07:10:49] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16992958', 'tblTempUsageDetail_20' ) end [2026-03-28 07:10:49] Production.ERROR: pbx prc_insertCDR start [2026-03-28 07:10:49] Production.ERROR: pbx prc_insertCDR end [2026-03-28 07:10:49] Production.INFO: ==13881== Releasing lock... [2026-03-28 07:10:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 07:10:49] Production.INFO: 30 MB #Memory Used# [2026-03-28 08:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 05:02:05 [end_date_ymd] => 2026-03-28 08:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 05:02:05' and `end` < '2026-03-28 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-03-28 08:02:16] Production.INFO: count ==100 [2026-03-28 08:02:16] Production.ERROR: pbx CDR StartTime 2026-03-28 05:02:05 - End Time 2026-03-28 08:02:05 [2026-03-28 08:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993205', 'tblTempUsageDetail_20' ) start [2026-03-28 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993205', 'tblTempUsageDetail_20' ) end [2026-03-28 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993205', 'tblTempVendorCDR_20' ) start [2026-03-28 08:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993205', 'tblTempVendorCDR_20' ) end [2026-03-28 08:02:16] Production.INFO: ProcessCDR(1,16993205,1,1,2) [2026-03-28 08:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16993205,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 08:05:59] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16993205,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 08:05:59] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16993205,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 08:10:35] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16993205,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 08:10:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993205', 'tblTempUsageDetail_20' ) start [2026-03-28 08:10:35] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993205', 'tblTempUsageDetail_20' ) end [2026-03-28 08:10:35] Production.ERROR: pbx prc_insertCDR start [2026-03-28 08:10:35] Production.ERROR: pbx prc_insertCDR end [2026-03-28 08:10:35] Production.INFO: ==18216== Releasing lock... [2026-03-28 08:10:35] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 08:10:35] Production.INFO: 28.75 MB #Memory Used# [2026-03-28 09:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 06:02:05 [end_date_ymd] => 2026-03-28 09:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 06:02:05' and `end` < '2026-03-28 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-03-28 09:02:16] Production.INFO: count ==180 [2026-03-28 09:02:16] Production.ERROR: pbx CDR StartTime 2026-03-28 06:02:05 - End Time 2026-03-28 09:02:05 [2026-03-28 09:02:16] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993452', 'tblTempUsageDetail_20' ) start [2026-03-28 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993452', 'tblTempUsageDetail_20' ) end [2026-03-28 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993452', 'tblTempVendorCDR_20' ) start [2026-03-28 09:02:16] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993452', 'tblTempVendorCDR_20' ) end [2026-03-28 09:02:16] Production.INFO: ProcessCDR(1,16993452,1,1,2) [2026-03-28 09:02:16] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16993452,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 09:06:04] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16993452,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 09:06:04] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16993452,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 09:10:40] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16993452,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 09:10:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993452', 'tblTempUsageDetail_20' ) start [2026-03-28 09:10:40] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993452', 'tblTempUsageDetail_20' ) end [2026-03-28 09:10:40] Production.ERROR: pbx prc_insertCDR start [2026-03-28 09:10:40] Production.ERROR: pbx prc_insertCDR end [2026-03-28 09:10:40] Production.INFO: ==22749== Releasing lock... [2026-03-28 09:10:40] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 09:10:40] Production.INFO: 29.25 MB #Memory Used# [2026-03-28 10:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 07:02:05 [end_date_ymd] => 2026-03-28 10:02:05 [RateCDR] => 1 ) [2026-03-28 10:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 07:02:05' and `end` < '2026-03-28 10:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 10:02:16] Production.INFO: count ==619 [2026-03-28 10:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 07:02:05 - End Time 2026-03-28 10:02:05 [2026-03-28 10:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993699', 'tblTempUsageDetail_20' ) start [2026-03-28 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993699', 'tblTempUsageDetail_20' ) end [2026-03-28 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993699', 'tblTempVendorCDR_20' ) start [2026-03-28 10:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993699', 'tblTempVendorCDR_20' ) end [2026-03-28 10:02:17] Production.INFO: ProcessCDR(1,16993699,1,1,2) [2026-03-28 10:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16993699,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 10:06:07] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16993699,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 10:06:07] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16993699,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 10:10:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16993699,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 10:10:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993699', 'tblTempUsageDetail_20' ) start [2026-03-28 10:10:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993699', 'tblTempUsageDetail_20' ) end [2026-03-28 10:10:50] Production.ERROR: pbx prc_insertCDR start [2026-03-28 10:10:51] Production.ERROR: pbx prc_insertCDR end [2026-03-28 10:10:51] Production.INFO: ==27440== Releasing lock... [2026-03-28 10:10:51] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 10:10:51] Production.INFO: 33.75 MB #Memory Used# [2026-03-28 11:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 08:02:05 [end_date_ymd] => 2026-03-28 11:02:05 [RateCDR] => 1 ) [2026-03-28 11:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 08:02:05' and `end` < '2026-03-28 11:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 11:02:17] Production.INFO: count ==1055 [2026-03-28 11:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 08:02:05 - End Time 2026-03-28 11:02:05 [2026-03-28 11:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993946', 'tblTempUsageDetail_20' ) start [2026-03-28 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16993946', 'tblTempUsageDetail_20' ) end [2026-03-28 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993946', 'tblTempVendorCDR_20' ) start [2026-03-28 11:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16993946', 'tblTempVendorCDR_20' ) end [2026-03-28 11:02:17] Production.INFO: ProcessCDR(1,16993946,1,1,2) [2026-03-28 11:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16993946,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 11:06:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16993946,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 11:06:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16993946,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 11:10:57] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16993946,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 11:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993946', 'tblTempUsageDetail_20' ) start [2026-03-28 11:10:57] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16993946', 'tblTempUsageDetail_20' ) end [2026-03-28 11:10:57] Production.ERROR: pbx prc_insertCDR start [2026-03-28 11:10:57] Production.ERROR: pbx prc_insertCDR end [2026-03-28 11:10:57] Production.INFO: ==32200== Releasing lock... [2026-03-28 11:10:57] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 11:10:57] Production.INFO: 37 MB #Memory Used# [2026-03-28 12:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 09:02:05 [end_date_ymd] => 2026-03-28 12:02:05 [RateCDR] => 1 ) [2026-03-28 12:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 09:02:05' and `end` < '2026-03-28 12:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 12:02:16] Production.INFO: count ==1455 [2026-03-28 12:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 09:02:05 - End Time 2026-03-28 12:02:05 [2026-03-28 12:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994193', 'tblTempUsageDetail_20' ) start [2026-03-28 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994193', 'tblTempUsageDetail_20' ) end [2026-03-28 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994193', 'tblTempVendorCDR_20' ) start [2026-03-28 12:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994193', 'tblTempVendorCDR_20' ) end [2026-03-28 12:02:17] Production.INFO: ProcessCDR(1,16994193,1,1,2) [2026-03-28 12:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16994193,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 12:06:14] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16994193,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 12:06:14] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16994193,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 12:10:54] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16994193,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 12:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994193', 'tblTempUsageDetail_20' ) start [2026-03-28 12:10:54] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994193', 'tblTempUsageDetail_20' ) end [2026-03-28 12:10:54] Production.ERROR: pbx prc_insertCDR start [2026-03-28 12:10:55] Production.ERROR: pbx prc_insertCDR end [2026-03-28 12:10:55] Production.INFO: ==4316== Releasing lock... [2026-03-28 12:10:55] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 12:10:55] Production.INFO: 39 MB #Memory Used# [2026-03-28 13:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 10:02:05 [end_date_ymd] => 2026-03-28 13:02:05 [RateCDR] => 1 ) [2026-03-28 13:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 10:02:05' and `end` < '2026-03-28 13:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 13:02:16] Production.INFO: count ==1474 [2026-03-28 13:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 10:02:05 - End Time 2026-03-28 13:02:05 [2026-03-28 13:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994440', 'tblTempUsageDetail_20' ) start [2026-03-28 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994440', 'tblTempUsageDetail_20' ) end [2026-03-28 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994440', 'tblTempVendorCDR_20' ) start [2026-03-28 13:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994440', 'tblTempVendorCDR_20' ) end [2026-03-28 13:02:17] Production.INFO: ProcessCDR(1,16994440,1,1,2) [2026-03-28 13:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16994440,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 13:06:14] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16994440,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 13:06:14] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16994440,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 13:11:01] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16994440,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 13:11:01] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994440', 'tblTempUsageDetail_20' ) start [2026-03-28 13:11:02] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994440', 'tblTempUsageDetail_20' ) end [2026-03-28 13:11:02] Production.ERROR: pbx prc_insertCDR start [2026-03-28 13:11:06] Production.ERROR: pbx prc_insertCDR end [2026-03-28 13:11:06] Production.INFO: ==8663== Releasing lock... [2026-03-28 13:11:06] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 13:11:06] Production.INFO: 39.25 MB #Memory Used# [2026-03-28 14:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 11:02:06 [end_date_ymd] => 2026-03-28 14:02:06 [RateCDR] => 1 ) [2026-03-28 14:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 11:02:06' and `end` < '2026-03-28 14:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 14:02:17] Production.INFO: count ==1537 [2026-03-28 14:02:18] Production.ERROR: pbx CDR StartTime 2026-03-28 11:02:06 - End Time 2026-03-28 14:02:06 [2026-03-28 14:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994687', 'tblTempUsageDetail_20' ) start [2026-03-28 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994687', 'tblTempUsageDetail_20' ) end [2026-03-28 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994687', 'tblTempVendorCDR_20' ) start [2026-03-28 14:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994687', 'tblTempVendorCDR_20' ) end [2026-03-28 14:02:18] Production.INFO: ProcessCDR(1,16994687,1,1,2) [2026-03-28 14:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16994687,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 14:06:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16994687,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 14:06:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16994687,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 14:10:48] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16994687,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 14:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994687', 'tblTempUsageDetail_20' ) start [2026-03-28 14:10:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994687', 'tblTempUsageDetail_20' ) end [2026-03-28 14:10:48] Production.ERROR: pbx prc_insertCDR start [2026-03-28 14:10:49] Production.ERROR: pbx prc_insertCDR end [2026-03-28 14:10:49] Production.INFO: ==13338== Releasing lock... [2026-03-28 14:10:49] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 14:10:49] Production.INFO: 40 MB #Memory Used# [2026-03-28 15:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 12:02:06 [end_date_ymd] => 2026-03-28 15:02:06 [RateCDR] => 1 ) [2026-03-28 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-03-28 12:02:06' and `end` < '2026-03-28 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-03-28 15:02:18] Production.INFO: count ==1481 [2026-03-28 15:02:19] Production.ERROR: pbx CDR StartTime 2026-03-28 12:02:06 - End Time 2026-03-28 15:02:06 [2026-03-28 15:02:19] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 15:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994934', 'tblTempUsageDetail_20' ) start [2026-03-28 15:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16994934', 'tblTempUsageDetail_20' ) end [2026-03-28 15:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994934', 'tblTempVendorCDR_20' ) start [2026-03-28 15:02:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16994934', 'tblTempVendorCDR_20' ) end [2026-03-28 15:02:19] Production.INFO: ProcessCDR(1,16994934,1,1,2) [2026-03-28 15:02:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16994934,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 15:07:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16994934,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 15:07:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16994934,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 15:11:47] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16994934,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 15:11:47] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994934', 'tblTempUsageDetail_20' ) start [2026-03-28 15:11:48] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16994934', 'tblTempUsageDetail_20' ) end [2026-03-28 15:11:48] Production.ERROR: pbx prc_insertCDR start [2026-03-28 15:11:48] Production.ERROR: pbx prc_insertCDR end [2026-03-28 15:11:48] Production.INFO: ==18057== Releasing lock... [2026-03-28 15:11:48] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 15:11:48] Production.INFO: 39.5 MB #Memory Used# [2026-03-28 16:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 13:02:05 [end_date_ymd] => 2026-03-28 16:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 13:02:05' and `end` < '2026-03-28 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-03-28 16:02:17] Production.INFO: count ==1472 [2026-03-28 16:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 13:02:05 - End Time 2026-03-28 16:02:05 [2026-03-28 16:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995181', 'tblTempUsageDetail_20' ) start [2026-03-28 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995181', 'tblTempUsageDetail_20' ) end [2026-03-28 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995181', 'tblTempVendorCDR_20' ) start [2026-03-28 16:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995181', 'tblTempVendorCDR_20' ) end [2026-03-28 16:02:17] Production.INFO: ProcessCDR(1,16995181,1,1,2) [2026-03-28 16:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16995181,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 16:06:02] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16995181,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 16:06:02] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16995181,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 16:10:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16995181,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 16:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995181', 'tblTempUsageDetail_20' ) start [2026-03-28 16:10:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995181', 'tblTempUsageDetail_20' ) end [2026-03-28 16:10:38] Production.ERROR: pbx prc_insertCDR start [2026-03-28 16:10:39] Production.ERROR: pbx prc_insertCDR end [2026-03-28 16:10:39] Production.INFO: ==22524== Releasing lock... [2026-03-28 16:10:39] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 16:10:39] Production.INFO: 39.25 MB #Memory Used# [2026-03-28 17:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 14:02:05 [end_date_ymd] => 2026-03-28 17:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 14:02:05' and `end` < '2026-03-28 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-03-28 17:02:17] Production.INFO: count ==1509 [2026-03-28 17:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 14:02:05 - End Time 2026-03-28 17:02:05 [2026-03-28 17:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 17:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995428', 'tblTempUsageDetail_20' ) start [2026-03-28 17:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995428', 'tblTempUsageDetail_20' ) end [2026-03-28 17:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995428', 'tblTempVendorCDR_20' ) start [2026-03-28 17:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995428', 'tblTempVendorCDR_20' ) end [2026-03-28 17:02:18] Production.INFO: ProcessCDR(1,16995428,1,1,2) [2026-03-28 17:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16995428,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 17:06:01] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16995428,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 17:06:01] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16995428,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 17:10:39] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16995428,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 17:10:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995428', 'tblTempUsageDetail_20' ) start [2026-03-28 17:10:39] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995428', 'tblTempUsageDetail_20' ) end [2026-03-28 17:10:39] Production.ERROR: pbx prc_insertCDR start [2026-03-28 17:10:41] Production.ERROR: pbx prc_insertCDR end [2026-03-28 17:10:41] Production.INFO: ==27078== Releasing lock... [2026-03-28 17:10:41] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 17:10:41] Production.INFO: 39.5 MB #Memory Used# [2026-03-28 18:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 15:02:05 [end_date_ymd] => 2026-03-28 18:02:05 [RateCDR] => 1 ) [2026-03-28 18:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 15:02:05' and `end` < '2026-03-28 18:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 18:02:16] Production.INFO: count ==1564 [2026-03-28 18:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 15:02:05 - End Time 2026-03-28 18:02:05 [2026-03-28 18:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 18:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995675', 'tblTempUsageDetail_20' ) start [2026-03-28 18:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995675', 'tblTempUsageDetail_20' ) end [2026-03-28 18:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995675', 'tblTempVendorCDR_20' ) start [2026-03-28 18:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995675', 'tblTempVendorCDR_20' ) end [2026-03-28 18:02:17] Production.INFO: ProcessCDR(1,16995675,1,1,2) [2026-03-28 18:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16995675,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 18:06:11] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16995675,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 18:06:11] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16995675,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 18:10:50] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16995675,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 18:10:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995675', 'tblTempUsageDetail_20' ) start [2026-03-28 18:10:50] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995675', 'tblTempUsageDetail_20' ) end [2026-03-28 18:10:50] Production.ERROR: pbx prc_insertCDR start [2026-03-28 18:10:52] Production.ERROR: pbx prc_insertCDR end [2026-03-28 18:10:52] Production.INFO: ==31353== Releasing lock... [2026-03-28 18:10:52] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 18:10:52] Production.INFO: 40.25 MB #Memory Used# [2026-03-28 19:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 16:02:05 [end_date_ymd] => 2026-03-28 19:02:05 [RateCDR] => 1 ) [2026-03-28 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-03-28 16:02:05' and `end` < '2026-03-28 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-03-28 19:02:17] Production.INFO: count ==1644 [2026-03-28 19:02:18] Production.ERROR: pbx CDR StartTime 2026-03-28 16:02:05 - End Time 2026-03-28 19:02:05 [2026-03-28 19:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 19:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995920', 'tblTempUsageDetail_20' ) start [2026-03-28 19:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16995920', 'tblTempUsageDetail_20' ) end [2026-03-28 19:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995920', 'tblTempVendorCDR_20' ) start [2026-03-28 19:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16995920', 'tblTempVendorCDR_20' ) end [2026-03-28 19:02:18] Production.INFO: ProcessCDR(1,16995920,1,1,2) [2026-03-28 19:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16995920,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 19:06:09] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16995920,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 19:06:09] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16995920,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 19:06:22] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16995920,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 19:06:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995920', 'tblTempUsageDetail_20' ) start [2026-03-28 19:06:22] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16995920', 'tblTempUsageDetail_20' ) end [2026-03-28 19:06:22] Production.ERROR: pbx prc_insertCDR start [2026-03-28 19:06:23] Production.ERROR: pbx prc_insertCDR end [2026-03-28 19:06:23] Production.INFO: ==3324== Releasing lock... [2026-03-28 19:06:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 19:06:23] Production.INFO: 40.5 MB #Memory Used# [2026-03-28 20:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 17:02:05 [end_date_ymd] => 2026-03-28 20:02:05 [RateCDR] => 1 ) [2026-03-28 20:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 17:02:05' and `end` < '2026-03-28 20:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 20:02:17] Production.INFO: count ==1461 [2026-03-28 20:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 17:02:05 - End Time 2026-03-28 20:02:05 [2026-03-28 20:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 20:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996167', 'tblTempUsageDetail_20' ) start [2026-03-28 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996167', 'tblTempUsageDetail_20' ) end [2026-03-28 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996167', 'tblTempVendorCDR_20' ) start [2026-03-28 20:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996167', 'tblTempVendorCDR_20' ) end [2026-03-28 20:02:18] Production.INFO: ProcessCDR(1,16996167,1,1,2) [2026-03-28 20:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16996167,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 20:06:03] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16996167,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 20:06:03] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16996167,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 20:06:19] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16996167,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 20:06:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996167', 'tblTempUsageDetail_20' ) start [2026-03-28 20:06:19] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996167', 'tblTempUsageDetail_20' ) end [2026-03-28 20:06:19] Production.ERROR: pbx prc_insertCDR start [2026-03-28 20:06:20] Production.ERROR: pbx prc_insertCDR end [2026-03-28 20:06:20] Production.INFO: ==7901== Releasing lock... [2026-03-28 20:06:20] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 20:06:20] Production.INFO: 39.75 MB #Memory Used# [2026-03-28 21:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 18:02:05 [end_date_ymd] => 2026-03-28 21:02:05 [RateCDR] => 1 ) [2026-03-28 21:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 18:02:05' and `end` < '2026-03-28 21:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 21:02:17] Production.INFO: count ==1330 [2026-03-28 21:02:18] Production.ERROR: pbx CDR StartTime 2026-03-28 18:02:05 - End Time 2026-03-28 21:02:05 [2026-03-28 21:02:18] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996414', 'tblTempUsageDetail_20' ) start [2026-03-28 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996414', 'tblTempUsageDetail_20' ) end [2026-03-28 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996414', 'tblTempVendorCDR_20' ) start [2026-03-28 21:02:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996414', 'tblTempVendorCDR_20' ) end [2026-03-28 21:02:18] Production.INFO: ProcessCDR(1,16996414,1,1,2) [2026-03-28 21:02:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16996414,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 21:06:05] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16996414,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 21:06:05] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16996414,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 21:06:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16996414,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 21:06:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996414', 'tblTempUsageDetail_20' ) start [2026-03-28 21:06:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996414', 'tblTempUsageDetail_20' ) end [2026-03-28 21:06:21] Production.ERROR: pbx prc_insertCDR start [2026-03-28 21:06:21] Production.ERROR: pbx prc_insertCDR end [2026-03-28 21:06:21] Production.INFO: ==12301== Releasing lock... [2026-03-28 21:06:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 21:06:21] Production.INFO: 38.25 MB #Memory Used# [2026-03-28 22:02:05] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 19:02:05 [end_date_ymd] => 2026-03-28 22:02:05 [RateCDR] => 1 ) [2026-03-28 22:02:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 19:02:05' and `end` < '2026-03-28 22:02:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 22:02:17] Production.INFO: count ==1119 [2026-03-28 22:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 19:02:05 - End Time 2026-03-28 22:02:05 [2026-03-28 22:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996661', 'tblTempUsageDetail_20' ) start [2026-03-28 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996661', 'tblTempUsageDetail_20' ) end [2026-03-28 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996661', 'tblTempVendorCDR_20' ) start [2026-03-28 22:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996661', 'tblTempVendorCDR_20' ) end [2026-03-28 22:02:17] Production.INFO: ProcessCDR(1,16996661,1,1,2) [2026-03-28 22:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16996661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 22:06:07] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16996661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 22:06:07] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16996661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 22:06:21] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16996661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 22:06:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996661', 'tblTempUsageDetail_20' ) start [2026-03-28 22:06:21] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996661', 'tblTempUsageDetail_20' ) end [2026-03-28 22:06:21] Production.ERROR: pbx prc_insertCDR start [2026-03-28 22:06:21] Production.ERROR: pbx prc_insertCDR end [2026-03-28 22:06:21] Production.INFO: ==17015== Releasing lock... [2026-03-28 22:06:21] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 22:06:21] Production.INFO: 37.5 MB #Memory Used# [2026-03-28 23:02:06] Production.ERROR: Array ( [start_date_ymd] => 2026-03-28 20:02:06 [end_date_ymd] => 2026-03-28 23:02:06 [RateCDR] => 1 ) [2026-03-28 23:02:06] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2026-03-28 20:02:06' and `end` < '2026-03-28 23:02:06' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2026-03-28 23:02:17] Production.INFO: count ==1060 [2026-03-28 23:02:17] Production.ERROR: pbx CDR StartTime 2026-03-28 20:02:06 - End Time 2026-03-28 23:02:06 [2026-03-28 23:02:17] Production.ERROR: ========================== pbx transaction end ============================= [2026-03-28 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996908', 'tblTempUsageDetail_20' ) start [2026-03-28 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16996908', 'tblTempUsageDetail_20' ) end [2026-03-28 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996908', 'tblTempVendorCDR_20' ) start [2026-03-28 23:02:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16996908', 'tblTempVendorCDR_20' ) end [2026-03-28 23:02:17] Production.INFO: ProcessCDR(1,16996908,1,1,2) [2026-03-28 23:02:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16996908,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 23:02:27] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16996908,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2026-03-28 23:02:27] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16996908,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 23:02:38] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16996908,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2026-03-28 23:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996908', 'tblTempUsageDetail_20' ) start [2026-03-28 23:02:38] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16996908', 'tblTempUsageDetail_20' ) end [2026-03-28 23:02:38] Production.ERROR: pbx prc_insertCDR start [2026-03-28 23:02:38] Production.ERROR: pbx prc_insertCDR end [2026-03-28 23:02:38] Production.INFO: ==21337== Releasing lock... [2026-03-28 23:02:38] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2026-03-28 23:02:38] Production.INFO: 38 MB #Memory Used#