cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Powerapps gateway connection to SharePoint 2016 on-premises

I'm attempting to setup and configure the gateway on my On-Premises SharePoint 2016 server. The gateway installation was successful but now I'm stuck on the configuration. I confirmed that the account I am using does have access to the PowerApps subscription. Also, when I go to PowerApps site, connections and try to make a SharePoint on-premises connection I do see my connection name.

I did look at the 'Troubleshooting the On-Premises gateway article' and did run the below command and confirmed I was successful.

 Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

Looks like I'm very close to getting this to work.

Below is the error I keep getting

Capture2.JPG

Let me know if I need to post that entire log text

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Employee

Re: Powerapps gateway connection to SharePoint 2016 on-premises

Thanks @darogael for walking us thru the issue.

Just to close on this, the root cause of the error was caused by the wrong time/date configuration in the machine where the gateway is being configured. Fixing these settings have fixed this issue.

4 REPLIES 4
Super User
Super User

Re: Powerapps gateway connection to SharePoint 2016 on-premises

Here is some added information I found while looking at the log file

 


Microsoft.IdentityModel.Clients.ActiveDirectory Error: 4 : 8/12/2016 10:00:40 AM: e8111417-699c-4ebd-a1e4-68ba47452dfc - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.VerifyAuthorizationResult()
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.PreTokenRequest()
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
ErrorCode: user_interaction_required
EnterpriseGatewayConfigurator.exe Error: 0 : 8/12/2016 10:00:40 AM: e8111417-699c-4ebd-a1e4-68ba47452dfc - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.VerifyAuthorizationResult()
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.PreTokenRequest()
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
ErrorCode: user_interaction_required
EnterpriseGatewayConfigurator.exe Warning: 0 : Error authenticating current user with forms authentication: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame. Attempting Windows integrated authentication.
EnterpriseGatewayConfigurator.exe Warning: 0 : Exception details: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.RunAsyncTask[T](Task`1 task)
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.AuthenticationManager.TryAuthenticateWithCurrentUser(AuthenticationResult& authResult)
ErrorCode: user_interaction_required
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AcquireTokenNonInteractiveHandler: === Token Acquisition started:
Authority: https://login.windows.net/common/oauth2/authorize/
Resource: https://analysis.windows.net/powerbi/api
ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
Authentication Target: User

EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AcquireTokenNonInteractiveHandler: === Token Acquisition started:
Authority: https://login.windows.net/common/oauth2/authorize/
Resource: https://analysis.windows.net/powerbi/api
ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
Authentication Target: User

Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Logged in user with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected
EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Logged in user with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: Looking up cache for a token...
EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: Looking up cache for a token...
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: No matching token was found in the cache
EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: No matching token was found in the cache
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Sending user realm discovery request to 'https://login.windows.net/common/UserRealm/first.last@domain.com?api-version=1.0'
EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Sending user realm discovery request to 'https://login.windows.net/common/UserRealm/first.last@domain.com?api-version=1.0'
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: User with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected as 'Managed'
EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: User with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected as 'Managed'
Microsoft.IdentityModel.Clients.ActiveDirectory Error: 4 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenNonInteractiveHandler.<PreTokenRequest>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
ErrorCode: password_required_for_managed_user
EnterpriseGatewayConfigurator.exe Error: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenNonInteractiveHandler.<PreTokenRequest>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
ErrorCode: password_required_for_managed_user
EnterpriseGatewayConfigurator.exe Warning: 0 : Error authenticating current user with Windows integrated authentication: password_required_for_managed_user: Password is required for managed user. Giving up - user has to enter credentials.
EnterpriseGatewayConfigurator.exe Warning: 0 : Exception details: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.RunAsyncTask[T](Task`1 task)
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.AuthenticationManager.TryAuthenticateWithCurrentUser(AuthenticationResult& authResult)
ErrorCode: password_required_for_managed_user
EnterpriseGatewayConfigurator.exe Warning: 0 : Could not acquire authentication token for current user.
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration Id: '27338'
EnterpriseGatewayConfigurator.exe Information: 0 : SB Endpoint: 'sb://wabi-us-east2-relay43.servicebus.windows.net/c0d3560e-1622-4537-85cd-66263ec84d1f/'
EnterpriseGatewayConfigurator.exe Information: 0 : Sign In

PowerApps Staff archanan
PowerApps Staff

Re: Powerapps gateway connection to SharePoint 2016 on-premises

Thanks for reporting this issue. We are looking into it and provide you an update shortly.

Highlighted
Microsoft Employee

Re: Powerapps gateway connection to SharePoint 2016 on-premises

Hi darogael,

 

Based on the messages you posted, we think you are running into a bug on our side. Good news is that there are three options:

 

1. Workaround:

As a workaround, uninstall the current On-premises data gateway, logoff, and then login as local administrator on that machine. Install the On-premises data gateway and go through the configuration like you did before, and let us know if that worked.

 

2. Fix: we believe we have a fix for the underlying issue, and plan to include it with the next public release of the On-premises data gateway planned at the end of August. When you install with that update, you should not encounter the problem anymore.

 

3. Beta-test the fix:

If you send a private email message to Robert.Bruckner at microsoft.com, we could look into sharing a private preview build of that August public release for you to try out the code change we made.

 

Thanks,

Robert Bruckner

Microsoft Employee

Re: Powerapps gateway connection to SharePoint 2016 on-premises

Thanks @darogael for walking us thru the issue.

Just to close on this, the root cause of the error was caused by the wrong time/date configuration in the machine where the gateway is being configured. Fixing these settings have fixed this issue.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 383 members 4,835 guests
Please welcome our newest community members: