Overview
When you send a mailing to a segment errors similar to the ones below may be noticed in LM's logs:
20210310 021237, 30, 2, 4576, "MessageData.cpp, line:336", "MessageData (MessageID=398728): Couldn't find info for column 'mtbcrmcaslid' in table 'members_'."
20210310 021237, 30, 2, 4576, "MessageData.cpp, line:336", "MessageData (MessageID=398728): Couldn't find info for column 'mtbsenderemail' in table 'members_'."
Solution
In a message, most likely in a segment, there are references to columns that do not exist in the members_
table:
- Go to "Mailings : Mailing Status : Mail Queues : Outgoing" and look for the
messageID
logged in the error message (ID 398728, in our example). - Check if you are using merge tags for
mtbcrmcaslid
andmtbsenderemail
or if you are using a segment for this message. - If you're using merge tags, check if they're malformed or if there's a misconfiguration.
- If you're using a segment, check the segment query.
Note that message ID, columns, and table name are valid for this example and may be different in your log messages.