[resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Highlighted
One Star

[resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Hi,
I've got some trouble with a job using a ToracleInput (TOS 5.3.1, On AIX using an oracle 11.2 database).
An error is throw at the first query: 
 
 Exception in component tOracleInput_1
  java.sql.SQLException: No more data to read from socket
This job have been use on several other server (With same configuration a first view), without any trouble.
Does someone know where to investigate to solve this trouble (Just a clue, please Smiley Wink) ?
thanks a lot

Accepted Solutions
Highlighted
One Star

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Thanks a lot !
Our oracle team solve the trouble : it was due to some error of configuration on the listener of the database.   
Good day.

View solution in original post


All Replies
Moderator

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Hi,
This issue is probably caused by oracle server.
Please see this article:http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Thanks a lot !
Our oracle team solve the trouble : it was due to some error of configuration on the listener of the database.   
Good day.

View solution in original post

Highlighted
Moderator

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Hi ntotor314,

Glad you could solve the issue. Could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.


Best regards

Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Five Stars

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Hi,

 

Could you specify what exact error of configuration on the listener of the database?

 

 

Thank you!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog