Start a conversation

Error "Couldn't find info for column" when using segments

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:

  1. Go to "Mailings : Mailing Status : Mail Queues : Outgoing" and look for the messageID logged in the error message (ID 398728, in our example).
  2. Check if you are using merge tags for mtbcrmcaslid and mtbsenderemail or if you are using a segment for this message.
  3. If you're using merge tags, check if they're malformed or if there's a misconfiguration.
  4. 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.

 

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Priyanka Bhotika

  2. Posted
  3. Updated

Comments