Published jobs with Snowflake connection not working in TMC

[BenG]

Hi,

I have developed several jobs which use snowflake components and a connection component.

I have all structured via parent and child jobs with context variables. I also created the variables by best practices from Talend (connection_Snowflake....).

If I run the jobs via Studio all works perfect without any error.

After I published my jobs to TMC and created a custom connection with the correct parameters. I get the following errors:

tDBConnection_1 Missing account

java.lang.RuntimeException: Missing account

  at dwh.job_temp_ invoicetrans_0_1.job_Temp_ InvoiceTrans.tDBConnection_1Process(job_Temp_ InvoiceTrans.java:881)

  at dwh.job_temp_ invoicetrans_0_1.job_Temp_ InvoiceTrans.tPrejob_1Process(job_Temp_ InvoiceTrans.java:643)

  at dwh.job_temp_ invoicetrans_0_1.job_Temp_ InvoiceTrans.runJobInTOS(job_Temp_ InvoiceTrans.java:2578)

  at dwh.job_temp_ invoicetrans_0_1.job_Temp_ InvoiceTrans.runJob(job_Temp_ InvoiceTrans.java:2201)

  at dwh.job_all_raw_ invoicetrans_0_1.job_All_RAW_ InvoiceTrans.tRunJob_1Process(job_All_RAW_ InvoiceTrans.java:655)

  at dwh.job_all_raw_ invoicetrans_0_1.job_All_RAW_ InvoiceTrans.runJobInTOS(job_All_RAW_ InvoiceTrans.java:1905)

  at dwh.job_all_raw_ invoicetrans_0_1.job_All_RAW_ InvoiceTrans.runJob(job_All_RAW_ InvoiceTrans.java:1514)

  at dwh.job_all_ data_0_1.job_All_ Data.tRunJob_1Process(job_All_ Data.java:654)

  at dwh.job_all_ data_0_1.job_All_ Data.runJobInTOS(job_All_ Data.java:1894)

  at dwh.job_all_ data_0_1.job_All_ Data.runJob(job_All_ Data.java:1503)

  at dwh.job_all_snowflake_staging_0_1.job_All_Snowflake_Staging.tRunJob_1Process(job_All_Snowflake_Staging.java:655)

  at dwh.job_all_snowflake_staging_0_1.job_All_Snowflake_Staging.tRunJob_4Process(job_All_Snowflake_Staging.java:1143)

  at dwh.job_all_snowflake_staging_0_1.job_All_Snowflake_Staging$2.run(job_All_Snowflake_Staging.java:1979)

I have checked every documentation and tried a lot without success. I also checked all parameters several times.

Does anyone has a hint? Working with cloud connections seems to be complete different.

Thanks

Ben

[BenG · Accepted solution]

Hi,

just found the problem. A small tick on "Transmit whole context" is solving the problem. That needs to be done on every child tRunJob component.

Maybe it will help someone else.

Cheers

Ben

[Anonymous]

Hello,

Please make sure the 'transmit whole context' box is checked on tRunJob.

In this way, your job will load/set Implicit Context in child Jobs.

Best regards

Sabrina