Question

2
Replies
1025
Views
 John Paul Raja Christu Raja (JohnPaulRaja,C)
PerseusX Incorporated
Consultant
PerseusX Incorporated
US
JohnPaulRaja,C Member since 2011 262 posts
PerseusX Incorporated
Posted: April 5, 2018
Last activity: April 11, 2018
Posted: 5 Apr 2018 17:39 EDT
Last activity: 11 Apr 2018 8:16 EDT
Closed
Solved

Reading CLOB data using Report definition

Hi,

I am trying to read more than 4k clob data using RD, but it is erroring out.

I know another alternate option is obj- browse. do we have any other alternate way to read the content using RD?

Data Integration Reporting
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.
Posted: 3 years ago
Posted: 8 Apr 2018 10:58 EDT
Chandrasekhar Gollamudi VN (chandrasekhar_g)
PEGA
Technical Manager
Pegasystems Inc.
IN

Hi,


using connect-sql the clob columns are reading as string values.


Support for CLOB columns in the Pega platform is available from 7.2.1


You can check below link also. It may help you.


https://pdn.pega.com/community/product-support/question/read-data-clob-field-database


 

Accepted Solution

Posted: 3 years ago
Posted: 11 Apr 2018 8:16 EDT
John Paul Raja Christu Raja (JohnPaulRaja,C)
PerseusX Incorporated
Consultant
PerseusX Incorporated
US

Solution : 


  1. Set the reporting/retrieveFullClobContent Dynamic System Setting (DSS) defined on Pega-RULES to True.

  2. Install HFix-37641.

  3. Restart the server.

https://pdn.pega.com/support-articles/error-ora-22835-when-executing-query-report-definition-0