Question
DXC Technology
BG
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!
Pegasystems Inc.
FR
Hello,
Can this be helpful maybe: https://collaborate.pega.com/question/getting-here-was-problem-getting-list-code-22835-sqlstate-99999-while-running-report
What Platform version is it?
DXC Technology
BG
Thank you,MarcLasserre_GCS! But I can not give you more information just because I am not aware of it. So I am the Oracle guy and my colleague is the Arcsight Engineer but none of us is a developer and can not change what is needed in order to prevent this error, unfortunately. So I will let him know that he must really go back to the developer. :) Thank you once again!