I am having issue with Bigquery Connector Node

I am having error while executing the knime BQ connector Node . The Following are the logs from the node … can any help me with this ?

DEBUG MemoryAlertSystem Tenured gen heap space usage below threshold (89%) after GC, currently 1% (0.14GB/12.00GB)
DEBUG MemoryAlertSystem Tenured gen heap space usage below threshold (67%) after GC, currently 1% (0.14GB/12.00GB)
INFO Google BigQuery Connector 0:2015 Could not create connection to database using URL: jdbc:bigquery://http://www.googleapis.com/bigquery/v2:443;ProjectId;Timeout=36000 and parameters: [OAuthPvtKeyPath, OAuthServiceAcctEmail, OAuthType]. Exception: [Simba]BigQueryJDBCDriver HttpTransport IO error : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
DEBUG Google BigQuery Connector 0:2015 reset
ERROR Google BigQuery Connector 0:2015 Execute failed: [Simba]BigQueryJDBCDriver HttpTransport IO error : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
DEBUG Google BigQuery Connector 0:2015 Google BigQuery Connector 0:2015 doBeforePostExecution
DEBUG Google BigQuery Connector 0:2015 Google BigQuery Connector 0:2015 has new state: POSTEXECUTE
DEBUG Google BigQuery Connector 0:2015 Google BigQuery Connector 0:2015 doAfterExecute - failure
DEBUG Google BigQuery Connector 0:2015 reset
DEBUG Google BigQuery Connector 0:2015 clean output ports.
DEBUG Google BigQuery Connector 0:2015 Google BigQuery Connector 0:2015 has new state: IDLE
DEBUG Google BigQuery Connector 0:2015 Configure succeeded. (Google BigQuery Connector)
DEBUG Google BigQuery Connector 0:2015 Google BigQuery Connector 0:2015 has new state: CONFIGURED
DEBUG Google BigQuery Connector 0:2015 tccc_publish_hyper_from_bigquery4 0 has new state: IDLE
DEBUG NodeContainer ROOT has new state: IDLE

Hi kirantodekar,

On a quick search on the KNIME forum, I came across a similar issue with ‘PKIX path building failed’ here.

As it is mentioned in the above-mentioned post, this might be a proxy-related issue.
Here is a video that explains the issue in detail: Resolving Common KNIME Certificates Problems - YouTube.

I hope this helps to resolve your issue.

Best,
Keerthan

2 Likes