Salesforce - Error ProfileId when Provisioning with Salesforce

Tann Pattanapaisarn 55 Reputation points
2023-07-26T06:04:04.58+00:00

Hello Community,

I have an issue with the Provisioning with Salesforce and It returns an error message "ERROR at Row:1:Column:140 No such column 'ProfileId' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names..".ProvisioningError

ProvisioningMapping

But the "Profile" field I have used in mapping is a default attribute, How can I fix this issue?

Best Regards,

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
711 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,307 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,256 questions
{count} vote

Accepted answer
  1. Givary-MSFT 35,216 Reputation points Microsoft Employee
    2023-08-02T06:30:27.6566667+00:00

    @Tann Pattanapaisarn Apologies for the delay in answering this from my side. I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

    Issue:

    issue with the Provisioning with Salesforce and It returns an error message "ERROR at Row:1:Column:140 No such column 'ProfileId' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names..".

    ProvisioningError

    ProvisioningMapping

    Solution:

    Issue has been resolved by @Tann Pattanapaisarn

    find the related article, and the article said that it's caused by the Admin Credential User that syncs between Salesforce and Azure does NOT have "View Setup and Configuration" permission. So, that user cannot access to the ProfileId and return the error.

    To Fix it, checked the "View Setup and Configuration" permission on the Admin Credential User profile.

    Article Link: https://developer.salesforce.com/forums/?id=906F00000008pKWIAY

    If you have any other questions or are still running into more issues, please let me know. Thank you again for your time and patience throughout this issue.

    Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Tann Pattanapaisarn 55 Reputation points
    2023-08-02T06:19:19.66+00:00

    Hi @Givary-MSFT and @AH, I can find the related article, and the article said that it's caused by the Admin Credential User that syncs between Salesforce and Azure does NOT have "View Setup and Configuration" permission. So, that user cannot access to the ProfileId and return the error.

    To Fix it, checked the "View Setup and Configuration" permission on the Admin Credential User profile.

    Article Link: https://developer.salesforce.com/forums/?id=906F00000008pKWIAY

    Thanks.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.