function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SATHISH REDDY.SATHISH REDDY. 

System.EmailTemplateRenderException: UNKNOWN_EXCEPTION: StringPlusClobField: clob inconsistent with varchar, and unable to clean varchar

Hi,

I am seeing this error in the recent times when clicked on an image on VF page which calls the following method previewEmail(). (This error was never seen befoere since the past 2 years). Also please find the error message screen shots received by multiple users while clicking the image. This error is inconsistent & hard to replicate.

Error Line as per logs - "emailBody = Messaging.renderStoredEmailTemplate(templateId, con.Id, accId);"
public PageReference previewEmail(){
        Id accId = ApexPages.currentPage().getParameters().get('accId');
        Messaging.SingleEmailMessage emailBody;
        Id templateId = [SELECT DeveloperName,Id,IsActive,Name FROM EmailTemplate where DeveloperName =: 'Account_Mass_Info'].Id;
        string[] sendingTo = new String[]{};
        for (Email_to_users_List__c cs : Email_to_users_List__c.getall().values()){
            sendingTo.add(cs.Email_List__c);
        } 
        Contact con = new Contact();
        con.FirstName = 'Test';
        con.LastName = 'Contact';
        con.Email = 'no-reply@organization.com';
        con.Title = 'Test Title';
        insert con;
/*Line 271*/   emailBody = Messaging.renderStoredEmailTemplate(templateId, con.Id, accId);
        emailWrap = new emailWrapper(sendingTo, emailBody.getHTMLBody());
        //Use Delete to delete the 'Test Contact'
        Delete con;
        Return null;             
    }
Error Log:
01:10:45.0 (760618096)|EXCEPTION_THROWN|[271]|System.EmailTemplateRenderException: UNKNOWN_EXCEPTION: StringPlusClobField: clob inconsistent with varchar, and unable to clean varchar

01:10:45.0 (760973008)|SYSTEM_MODE_EXIT|false
01:10:45.0 (761229722)|FATAL_ERROR|System.EmailTemplateRenderException: UNKNOWN_EXCEPTION: StringPlusClobField: clob inconsistent with varchar, and unable to clean varchar


Class.AccListMassUpdateStatusTABController_AC.previewEmail: line 271, column 1
for User 1:
Redirected to this Error page

for User 2:
Redirected to this Error Page


Any help is really appreciated.

Thanks,
Sathish
 
NagendraNagendra (Salesforce Developers) 
Hi Sathish,

Seems, nothing wrong with the code.

May I suggest you please reach out to the Salesforce support team for a better assistance on the above issue.

You may reach the support team at the below email address. Thanks,
Nagendra
 
SATHISH REDDY.SATHISH REDDY.
@Nagendra - Thanks for your response. Will they be able to help me with this issue as we only have basic support.