Question

Not able to open blob from external DB

We are Archiving all the Resolved cases that are older than 6 months in to a Reports database(External db) on the daily basis and then purging all the cases from the PEGA database. we have a requirement to display these purged cases from the external db in UI and also have a requirement to open the case in review mode.

Here we are able to get the archived cases from external DB through RD by enableing "use alternative database" option. But not able to open the case from external DB (getting exception that not able to open the BLOB)

Is there any way to retrieve blob data from external DB, please guide us?

Correct Answer
December 5, 2018 - 8:56am

Hi Vikram,

 I think currently,there is no support for BLOB columns in external table. Please see below the article which describes the same.
 https://community1.pega.com/community/pega-support/question/read-data-blob-column-external-db

 You can give a try by creating a java activity step as suggested in below article.
 https://community1.pega.com/community/pega-product-support/question/read-data-blob-column-external-db
 

Comments

Keep up to date on this post and subscribe to comments

Pega
December 5, 2018 - 8:56am

Hi Vikram,

 I think currently,there is no support for BLOB columns in external table. Please see below the article which describes the same.
 https://community1.pega.com/community/pega-support/question/read-data-blob-column-external-db

 You can give a try by creating a java activity step as suggested in below article.
 https://community1.pega.com/community/pega-product-support/question/read-data-blob-column-external-db
 

December 9, 2018 - 12:30pm

Thanks Khan for your quick response. I tried the JAVA step metioned above and it is working fine to read BLOB. But we need to prepare a clipboard page for respective BLOB, Is there any APIs to convert byte array into clipboard page. Do we need to decrypt it?