<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
Salesforce Provisioning Error "INVALID_FIELD : No such column 'UserPermissionsLiveAgentUser' on entity 'User'" in Okta
Okta Integration Network
Overview

Salesforce's provisioning flow fails with the following error visible in the Okta dashboard:
 

Automatic provisioning of user <user> to app Salesforce.com failed: INVALID_FIELD : No such column 'UserPermissionsLiveAgentUser' on entity 'User'.

 

Applies To
  • Salesforce
  • Provisioning
Cause

This error can occur when trying to send data to a Salesforce field that has been deleted or modified. Salesforce app data in Okta is not up to date and needs to be refreshed.

Solution

Refresh application data by re-authenticating API credentials used for provisioning to/from Salesforce, which will cause the download and update of application data into Okta.

  1. Go to the Okta admin panel and navigate to Applications > Applications > Salesforce > Provisioning > Integration > Edit.
  2. Enter the OAuth Consumer Key and OAuth Consumer Secret. See Configure OAuth and REST integration for more details.
    • OAuth Consumer Key: Consumer Key from Salesforce OAuth settings.
    • OAuth Consumer Secret: Consumer Secret from Salesforce OAuth settings.
  3. Click Re-authenticate with Salesforce.com.

Re-authenticate with Salesforce.com

  1. In the new Salesforce.com window, enter the administrator username and password that were used to create the Connected OAuth App.
  2. Click Allow to permit access to the Connected App.
  3. Back on the Provisioning page in Okta, see a message confirming successful authentication. Click Save.
  4. Attempt the failed tasks again. Navigate to Dashboard > Tasks. Any failed assignments should appear under Tasks.

Tasks

  1. After identifying the failed task for the user that should be retried, click on Retry Selected.

 

Related References

Loading
Salesforce Provisioning Error "INVALID_FIELD : No such column 'UserPermissionsLiveAgentUser' on entity 'User'" in Okta