Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ASingh1661970940
Contributor II
Contributor II

java.io.IOException: Protocol violation: [ 14, 32, ]

Hi,

I am getting below java IOException in tDBinput(Oracle) component, can anyone help here.

Error: java.io.IOException: Protocol violation: [ 14, 32, ]

Thanks,

Asim

Labels (3)
1 Solution

Accepted Solutions
ASingh1661970940
Contributor II
Contributor II
Author

Thank you JFurman

View solution in original post

6 Replies
Ruchi_27
Contributor III
Contributor III

Hello,

I have found the following links to this problem:

http://stackoverflow.com/questions/29372626/sqlexception-protocol-violation-in-oracle

http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation

I hope this helps.

The problem seems to be related to CLOB. It seems that if the length of clob is 4193 characters, driver fails to retrieve and hence upgrading the driver to latest version might help resolve this issue.

Thanks!

ASingh1661970940
Contributor II
Contributor II
Author

Yes you are correct, I have two CLOB field in my job, which is causing issue.

Thank you Ruchi.

Daniel044
Contributor II
Contributor II

I’m also having this exact issue.

Ruchi_27
Contributor III
Contributor III

Hello,

The problem seems to be related to CLOB. It seems that if the length of clob is 4193 characters, the driver fails to retrieve it, and hence upgrading the driver to the latest version might help resolve this issue.

http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation

Thanks!

ASingh1661970940
Contributor II
Contributor II
Author

Thank you JFurman

Daniel044
Contributor II
Contributor II

I also have this same question and I cannot find any proper answers on the internet and also need a solution.