topic Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified in Talend Studio

Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Sat, 16 Nov 2024 02:26:18 GMT

Talent Studio - cloud 7.3.1 TRIAL Version

Cannot connect to SNOWFLAKE. I am able to connect using the design mode. When I give test connection, IDE brings back the tables/schema related to that connection. But when I run the job with the same connection from the meta it fails with an exception report stating

"Exception in component tDBConnection_1 (APP1_POC)

java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified."

I would highly thank anybody who would give a solution to the above. Thank you so much.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Fri, 15 May 2020 04:47:40 GMT

@soadevelopers, as per the error your user name or password incorrect, please re-check username and password.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Fri, 15 May 2020 04:51:49 GMT

Thank you for the quick response @manodwhb

Like I said, if either would have been wrong IDE will not bring the tables/schema from snowflake right?

This is happening at runtime. I thought once I configure the user/pwd in ide properties window i can just run.

Please let me know.

Thank you.

Soadeveloper

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Fri, 15 May 2020 04:56:27 GMT

@soadevelopers, can you please share screen shoots to understand better your issue?

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Fri, 15 May 2020 05:05:38 GMT

Here is the exception thrown on the IDE

I have one connection, one csv converter (CSV IS WORKING FINE)

Converted connecting to tSnoflakeconnection or tdbconnetion where i pick snowflake from db property

Please see the screenshot. Basically just one connection being put as a job also it simply gives the same exception constantly.

Thank you for the response.

talenderror.png

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Fri, 15 May 2020 05:15:55 GMT

@soadevelopers, can you share a screenshot of the component too?

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Fri, 15 May 2020 06:17:00 GMT

@manodwhb

Here it is attached. Like I said, its very simple. In IDE during development it is correctly bringing the schemas from snowflake. So username pwd and jdbc url all working in design time. But when I run it fails.

Screen shot attached as requested.

talendidescreen.png

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Fri, 15 May 2020 07:49:42 GMT

can somebody help please?

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Fri, 15 May 2020 07:56:56 GMT

@soadevelopers, when you created metadata connection in Talend repository its working and when running the job it is failing ? is that your statement?

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Fri, 15 May 2020 19:27:26 GMT

Yes. Exactly.

When running the job it is NOT Working. Correct.

Thank you.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Sat, 16 May 2020 00:21:22 GMT

Can anyone help? This should be possible. Is there any place where at runtime I need to specify userid, pwd? I gave it during design time of metadata and it connects.

Kindly help please.

Thank you,
S

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Mon, 18 May 2020 05:20:14 GMT

@soadevelopers, I have not seen this type of issue when connecting with the snowflake from Talend. which version of Talend are you using?

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Mon, 18 May 2020 19:10:59 GMT

Using the latest. Downloaded few days back.

I just found out FTP is also having issues. There seems to be some conflicts when installed on MAC system.

Cloud Studio seems to be not working. Looks like I have to troubleshoot myself. Will keep you posted.

Thank you for trying to support.

regards,

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

manodwhb — Tue, 19 May 2020 06:15:43 GMT

@soadevelopers, Ok check and let me know.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

kai_1892 — Mon, 15 Jun 2020 07:44:57 GMT

Hi,

is there any update on this topic?

We are currently facing a similar issue with Talend 7.3. On my local machine the job is working as expected, but when uploading it to a server and running the shell script from there, I get the following error message:

java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified.

Same job build with Talend 7.2 is working fine.

Best,

Kai

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

Anonymous — Mon, 15 Jun 2020 18:48:37 GMT

My problem is solved. Look into the following things:1. Check JDBC url. Make sure it has role defined correctly and also the role in snowflake remains same. Also make sure snowflake warehouse RUNNING.2. Check server firewall policies. 3. Access to snowflake should have a parameter in JDBC which says authentication or authorization which should be snowflake. Please search for the 3rd point. Snowflake has given some documentation.4. see that the JDBC driver link is also available in the server.5. If al above looks good then.. restart.
Hope this helps.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

JJS1 — Fri, 24 Sep 2021 21:17:34 GMT

I had this same issue with Talend Studio 7.3.1. this week I was able to access my Snowflake account through the IDE using the tSnowflakeOutput component; that is, I could see the database objects in my schema and select the table in the component, but then at run time I would get "Incorrect user name or password specified." I seemed to search Google exhaustively, until a colleague speculated that perhaps my installed version of the JRE (1.8.0_74) might be the issue. He was correct. I upgraded to 1.8.0_301 and the error was fixed. I was able to immediately connect and insert records to the Snowflake table.

If you are experiencing this error, run a java -version check and see if your JRE might be in need of a more recent version. Certainly, version 1.8.0_74 did not work as expected.

Re: Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

JJS1 — Mon, 27 Sep 2021 13:38:36 GMT

Also - as a point of interest - when increasing the memory for my Talend IDE in the Talend-Studio-macosx-cocoa.ini on my MaOS today, I noted that the JRE that the Talend Studio IDE is using is configured in that file and the IDE is configured to use the JRE bundled with the 7.3.1 install (1.8.0_202 in this example), and it's not using the JRE found in $JAVA_HOME. However, when running a job in Talend itself, the jobs will use the JRE that is configured in your $JAVA_HOME directory. I'm near certain this is the case because this explains why I was having a problem running a Talend job where the IDE was able to connect with Snowflake via a Snowflake component, but when running the job the same Snowflake component failed with an error and was unable to connect and said "Incorrect user name and password specified." (with the same user name and password). Again, the problem was fixed by upgrading the JRE run time pointed to by my $JAVA_HOME.