Error Referenced component: tSnowflakeConnection_2 not connected

[Anonymous]

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?

[TRF · Accepted solution]

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.

[NNot_defined1655126342]

hallo,

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

[gjeremy1617088143]

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

[NNot_defined1655126342]

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 🙂

[gjeremy1617088143]

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

[NNot_defined1655126342]

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

[NNot_defined1655126342]

it's solved . thanks for your help