Advertisement
Guest User

rate import log

a guest
Sep 4th, 2018
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.88 KB | None | 0 0
  1. mail_client_started | 2018-09-04 12:19:26,430 INFO === mail_client started ===
  2. mail_client_started | 2018-09-04 12:19:26,443 INFO Eml file created: "/var/www/html/invoice/inbox/eml-files/20180904_121926_431007.eml"
  3. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO
  4. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO An e-mail has been received
  5. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO FROM: uksellrates@idteurope.com
  6. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO TO: rates@viber.com, carlos.campoy@idt.net
  7. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO SUBJECT: "New Voice Rates for Viber Media Sarl Gold [TID:3118538]"
  8. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,323 INFO DATE: Mon, 03 Sep 2018 10:45:16 +0000 (UTC)
  9. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:27,324 INFO
  10. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,442 INFO EMAIL_VALIDITY_PERIOD_HOURS=10.0
  11. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,477 INFO
  12. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,477 INFO IMPORT_DEFAULT_INTERFACE=2
  13. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,477 INFO Default folder for email fetched files is <undef-import>
  14. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,477 INFO
  15. <201809031045.w83AjDmT009617@localhost.localdomain> | 2018-09-04 12:19:35,477 INFO The e-mail ignored as outdated according to the system parameter "Ignore emails older than 10.0 hours"
  16. mail_client_finished | 2018-09-04 12:19:35,480 INFO === mail_client finished ===
  17.  
  18.  
  19.  
  20. mail_client_started | 2018-09-04 10:17:50,612 INFO === mail_client started ===
  21. mail_client_started | 2018-09-04 10:17:50,624 INFO Eml file created: "/var/www/html/invoice/inbox/eml-files/20180904_101750_613586.eml"
  22. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO
  23. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO An e-mail has been received
  24. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO FROM: pricing@tatacommunications.com
  25. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO TO: rates@viber.com
  26. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO SUBJECT: "Registered: Tata Communications (Formerly Teleglobe/VSNL) Official
  27. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO Rate Addendum VTSPrime - VIBER MEDIA S.A.R.L.(VTSPRIME) (32859)(Customer
  28. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO Number= 39837)(Ref No=5301475)"
  29. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,182 INFO DATE: Tue, 4 Sep 2018 10:11:09 +0000
  30. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,183 INFO
  31. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,428 INFO EMAIL_VALIDITY_PERIOD_HOURS=10.0
  32. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,434 INFO
  33. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,434 INFO IMPORT_DEFAULT_INTERFACE=2
  34. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,434 INFO Default folder for email fetched files is <undef-import>
  35. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,434 INFO
  36. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,438 DEBUG
  37. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,438 DEBUG --- multipart/mixed ---
  38. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,438 DEBUG Content-Type is "multipart/mixed". Skipped.
  39. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,438 DEBUG
  40. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,438 DEBUG --- text/html ---
  41. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,439 INFO Mail part is considered as the message text
  42. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,439 DEBUG Part charset: ['utf-8']
  43. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,713 INFO Mail text was saved to file
  44. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,714 DEBUG
  45. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,714 DEBUG --- application/octet-stream ---
  46. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,714 INFO Attached file found.
  47. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,714 INFO File name before decoding: Amend_39837_ELISABETTATEDESCO.xls
  48. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,714 INFO File name after decoding: Amend_39837_ELISABETTATEDESCO.xls
  49. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,753 INFO Original file name: "Amend_39837_ELISABETTATEDESCO.xls"
  50. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,753 INFO Created file name: "/var/www/html/invoice/inbox/20180904_101751_714718_Amend_39837_ELISABETTATEDESCO.xls"
  51. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,753 INFO
  52. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,930 INFO Identified by email rule "" (id=10002):
  53. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,930 INFO Carrier "TATA" (id=199)
  54. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:51,968 INFO Voice product "CLI" (id=298)
  55. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,573 DEBUG DB error on call "api.exec_procedure" with params:
  56. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,574 DEBUG ['bas_import_utils.update_file_list', ['file_car_id', 'file_from_mail', 'file_type', 'file_md5', 'file_to_mail', 'file_product_id', '
  57. file_status', 'file_id', 'file_email_rule_id', 'file_date_delivered', 'file_original_name', 'file_mail_subject'], ['199', 'pricing@tatacommunications.com', '0', 'cf598dfe7ac77066a884461e47defc33', 'rates@viber.com', '298', '5', '20180904
  58. _101751_976210', '10002', '2018-09-04 10:11:09', 'Amend_39837_ELISABETTATEDESCO.xls', 'Registered: Tata Communications (Formerly Teleglobe/VSNL) Official\n Rate Addendum VTSPrime - VIBER MEDIA S.A.R.L.(VTSPRIME) (32859)(Customer\n Nu
  59. mber= 39837)(Ref No=5301475)']]
  60. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,574 DEBUG
  61. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 DEBUG File "/var/www/html/invoice/inbox/rate-import/20180904_101751_976210_Amend_39837_ELISABETTATEDESCO.xls" was deleted
  62. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-20000: invalid number
  63. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1227
  64. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1254
  65. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1366
  66. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1654
  67. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at line 1
  68. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.API", line 683
  69. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.API", line 113
  70. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,575 WARNING ORA-06512: at "INVOICE.API", line 688
  71. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,576 WARNING ORA-06512: at line 1
  72. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,576 WARNING
  73. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,576 INFO Email rule is last, file processing is stopped
  74. <5b8e5ab8.1c69fb81.16f7a.23a9SMTPIN_ADDED_BROKEN@mx.google.com> | 2018-09-04 10:17:52,576 DEBUG Source file "/var/www/html/invoice/inbox/20180904_101751_714718_Amend_39837_ELISABETTATEDESCO.xls" was deleted, it`s normal
  75. mail_client_finished | 2018-09-04 10:17:52,579 INFO === mail_client finished ===
  76.  
  77.  
  78.  
  79. mail_client_started | 2018-09-04 09:57:35,713 INFO === mail_client started ===
  80. mail_client_started | 2018-09-04 09:57:35,714 INFO Eml file created: "/var/www/html/invoice/inbox/eml-files/20180904_095735_714050.eml"
  81. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,803 INFO
  82. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,803 INFO An e-mail has been received
  83. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,803 INFO FROM: sell.rates@akton.si
  84. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,803 INFO TO: <rates@viber.com>, <lior@viber.com>, <rshmueli@viber.com>
  85. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,803 INFO SUBJECT: "Akton Pricelist"
  86. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,816 INFO DATE: Tue, 4 Sep 2018 11:51:12 +0200
  87. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:35,816 INFO
  88. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,012 INFO EMAIL_VALIDITY_PERIOD_HOURS=10.0
  89. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,018 INFO
  90. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,018 INFO IMPORT_DEFAULT_INTERFACE=2
  91. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,018 INFO Default folder for email fetched files is <undef-import>
  92. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,018 INFO
  93. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,022 DEBUG
  94. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,022 DEBUG --- multipart/mixed ---
  95. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,022 DEBUG Content-Type is "multipart/mixed". Skipped.
  96. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,023 DEBUG
  97. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,023 DEBUG --- text/plain ---
  98. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,023 INFO Mail part is considered as the message text
  99. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,023 DEBUG Part charset: ['windows-1252']
  100. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,023 INFO Decoding text with charset="windows-1252" detected by letter headers
  101. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 INFO Mail text was saved to file
  102. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 DEBUG
  103. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 DEBUG --- application/octet-stream ---
  104. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 INFO Attached file found.
  105. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 INFO File name before decoding: CPL_VIBER EUR_ZZT-201894-50130_.xls
  106. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,024 INFO File name after decoding: CPL_VIBER EUR_ZZT-201894-50130_.xls
  107. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,028 INFO Original file name: "CPL_VIBER EUR_ZZT-201894-50130_.xls"
  108. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,028 INFO Created file name: "/var/www/html/invoice/inbox/20180904_095736_025010_CPL_VIBER EUR_ZZT-201894-50130_.xls"
  109. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,028 INFO
  110. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,204 INFO Identified by email rule "" (id=10086):
  111. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,205 INFO Carrier "Akton" (id=223)
  112. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,264 INFO Voice product "CLI" (id=1400)
  113. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 DEBUG DB error on call "api.exec_procedure" with params:
  114. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 DEBUG ['bas_import_utils.update_file_list', ['file_car_id', 'file_from_mail', 'file_type', 'file_md5', 'file_to_mail', 'file_product_id', 'file_status', 'file_id', 'file_email_rule_id', 'file_date_delivered', 'file_original_name', 'file_mail_subject'], ['223', 'sell.rates@akton.si', '0', 'f4ec2869c710a87a129e0d32655c2aeb', 'lior@viber.com, rates@viber.com, rshmueli@viber.com', '1400', '5', '201809
  115. 04_095736_266108', '10086', '2018-09-04 09:51:12', 'CPL_VIBER EUR_ZZT-201894-50130_.xls', 'Akton Pricelist']]
  116. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 DEBUG
  117. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 DEBUG File "/var/www/html/invoice/inbox/rate-import/20180904_095736_266108_CPL_VIBER EUR_ZZT-201894-50130_.xls" was deleted
  118. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 WARNING ORA-20000: trigger 'INVOICE.LOG_BAS_FILE_TR' is invalid and failed re-validation
  119. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,282 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1285
  120. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1363
  121. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at "INVOICE.BAS_IMPORT_UTILS", line 1654
  122. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at line 1
  123. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at "INVOICE.API", line 683
  124. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at "INVOICE.API", line 113
  125. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at "INVOICE.API", line 688
  126. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING ORA-06512: at line 1
  127. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 WARNING
  128. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 INFO Email rule is last, file processing is stopped
  129. <20180904095112676.A1DBEE19C695BD66@n-tmodic2> | 2018-09-04 09:57:36,283 DEBUG Source file "/var/www/html/invoice/inbox/20180904_095736_025010_CPL_VIBER EUR_ZZT-201894-50130_.xls" was deleted, it`s normal
  130. mail_client_finished | 2018-09-04 09:57:36,284 INFO === mail_client finished ===
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement