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?
I think currently,there is no support for BLOB columns in external table. Please see below the article which describes the same.
You can give a try by creating a java activity step as suggested in below article.
Keep up to date on this post and subscribe to comments