none
SharePoint 2010 workflows add random characters into email RRS feed

  • Question

  • Hi all,

    since we patched our SharePoint 2016 Server (April Update) we experience a problem with 2010 Workflows. The 2013 Workflow Manager is not installed on the Server.

    Everytime a Workflow sends an email it generates some random characters. Most of the time it's a whitespace or "!". It happens for old or new Workflows the same.

    Is somebody experience the same issue? How can I troubleshoot this Problem?

    Any help is appreciated.

    //Igor

    Monday, May 15, 2017 9:30 AM

Answers

  • Had a support case with Microsoft and received this statement:

    Symptom:

    SharePoint 2010 workflow when sending mails with text which contains more than 998 characters lines, are not correctly displayed when using Linux mail server.

    When using Exchange Server as mail server the text is correctly displayed.

     

    Cause:

    3<sup>rd</sup> party SMTP Server is unable to handle html email in a single line with more than 998 characters lines

     

    Resolution:

    By Design SharePoint 2010 workflows are sending the html email in a single line.

    Use MS Exchange which is able to handle  larger than 1000 characters lines,


    So we had a Linux Mail Server as SMTP Outgoing but SharePoint only works with Exchange.


    • Marked as answer by Igor, B Tuesday, December 19, 2017 1:13 PM
    • Edited by Igor, B Tuesday, December 19, 2017 1:16 PM
    Tuesday, December 19, 2017 1:13 PM

