Search Engine: Elastic

Article ID: 131473, created on Sep 16, 2017, last review on Sep 16, 2017

  • Applies to:
  • Business Automation 7.0

Symptoms

Notifications are not sent after migration to CentOS 7. The following entries can be found in billing.log:

[17-04-21 13:24:45.241 billing     RQ65769 TH03069 NTE] [29855] Exclusively locking a row (MailID=2497528) in table MailMsg
[17-04-21 13:24:45.241 RDBMS       RQ65769 TH03069 INF] Prepare [0x7f72785a9f60]: SELECT "MailID", "Direction", "Status", "CollectorID", "To", "From", "Subject", "Comment", "Message", "UserArc", "DateArc" FROM "MailMsg" WHERE "MailID" = $1 FOR UPDATE
[17-04-21 13:24:45.241 RDBMS       RQ65769 TH03069 INF] Execute [0x7f72785a9f60]: 2497528
[17-04-21 13:24:45.241 RDBMS       RQ65769 TH03069 INF] Service execute [0x7f7278164cb0_0]: BEGIN (implicit on previous command)
[17-04-21 13:24:45.243 RDBMS       RQ65769 TH03069 DBG] Fetch [0x7f72785a9f60]: 2497528, 2, 12, <NULL>, <NULL>, 'Provider <no-reply@provider.com>', 'Payemnt 1,440.00 USD  received', 'mailsmtp_data failed with code error 14:'Transaction failed'', <BLOB>, -1, 1492765920
[17-04-21 13:24:45.272 billing     RQ65769 TH03069 FTL] Terminated; Minidump: /usr/local/bm/var/dump/00000b81-0fdc-38d8-2aea10ce-0df69f90.dmp

Cause

The issue #PBA-80225 "Notifications are not sent and AMAIL container crashes Billing when "To" in "MailMsg" is empty"

Resolution .

For a workaround, please, refer to the following KB article.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 c0f836394088a28cc30dd0e5fe8b600e b2c3b33425dfc50c7d41a2efaa7f84f3

Email subscription for changes to this article
Save as PDF