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:
- Default Size
- For storing medium size texts
- 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 188.8.131.52 on HANA 10.
KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Commerce) , Problem
About this pageThis 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.