Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 John Paul Raja Christu Raja (JohnPaulRaja,C)
Maantic Inc
Consultant
Maantic Inc
US
JohnPaulRaja,C Member since 2011 306 posts
Maantic Inc
Posted: Apr 5, 2018
Last activity: Apr 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?

To see attachments, please log in.
Data Integration
Reporting

Accepted Solution

Posted: 7 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

To see attachments, please log in.
Posted: 7 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

 

To see attachments, please log in.

Accepted Solution

Posted: 7 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

To see attachments, please log in.
  • Genifer Graff Pradeep Yarlagadda Sowmya Narahari

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