One Star

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

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.

13 REPLIES
Seventeen Stars

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

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..
One Star

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

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.
Moderator

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

Hi,
This is component reference about tOracleConnection.
In addition, here are some related forums about tOracleConnection Forum27884, Forum 26353. Hope it will be helpful for you.
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.
One Star

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

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.
Seventeen Stars

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

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.
One Star

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

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
Moderator

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

Hi,
What is your new designed work flow with tOracleConnection? Do you use tOracleClose and tOracleCommit. More screenshots of your job will be appreciated.
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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.
Moderator

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

Hi,
Thanks for your response, if you have any problem when using tOracleConnection component, feel free post your issue on forum.
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.
One Star

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

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

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

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 Forum 28851
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.
One Star

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

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

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.