topic tBigQueryInput getting StringIndexOutOfBoundsException in release 7.2.1 in Talend Studio

tBigQueryInput getting StringIndexOutOfBoundsException in release 7.2.1

Anonymous — Sat, 16 Nov 2024 04:53:50 GMT

Using release 7.2.1 ... using tBigQueryInput and tLogRow like the example in the document ... https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/vwx5WuXNi7g0W_rK1Pi1AQ

project_id is someProject

dataset id is demos

schema for table some_user_native and project

first_name String

customerid String

email String

query is

"select first_name, customerid, email from demos.some_user_native"

tBigQueryInput linked to tLogRow

Running the job resulted in

Exception in component tBigQueryInput_4
java.lang.StringIndexOutOfBoundsException: String index out of range: -14
at java.lang.String.substring(Unknown Source)

I tried to run insert and update statements and getting the same error.

Does anyone encounter similar issues?

Re: tBigQueryInput getting StringIndexOutOfBoundsException in release 7.2.1

Anonymous — Thu, 22 Aug 2019 15:02:44 GMT

Hi,

Could you please try it once again by giving the Length parameter details in the schema for each column? If the error persists, could you please create a jira ticket for the same?

https://jira.talendforge.org/secure/Dashboard.jspa

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tBigQueryInput getting StringIndexOutOfBoundsException in release 7.2.1

Anonymous — Thu, 22 Aug 2019 16:00:48 GMT

Hi Nikhil,

It seems to be working now ... but ...

Here is a few things I noticed ...

1. In the previous release, I don't need to save the change before running. I think NOW I need to save after the change in order to run with the change.

2. When I use an alias for the table, it gives me the StringIndexOutOfBountsException. I tried to do this in the select, update, insert and getting the StringIndexOutOfBountsException.

For example ... I got this select query statement working in Talend ...

select first_name, customerid, email from demos.some_user_native

but not this ...

select su.first_name, su.customerid, su.email from demos.some_user_native su

Both of these statements worked in GCP BigQuery Query editor.