topic Re: [resolved] got minus one from a read call...ERROR! in Talend Studio

[resolved] got minus one from a read call...ERROR!

Anonymous — Thu, 18 Apr 2013 16:35:39 GMT

Hi,
my job consist in read froma a table and match this with other and insert in the same table. See th screenshot IS BETTER!
I have the error got minus one from a read call, randomly on the tables of the job and if i close and reopen Talend, all warks good!!!
Why?
I work on oracle 11g and windows server2008
Thanks in advance,
Gino.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Thu, 18 Apr 2013 16:54:43 GMT

I suppose you mean an error message like this: "...the socket returns a negative value...." or similar message. In this case this means you have network problems randomly.
The other possible explanation (it would be better to know the exact message) is: some Oracle error codes are in fact negative. E.g. all user defined error messages are negative.
Please provide an example of the actual error message.
I see you read a lot tables as lookup. Your job establish alway a new connection and this could lead to a lack of possible connections. Please try to use one connection which is used by all input components and another separate connection for all output components..

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Fri, 19 Apr 2013 09:07:24 GMT

Hi jlolloing,
probably is a connection problem (I work on a server and DB is in another server), infact i coud not reply the error...is RANDOM!
Now if i want to use one connection which is used by all output or input components, can you explain me the way?
Thanks in advance,
Gino.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Fri, 19 Apr 2013 10:08:25 GMT

Hi,
This is component reference about tOracleConnection.
In addition, here are some related forums about tOracleConnection https://community.talend.com/t5/Design-and-Development/tOracleConnection-gt-performances/td-p/93888, https://community.talend.com/t5/Design-and-Development/How-to-use-the-same-tOracleConnection-in-the-subjobs/td-p/81987. Hope it will be helpful for you.
Best regards
Sabrina

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Fri, 19 Apr 2013 13:43:28 GMT

Hi,
i have the error again:
Inizio job Applicazione_Regole_DAT_NOMAP_NOEST: 14:39 19/04/2013.
connecting to socket on port 3659
connected
Exception in component tOracleOutput_9
java.sql.SQLException: Got minus one from a read call
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.tOracleInput_1Process(Applicazione_Regole_DAT_NOMAP_NOEST.java:9481)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.runJobInTOS(Applicazione_Regole_DAT_NOMAP_NOEST.java:24574)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.main(Applicazione_Regole_DAT_NOMAP_NOEST.java:24442)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:243)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 9 more
disconnected
For Sabrina...now I will read your suggestions, thanks.
Best Regards,
Gino.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Fri, 19 Apr 2013 20:52:17 GMT

Could you please check this connection with a external JDBC based SQL client like SQLSquirrel or SQLWorkbench?
It looks like you have a network problem or a problem in the configuration of the database.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Sat, 20 Apr 2013 10:33:09 GMT

I'm always connect with the Oracle Db with a sql client...i don't understand... but probably is a connection problem. On Monday, make a test with oracleconnection component...
Thanks

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Mon, 22 Apr 2013 04:13:30 GMT

Hi,
What is your new designed work flow with tOracleConnection? Do you use tOracleClose and tOracleCommit. More screenshots of your job will be appreciated.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Mon, 22 Apr 2013 08:56:00 GMT

Hi Sabrina,
at this moment I have not changed the job with the tOracleConnection component, when I do I will use also tOracleClose and tOracleCommmit componets, thanks for suggentions...
Gino.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Mon, 22 Apr 2013 09:26:04 GMT

Hi,
Thanks for your response, if you have any problem when using tOracleConnection component, feel free post your issue on forum.
Best regards
Sabrina

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Tue, 23 Apr 2013 15:02:44 GMT

Hi Sabrina,
I took your advice to use tOracleConnection, and all works FINE!
Once again you have given me useful advice!
Thanks,
Gino.

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Wed, 24 Apr 2013 04:24:18 GMT

Hi,

I took your advice to use tOracleConnection, and all works FINE!
Once again you have given me useful advice!

It is a good news. BTW, tOracleConnection may refer to performance issue. If you face it, please view the related https://community.talend.com/t5/Design-and-Development/Reduce-tOracleInput-Outpu-s-performance/td-p/102798
Best regards
Sabrina

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Wed, 24 Apr 2013 10:47:13 GMT

Hi,
did you mean that the performance are better with tOracleConnection component? Because my performance has improved with tOracleConnection...

Re: [resolved] got minus one from a read call...ERROR!

Anonymous — Wed, 24 Apr 2013 11:21:08 GMT

Hi,
Usually, using tXXXConnection component will make the performance fall. But in your old job, your design is not proper so when you use tXXXConnection, you will find the performance is good.
Best regards
Sabrina