Sage EmailManager - error while setting eMail.body value

Excepion: jscript error: [SafeCall Exception]: List index out of bounds (0) Line: 270 Char: 1

Three weeks ago we upgraded our SCRM to the latest Version 2018.R2.
And since forever we are using the Sage EmailManager to send replys to our Customers, that a Ticket has been created.
But about 2 weeks ago the Manager throws an exception in both of our emailscripts, always when we try to set the value of eMail.Body.

For Example:

var templateBody = "My Email Body Text.";
eMail.Body = templateBody;

Or

eMail.Body = "My Email Body Text.";

If we remove this line and try sending the Email without writing something into the email.Body.
It works like a charm.

I've gone up and down through the script but i can't manage to find the problem.

Some ideas to that?

  • 0

    DNellesen, are you still having this issue? I just upgraded a client to 2018 R2 over the weekend and now they are getting the same error message when sending out emails through the emailManager. I would love to know what you did to fix it :-) Thanks in advance.

  • 0

    Hi Brad, we never realy did.

    I've implemented a workaround where I created an SQL-Server function and called it within the emailManager.

    function ISBSendMail(pProfile, pRecipients, pSubject, pBody, pSender)

    {

    var DBMailSQL = "EXEC msdb.dbo.sp_send_dbmail "+

    "@recipients='"+pRecipients+"', "+

    "@subject = '"+pSubject+"', "+

    "@body = '"+pBody.replace(/\n|\r/g, "")+"', "+

    "@body_format = 'HTML' , "+

    "@profile_name = '"+pProfile+"', " +

    "@from_address = '"+pSender+"'; ";

    MsgHandler.Log("DN LOG - "+DBMailSQL);

    var DBMailQuery = eWare.CreateQueryObj(DBMailSQL);

    DBMailQuery.ExecSql();

    }