Error Referenced component: tSnowflakeConnection_2 not connected

Four Stars

Error Referenced component: tSnowflakeConnection_2 not connected

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.

Capture.PNG

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?

 


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: Error Referenced component: tSnowflakeConnection_2 not connected

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.


TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: Error Referenced component: tSnowflakeConnection_2 not connected

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.


TRF

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch