Question
Centene Corporation
US
Last activity: 9 Dec 2018 12:31 EST
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?
Accepted Solution
Pegasystems Inc.
IN
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://collaborate.pega.com/question/read-data-blob-column-external-db
You can give a try by creating a java activity step as suggested in below article.
https://collaborate.pega.com/question/read-data-blob-column-external-db
Centene Corporation
US
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?