beowulf1416

Untitled

Aug 18th, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. 2015-08-18 16:39:17 ERROR ERROR : Delayed::WorkerTimeout: execution expired (Delayed::Worker.max_run_time is only 600 seconds):
  2. select
  3. a.minutes,
  4. de.did_e164,
  5. dep.title clec,
  6. a.carrier_title
  7. from data_entryway de
  8. inner join data_entryway_provider dep on de.entryway_provider = dep.id
  9. left join (
  10. select
  11. sc.entryway_id,
  12. dlac.title carrier_title,
  13. sum(sc.seconds / 60) minutes
  14. from summary_call sc
  15. inner join data_listener_ani_carrier dlac on dlac.id = sc.listener_ani_carrier_id
  16. where sc.date >= '2015-08-17'
  17. and sc.date < '2015-08-18'
  18. group by sc.entryway_id
  19. ) a on de.id = a.entryway_id
  20. left join reachout_tab_mapping_rule rtmr on dep.title = rtmr.entryway_provider and a.carrier_title = rtmr.carrier_title
  21. where de.is_deleted = 0
  22. and substr(de.did_e164,1,4) not in ('1600','1700')
  23. and dep.title in
  24. (
  25. select distinct rtmr2.entryway_provider
  26. from reachout_tab_mapping_rule rtmr2
  27. )
  28. and de.gateway_id = '618'
  29. group by de.entryway_provider
  30. order by a.minutes desc
Advertisement
Add Comment
Please, Sign In to add comment