After creating four new business rules copied from other simiar working rules, three of the four do not deliver an email. This has occured several times in the past with prior versions of stat. Resolution is to create another rule from scratch with EXACT criteria and To/CC recipients.
The error message tells us that the problem is in table MERC_EMAIL_CFG_DIST in a Business Rule e-mail recipient is “Customer Specified” i.e MERC_EMAIL_CFG_DIST.DIST_TYPE = ‘K’. In that case, the Stat Agent expects MERC_EMAIL_CFG_DIST.MSG_VAL1 to be a number, the value that represents a customer id. Apparently on customer database MERC_EMAIL_CFG_DIST.MSG_VAL1 is not a number.
SELECT * FROM MERC_EMAIL_CFG_DIST WHERE DIST_TYPE = 'K'
There is an issue with the copy functions where the msg_val1 is not being populated with the customer id. Here is the workaround:
1. Go to the sent to tab | remove the customer/specified. Make sure to click apply and Ok
2. Now go back to the same rule and re-add the customer/specified field
3. If you query for SELECT * FROM MERC_EMAIL_CFG_DIST WHERE DIST_TYPE = 'K'. You should see the customer id #.
Waiting for fix in a future release of Stat