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 5.7.0.3 on HANA 10.

KBA , CEC-COM-CPS , SAP Commerce , Problem