Skip to main content
Contact a Moderator

Question

2
Replies
1435
Views
 John Paul Raja Christu Raja (JohnPaulRaja,C) Maantic Inc Consultant
Maantic Inc
US
JohnPaulRaja,C Member since 2011 277 posts
Maantic Inc
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

Report

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: 4 years ago
Posted: 8 Apr 2018 10:58 EDT
Chandrasekhar Gollamudi VN (chandrasekhar_g) PEGA Senior Manager, Technical Support - Runtime Engine and Search
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: 4 years ago
Posted: 11 Apr 2018 8:16 EDT
John Paul Raja Christu Raja (JohnPaulRaja,C) Maantic Inc Consultant
Maantic Inc
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://community.pega.com/support/support-articles/error-ora-22835-when-executing-query-report-definition-0

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice