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?

 

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars TRF
Seven 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
1 REPLY
Seven Stars TRF
Seven 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