ORACLE to BigQuery

kotvir — Sat, 16 Nov 2024 00:05:41 GMT

Hi Folks,

I am trying to ingest data from On prem Oracle table to table in BigQuery, but getting following error.

BigQuery component configuration has been attached.

[statistics] connecting to socket on port 3830

[statistics] connected

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

Exception in component tBigQueryOutput_2_tBQBE (Proceeding_Care_v1)

org.jets3t.service.ServiceException: Request Error: Connection timed out: connect

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 local_project.proceeding_care_v1_0_1.Proceeding_Care_v1.tDBInput_5Process(Proceeding_Care_v1.java:2002)

at local_project.proceeding_care_v1_0_1.Proceeding_Care_v1.runJobInTOS(Proceeding_Care_v1.java:4295)

at local_project.proceeding_care_v1_0_1.Proceeding_Care_v1.main(Proceeding_Care_v1.java:4144)

Caused by: java.net.ConnectException: Connection timed out: connect

at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:542)

at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:414)

at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)

at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:144)

at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:134)

at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:610)

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

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

[statistics] disconnected

Job Proceeding_Care_v1 ended at 09:14 02/06/2021. [Exit code = 1]

Re: ORACLE to BigQuery

Anonymous — Thu, 24 Jun 2021 08:42:06 GMT

Hello,

Are you able to write to bigquery? All the connection parameters are correct?

Note that The file name in the File filed must be the same as the one you defined in the Local filename field.

Best regards

Sabrina

topic ORACLE to BigQuery in Talend Studio

ORACLE to BigQuery

Re: ORACLE to BigQuery