BigQuery error in talend 7.1

Four Stars

BigQuery error in talend 7.1

Hi in the new version i have this error in Bigquery input, any solution for this? It´s a sample query in bigquery.

 

Detail Message: jobId_tBigQueryInput_4 cannot be resolved to a variable
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:338)
at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:510)
a

Employee

Re: BigQuery error in talend 7.1

Hi,

 

    Could you please advise the JDK version you are using in your system? I hope it is Java 1.8 version.

 

    If it is different, could you please add the right Java version?

 

     If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)

 

Warm Regards,

 

Nikhil Thampi

Four Stars

Re: BigQuery error in talend 7.1

Java version are the 1.8, updated 181.

Employee

Re: BigQuery error in talend 7.1

Hi,

 

   Are you still facing the issue? If yes, could you please share the job screenshots and the component details screen shots for reference?

 

Warm Regards,

 

Nikhil Thampi

Four Stars

Re: BigQuery error in talend 7.1

Hi,

 

The error Continues, I have 2 components bigquery in job, when i deactivated the second, the first run with 

success:

first.PNG

 

when i run the job with the 2 components activated, generated the error:

 

erro.PNGsecond.PNG

 

The queries are the same, authentication_mode set to Service Account.

 

Thanks

Employee

Re: BigQuery error in talend 7.1

Hi,

 

    Since it is a connection authorization related issue where you are having limitations in showing the details of connection to verify further, my suggestion will be to create a support case for this issue. They will be able to help you remotely and verify the details.

 

Warm Regards,

 

Nikhil Thampi

Four Stars

Re: BigQuery error in talend 7.1

nikhilthampi,

 

Follow the connection details

connection.PNG

 

 

I  tried to split in 2 jobs and trying to give a build in the second generated the same error

Five Stars

Re: BigQuery error in talend 7.1

i met the same issue, try to use tGSConnection component to open a connection in prejob, then, use tBigQueryInput.

Make sure, your Service account path is good :-p ...

 

 

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 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog