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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

"Variable can not be resolved" error for multiple tBigQueryInput's

I am getting the following error if there are more than one tBigQueryInput's:

Detail Message: jobId_tBigQueryInput_2 cannot be resolved to a variable

This is my job and the configuration of tBigQueryInput_2. But the config of tBigQueryInput_1 is the same:

0683p000009M2X1.png

In the source code, I am getting the following for tBigQueryInput_1, which is correct:

com.google.cloud.bigquery.JobId jobId_tBigQueryInput_1 = com.google.cloud.bigquery.JobId
		.of(java.util.UUID.randomUUID().toString());
com.google.cloud.bigquery.Job job_tBigQueryInput_1 = bigquery_tBigQueryInput_1
		.create(com.google.cloud.bigquery.JobInfo
			.newBuilder(queryConfiguration_tBigQueryInput_1)
			.setJobId(jobId_tBigQueryInput_1).build());

For tBigQueryInput_2, I am getting an error on the last line of the following code:

com.google.cloud.bigquery.JobId jobId_tBigQueryInput_1 = com.google.cloud.bigquery.JobId
		.of(java.util.UUID.randomUUID().toString());
com.google.cloud.bigquery.Job job_tBigQueryInput_2 = bigquery_tBigQueryInput_2
		.create(com.google.cloud.bigquery.JobInfo
			.newBuilder(queryConfiguration_tBigQueryInput_2)
			.setJobId(jobId_tBigQueryInput_2).build());

The error is on the first line of the above code. Variable `jobId_tBigQueryInput_1` is beeing initialized, but on the last line it references `jobId_tBigQueryInput_2`, which does not exist.

It works for tBigQueryInput_1, but fails for any other tBigQueryInput's.

 

Talend Version used: 7.1.1.20181026_1147

The same job has worked on Taled Version 7.0.1.2018.0411_1414

 

Best regards,

Simon

Labels (4)
16 Replies
Anonymous
Not applicable
Author

Hello @ssomanchi,

We need more information about your another issue:https://community.talend.com/t5/Design-and-Development/Issue-when-Using-2-tBigQueryOutput-in-1-job/m....

Best regards

Sabrina

 

Anonymous
Not applicable
Author

Hi,

 

Will this be fixed in 7.3 or 8.0?

Anonymous
Not applicable
Author

Hi,

 

I have also this bug in 7.1.

 

Can I give you the details you need?

 

Is there any way to have th bug's link so we can now whats the resolution state?

 

Thanks.

Anonymous
Not applicable
Author

The link to my ticket is given above. It has been closed as duplicate of TBD-8102.
I guess the link to this issue is https://jira.talendforge.org/plugins/servlet/mobile#issue/TBD-8102
But I don't have access to see it.
Anonymous
Not applicable
Author

Neither do I

Anonymous
Not applicable
Author

Hello @Moe 

TBD-8102 is fixed in 7.2.1, 7.1.2  and the security level is Talend internal.

Best regards

Sabrina

 

 

Anonymous
Not applicable
Author

Hello @amarhaba 

Here exists a jira issue: TBD-8102 "tBigQueryInput - Always fails when you have more than one".It's fixed in 7.2.1, 7.1.2

The security level is Talend internal. Only Talend employees will be able to see the issue. Let us know if there is any help we can give.

Best regards

Sabrina