Error Message: 'Cannot find the requested object' when using Service Account Authentication in Google BigQuery Connection.
Action:
When using Service Account authentication in Google BigQuery connection Manager the following error is received.
Error Message:
Validating connectivity via endpoint '' failed. Details:Cannot find the requested object. (CozyRoc.SSISPlus.2019)Additional information:Cannot find the requested object. (mscorlib)
Solution:
If you want to use "Service Account" authentication, you have to provide the key file in pfx (p12) format. You can refer to the following KB article to export the key file to .pfx.
How to export key pair and certificate to .pfx file.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Where can I find the documentation for the Google BigQuery Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Google BigQuery Connection can be found at the following link. For many of the components you can ...Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action: When trying to fetch data from Google Big Query view using Query Resource in Rest Source. Error Message: ''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not ...Error Message: Negotiation failed. Requested service is not implemented.
Action: Packages that used to work fine have suddenly started failing. These packages use the SFTP task. Error Message: Negotiation failed. Requested service is not implemented. Solution: Security algorithms are improved and changed regularly. It ...How to manually generate a Google Services Token?
A token-based authentication system allows users to enter their username and password in order to obtain a token, which allows them to fetch a specific resource, without using their username and password. Once their token has been obtained, the user ...Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"
Action: When running an SSIS package under the SQL Job Agent, the following error is encountered. Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error ...