Applies to Pega Platform versions 8.3.3 through 8.4.6 and Pega Customer Service versions 8.3 through 8.4
Symptoms
When you create email correspondence or email interaction for a case using an Email Listener or Email Channel, an error occurs for several email messages. Log analysis shows a problem with saving the property Data-NLP-Report-Summary.pyText when the email body exceeds 4000 characters.
Case creation also fails.
Error
DatabaseException caused by prior exception: java.sql.SQLException: ORA-12899: value too large for column "PEGA_DATA"."PR_DATA_NLP_SUMMARY"."PYTEXT" (actual: 4041, maximum: 4000)
Explanation
The column pyText of the table pr_data_nlp_summary is exposed in the Customer Service layer, which has a dedicated column size. If the email body size exceeds the column size, the SQLException is thrown. The pyText property was exposed to support functionality in Pega Social in the past. But Pega Social was deprecated and is no longer available. Therefore, the optimization originally provided by exposing the property is no longer needed.
Solution
To resolve this issue, complete the following steps:
- Back up the database.
For Pega Cloud Services environments, see Database backup and restore. - Delete the dedicated column pyText from the table pr_data_nlp_summary.