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 for Me (Login required).

Search for additional results

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