topic Re: Error Referenced component: tSnowflakeConnection_2 not connected in Talend Studio

Error Referenced component: tSnowflakeConnection_2 not connected

Anonymous — Fri, 12 May 2017 18:34:38 GMT

I'm trying to load data from oracle to Snowflake. I download snowflake connector from Talend exchange and install it.

Then I create a job with a oracle input and a snowflake output.

I get below error while running it.

Exception in component tSnowflakeOutput_1
java.lang.RuntimeException: Referenced component: tSnowflakeConnection_2 not connected
at local_project.genlogs_0_1..tOracleInput_1Process(genlogs.java:674)
at local_project.genlogs_0_1..runJobInTOS(genlogs.java:1343)
at local_project.genlogs_0_1..main(genlogs.java:1188)

Not sure why tSnowflakeConnection_2 are referenced by tOracleInput_1Process.

Does it mean snowflake component not compatible with Oracle component?

Re: Error Referenced component: tSnowflakeConnection_2 not connected

TRF — Fri, 12 May 2017 22:09:48 GMT

You need to link component one to each other else you cannot predict the order the will start.

Usally you should have something like:

tSnowflakeConnection_2 -- onComponentOK --> tOracleConnection_1
|
onSubjobOK
|
tOracleInput_1 -- main --> tSnowflakeOutput_1

Hope this helps.

Re: Error Referenced component: tSnowflakeConnection_2 not connected

NNot_defined1655126342 — Mon, 27 Jun 2022 07:59:43 GMT

hallo,

i get some problem. can anyone help me to solve the problem? thanks

Re: Error Referenced component: tSnowflakeConnection_2 not connected

gjeremy1617088143 — Mon, 27 Jun 2022 15:04:44 GMT

Hi @Not defined Not defined , it seems you set the on subjob ok link between tDbinput and tDBcommit in the wrong direction ,

here tDBcommit --> tDBInput

change it to tDBInput --> tDBCommit and it will resolve your issue.

also do the same for the tDBRollback

Send me love and kudos

Re: Error Referenced component: tSnowflakeConnection_2 not connected

NNot_defined1655126342 — Mon, 27 Jun 2022 16:37:39 GMT

Hi, thanks for your help i have solved the problem with ETL. but now i have new error with ELT. here is the image i have

could you help me again?. thanks 🙂

Re: Error Referenced component: tSnowflakeConnection_2 not connected

gjeremy1617088143 — Mon, 27 Jun 2022 16:47:32 GMT

You try to create a new table with the tELToutput, maybe you don’t have the right to do it or it already exist

Re: Error Referenced component: tSnowflakeConnection_2 not connected

NNot_defined1655126342 — Mon, 27 Jun 2022 16:54:53 GMT

this is the complete error. is that mean, that i shall use another DATABASE ?

Re: Error Referenced component: tSnowflakeConnection_2 not connected

NNot_defined1655126342 — Mon, 27 Jun 2022 16:58:25 GMT

it's solved . thanks for your help