Error while inserting data to big query table

DM2017 — Sat, 16 Nov 2024 02:49:27 GMT

Hello Everyone,

Getting below error in the last insert in bigquery output

Starting job live_exercise_v1 at 01:45 30/03/2020.

[statistics] connecting to socket on port 4034

[statistics] connected

[WARN ] 01:45:11 org.jets3t.service.utils.Mimetypes- Unable to find 'mime.types' file in classpath

Exception in component tBigQueryOutput_1_tBQBE (live_exercise_v1)

org.jets3t.service.ServiceException: Service Error Message. -- ResponseCode: 400, ResponseStatus: Bad Request, XML Error Message: <?xml version='1.0' encoding='UTF-8'?><Error><Code>MalformedBucketConfiguration</Code><Message>The XML you provided was not well-formed or did not validate against our published schema.</Message><Details>Failed to parse bucket creation configuration

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRequest(RestStorageService.java:400)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRequest(RestStorageService.java:264)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRestPut(RestStorageService.java:1017)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.createObjectImpl(RestStorageService.java:1828)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.putObjectWithRequestEntityImpl(RestStorageService.java:1749)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.putObjectImpl(RestStorageService.java:1741)

at org.jets3t.service.StorageService.putObject(StorageService.java:840)

at org.jets3t.service.impl.rest.httpclient.GoogleStorageService.putObject(GoogleStorageService.java:416)

at project_first.live_exercise_v1_0_1.live_exercise_v1.tFileInputDelimited_2Process(live_exercise_v1.java:3339)

at project_first.live_exercise_v1_0_1.live_exercise_v1.runJobInTOS(live_exercise_v1.java:3880)

at project_first.live_exercise_v1_0_1.live_exercise_v1.main(live_exercise_v1.java:3729)

[statistics] disconnected

Job live_exercise_v1 ended at 01:45 30/03/2020. [Exit code = 1]

Thanks in advance.

Re: Error while inserting data to big query table

manodwhb — Thu, 02 Apr 2020 08:11:18 GMT

Check the below link may help you.
https://community.talend.com/t5/Design-and-Development/resolved-Error-while-trying-to-insert-into-a-BigQuery-table/td-p/73584

Re: Error while inserting data to big query table

Karthik_Kommarraju — Mon, 23 Aug 2021 14:59:20 GMT

Were you able to find a way for this error @Dharmendra Mohapatra @Manohar B

topic Re: Error while inserting data to big query table in Talend Studio

Error while inserting data to big query table

Re: Error while inserting data to big query table

Re: Error while inserting data to big query table