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]
