SAP Knowledge Base Article - Preview

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


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!



SAP Hybris Commerce Version on HANA 10.


SAP hybris Commerce 5.7


KBA , CEC-COM-CPS , SAP Commerce , 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.