All replies

  • Hi,

    Could you provide a screenshot about how you configure the email contents in the designer workflow?

    And provide a screenshot about the email you received, I want to know which location of the email body the random character in.

    If you send email with simple conteng e.g. "Hello World!", will the issue occur?

    Thanks,

    Dean Wang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, May 19, 2017 8:06 AM
    Moderator
  • Hi Dean,

    thank you for your help.

    Based on your questions I have made some new tests. I'm using SharePoint Designer 2013 to create these workflows.

    My "design":

    <HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD> <META name=GENERATOR content="MSHTML 11.00.10570.1001"></HEAD> <BODY> <P><FONT face="Segoe UI">Hello World!</FONT></P></BODY></HTML>



    When I have only written "Hello World!" I have received a correct email. No random characters anymore.

    Then I have added some lookup information from the list - but it still was correct, no issues.

    Lastly, I have put some random text which is quite long into the sendmail command.

    <HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD> <META name=GENERATOR content="MSHTML 11.00.10570.1001"></HEAD> <BODY> <P>Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. If we landlord stanhill mr whatever pleasure supplied concerns so. Exquisite by it admitting cordially september newspaper an. Acceptance middletons am it favourable. It it oh happen lovers afraid. </P> <P>Attention he extremity unwilling on otherwise. Conviction up partiality as delightful is discovered. Yet jennings resolved disposed exertion you off. Left did fond drew fat head poor. So if he into shot half many long. China fully him every fat was world grave. </P> <P>Written enquire painful ye to offices forming it. Then so does over sent dull on. Likewise offended humoured mrs fat trifling answered. On ye position greatest so desirous. So wound stood guest weeks no terms up ought. By so these am so rapid blush songs begin. Nor but mean time one over. </P> <P>By impossible of in difficulty discovered celebrated ye. Justice joy manners boy met resolve produce. Bed head loud next plan rent had easy add him. As earnestly shameless elsewhere defective estimable fulfilled of. Esteem my advice it an excuse enable. Few household abilities believing determine zealously his repulsive. To open draw dear be by side like. </P> <P>On projection apartments unsatiable so if he entreaties appearance. Rose you wife how set lady half wish. Hard sing an in true felt. Welcomed stronger if steepest ecstatic an suitable finished of oh. Entered at excited at forming between so produce. Chicken unknown besides attacks gay compact out you. Continuing no simplicity no favourable on reasonably melancholy estimating. Own hence views two ask right whole ten seems. What near kept met call old west dine. Our announcing sufficient why pianoforte. </P> <P>Son agreed others exeter period myself few yet nature. Mention mr manners opinion if garrets enabled. To an occasional dissimilar impossible sentiments. Do fortune account written prepare invited no passage. Garrets use ten you the weather ferrars venture friends. Solid visit seems again you nor all. </P> <P>Sportsman do offending supported extremity breakfast by listening. Decisively advantages nor expression unpleasing she led met. Estate was tended ten boy nearer seemed. As so seeing latter he should thirty whence. Steepest speaking up attended it as. Made neat an on be gave show snug tore. </P> <P>Her old collecting she considered discovered. So at parties he warrant oh staying. Square new horses and put better end. Sincerity collected happiness do is contented. Sigh ever way now many. Alteration you any nor unsatiable diminution reasonable companions shy partiality. Leaf by left deal mile oh if easy. Added woman first get led joy not early jokes. </P> <P>Ask especially collecting terminated may son expression. Extremely eagerness principle estimable own was man. Men received far his dashwood subjects new. My sufficient surrounded an companions dispatched in on. Connection too unaffected expression led son possession. New smiling friends and her another. Leaf she does none love high yet. Snug love will up bore as be. Pursuit man son musical general pointed. It surprise informed mr advanced do outweigh. </P> <P>Are own design entire former get should. Advantages boisterous day excellence boy. Out between our two waiting wishing. Pursuit he he garrets greater towards amiable so placing. Nothing off how norland delight. Abode shy shade she hours forth its use. Up whole of fancy ye quiet do. Justice fortune no to is if winding morning forming. </P> <P>&nbsp;</P></BODY></HTML>

    Now I get this result every time:

    <Start of E-Mail>

    Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. If we landlord stanhill mr whatever pleasure supplied concerns so. Exquisite by it admitting cordially september newspaper an. Acceptance middletons am it favourable. It it oh happen lovers afraid.

    Attention he extremity unwilling on otherwise. Conviction up partiality as delightful is discovered. Yet jennings resolved disposed exertion you off. Left did fond drew fat head poor. So if he into shot half many long. China fully him every fat was world grave.

    !

    Writt en enquire painful ye to offices forming it. Then so does over sent dull on. Likewise offended humoured mrs fat trifling answered. On ye position greatest so desirous. So wound stood guest weeks no terms up ought. By so these am so rapid blush songs begin. Nor but mean time one over.

    <End of E-Mail>

    The "!" character was not in the original text.

    So this seems to be related with long texts? I'll do some additional tests later with some special characters (German stuff like Ä,Ö).

    And sorry, I can't paste pictures in the text. Maybe I'm too new here?

    Kind Regards,
    Igor

    Friday, May 19, 2017 8:56 AM
  • Just tested it with some special character. The special characters are displayed correctly.

    But the whitespaces and "!" still appeared. I have triggered the workflow 3 times and it was each time the same email now for several recipients. Very strange..

    Friday, May 19, 2017 1:33 PM
  • Hi,

    I copied the body you provided in my email, and it works fine:

    Do you use the “Send Email” action in the designer workflow? Or any other action?

    Thanks,

    Dean Wang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Monday, May 22, 2017 7:14 AM
    Moderator
  • Hi Dean,

    yes, I'm using the "Send Email" action in SharePoint Designer.

    I have also updated the language pack for SharePoint 2016. Maybe it's related to that?
    Is there any way to go back or to uninstall it?

    Kind Regards,
    Igor

    Monday, May 22, 2017 8:49 PM
  • Hi,

    I have installed a newer language pack and SP2016 Update. But still the same issue..

    Friday, June 16, 2017 5:53 PM
  • Hi everyone,

    our consultants have found out why this happens.

    The SharePoint 2010 Workflow Engine in SharePoint 2016 Server sends the E-Mail text in one line.
    But the RFC 2822 states that only 1000 characters are allowed in one HTML message line.
    That's why it behaves so strange.

    So that's obviously a bug in the SharePoint 2010 Workflow Engine and it's likely that there is no workaround (we haven't found out one). Now we have to install the Workflow Manager 2013 und test it with that.

    BR,
    Igor

    References:

    https://www.reddit.com/r/sharepoint/comments/4lx01e/sharepoint_2016_sp_designer_emails_have_random/

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_winother/outlook-2013-adding-random-exclamation-marks-to/86280930-d026-4f91-9819-fc3fc383fb44

    • Marked as answer by Igor, B Friday, July 14, 2017 11:57 AM
    • Unmarked as answer by Igor, B Tuesday, December 19, 2017 1:13 PM
    Friday, July 14, 2017 11:57 AM
  • Had a support case with Microsoft and received this statement:

    Symptom:

    SharePoint 2010 workflow when sending mails with text which contains more than 998 characters lines, are not correctly displayed when using Linux mail server.

    When using Exchange Server as mail server the text is correctly displayed.

     

    Cause:

    3<sup>rd</sup> party SMTP Server is unable to handle html email in a single line with more than 998 characters lines

     

    Resolution:

    By Design SharePoint 2010 workflows are sending the html email in a single line.

    Use MS Exchange which is able to handle  larger than 1000 characters lines,


    So we had a Linux Mail Server as SMTP Outgoing but SharePoint only works with Exchange.


    • Marked as answer by Igor, B Tuesday, December 19, 2017 1:13 PM
    • Edited by Igor, B Tuesday, December 19, 2017 1:16 PM
    Tuesday, December 19, 2017 1:13 PM