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.