Posted: 21 Jul 2017 14:32 EDT Last activity: 16 Oct 2018 12:03 EDT
Does 7.2.1 generate connector rules wizard for external database support clob datatype ?
I generated rules for an external database using the following wizard.
select Designer Studio > Integration > Connectors > Connector and Metadata wizard.
It was not able to create corresponding properties, activities for a column of clob datatype.
Does anyone have an alternative to get those properties created for clob. Looks like pega property type doesn't have clob type.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
You wont be able to map the CLOB column to any property in Pega directly. However, you can try make using use of pyLargeColumn property qualifier introduced from Pega 7.2.1 for supporting CLOB.
A property qualifier can be a supplement information in a property that extends or restricts the given functionality. Property qualifier rules are instances of Rule-Obj-Property-Qualifier and stored in pr4_rule_property table.
When 'pyLargeColumn' qualifier is set on a property, it will be treated as a CLOB column when it is optimized.
Hi Sandeep, I just added pyLargeColumn in Clob column property qualifier.
CLOB column property is configured in Report definition, when I run the RD, it shows below error.
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 22835 SQLState: 99999 Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 13900, maximum: 4000) DatabaseException caused by prior exception: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 13900, maximum: 4000) | SQL Code: 22835 | SQL State: 99999
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.