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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
DM2017
Contributor II
Contributor II

Error while inserting data to big query table

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.

Labels (4)
2 Replies
manodwhb
Champion II
Champion II

Karthik_Kommarraju
Contributor
Contributor

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