Question

3
Replies
259
Views
Phanindra Kumar Sura (PHANISURA)
Tcs

Tcs
IN
PHANISURA Member since 2013 4 posts
Tcs
Posted: September 19, 2016
Last activity: January 23, 2017
Posted: 19 Sep 2016 15:42 EDT
Last activity: 23 Jan 2017 8:05 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.