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)
Accepted Solution
Tcs
IN
Hi, I think, we found a solution to this issue. It is as below:
We have added indexing for pzInsKey (for table which has BLOB) and this showed a significant improvement.
Additional Load tests were in progress. Will update further.
Pegasystems Inc.
JP
Which RDB are you using?
I remember Oracle has maximun size limitation for VarChar type column and the system will throw exception if you try to extract bytes from CLOB or BLOB which exceeds the limit.
Tcs
IN
Yes, we use ORACLE.
But in Marketing, I believe it is common to have these kind of scenarios (Saving mail content to DB and sending source to other systems).
Would like to know if any suggestions from others experience on how it is implemented or any suggestions.
Thanks in advance.
Accepted Solution
Tcs
IN
Hi, I think, we found a solution to this issue. It is as below:
We have added indexing for pzInsKey (for table which has BLOB) and this showed a significant improvement.
Additional Load tests were in progress. Will update further.