Posted: 19 Sep 2016 15:42 EDT Last activity: 23 Jan 2017 8:05 EST
How to save a large content to external table
I have below requirement, can someone suggest or shed some light if anyone has implemented of faced this issue. We are using pega marketing (713) on Pega (719).
Business users update the email treatment content with source code(Usually this is large data) and by default it will be saved to pr4_rules table (treatment content being saved to pySourceStream property, which is in BLOB). Now, I have to retrive the source content from the table, send it to another system over REST and also I need to save the email source to my external table.
1. When I tried to retrive the souce content from blob - It throws a error saying, the data has been truncated...can't be retrived.... So, How can I retrive the content from blob and save to external table?
2. While saving to external table, I created a blob column and was able to save (Unit testing from activity). However, the message is truncated with '+' at the end of the message and when retrived, it is being displayed with '+' at the end (Not able to see complete message)