Build Job script, Exception in component tDBOutput_1 (table_mysql_orcl) java.sql.SQLException: ORA-01017: invalid username/password; logon denied

[Anonymous]

Hi, 

Within Talend Open Studio, I created a job to export from a MySql(5) table to a Oracle(11) table, simply with two components: tDBInput and tDBoutput, the job runs fine within the Open Studio. But gives error "java.sql.SQLException: ORA-01017: invalid username/password; logon denied" when running in command line with the Build Job shell script.  Any ideas?

Exception in component tDBOutput_1 (j_catalogType_mysql_orcl)
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:448)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:383)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:776)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:432)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)

[manodwhb]

Based on the error, you might have been used wrong credentials. please check the credentials.

[Anonymous]

Hi Manohar B,

It is the same credential used in Talend studio, and it is working fine within Talend studio.
Only when running the script provided build job that I got the "invalid username/password" error.
Where can I check in the build job? Supposingly I am planning to deploy the build job zip file to another box which does not have Talend Studio installed. But even the initial attempt to deploy on the same machine where Talend Studio was installed failed.