[2025-10-11 00:25:04] Production.INFO: next invoice date [2025-10-11 00:25:04] Production.INFO: 2025-11-11 [2025-10-11 00:25:04] Production.INFO: getdaysdiff [2025-10-11 00:25:04] Production.INFO: +31 [2025-10-11 00:25:04] Production.INFO: call prc_setAccountDiscountPlan (229,16,1,31,31,'RMScheduler',2025-10-11 00:25:04,1,0,,,0) [2025-10-11 00:25:04] Production.INFO: next invoice date [2025-10-11 00:25:04] Production.INFO: 2025-11-11 [2025-10-11 00:25:04] Production.INFO: getdaysdiff [2025-10-11 00:25:04] Production.INFO: +31 [2025-10-11 00:25:04] Production.INFO: call prc_setAccountDiscountPlan (229,13,2,31,31,'RMScheduler',2025-10-11 00:25:04,1,0,,,0) [2025-10-11 00:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-10 21:25:05 [end_date_ymd] => 2025-10-11 00:25:05 [RateCDR] => 1 ) [2025-10-11 00:25: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` >= '2025-10-10 21:25:05' and `end` < '2025-10-11 00:25: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 ,'') [2025-10-11 00:25:18] Production.INFO: count ==926 [2025-10-11 00:25:18] Production.ERROR: pbx CDR StartTime 2025-10-10 21:25:05 - End Time 2025-10-11 00:25:05 [2025-10-11 00:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 00:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995424', 'tblTempUsageDetail_20' ) start [2025-10-11 00:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995424', 'tblTempUsageDetail_20' ) end [2025-10-11 00:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995424', 'tblTempVendorCDR_20' ) start [2025-10-11 00:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995424', 'tblTempVendorCDR_20' ) end [2025-10-11 00:25:18] Production.INFO: ProcessCDR(1,15995424,1,1,2) [2025-10-11 00:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15995424,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 00:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15995424,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 00:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15995424,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 00:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15995424,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 00:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995424', 'tblTempUsageDetail_20' ) start [2025-10-11 00:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995424', 'tblTempUsageDetail_20' ) end [2025-10-11 00:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 00:25:27] Production.ERROR: pbx prc_insertCDR end [2025-10-11 00:25:29] Production.INFO: ==15985== Releasing lock... [2025-10-11 00:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 00:25:29] Production.INFO: 39.5 MB #Memory Used# [2025-10-11 01:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-10 22:25:05 [end_date_ymd] => 2025-10-11 01:25:05 [RateCDR] => 1 ) [2025-10-11 01:25: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` >= '2025-10-10 22:25:05' and `end` < '2025-10-11 01:25: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 ,'') [2025-10-11 01:25:18] Production.INFO: count ==863 [2025-10-11 01:25:18] Production.ERROR: pbx CDR StartTime 2025-10-10 22:25:05 - End Time 2025-10-11 01:25:05 [2025-10-11 01:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 01:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995671', 'tblTempUsageDetail_20' ) start [2025-10-11 01:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995671', 'tblTempUsageDetail_20' ) end [2025-10-11 01:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995671', 'tblTempVendorCDR_20' ) start [2025-10-11 01:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995671', 'tblTempVendorCDR_20' ) end [2025-10-11 01:25:18] Production.INFO: ProcessCDR(1,15995671,1,1,2) [2025-10-11 01:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15995671,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 01:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15995671,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 01:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15995671,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 01:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15995671,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 01:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995671', 'tblTempUsageDetail_20' ) start [2025-10-11 01:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995671', 'tblTempUsageDetail_20' ) end [2025-10-11 01:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 01:25:27] Production.ERROR: pbx prc_insertCDR end [2025-10-11 01:25:27] Production.INFO: ==20450== Releasing lock... [2025-10-11 01:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 01:25:27] Production.INFO: 34.5 MB #Memory Used# [2025-10-11 02:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-10 23:25:05 [end_date_ymd] => 2025-10-11 02:25:05 [RateCDR] => 1 ) [2025-10-11 02:25: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` >= '2025-10-10 23:25:05' and `end` < '2025-10-11 02:25: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 ,'') [2025-10-11 02:25:17] Production.INFO: count ==666 [2025-10-11 02:25:17] Production.ERROR: pbx CDR StartTime 2025-10-10 23:25:05 - End Time 2025-10-11 02:25:05 [2025-10-11 02:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 02:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995918', 'tblTempUsageDetail_20' ) start [2025-10-11 02:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15995918', 'tblTempUsageDetail_20' ) end [2025-10-11 02:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995918', 'tblTempVendorCDR_20' ) start [2025-10-11 02:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15995918', 'tblTempVendorCDR_20' ) end [2025-10-11 02:25:17] Production.INFO: ProcessCDR(1,15995918,1,1,2) [2025-10-11 02:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15995918,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 02:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15995918,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 02:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15995918,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 02:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15995918,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 02:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995918', 'tblTempUsageDetail_20' ) start [2025-10-11 02:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15995918', 'tblTempUsageDetail_20' ) end [2025-10-11 02:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 02:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 02:25:26] Production.INFO: ==25134== Releasing lock... [2025-10-11 02:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 02:25:26] Production.INFO: 33.5 MB #Memory Used# [2025-10-11 03:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 00:25:05 [end_date_ymd] => 2025-10-11 03:25:05 [RateCDR] => 1 ) [2025-10-11 03:25: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` >= '2025-10-11 00:25:05' and `end` < '2025-10-11 03:25: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 ,'') [2025-10-11 03:25:18] Production.INFO: count ==569 [2025-10-11 03:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 00:25:05 - End Time 2025-10-11 03:25:05 [2025-10-11 03:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996165', 'tblTempUsageDetail_20' ) start [2025-10-11 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996165', 'tblTempUsageDetail_20' ) end [2025-10-11 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996165', 'tblTempVendorCDR_20' ) start [2025-10-11 03:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996165', 'tblTempVendorCDR_20' ) end [2025-10-11 03:25:18] Production.INFO: ProcessCDR(1,15996165,1,1,2) [2025-10-11 03:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15996165,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 03:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15996165,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 03:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15996165,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 03:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15996165,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 03:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996165', 'tblTempUsageDetail_20' ) start [2025-10-11 03:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996165', 'tblTempUsageDetail_20' ) end [2025-10-11 03:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 03:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 03:25:26] Production.INFO: ==29446== Releasing lock... [2025-10-11 03:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 03:25:26] Production.INFO: 32.25 MB #Memory Used# [2025-10-11 04:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 01:25:05 [end_date_ymd] => 2025-10-11 04:25:05 [RateCDR] => 1 ) [2025-10-11 04:25: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` >= '2025-10-11 01:25:05' and `end` < '2025-10-11 04:25: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 ,'') [2025-10-11 04:25:17] Production.INFO: count ==391 [2025-10-11 04:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 01:25:05 - End Time 2025-10-11 04:25:05 [2025-10-11 04:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996413', 'tblTempUsageDetail_20' ) start [2025-10-11 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996413', 'tblTempUsageDetail_20' ) end [2025-10-11 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996413', 'tblTempVendorCDR_20' ) start [2025-10-11 04:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996413', 'tblTempVendorCDR_20' ) end [2025-10-11 04:25:18] Production.INFO: ProcessCDR(1,15996413,1,1,2) [2025-10-11 04:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15996413,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 04:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15996413,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 04:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15996413,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 04:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15996413,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 04:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996413', 'tblTempUsageDetail_20' ) start [2025-10-11 04:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996413', 'tblTempUsageDetail_20' ) end [2025-10-11 04:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 04:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 04:25:26] Production.INFO: ==2045== Releasing lock... [2025-10-11 04:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 04:25:26] Production.INFO: 31.75 MB #Memory Used# [2025-10-11 05:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 02:25:05 [end_date_ymd] => 2025-10-11 05:25:05 [RateCDR] => 1 ) [2025-10-11 05:25: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` >= '2025-10-11 02:25:05' and `end` < '2025-10-11 05:25: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 ,'') [2025-10-11 05:25:18] Production.INFO: count ==363 [2025-10-11 05:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 02:25:05 - End Time 2025-10-11 05:25:05 [2025-10-11 05:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996661', 'tblTempUsageDetail_20' ) start [2025-10-11 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996661', 'tblTempUsageDetail_20' ) end [2025-10-11 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996661', 'tblTempVendorCDR_20' ) start [2025-10-11 05:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996661', 'tblTempVendorCDR_20' ) end [2025-10-11 05:25:18] Production.INFO: ProcessCDR(1,15996661,1,1,2) [2025-10-11 05:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15996661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 05:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15996661,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 05:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15996661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 05:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15996661,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 05:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996661', 'tblTempUsageDetail_20' ) start [2025-10-11 05:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996661', 'tblTempUsageDetail_20' ) end [2025-10-11 05:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 05:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 05:25:26] Production.INFO: ==7750== Releasing lock... [2025-10-11 05:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 05:25:26] Production.INFO: 31.25 MB #Memory Used# [2025-10-11 06:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 03:25:05 [end_date_ymd] => 2025-10-11 06:25:05 [RateCDR] => 1 ) [2025-10-11 06:25: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` >= '2025-10-11 03:25:05' and `end` < '2025-10-11 06:25: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 ,'') [2025-10-11 06:25:17] Production.INFO: count ==208 [2025-10-11 06:25:17] Production.ERROR: pbx CDR StartTime 2025-10-11 03:25:05 - End Time 2025-10-11 06:25:05 [2025-10-11 06:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996908', 'tblTempUsageDetail_20' ) start [2025-10-11 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15996908', 'tblTempUsageDetail_20' ) end [2025-10-11 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996908', 'tblTempVendorCDR_20' ) start [2025-10-11 06:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15996908', 'tblTempVendorCDR_20' ) end [2025-10-11 06:25:17] Production.INFO: ProcessCDR(1,15996908,1,1,2) [2025-10-11 06:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15996908,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 06:25:18] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15996908,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 06:25:18] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15996908,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 06:25:23] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15996908,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 06:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996908', 'tblTempUsageDetail_20' ) start [2025-10-11 06:25:23] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15996908', 'tblTempUsageDetail_20' ) end [2025-10-11 06:25:23] Production.ERROR: pbx prc_insertCDR start [2025-10-11 06:25:23] Production.ERROR: pbx prc_insertCDR end [2025-10-11 06:25:23] Production.INFO: ==13750== Releasing lock... [2025-10-11 06:25:23] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 06:25:23] Production.INFO: 29.75 MB #Memory Used# [2025-10-11 07:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 04:25:05 [end_date_ymd] => 2025-10-11 07:25:05 [RateCDR] => 1 ) [2025-10-11 07:25: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` >= '2025-10-11 04:25:05' and `end` < '2025-10-11 07:25: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 ,'') [2025-10-11 07:25:17] Production.INFO: count ==166 [2025-10-11 07:25:17] Production.ERROR: pbx CDR StartTime 2025-10-11 04:25:05 - End Time 2025-10-11 07:25:05 [2025-10-11 07:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997155', 'tblTempUsageDetail_20' ) start [2025-10-11 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997155', 'tblTempUsageDetail_20' ) end [2025-10-11 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997155', 'tblTempVendorCDR_20' ) start [2025-10-11 07:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997155', 'tblTempVendorCDR_20' ) end [2025-10-11 07:25:17] Production.INFO: ProcessCDR(1,15997155,1,1,2) [2025-10-11 07:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15997155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 07:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15997155,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 07:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15997155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 07:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15997155,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 07:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997155', 'tblTempUsageDetail_20' ) start [2025-10-11 07:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997155', 'tblTempUsageDetail_20' ) end [2025-10-11 07:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 07:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 07:25:26] Production.INFO: ==18091== Releasing lock... [2025-10-11 07:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 07:25:26] Production.INFO: 29.5 MB #Memory Used# [2025-10-11 08:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 05:25:05 [end_date_ymd] => 2025-10-11 08:25:05 [RateCDR] => 1 ) [2025-10-11 08:25: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` >= '2025-10-11 05:25:05' and `end` < '2025-10-11 08:25: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 ,'') [2025-10-11 08:25:17] Production.INFO: count ==183 [2025-10-11 08:25:17] Production.ERROR: pbx CDR StartTime 2025-10-11 05:25:05 - End Time 2025-10-11 08:25:05 [2025-10-11 08:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997402', 'tblTempUsageDetail_20' ) start [2025-10-11 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997402', 'tblTempUsageDetail_20' ) end [2025-10-11 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997402', 'tblTempVendorCDR_20' ) start [2025-10-11 08:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997402', 'tblTempVendorCDR_20' ) end [2025-10-11 08:25:17] Production.INFO: ProcessCDR(1,15997402,1,1,2) [2025-10-11 08:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15997402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 08:25:21] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15997402,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 08:25:21] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15997402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 08:25:25] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15997402,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 08:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997402', 'tblTempUsageDetail_20' ) start [2025-10-11 08:25:25] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997402', 'tblTempUsageDetail_20' ) end [2025-10-11 08:25:25] Production.ERROR: pbx prc_insertCDR start [2025-10-11 08:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 08:25:26] Production.INFO: ==22987== Releasing lock... [2025-10-11 08:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 08:25:26] Production.INFO: 29.75 MB #Memory Used# [2025-10-11 09:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 06:25:05 [end_date_ymd] => 2025-10-11 09:25:05 [RateCDR] => 1 ) [2025-10-11 09:25: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` >= '2025-10-11 06:25:05' and `end` < '2025-10-11 09:25: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 ,'') [2025-10-11 09:25:17] Production.INFO: count ==638 [2025-10-11 09:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 06:25:05 - End Time 2025-10-11 09:25:05 [2025-10-11 09:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997649', 'tblTempUsageDetail_20' ) start [2025-10-11 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997649', 'tblTempUsageDetail_20' ) end [2025-10-11 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997649', 'tblTempVendorCDR_20' ) start [2025-10-11 09:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997649', 'tblTempVendorCDR_20' ) end [2025-10-11 09:25:18] Production.INFO: ProcessCDR(1,15997649,1,1,2) [2025-10-11 09:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15997649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 09:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15997649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 09:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15997649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 09:25:26] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15997649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 09:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997649', 'tblTempUsageDetail_20' ) start [2025-10-11 09:25:26] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997649', 'tblTempUsageDetail_20' ) end [2025-10-11 09:25:26] Production.ERROR: pbx prc_insertCDR start [2025-10-11 09:25:26] Production.ERROR: pbx prc_insertCDR end [2025-10-11 09:25:26] Production.INFO: ==27454== Releasing lock... [2025-10-11 09:25:26] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 09:25:26] Production.INFO: 33.75 MB #Memory Used# [2025-10-11 10:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 07:25:05 [end_date_ymd] => 2025-10-11 10:25:05 [RateCDR] => 1 ) [2025-10-11 10:25: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` >= '2025-10-11 07:25:05' and `end` < '2025-10-11 10:25: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 ,'') [2025-10-11 10:25:18] Production.INFO: count ==1102 [2025-10-11 10:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 07:25:05 - End Time 2025-10-11 10:25:05 [2025-10-11 10:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 10:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997896', 'tblTempUsageDetail_20' ) start [2025-10-11 10:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15997896', 'tblTempUsageDetail_20' ) end [2025-10-11 10:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997896', 'tblTempVendorCDR_20' ) start [2025-10-11 10:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15997896', 'tblTempVendorCDR_20' ) end [2025-10-11 10:25:18] Production.INFO: ProcessCDR(1,15997896,1,1,2) [2025-10-11 10:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15997896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 10:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15997896,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 10:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15997896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 10:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15997896,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 10:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997896', 'tblTempUsageDetail_20' ) start [2025-10-11 10:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15997896', 'tblTempUsageDetail_20' ) end [2025-10-11 10:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 10:25:28] Production.ERROR: pbx prc_insertCDR end [2025-10-11 10:25:28] Production.INFO: ==31859== Releasing lock... [2025-10-11 10:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 10:25:28] Production.INFO: 37 MB #Memory Used# [2025-10-11 11:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 08:25:05 [end_date_ymd] => 2025-10-11 11:25:05 [RateCDR] => 1 ) [2025-10-11 11:25: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` >= '2025-10-11 08:25:05' and `end` < '2025-10-11 11:25: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 ,'') [2025-10-11 11:25:18] Production.INFO: count ==1618 [2025-10-11 11:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 08:25:05 - End Time 2025-10-11 11:25:05 [2025-10-11 11:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 11:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998143', 'tblTempUsageDetail_20' ) start [2025-10-11 11:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998143', 'tblTempUsageDetail_20' ) end [2025-10-11 11:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998143', 'tblTempVendorCDR_20' ) start [2025-10-11 11:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998143', 'tblTempVendorCDR_20' ) end [2025-10-11 11:25:19] Production.INFO: ProcessCDR(1,15998143,1,1,2) [2025-10-11 11:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15998143,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 11:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15998143,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 11:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15998143,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 11:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15998143,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 11:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998143', 'tblTempUsageDetail_20' ) start [2025-10-11 11:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998143', 'tblTempUsageDetail_20' ) end [2025-10-11 11:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 11:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 11:25:29] Production.INFO: ==4119== Releasing lock... [2025-10-11 11:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 11:25:29] Production.INFO: 40.25 MB #Memory Used# [2025-10-11 12:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 09:25:06 [end_date_ymd] => 2025-10-11 12:25:06 [RateCDR] => 1 ) [2025-10-11 12:25: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` >= '2025-10-11 09:25:06' and `end` < '2025-10-11 12:25: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 ,'') [2025-10-11 12:25:18] Production.INFO: count ==1842 [2025-10-11 12:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 09:25:06 - End Time 2025-10-11 12:25:06 [2025-10-11 12:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 12:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998390', 'tblTempUsageDetail_20' ) start [2025-10-11 12:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998390', 'tblTempUsageDetail_20' ) end [2025-10-11 12:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998390', 'tblTempVendorCDR_20' ) start [2025-10-11 12:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998390', 'tblTempVendorCDR_20' ) end [2025-10-11 12:25:19] Production.INFO: ProcessCDR(1,15998390,1,1,2) [2025-10-11 12:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15998390,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 12:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15998390,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 12:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15998390,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 12:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15998390,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 12:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998390', 'tblTempUsageDetail_20' ) start [2025-10-11 12:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998390', 'tblTempUsageDetail_20' ) end [2025-10-11 12:25:29] Production.ERROR: pbx prc_insertCDR start [2025-10-11 12:25:30] Production.ERROR: pbx prc_insertCDR end [2025-10-11 12:25:30] Production.INFO: ==8863== Releasing lock... [2025-10-11 12:25:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 12:25:30] Production.INFO: 42 MB #Memory Used# [2025-10-11 13:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 10:25:05 [end_date_ymd] => 2025-10-11 13:25:05 [RateCDR] => 1 ) [2025-10-11 13:25: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` >= '2025-10-11 10:25:05' and `end` < '2025-10-11 13:25: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 ,'') [2025-10-11 13:25:17] Production.INFO: count ==2129 [2025-10-11 13:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 10:25:05 - End Time 2025-10-11 13:25:05 [2025-10-11 13:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 13:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998637', 'tblTempUsageDetail_20' ) start [2025-10-11 13:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998637', 'tblTempUsageDetail_20' ) end [2025-10-11 13:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998637', 'tblTempVendorCDR_20' ) start [2025-10-11 13:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998637', 'tblTempVendorCDR_20' ) end [2025-10-11 13:25:19] Production.INFO: ProcessCDR(1,15998637,1,1,2) [2025-10-11 13:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15998637,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 13:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15998637,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 13:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15998637,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 13:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15998637,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 13:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998637', 'tblTempUsageDetail_20' ) start [2025-10-11 13:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998637', 'tblTempUsageDetail_20' ) end [2025-10-11 13:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 13:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 13:25:29] Production.INFO: ==13242== Releasing lock... [2025-10-11 13:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 13:25:29] Production.INFO: 44.25 MB #Memory Used# [2025-10-11 14:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 11:25:06 [end_date_ymd] => 2025-10-11 14:25:06 [RateCDR] => 1 ) [2025-10-11 14:25: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` >= '2025-10-11 11:25:06' and `end` < '2025-10-11 14:25: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 ,'') [2025-10-11 14:25:18] Production.INFO: count ==2143 [2025-10-11 14:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 11:25:06 - End Time 2025-10-11 14:25:06 [2025-10-11 14:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 14:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998884', 'tblTempUsageDetail_20' ) start [2025-10-11 14:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15998884', 'tblTempUsageDetail_20' ) end [2025-10-11 14:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998884', 'tblTempVendorCDR_20' ) start [2025-10-11 14:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15998884', 'tblTempVendorCDR_20' ) end [2025-10-11 14:25:19] Production.INFO: ProcessCDR(1,15998884,1,1,2) [2025-10-11 14:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15998884,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 14:25:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15998884,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 14:25:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15998884,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 14:25:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15998884,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 14:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998884', 'tblTempUsageDetail_20' ) start [2025-10-11 14:25:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15998884', 'tblTempUsageDetail_20' ) end [2025-10-11 14:25:29] Production.ERROR: pbx prc_insertCDR start [2025-10-11 14:25:30] Production.ERROR: pbx prc_insertCDR end [2025-10-11 14:25:30] Production.INFO: ==17875== Releasing lock... [2025-10-11 14:25:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 14:25:30] Production.INFO: 44.25 MB #Memory Used# [2025-10-11 15:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 12:25:05 [end_date_ymd] => 2025-10-11 15:25:05 [RateCDR] => 1 ) [2025-10-11 15:25: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` >= '2025-10-11 12:25:05' and `end` < '2025-10-11 15:25: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 ,'') [2025-10-11 15:25:18] Production.INFO: count ==2072 [2025-10-11 15:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 12:25:05 - End Time 2025-10-11 15:25:05 [2025-10-11 15:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 15:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999131', 'tblTempUsageDetail_20' ) start [2025-10-11 15:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999131', 'tblTempUsageDetail_20' ) end [2025-10-11 15:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999131', 'tblTempVendorCDR_20' ) start [2025-10-11 15:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999131', 'tblTempVendorCDR_20' ) end [2025-10-11 15:25:19] Production.INFO: ProcessCDR(1,15999131,1,1,2) [2025-10-11 15:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15999131,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 15:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15999131,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 15:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15999131,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 15:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15999131,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 15:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999131', 'tblTempUsageDetail_20' ) start [2025-10-11 15:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999131', 'tblTempUsageDetail_20' ) end [2025-10-11 15:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 15:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 15:25:29] Production.INFO: ==22606== Releasing lock... [2025-10-11 15:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 15:25:29] Production.INFO: 43.75 MB #Memory Used# [2025-10-11 16:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 13:25:05 [end_date_ymd] => 2025-10-11 16:25:05 [RateCDR] => 1 ) [2025-10-11 16:25: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` >= '2025-10-11 13:25:05' and `end` < '2025-10-11 16:25: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 ,'') [2025-10-11 16:25:18] Production.INFO: count ==1783 [2025-10-11 16:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 13:25:05 - End Time 2025-10-11 16:25:05 [2025-10-11 16:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 16:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999378', 'tblTempUsageDetail_20' ) start [2025-10-11 16:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999378', 'tblTempUsageDetail_20' ) end [2025-10-11 16:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999378', 'tblTempVendorCDR_20' ) start [2025-10-11 16:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999378', 'tblTempVendorCDR_20' ) end [2025-10-11 16:25:19] Production.INFO: ProcessCDR(1,15999378,1,1,2) [2025-10-11 16:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15999378,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 16:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15999378,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 16:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15999378,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 16:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15999378,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 16:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999378', 'tblTempUsageDetail_20' ) start [2025-10-11 16:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999378', 'tblTempUsageDetail_20' ) end [2025-10-11 16:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 16:25:28] Production.ERROR: pbx prc_insertCDR end [2025-10-11 16:25:28] Production.INFO: ==28085== Releasing lock... [2025-10-11 16:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 16:25:28] Production.INFO: 41.75 MB #Memory Used# [2025-10-11 17:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 14:25:05 [end_date_ymd] => 2025-10-11 17:25:05 [RateCDR] => 1 ) [2025-10-11 17:25: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` >= '2025-10-11 14:25:05' and `end` < '2025-10-11 17:25: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 ,'') [2025-10-11 17:25:18] Production.INFO: count ==1712 [2025-10-11 17:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 14:25:05 - End Time 2025-10-11 17:25:05 [2025-10-11 17:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999625', 'tblTempUsageDetail_20' ) start [2025-10-11 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999625', 'tblTempUsageDetail_20' ) end [2025-10-11 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999625', 'tblTempVendorCDR_20' ) start [2025-10-11 17:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999625', 'tblTempVendorCDR_20' ) end [2025-10-11 17:25:18] Production.INFO: ProcessCDR(1,15999625,1,1,2) [2025-10-11 17:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15999625,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 17:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15999625,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 17:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15999625,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 17:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15999625,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 17:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999625', 'tblTempUsageDetail_20' ) start [2025-10-11 17:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999625', 'tblTempUsageDetail_20' ) end [2025-10-11 17:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 17:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 17:25:29] Production.INFO: ==32613== Releasing lock... [2025-10-11 17:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 17:25:29] Production.INFO: 41 MB #Memory Used# [2025-10-11 18:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 15:25:05 [end_date_ymd] => 2025-10-11 18:25:05 [RateCDR] => 1 ) [2025-10-11 18:25: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` >= '2025-10-11 15:25:05' and `end` < '2025-10-11 18:25: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 ,'') [2025-10-11 18:25:17] Production.INFO: count ==1636 [2025-10-11 18:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 15:25:05 - End Time 2025-10-11 18:25:05 [2025-10-11 18:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999872', 'tblTempUsageDetail_20' ) start [2025-10-11 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15999872', 'tblTempUsageDetail_20' ) end [2025-10-11 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999872', 'tblTempVendorCDR_20' ) start [2025-10-11 18:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15999872', 'tblTempVendorCDR_20' ) end [2025-10-11 18:25:18] Production.INFO: ProcessCDR(1,15999872,1,1,2) [2025-10-11 18:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15999872,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 18:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15999872,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 18:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15999872,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 18:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15999872,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 18:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999872', 'tblTempUsageDetail_20' ) start [2025-10-11 18:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15999872', 'tblTempUsageDetail_20' ) end [2025-10-11 18:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 18:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 18:25:29] Production.INFO: ==6160== Releasing lock... [2025-10-11 18:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 18:25:29] Production.INFO: 40.5 MB #Memory Used# [2025-10-11 19:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 16:25:05 [end_date_ymd] => 2025-10-11 19:25:05 [RateCDR] => 1 ) [2025-10-11 19:25: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` >= '2025-10-11 16:25:05' and `end` < '2025-10-11 19:25: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 ,'') [2025-10-11 19:25:18] Production.INFO: count ==1728 [2025-10-11 19:25:19] Production.ERROR: pbx CDR StartTime 2025-10-11 16:25:05 - End Time 2025-10-11 19:25:05 [2025-10-11 19:25:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 19:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000116', 'tblTempUsageDetail_20' ) start [2025-10-11 19:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000116', 'tblTempUsageDetail_20' ) end [2025-10-11 19:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000116', 'tblTempVendorCDR_20' ) start [2025-10-11 19:25:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000116', 'tblTempVendorCDR_20' ) end [2025-10-11 19:25:19] Production.INFO: ProcessCDR(1,16000116,1,1,2) [2025-10-11 19:25:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16000116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 19:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16000116,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 19:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16000116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 19:25:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16000116,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 19:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000116', 'tblTempUsageDetail_20' ) start [2025-10-11 19:25:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000116', 'tblTempUsageDetail_20' ) end [2025-10-11 19:25:28] Production.ERROR: pbx prc_insertCDR start [2025-10-11 19:25:29] Production.ERROR: pbx prc_insertCDR end [2025-10-11 19:25:29] Production.INFO: ==11254== Releasing lock... [2025-10-11 19:25:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 19:25:29] Production.INFO: 41 MB #Memory Used# [2025-10-11 20:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 17:25:05 [end_date_ymd] => 2025-10-11 20:25:05 [RateCDR] => 1 ) [2025-10-11 20:25: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` >= '2025-10-11 17:25:05' and `end` < '2025-10-11 20:25: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 ,'') [2025-10-11 20:25:17] Production.INFO: count ==1678 [2025-10-11 20:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 17:25:05 - End Time 2025-10-11 20:25:05 [2025-10-11 20:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000363', 'tblTempUsageDetail_20' ) start [2025-10-11 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000363', 'tblTempUsageDetail_20' ) end [2025-10-11 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000363', 'tblTempVendorCDR_20' ) start [2025-10-11 20:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000363', 'tblTempVendorCDR_20' ) end [2025-10-11 20:25:18] Production.INFO: ProcessCDR(1,16000363,1,1,2) [2025-10-11 20:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16000363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 20:25:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16000363,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 20:25:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16000363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 20:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16000363,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 20:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000363', 'tblTempUsageDetail_20' ) start [2025-10-11 20:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000363', 'tblTempUsageDetail_20' ) end [2025-10-11 20:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 20:25:28] Production.ERROR: pbx prc_insertCDR end [2025-10-11 20:25:28] Production.INFO: ==15633== Releasing lock... [2025-10-11 20:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 20:25:28] Production.INFO: 40.75 MB #Memory Used# [2025-10-11 21:25:06] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 18:25:06 [end_date_ymd] => 2025-10-11 21:25:06 [RateCDR] => 1 ) [2025-10-11 21:25: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` >= '2025-10-11 18:25:06' and `end` < '2025-10-11 21:25: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 ,'') [2025-10-11 21:25:18] Production.INFO: count ==1422 [2025-10-11 21:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 18:25:06 - End Time 2025-10-11 21:25:06 [2025-10-11 21:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000610', 'tblTempUsageDetail_20' ) start [2025-10-11 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000610', 'tblTempUsageDetail_20' ) end [2025-10-11 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000610', 'tblTempVendorCDR_20' ) start [2025-10-11 21:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000610', 'tblTempVendorCDR_20' ) end [2025-10-11 21:25:18] Production.INFO: ProcessCDR(1,16000610,1,1,2) [2025-10-11 21:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16000610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 21:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16000610,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 21:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16000610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 21:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16000610,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 21:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000610', 'tblTempUsageDetail_20' ) start [2025-10-11 21:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000610', 'tblTempUsageDetail_20' ) end [2025-10-11 21:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 21:25:27] Production.ERROR: pbx prc_insertCDR end [2025-10-11 21:25:28] Production.INFO: ==20052== Releasing lock... [2025-10-11 21:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 21:25:28] Production.INFO: 38.75 MB #Memory Used# [2025-10-11 22:25:05] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 19:25:05 [end_date_ymd] => 2025-10-11 22:25:05 [RateCDR] => 1 ) [2025-10-11 22:25: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` >= '2025-10-11 19:25:05' and `end` < '2025-10-11 22:25: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 ,'') [2025-10-11 22:25:18] Production.INFO: count ==1176 [2025-10-11 22:25:18] Production.ERROR: pbx CDR StartTime 2025-10-11 19:25:05 - End Time 2025-10-11 22:25:05 [2025-10-11 22:25:18] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000857', 'tblTempUsageDetail_20' ) start [2025-10-11 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16000857', 'tblTempUsageDetail_20' ) end [2025-10-11 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000857', 'tblTempVendorCDR_20' ) start [2025-10-11 22:25:18] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16000857', 'tblTempVendorCDR_20' ) end [2025-10-11 22:25:18] Production.INFO: ProcessCDR(1,16000857,1,1,2) [2025-10-11 22:25:18] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16000857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 22:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16000857,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 22:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16000857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 22:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16000857,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 22:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000857', 'tblTempUsageDetail_20' ) start [2025-10-11 22:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16000857', 'tblTempUsageDetail_20' ) end [2025-10-11 22:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 22:25:28] Production.ERROR: pbx prc_insertCDR end [2025-10-11 22:25:28] Production.INFO: ==24730== Releasing lock... [2025-10-11 22:25:28] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 22:25:28] Production.INFO: 37.25 MB #Memory Used# [2025-10-11 23:25:04] Production.ERROR: Array ( [start_date_ymd] => 2025-10-11 20:25:04 [end_date_ymd] => 2025-10-11 23:25:04 [RateCDR] => 1 ) [2025-10-11 23:25:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-10-11 20:25:04' and `end` < '2025-10-11 23:25:04' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-10-11 23:25:17] Production.INFO: count ==925 [2025-10-11 23:25:17] Production.ERROR: pbx CDR StartTime 2025-10-11 20:25:04 - End Time 2025-10-11 23:25:04 [2025-10-11 23:25:17] Production.ERROR: ========================== pbx transaction end ============================= [2025-10-11 23:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16001104', 'tblTempUsageDetail_20' ) start [2025-10-11 23:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '16001104', 'tblTempUsageDetail_20' ) end [2025-10-11 23:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16001104', 'tblTempVendorCDR_20' ) start [2025-10-11 23:25:17] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '16001104', 'tblTempVendorCDR_20' ) end [2025-10-11 23:25:17] Production.INFO: ProcessCDR(1,16001104,1,1,2) [2025-10-11 23:25:17] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,16001104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 23:25:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,16001104,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-10-11 23:25:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,16001104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 23:25:27] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,16001104,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-10-11 23:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16001104', 'tblTempUsageDetail_20' ) start [2025-10-11 23:25:27] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('16001104', 'tblTempUsageDetail_20' ) end [2025-10-11 23:25:27] Production.ERROR: pbx prc_insertCDR start [2025-10-11 23:25:27] Production.ERROR: pbx prc_insertCDR end [2025-10-11 23:25:27] Production.INFO: ==29332== Releasing lock... [2025-10-11 23:25:27] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-10-11 23:25:27] Production.INFO: 35.25 MB #Memory Used#