Question

2
Replies
137
Views
Martina Naydenova (MartinaN1700)
DXC Technology

DXC Technology
BG
MartinaN1700 Member since 2020 1 post
DXC Technology
Posted: September 15, 2020
Last activity: September 16, 2020
Posted: 15 Sep 2020 5:11 EDT
Last activity: 16 Sep 2020 6:47 EDT

java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 2075, maximum: 2000)

Hello,

we are involved in a project where some Oracle databases have to be configured in the Arcsight Oracle Smart Connector using JDBC connection string. I am responsible to provide it to my colleague and for me it seems without any issues but here is the error that occurred:

*I filled with stars the hosts and the service name because it is confidentional information.

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(CONNECT_TIMEOUT=3)(RETRY_COUNT=1)(ADDRESS_LIST=(LOAD_BALANCE=off)(ADDRESS=(PROTOCOL=tcp)(HOST=*******)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=*****)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=*****)))

*** Passes initial Validation, but the below error appears in the log file. *** INFO   | jvm 46   | 2020/09/10 15:48:52 | FATAL EXCEPTION: INFO   | jvm 46   | 2020/09/10 15:48:52 | java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 2075, maximum: 2000)

 

Could you please explain me or at least clarify why this kind of error had occurred? My first reply to my colleague was to contact a developer because this error ORA-22835 is not related to the connection string but he asked me to escalate to someone else who can check. On the other servers we didn't face this error.

 

Thank you in advance!

 

***Edited by Moderator: Pallavi to change content type from Discussion to Question***
Pega Platform System Administration Technology Services System Administrator