SHARE
TWEET

Untitled

a guest Feb 14th, 2020 249 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Connection RTS properties
  2. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Active connections: 0
  3. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Idle connections: 10
  4. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Total connections: 10
  5. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Threads Awaiting Connection: 0
  6. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Get data from RTS DB
  7. 2020-02-14 10:49:07.740  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Execute SQL in RTS DB: SELECT v.VN_BS_NUM, VN_BS_GFK,
  8. VN_CMR_SPR, p.BS_GPO_SHORT_NAME, p.BS_GPO_FULL_NAME
  9. FROM RTS_MAIN.rts_dat_new_ni_rollout_veon_v v
  10. JOIN RTS_MAIN.rts_spr_bs_gpo p  ON p.bs_gpo_id = v.VN_CMR_SPR
  11. WHERE
  12. (VN_BS_GFK = 'MRB00RUROS069072'   OR   VN_BS_GFK = 'MRB00RUROS069072')
  13. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Connection RTS properties
  14. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Active connections: 0
  15. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Idle connections: 10
  16. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Total connections: 10
  17. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Threads Awaiting Connection: 0
  18. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Sending letter to [perevertkinma@gmail.com, test_xena@mail.ru, perevertkinma@gmail.com]
  19. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Subject:  ❌ В RTS для сайта MRB00RUROS069072 отсутствует подрядчик.
  20. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : From xena.functional@nokia.com
  21. 2020-02-14 10:49:07.752  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : throw SMTP smtp.office365.com port 587
  22. 2020-02-14 10:49:07.754  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - begin waiting
  23. 2020-02-14 10:49:09.783  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - end waiting
  24. 2020-02-14 10:49:10.575  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Sending letter to [perevertkinma@gmail.com, test_xena@mail.ru]
  25. 2020-02-14 10:49:10.575  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Subject: Сайт MRB00RUROS069072 закрыт к монтажу. У ПО ООО «ДЕЛЬТА» есть оборудование к возврату.
  26. 2020-02-14 10:49:10.575  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : From xena.functional@nokia.com
  27. 2020-02-14 10:49:10.575  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : throw SMTP smtp.office365.com port 587
  28. 2020-02-14 10:49:10.577  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - begin waiting
  29. 2020-02-14 10:49:12.465  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - end waiting
  30. 2020-02-14 10:49:12.465  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.resources.SiteResource     : GetLastSiteMontageContractor
  31. 2020-02-14 10:49:12.465  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.resources.SiteResource     : SELECT
  32. u.company_id AS  contractor_id,
  33. o.name AS  contractor_name,
  34. max(date)  as last_modified_date
  35. FROM montage m
  36. JOIN em_user u on m.user_username = u.username
  37. JOIN org o on o.id  = u.company_id
  38. WHERE site_id = 175092
  39. GROUP BY contractor_id, o.name
  40. ORDER BY max(date) DESC
  41. LIMIT 1
  42. 2020-02-14 10:49:12.468  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Get data from RTS DB
  43. 2020-02-14 10:49:12.468  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Execute SQL in RTS DB: SELECT v.VN_BS_NUM, VN_BS_GFK,
  44. VN_CMR_SPR, p.BS_GPO_SHORT_NAME, p.BS_GPO_FULL_NAME,
  45. UPPER(REPLACE(REPLACE(REPLACE(REPLACE(p.BS_GPO_SHORT_NAME,'"',''),'«',''),'»',''),' ','')) AS BS_GPO_SHORT_NAME_1,
  46. UPPER(REPLACE(REPLACE(REPLACE(REPLACE(p.BS_GPO_FULL_NAME,'"',''),'«',''),'»',''),' ','')) AS BS_GPO_FULL_NAME_1
  47. FROM RTS_MAIN.rts_dat_new_ni_rollout_veon_v v
  48. JOIN RTS_MAIN.rts_spr_bs_gpo p  ON p.bs_gpo_id = v.VN_CMR_SPR
  49. WHERE
  50. (UPPER(REPLACE(REPLACE(REPLACE(REPLACE(p.BS_GPO_SHORT_NAME,'"',''),'«',''),'»',''),' ','')) = 'ОООВНИЦРАДИОСИСТЕМЫ'
  51. OR UPPER(REPLACE(REPLACE(REPLACE(REPLACE(p.BS_GPO_FULL_NAME,'"',''),'«',''),'»',''),' ','')) = 'ОООВНИЦРАДИОСИСТЕМЫ')
  52. AND (VN_BS_GFK = 'MRB00RUROS069072'   OR   VN_BS_GFK = 'MRB00RUROS069072')
  53. 2020-02-14 10:49:12.485  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Connection RTS properties
  54. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Active connections: 0
  55. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Idle connections: 10
  56. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Total connections: 10
  57. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Threads Awaiting Connection: 0
  58. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Get data from RTS DB
  59. 2020-02-14 10:49:12.486  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Execute SQL in RTS DB: SELECT v.VN_BS_NUM, VN_BS_GFK,
  60. VN_CMR_SPR, p.BS_GPO_SHORT_NAME, p.BS_GPO_FULL_NAME
  61. FROM RTS_MAIN.rts_dat_new_ni_rollout_veon_v v
  62. JOIN RTS_MAIN.rts_spr_bs_gpo p  ON p.bs_gpo_id = v.VN_CMR_SPR
  63. WHERE
  64. (VN_BS_GFK = 'MRB00RUROS069072'   OR   VN_BS_GFK = 'MRB00RUROS069072')
  65. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Connection RTS properties
  66. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Active connections: 0
  67. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Idle connections: 10
  68. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Total connections: 10
  69. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.b.service.ContractorRtsService     : Threads Awaiting Connection: 0
  70. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Sending letter to [perevertkinma@gmail.com, test_xena@mail.ru, perevertkinma@gmail.com]
  71. 2020-02-14 10:49:12.497  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Subject:  ❌ В RTS для сайта MRB00RUROS069072 отсутствует подрядчик.
  72. 2020-02-14 10:49:12.498  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : From xena.functional@nokia.com
  73. 2020-02-14 10:49:12.498  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : throw SMTP smtp.office365.com port 587
  74. 2020-02-14 10:49:12.499  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - begin waiting
  75. 2020-02-14 10:49:14.428  INFO 1398 --- [http-nio-8086-exec-7] r.r.m.backend.service.EmailService       : Call SMTP - end waiting
  76. 2020-02-14 10:50:04.076  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : End receiving mail with simple (non-outlook) box
  77. 2020-02-14 10:50:04.076  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Begin execute afterLoadFiles
  78. 2020-02-14 10:50:04.085  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : End execute afterLoadFiles
  79. 2020-02-14 10:50:04.085  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : End processing mail
  80. 2020-02-14 10:53:04.085  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Begin processing mail
  81. 2020-02-14 10:53:04.087  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Database: jdbc:postgresql://10.215.1.109:5432/mounting
  82. 2020-02-14 10:53:04.087  INFO 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Begin receiving mail with simple (non-outlook) box
  83. 2020-02-14 10:53:04.087 ERROR 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Receiving mails:  simple (non Outlook) box
  84. 2020-02-14 10:53:04.087 ERROR 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Receiving mails:  mailUserName =  stage.xena.vk@yandex.ru
  85. 2020-02-14 10:53:04.087 ERROR 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Receiving mails:  imapHost =  imap.yandex.ru
  86. 2020-02-14 10:53:04.088 ERROR 1398 --- [scheduling-1] r.r.m.b.schedulers.MailReceiveScheduler  : Receiving mails:  imapPort =  993
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top