topic Re: ORA-28040 error in Talend Studio

ORA-28040 error

Anonymous — Sun, 21 May 2017 08:41:21 GMT

Hello,

I have 2 database Ora 10 and Ora 11.

When used in separated jobs it is ok but once I have them both in the same job I have an ORA-28040 error.

My tOracleOutput_java.xml

Thanks,

Re: ORA-28040 error

TRF — Sun, 21 May 2017 09:02:41 GMT

Seems to be an Oracle bug https://www.google.fr/url?sa=t&source=web&rct=j&url=https://community.oracle.com/thread/2349728&ved=0ahUKEwi6kKj6wIDUAhWrL8AKHYIpCLoQFggsMAI&usg=AFQjCNFfY1PCwE7nde9zJ_-BhcumqQXuGQ&sig2=iglzqmca6cA8PzV9afj55g
Can you share the job and configuration (screen capture) for tOracleConnection (if any) + tOracleInpout + tOracleOutput component?

Re: ORA-28040 error

Anonymous — Mon, 22 May 2017 08:27:11 GMT

Hello,

Did you have several oracle DB connections in your work flow?

Is this solution mentioned in this article Ok with you?

http://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception

Best regards

Sabrina

Re: ORA-28040 error

Anonymous — Mon, 22 May 2017 08:51:40 GMT

Hi, yes

I have 2 Oracle connection (ora9 , ora12) and 1 read table in (ora9) and 1 output table in (ora12).

I have read the stackoverflow but not able to implement it (lack of knowledge); and after the changes TOS.6.1.1 does not work anymore on previous job.

So I'm going to start over

Thanks

Re: ORA-28040 error

TRF — Mon, 22 May 2017 09:15:03 GMT

Hi,

How is designed your job? Do you need to open both connections at the time?

If not, I suggest you to try this kind of design:

tOracleConnection (Oracle 9) --> tOracleInput --> tHashOutput --> tOracleCommit (to  close the connection)
|
onSubjobOk
|
tOracleConnection (Oracle 12) --> tHashInput --> tOracleOutput --> tOracleCommit (to  close the connection)

Let us know.

Re: ORA-28040 error

Anonymous — Tue, 23 May 2017 07:06:02 GMT

Same problem