API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 14th, 2020
359
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.39 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!