Question

3
Replies
210
Views
PHANISURA Member since 2013 4 posts
Tcs
Posted: 4 years ago
Last activity: 3 years 8 months ago
Closed
Solved

How to save a large content to external table

Hi,

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).

Requirement:

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.

Questions: 

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)

 

 

Data Integration
Moderation Team has archived post
Share this page LinkedIn