SAP Knowledge Base Article - Preview

2474249 - Email business process errors because of body exceeds 5000 character limit

Symptom

Getting errors on some of email business processes because of the column P_BODY in the table EMAILMESSAGE. 

We can see this column is limited by default to 5000 characters for SAP databases (core-advanced-deployment.xml).

This is very short for an e-mail body, especially when styling is included.

Good practice is avoid custom column mappings. For text columns consider these 3 options:

  1. Default Size
  2. For storing medium size texts
  3. For large texts exceeding 4000 characters ( or rather: 2000 unicode characters ) must be manually mapped as CLOB (for Oracle DB), NCLOB (for SAP DB), but you must be aware of the fact that the content may not be query-able on all databases!

Read more...

Environment

SAP Hybris Commerce Version 5.7.0.3 on HANA 10.

Product

SAP hybris Commerce 5.7

Keywords

KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Hybris) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.