SuiteCRM 8.9.3 campaign issues

đź’¬ General Discussion
1

Hi there,

I am having an issue with the camapigns.
I created an email template, and 3 target lists and a campaign.
my goal is to schedule a campaign to send the same message (email) to the 3 different target lists at a 3 different time

image
image1882Ă—630 36.5 KB

after scheduling the first batch is sent correctly but the 2 others are stuck in the queue:
(the test emails in the target lists are defferent emails I own)

image
image1514Ă—209 13.9 KB

associated message in the log :[FATAL] Error retrieving template for the email campaign. marketing_id = ca7e469b-e6a6-439e-bf52-cece53bd0901.

at this stage I cannot delete the emails from the queue

I am probably doing something wrong, but I don’th know what.
any Idea or a tutorial :wink:

2

Related: Fix #862 -Legacy campaign send to prefer Email Marketing content over template by eleknader · Pull Request #876 · SuiteCRM/SuiteCRM-Core · GitHub

3

thanks,
this issue is happening on suite CRM 8.9.3. the video is on 7.15. the process there is slightly different.

however, I think the campaigns are properly done as the first batch is sent correctly. Only the following batches on the same campain have this issue (not finding the email template, preventing the next batches of emails to be sent) the first time the template is correctly found.

the question is more about sending multiple batches in the same campaign with the same email template

4

I’m not sure which version exactly it started, but the scheduled jobs chaned there are two new scheduler jobs to add to send and queue campaigns in SuiteCRM 8..

5

Thanks, I made the chage, now waitting next batch running on monday.
I will let you know if it works

6

Threre is also a new server job to run, it doesn’t run under the legacy cron.

7

I put this together after a day of testing. Thought you might find it useful.

3 Likes
8

You’ve outdone yourself this time, Paul!

That’s great work :clap:

Thanks

1 Like
9

I put this together after a day of testing. Thought you might find it useful.

Thanks @pgr I’m like the worst user in the World so I run into all the roadblocks all at the same time! LOL!

2 Likes
10

thanks alot for that!

so the campaign was till in the queue and didn’t go through.

so I added manually the template ID in the table email_marketing to the campaign and the emails went through .

11

Did you have all the right jobs running? Seems odd that this would happen under normal processes. Or maybe you had campiagns scheduled in between upgrades? Maybe that could cause that. With all the right jobs running, I had no issue sending the campaign once all the steps were done.

It really is way too complicated to send an email campaign. There’s so many little nuances and if you miss one, it doesn’t send.

12

the 3 schedulers are ok and renning designated time. So I am wodering if there is a restriction : can you send the same template in different campaigns?

13

You should be able to, although I didn’t go as far as testing specific templates, just wanted to make sure I covered the basic “getting it to send, and what can go wrong covered”… I’ll do some more testing with actual templates and see what impact that does.

14

actually what I am trying to acheive is:

I split my target list in several lists (groupped by location) .
I am scheduling sent over a week (one every day)
1 email template, the same for all for all.

the result I am getting is:
the first batch is sent ok, the folowwing batches are stuck in the queue

15

We have a topic on the similar issue.