bug when sending mailing with multiple target group
Posted: Fri Apr 11, 2014 4:06 pm
Hi,
I've faced issue with sending dynamic content (multiple content for multiple target group). The log output is below. I'm using OpenEMM 2013 R2, on Ubuntu 12.04 64bit. Everything is fine until I test dynamic content feature.
The output on GUI is "Error in dyn tags." The log from file 20140411-openemm-01-mailgun.log
===
[11.04.2014 15:03:44] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error1408408869775560055.tmp, -opreview:path=/home/openemm/temp/preview5650335494561699500.xml, /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz] returns 1:
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Error in parsing:
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
Error description:
Syntax error hit.
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
*
Failed in parsing.
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Unable to setup condition for DynID 277 in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Unable to find valid element dyncont in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics: Unable to find valid element dynamic in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail: Unable to find valid element dynamics in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error1408408869775560055.tmp, -opreview:path=/home/openemm/temp/preview5650335494561699500.xml, /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz] failed (Missing binary? Wrong permissions?): java.lang.Exception: command returns 1 (1181)
[11.04.2014 15:03:45] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error5440456575973078342.tmp, -opreview:path=/home/openemm/temp/preview4822611061111926102.xml, /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz] returns 1:
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Error in parsing:
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
Error description:
Syntax error hit.
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
*
Failed in parsing.
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Unable to setup condition for DynID 277 in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Unable to find valid element dyncont in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics: Unable to find valid element dynamic in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail: Unable to find valid element dynamics in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error5440456575973078342.tmp, -opreview:path=/home/openemm/temp/preview4822611061111926102.xml, /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz] failed (Missing binary? Wrong permissions?): java.lang.Exception: command returns 1 (1181)
===
I google alot but not finding solutions yet.
Please help.
Thank you.
I've faced issue with sending dynamic content (multiple content for multiple target group). The log output is below. I'm using OpenEMM 2013 R2, on Ubuntu 12.04 64bit. Everything is fine until I test dynamic content feature.
The output on GUI is "Error in dyn tags." The log from file 20140411-openemm-01-mailgun.log
===
[11.04.2014 15:03:44] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error1408408869775560055.tmp, -opreview:path=/home/openemm/temp/preview5650335494561699500.xml, /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz] returns 1:
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Error in parsing:
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
Error description:
Syntax error hit.
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
*
Failed in parsing.
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Unable to setup condition for DynID 277 in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics->dynamic: Unable to find valid element dyncont in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail->dynamics: Unable to find valid element dynamic in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] 8891 ERROR/blockmail: Unable to find valid element dynamics in /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:44] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error1408408869775560055.tmp, -opreview:path=/home/openemm/temp/preview5650335494561699500.xml, /home/openemm/var/spool/META/AgnMail=D20140411150344=1=76=00001=liaMngA.xml.gz] failed (Missing binary? Wrong permissions?): java.lang.Exception: command returns 1 (1181)
[11.04.2014 15:03:45] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error5440456575973078342.tmp, -opreview:path=/home/openemm/temp/preview4822611061111926102.xml, /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz] returns 1:
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Error in parsing:
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
Error description:
Syntax error hit.
( date_format(cust.SEND_DATE, '%Y%m%d') = date_format(date_sub(now(), interval 0 day), '%Y%m%d') AND cust.REGISTER_COUNT > 0)
*
Failed in parsing.
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Unable to setup condition for DynID 277 in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics->dynamic: Unable to find valid element dyncont in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail->dynamics: Unable to find valid element dynamic in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] 8893 ERROR/blockmail: Unable to find valid element dynamics in /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz
[11.04.2014 15:03:45] ERROR/writer/meta/(1/8/76/-1): command [/home/openemm/bin/xmlback, -r, -q, -l, -E/home/openemm/temp/error5440456575973078342.tmp, -opreview:path=/home/openemm/temp/preview4822611061111926102.xml, /home/openemm/var/spool/META/AgnMail=D20140411150345=1=76=00001=liaMngA.xml.gz] failed (Missing binary? Wrong permissions?): java.lang.Exception: command returns 1 (1181)
===
I google alot but not finding solutions yet.
Please help.
Thank you.