Record Overflow

a_fontana — Sat, 16 Nov 2024 02:08:47 GMT

Hello,

I'm using Talend Open Studio for Big Data for update massive data from an excel to a Big Query's table.

During my testing everything is fine but after a certain amount of characters this fail message appear:

Exception in component tBigQueryOutput_1_tBQBE (ExcelBigQuery_output)

org.jets3t.service.ServiceException: Request Error: Received fatal alert: record_overflow

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

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_big_data.excelbigquery_output_0_1.ExcelBigQuery_output.tFileInputExcel_1Process(ExcelBigQuery_output.java:6023)

at project_big_data.excelbigquery_output_0_1.ExcelBigQuery_output.runJobInTOS(ExcelBigQuery_output.java:6947)

at project_big_data.excelbigquery_output_0_1.ExcelBigQuery_output.main(ExcelBigQuery_output.java:6796)

Caused by: javax.net.ssl.SSLException: Received fatal alert: record_overflow

at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133)

at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)

at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:307)

at java.base/sun.security.ssl.Alert$AlertConsumer.consume(Alert.java:285)

at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:180)

at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)

at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1183)

at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1153)

at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:828)

at org.apache.http.impl.io.AbstractSessionInputBuffer.fillBuffer(AbstractSessionInputBuffer.java:161)

at org.apache.http.impl.io.SocketInputBuffer.fillBuffer(SocketInputBuffer.java:82)

at org.apache.http.impl.io.AbstractSessionInputBuffer.readLine(AbstractSessionInputBuffer.java:278)

at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:138)

at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:56)

at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:259)

at org.apache.http.impl.AbstractHttpClientConnection.receiveResponseHeader(AbstractHttpClientConnection.java:286)

at org.apache.http.impl.conn.DefaultClientConnection.receiveResponseHeader(DefaultClientConnection.java:257)

at org.apache.http.impl.conn.AbstractClientConnAdapter.receiveResponseHeader(AbstractClientConnAdapter.java:230)

at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:273)

at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:125)

at org.apache.http.impl.client.DefaultRequestDirector.tryExecute(DefaultRequestDirector.java:684)

at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:486)

at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:835)

at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)

at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)

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

... 10 more

I can confirm it's about the length because it only appear only when the row with a lot of characters (content) is upload.

For reference I attach the excel I'm using for the tests.

Thanks

topic Record Overflow in Talend Studio

Record Overflow