HI
In new version 1.10 i have problem in report customer traffic
Web Browser error:
We’re sorry, but something went wrong.
Log “/var/log/yeti/ yeti-web.log” error :
[FATAL]: ActiveRecord::NotNullViolation (PG::NotNullViolation: ERROR: el valor null para la columna «customer_calls_duration» viola la restricción not null
INSERT INTO reports.customer_traffic_report_data_full(#012 report_id,#012 vendor_id, destination_prefix, dst_country_id, dst_network_id,#012 calls_count, short_calls_count, success_calls_count,#012 calls_duration, customer_calls_duration, vendor_calls_duration,#012 acd,#012 asr,#012 origination_cost ,termination_cost,#012 profit,#012 first_call_at, last_call_at#012 )#012 SELECT#012 536,#012 vendor_id, destination_prefix, dst_country_id, dst_network_id,#012 count(id), count(nullif((duration<=15 AND success),false)), count(nullif(success,false)),#012 sum(duration), sum(customer_duration), sum(vendor_duration),#012 sum(duration)::float/nullif(count(nullif(success,false)),0)::float, /* ACD /#012 count(nullif(success,false))::float/nullif(count(id),0)::float, / ASR */#012 sum(customer_price), sum(vendor_price),#012 sum(profit),#012 min(time_start), max(time_start)#012 from cdr.cdr#012 WHERE#012 time_start>=‘2020-03-27 00:00:00’#012 AND time_start<‘2020-03-28 00:00:00’#012 AND customer_id=17#012 GROUP BY vendor_id, destination_prefix, dst_country_id, dst_network_id):
] [FATAL]: app/models/yeti/active_record.rb:53:in perform_sp'#012app/models/yeti/active_record.rb:33:in execute_sp’#012app/models/yeti/active_record.rb:47:in block (2 levels) in <class:ActiveRecord>'#012app/models/report/customer_traffic.rb:48:in block in class:CustomerTraffic’#012app/jobs/jobs/report_scheduler.rb:10:in block (3 levels) in execute'#012app/jobs/jobs/report_scheduler.rb:8:in block (2 levels) in execute’#012app/jobs/base_job.rb:61:in block in capture_job_extra'#012lib/capture_error.rb:104:in with_extra’#012app/jobs/base_job.rb:61:in capture_job_extra'#012app/jobs/jobs/report_scheduler.rb:7:in block in execute’#012app/jobs/jobs/report_scheduler.rb:6:in execute'#012app/jobs/base_job.rb:23:in block in run!’#012app/jobs/base_job.rb:22:in run!'#012app/jobs/base_job.rb:50:in launch!’#012app/controllers/api/rest/system/jobs_controller.rb:6:in run'#012app/controllers/api_controller.rb:13:in db_logging’#012config/initializers/instrumentation_notification.rb:32:in block in process_action'#012config/initializers/instrumentation_notification.rb:31:in process_action’
thank you for your answer