Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (4)
7 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Java version are the 1.8, updated 181.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

 

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

success:

0683p000009M19q.png

 

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

 

0683p000009M11x.png0683p000009M19v.png

 

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

 

Thanks

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

@nthampi,

 

Follow the connection details

0683p000009M0pw.png

 

 

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

Anonymous
Not applicable
Author

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 😛 ...