Symptom
When adding a large amount of text into 'Predefine Email Body', the system throws the error "String or binary data would be truncated in table", indicating that the data being inserted is too long.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
- Go to Setup
- Go to quotes
- Document Generation Template
- Choose Tab "General Settings" and modify field "Predefine Email Body"
- After adding further formula and with clicking "Save".
Cause
- There is a limitation of 2000 characters.
- Currently there is no validation in place for the limitation, which is why there is a fatal error.
Resolution
- Character limit is set to 2000.
- Development are working on the issue to add validation for that field. If a user tries to save a predefined email body with more than 2000 characters, they will receive a user-friendly error message.
- This has a tentative fix version for 2508.
See Also
3487591 - Known Issues in SAP CPQ
Keywords
Predefine email body, Document Generation Template, Character limit, 2000 , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem
Product
SAP CPQ all versions