Salesforce Connector Error

Hi @Andrew Cotter

There are a few potential causes for an error like this. Here are some things you can check:

1 - Check Permissions: The user account that owns the Jira Connector connection will need to be a Site Admin in Jira. Users without this permission cannot create Webhooks in Jira, so automated workflows won't work. 

2 - Possible Firewall Issue: The Jira Connector might be blocked in your firewall from reaching the /webhooks endpoint in Jira - ensure the Jira Connector can reach Jira endpoints. (See: Jira connector firewall settings)

3 - Reset OAuth token: If that hasn't helped, try re-setting the OAuth token by following these steps:

1. In your browser, log in to Jira as a Jira Global Administrator
2. In another tab of the same browser, log in to the Connector
3. Navigate to the Account Admin page through the upper left Menu icon (or click here https://connectors.smartsheet.com/c/jira/admin)
4. Next to the affected Jira Server, select the edit icon (pencil)
5. Click through the setup pages. No adjustments should be necessary.
6. On the last page, click "Connect."
7. You should be redirected to a Jira OAuth page. Click "Allow" to re-establish the OAuth token.

Once the OAuth token is re-established, the webhooks should be successful as long as the OAuth token was established under the credentials of a valid Jira Global Administrator.

Should you still be receiving the error, please contact the Support team through the Support portal providing them with all the steps you've tried as well as the Work Execution file:

• In the Jira Connector dashboard, select the timestamp under the Run Date column of the workflow.
• Select the timestamp under Last Run for the latest run of the workflow with the error.
• On the workflow run page, go to the hamburger menu (three horizontal lines in the upper left) and choose Download Workflow Execution Support Info.

Cheers,

Genevieve

Hey @Andrew Cotter

My apologies! I saw connector and went into auto-pilot!

Yes - you're receiving the same error I've seen in Jira before and the checks are very similar. Here are the adjusted directions for the Salesforce Connector:

1 - Check Permissions: In the Connector, navigate to the Account Admin screen through the hamburger menu (three horizontal lines) in the top left corner. From there, next to your Salesforce Organization, identify the Owner of the connection. From there, have your Salesforce Admin verify that this person has the required permissions to own the connection:

• API Enabled
• View Setup and Configuration
• View All Data

(See this Help Article: Before you Begin: Requirements)

2 - Verify that the workflow owner has access

It's possible that the person who created the workflow no longer has access to the Salesforce object or target sheet in Smartsheet. Verify that the user is a licensed Smartsheet user and still has access to the connected sheets and objects.

3 - Reset Access token: If that hasn't helped, try re-setting the Access token by following these steps:

1. Log in to Smartsheet, navigate to Account (Profile Icon in the top-right corner) > Apps & Integrations 
2. Find Smartsheet for Salesforce in the list of connected apps
3. Select revoke on the right-side
4. Once revoked, log into the Connector to re-enable the disabled workflow

Should you still be receiving the error, please contact the Support team through the Support portal providing them with all the steps you've tried as well as the Work Execution file:

1. In the Salesforce Connector dashboard, select the timestamp under the Run Date column of your workflow.
2. Select the timestamp under the Last Run column for the latest run of the workflow.
3. On following page, go to the hamburger menu and choose Download Workflow Execution Support Info. (Not Account Support Info file)

Cheers,

Genevieve