terraform-provider-airbyte icon indicating copy to clipboard operation
terraform-provider-airbyte copied to clipboard

Salesforce resource fails to authenticate after deploy

Open thatkellenguy opened this issue 1 year ago • 0 comments

I have created a Salesforce source connector that applies properly in Terraform but once you go to use this connector, it fails to generate a connection properly. In addition, you cannot resave this connector at all because it responds with: image

Configuration check failed
'An error occurred: {"error":"invalid_grant","error_description":"token validity expired"}'

To help with troubleshooting here is the chronology of how I got here:

  1. Created a Salesforce connector manually using username/password in the Airbyte UI. This worked and was able to setup a connection and sync data.

  2. Created the same resource via Terraform and re-deployed it. This did not work and exhibited the behavior I described above.

  3. Deleted the Terraform resource and tried to recreate the Salesforce connector manually again. Suddenly, even that did not work and no matter what I did, it would display the error noted above.

Now, it seems I cannot create a Salesforce connector at all in any of my workspaces without experiencing this error. Even though I did not deploy a Salesforce connector in some of the workspaces. This is odd behavior and I wouldn't expect this behavior to span all workspaces so that is perplexing.

The Terraform resource requires client id, client secret, and refresh token (even though the UI never calls for these). Is it possible that these attributes stick around for all salesforce connectors after they are applied once?

I'm sorry I don't have more thorough information but I'm befuddled.

thatkellenguy avatar Sep 14 '23 21:09 thatkellenguy