Browser form REST query errors on form load - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Browser form REST query errors on form load

Last post 03-22-2019 08:04 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-20-2019 04:34 AM

    • dan508
    • Not Ranked
    • Joined on 07-12-2018
    • Posts 5

    Browser form REST query errors on form load

    Good day all. I'm pulling my hair out over this one. I have an InfoPath form that queries a data connection for a REST lookup to the user profile api. When opening the form in the InfoPath program, this data connection works fine. However when opening it as a web form, I get the following error appear: XML data that is required for this form to function correctly cannot be found. An entry has been added to the Windows event log of the server. Log ID:5566 The event log states the following: The following query failed: Get User properties (User: 0#.w|*UserName*, Form Name: Electronic Appraisals, IP: , Connection Target: https://*ServerURL*/DataConnectionLibrary/AppraisalsREST.udcx, Request: https:/*ServerURL*/_layouts/15/FormServer.aspx?XsnLocation=https:/*ServerURL*/hr/Electronic Appraisals/Forms/template.xsn&SaveLocation=https://*ServerURL*/hr/Electronic Appraisals&ClientInstalled=true&DefaultItemOpen=1&Source=https://*ServerURL*/hr/Electronic%2520Appraisals/Forms/AllItems.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:Electronic-Appraisals:-myXSD-2019-03-14T12-26-26 Type: DataAdapterException, Exception Message: The form cannot run the specified query. The remote server returned an error: (404) Not Found.) The Data connection is set to use an appID which was successfully configured on the server. It is set to use Kerberos (Any other authentication and I get a 401 error instead). I have manually specified my own credentials in the connection file to test, and this did not work either. DisableLoopBack is set. Looking at the correlation logs, I see the following errors which I suspect are the root of the problem: Outer Exception: The form cannot run the specified query.. Stack trace: at Microsoft.Office.InfoPath.Server.Util.InfoPathException.LogException(Exception e) at Microsoft.Office.InfoPath.Server.Util.InfoPathLocalizedException..ctor(Ids id, Exception innerException, String[] args) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.HandleExecuteException(Exception exception, String safeMessage) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.ExecuteNonSolutionFile(String fileUrl, XPathNavigator output, Document document, DataAdapterCredentials credentials, Boolean useDcl, Int64& auxDomSize) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.Execute(String fileUrl, XPathNavigator output, Document document, DataAdapterCredentials credentials, Boolean useDcl, Int64& auxDomSize) at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataAdapterXmlFile.ExecuteInternal(XPathNavigator output) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.QueryDataOnLoad(DataAdapter documentDataAdapter, DataObject documentDataObject) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.ExecuteInitOnLoadForDataObjects() at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.LoadSolutionAndDocument(HttpContext context, Solution solution, DocumentMetaInformation documentMetaInformation, OnInitializeCallback onInitializeCallback, OpenParameters openParameters) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.OpenDocumentWithSolution(HttpContext context, SPSite contextSite, Solution solution, DocumentMetaInformation documentMetaInformation, OnInitializeCallback onInitializeCallback, OpenParameters openParameters) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.NewFromSolution(HttpContext context, SPSite contextSite, Solution solution, DocumentMetaInformation documentMetaInformation, Boolean disableFirstRequestOptization, OnInitializeCallback onInitializeCallback, OpenParameters openParameters) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.DataBindInternal(SolutionMetaInformation solutionMetaInformation, DocumentMetaInformation documentMetaInformation, String absoluteSolutionLocation, Boolean hasCloseHandler, Document& document) at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.InitializeRenderInLine(SolutionMetaInformation solutionMetaInformation, DocumentMetaInformation documentMetaInformation, String absoluteSolutionLocation) at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.NewEditingSession(SPSite contextSite, FormServerPageQueryParameters queryParameters, Boolean isFormServerProperlyConfigured, Boolean& renderSessionsStateError) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.StartNewEditingSession() at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.EnsureDocument(EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.<>c__DisplayClassb.b__5() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RunAndGetErrorRendererOnException(HttpContext context, EventLogStart eventLogStart, TryBlock tryblock, CatchBlock catchblock) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.LoadDocumentAndPlayEventLog() at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.OnDataBindHelper() at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.WebParts.Part.DataBind() at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.Initialize() at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) . Inner Exception The remote server returned an error: (404) Not Found.. Stack trace: at System.Net.HttpWebRequest.GetResponse() at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.GetXmlFileStreamThroughHttpRequest(Uri fileUri, DataAdapterCredentials credentials) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.<>c__DisplayClass4.b__0(Boolean differentIdentity) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterUtil.Impersonate(DataAdapterInformation adapterInfo, String userName, String userDomain, String password, CodeToRunUnderImpersonation codeToRun) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterUtil.Impersonate(DataAdapterInformation adapterInfo, String userName, String password, CodeToRunUnderImpersonation codeToRun) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterXmlFile.ExecuteNonSolutionFile(String fileUrl, XPathNavigator output, Document document, DataAdapterCredentials credentials, Boolean useDcl, Int64& auxDomSize). Data adapter failed during OnLoad: The form cannot run the specified query. Any help would really be appreciated.
  • 03-22-2019 08:04 AM In reply to

    Re: Browser form REST query errors on form load

    Ick. I found this: https://www.infopathdev.com/forums/p/25654/89011.aspx which suggested https://blogs.msdn.microsoft.com/besidethepoint/2010/05/08/double-hop-authentication-why-ntlm-fails-and-kerberos-works/. I know nothing about kerberos (well, I once worked with someone who named their dog that - but that's all I've got) - but perhaps the MSDN post will have some suggestions?
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.