While trying to Import the managed solution exported from Development environment (that contains the Virtual Table connectors), we are facing issues in the QA and Production environment. When we open the virtual table in QA or Production, we are seeing the below error. Please help us to resolve this issue.
I just ran into this today. When I went to drop and recreate the table in the new environment to troubleshoot, it told me user 9783da46-e606-ee11-8f6e-000d3a565aab needed to have at least "use and share" permissions on the underlying connection. For me this was an application account. Upon further review, this is the app id of our deployment user. So I think that going forward, we'll want to create the Connection first, and grant these permissions, then run our deployment pipelines. However, the below also worked post deployment.
Went to the new/import environment and clicked share
Added the deployment account as "Can use + share" and clicked save
After that another virtual table with the same issue showed data correctly without further intervention. I also noticed that I was not able to reproduce the error message when creating a virtual table after (I tried to get screenshots), which makes me think there was something from the deployment that it could not finish that resolved after I opened the other virtual table.
Symptoms I found that may help diagnose this as your issue
-- Plugin Tracelog records RetrieveMultiple for the Virtual Entity
Message: "System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: The remote server returned an error: (403) Forbidden."
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.